locked
please help Inserting budget perworkweek RRS feed

  • Question

  • User-1790113996 posted

    Good Day to all MVC users and master,

    help how could i achieve inserting in the database
    perworkweek with a different departemtname,
    we can able to filter the departmentname, month and year,

    can you please give me a guide or reference tahnk you,

    please see my attachement below, thank you.

    https://imgur.com/a/0ucjr

    tbl_Calendar		
    Date		
    Year		
    Month		
    WorkWeek_Of_Month
    
    tbl_Budget		
    Date		
    Month		
    Year		
    Departmentname		
    Budget		
    
    
    tbl_issueditem		
    requestno		
    item		
    Date		
    qty		
    cost		
    totalcost		
    departmentname		
    		
    

    screenshot what i want to show in View Page

    https://imgur.com/a/Ob0hu

    thank you again.

    Monday, January 8, 2018 8:47 AM

All replies

  • User753101303 posted

    Hi,

    It would be easier to help if you are more explicit about the first problem you have. You are showing already a form but you have a problem in updating the db ? It is about retrieving the department shown on top or about the weelk number which is always 0.

    Not directly related but my personal preference would be to avoid using week numbers behind the scene but actual dates. It should be easier to work with that (week numbers is just a shortcut for users).

    Monday, January 8, 2018 9:14 AM
  • User-1790113996 posted

    Hi,

    It would be easier to help if you are more explicit about the first problem you have. You are showing already a form but you have a problem in updating the db ? It is about retrieving the department shown on top or about the weelk number which is always 0.

    Not directly related but my personal preference would be to avoid using week numbers behind the scene but actual dates. It should be easier to work with that (week numbers is just a shortcut for users).

    yes my problem is updating in the db, yes you are right about retrieving the department , how can i used in date?, could you please give an reference thank you.

    Wednesday, January 17, 2018 6:35 AM
  • User283571144 posted

    Hi Cloudfiers,

    help how could i achieve inserting in the database
    perworkweek with a different departemtname,
    we can able to filter the departmentname, month and year,

    According to your description, we still couldn't understand the requirement.

    I suggest you could post some related codes and the example about your requirement.

    e.g:

    The data example you want to insert into the database.

    Best Regards,

    Brando

    Tuesday, January 23, 2018 6:41 AM