protected void btnSave_Click(object sender, EventArgs e) { clsMachineryUsage obj = new clsMachineryUsage(); obj.SiteID = Convert.ToInt32(ddlSite.SelectedValue); obj.Shift = Convert.ToInt32(ddlShift.SelectedValue); obj.EntryDate1 = Convert.ToDateTime(txtDate.Text).ToShortDateString(); obj.Op = 12; obj.MachineryUsage(obj); double TotalFuelUsed = 0; foreach (GridViewRow dr in grd.Rows) { Label lblMachine = dr.FindControl("lblMachine") as Label; HiddenField hdSiteMachineID = dr.FindControl("hdSiteMachineID") as HiddenField; TextBox txtOpenKMReading = dr.FindControl("txtOpenKMReading") as TextBox; TextBox txtCloseKMReading = dr.FindControl("txtCloseKMReading") as TextBox; Label lblTotalKMReading = dr.FindControl("lblTotalKMReading") as Label; TextBox txtOpenHReading = dr.FindControl("txtOpenHReading") as TextBox; TextBox txtOpenMReading = dr.FindControl("txtOpenMReading") as TextBox; TextBox txtCloseHReading = dr.FindControl("txtCloseHReading") as TextBox; TextBox txtCloseMReading = dr.FindControl("txtCloseMReading") as TextBox; Label lblTotalHRReading = dr.FindControl("lblTotalHRReading") as Label; TextBox txtOpenHSDReading = dr.FindControl("txtOpenHSDReading") as TextBox; TextBox txtHSDIssue = dr.FindControl("txtHSDIssue") as TextBox; TextBox txtCloseHSDReading = dr.FindControl("txtCloseHSDReading") as TextBox; Label lblTotalHSDReading = dr.FindControl("lblTotalHSDReading") as Label; CheckBox chkBreakdown = dr.FindControl("chkBreakdown") as CheckBox; CheckBox chkIdle = dr.FindControl("chkIdle") as CheckBox; TextBox txtDriver = dr.FindControl("txtDriver") as TextBox; TextBox txtRemarks = dr.FindControl("txtRemarks") as TextBox; obj.SiteMachineID = Convert.ToInt32(hdSiteMachineID.Value); obj.OpenKMReading = Convert.ToDouble(txtOpenKMReading.Text); obj.CloseKMReading = Convert.ToDouble(txtCloseKMReading.Text); obj.TotalKMReading = Convert.ToDouble(lblTotalKMReading.Text); obj.OpenHRReading = txtOpenHReading.Text + ":" + txtOpenMReading.Text; obj.CloseHRReading = txtCloseHReading.Text + ":" + txtCloseMReading.Text; obj.TotalHRReading = lblTotalHRReading.Text; obj.OpenHSDReading = Convert.ToDouble(txtOpenHSDReading.Text); obj.CloseHSDReading = Convert.ToDouble(txtCloseHSDReading.Text); obj.HSDIssue = Convert.ToDouble(txtHSDIssue.Text); TotalFuelUsed = TotalFuelUsed + Convert.ToDouble(txtHSDIssue.Text); obj.TotalHSDReading = Convert.ToDouble(lblTotalHSDReading.Text); if (chkBreakdown.Checked == true) { obj.Breakdown = 1; } if (chkIdle.Checked == true) { obj.Idle = 1; } obj.DriverName = txtDriver.Text; obj.Remarks = txtRemarks.Text; obj.Status = 1; obj.EnteredBy = Convert.ToInt32(Request.Cookies["User"].Value); obj.Op = 1; obj.MachineryUsage(obj); if (chkBreakdown.Checked == true) { clsSiteMachines obSM = new clsSiteMachines(); obSM.ID = Convert.ToInt32(hdSiteMachineID.Value); obSM.Op = 2; obSM.Status = 3; try { obSM.UpdateDate = txtDate.Text; } catch { } obSM.SiteMachines(obSM); clsMachineDamage obMD = new clsMachineDamage(); obMD.SiteID = Convert.ToInt32(ddlSite.SelectedValue); obMD.SiteMachineID = Convert.ToInt32(hdSiteMachineID.Value); obMD.EntryDate1 = Convert.ToDateTime(txtDate.Text).ToShortDateString(); obMD.Remarks = "Entry From Daily Progress Report"; obMD.Op = 1; obMD.MachineDamage(obMD); } else { if (chkIdle.Checked == true) { clsSiteMachines obSM = new clsSiteMachines(); obSM.ID = Convert.ToInt32(hdSiteMachineID.Value); obSM.Op = 2; obSM.Status = 2; try { obSM.UpdateDate = txtDate.Text; } catch { } obSM.SiteMachines(obSM); } else { clsSiteMachines obSM = new clsSiteMachines(); obSM.ID = Convert.ToInt32(hdSiteMachineID.Value); obSM.Op = 2; obSM.Status = 1; try { obSM.UpdateDate = txtDate.Text; } catch { } obSM.SiteMachines(obSM); } } } clsSiteFuelIssue obSFI = new clsSiteFuelIssue(); obSFI.SiteID = Convert.ToInt32(ddlSite.SelectedValue); try { obSFI.IssueDate1 = Convert.ToDateTime(txtDate.Text).ToShortDateString(); } catch { } obSFI.InAmount = Convert.ToDouble(txtFuelIssued.Text); obSFI.OutAmount = TotalFuelUsed; obSFI.Balance = Convert.ToDouble(txtFuelBalance.Text); obSFI.Rate = 0; obSFI.Total = 0; obSFI.Remarks = "Entry from Daily Progress Report"; obSFI.Op = 1; obSFI.SiteFuelIssue(obSFI); LoadMachines(); LoadFuel(); }