asp.net - Total Amount won't calculate and show the record in the textbox C# -
i doing project similar sales , inventory. everytime add resource (materials, equipment, vehicle, contractor) must calculate total cost/amount based on price in database.
i have here textbox total amount must display. suppose everytime add resource should update. , when click save button, must inserted in database.
what happen in here calculate total amount wont show in current context. have press save button need go page before record shows. if want save database need click save button again.
below codes getting total amount
//getting total cost per resources decimal gettotalmaterialcost() { decimal total = 0; con.open(); sqlcommand cmd = new sqlcommand(); cmd.connection = con; cmd.commandtext = "select sum(rm.quantity * m.sellingprice) totalmaterialcost resource_materials rm " + "join materials m on m.materialid = rm.materialid " + "join projecttasks t on t.taskid = rm.taskid " + "where t.taskid=@taskid having count (*) > 0"; cmd.parameters.addwithvalue("@taskid", request.querystring["id"].tostring()); object data = cmd.executescalar(); if (data == null) total = 0; else total = (decimal)cmd.executescalar(); con.close(); return total; } decimal gettotalequipmentcost() { decimal total = 0; con.open(); sqlcommand cmd = new sqlcommand(); cmd.connection = con; cmd.commandtext = "select sum(e.price * re.quantity) totalequipmentcost resource_equipments re " + "join equipments e on e.equipmentid = re.equipmentid " + "join projecttasks t on t.taskid = re.taskid " + "where t.taskid=@taskid having count (*) > 0"; cmd.parameters.addwithvalue("@taskid", request.querystring["id"].tostring()); object data = cmd.executescalar(); if (data == null) total = 0; else total = (decimal)cmd.executescalar(); con.close(); return total; } decimal gettotalvehiclecost() { decimal total = 0; con.open(); sqlcommand cmd = new sqlcommand(); cmd.connection = con; cmd.commandtext = "select sum(rv.cost) resource_vehicles rv " + "join vehicles v on v.vehicleid = rv.vehicleid " + "join projecttasks t on t.taskid = rv.taskid " + "where t.taskid=@taskid having count (*) > 0"; cmd.parameters.addwithvalue("@taskid", request.querystring["id"].tostring()); object data = cmd.executescalar(); if (data == null) total = 0; else total = (decimal)cmd.executescalar(); con.close(); return total; } decimal gettotalcontractorcost() { decimal total = 0; con.open(); sqlcommand cmd = new sqlcommand(); cmd.connection = con; cmd.commandtext = "select sum(c.rate) resource_contractors rc " + "join contractors c on c.contractorid = rc.contractorid " + "join projecttasks t on t.taskid = rc.taskid " + "where t.taskid=@taskid having count (*) > 0"; cmd.parameters.addwithvalue("@taskid", request.querystring["id"].tostring()); object data = cmd.executescalar(); if (data == null) total = 0; else total = (decimal)cmd.executescalar(); con.close(); return total; } //end double getamount() { double balance = 0; balance = convert.todouble(gettotalmaterialcost() + gettotalequipmentcost() + gettotalvehiclecost() + gettotalcontractorcost()); return balance; } //count total actual cost below code declare show record in textbox put in page_load
ltamount.text = getamount().tostring("0.00");
below source code textbox
<!--cost--> <div class="form-group"> <label class="control-label col-lg-4"> cost</label> <div class="col-lg-8"> <asp:textbox id="ltamount" runat="server" class="form-control" type="number" min="0.01" max="1000000000.00" step="0.01" readonly /> </div> </div> if notice add resource contractor cost/rate of 500.75. 500.75 need to show in cost textbox not show. show when pressed save button , reopen page again thats time able save database clicking save button once more.
here's actual code page. click here
please tell me if need clarifications. thanks! hoping kind answers.
"you mean after adding resource should able display total amount? if yes ltamount.text = getamount().tostring("0.00"); after adding resourse code." – imadoddin ibn alauddin
Comments
Post a Comment