protected void btnSave_Click(object sender, EventArgs e) { clsSiteFuelIssue obj = new clsSiteFuelIssue(); foreach (GridViewRow dr in grdEntry.Rows) { TextBox txtIssueAmount = dr.FindControl("txtIssueAmount") as TextBox; Label lblCurrentBalance = dr.FindControl("lblCurrentBalance") as Label; TextBox txtRemarks = dr.FindControl("txtRemarks") as TextBox; //TextBox txtRate = dr.FindControl("txtRate") as TextBox; obj.SiteID = Convert.ToInt32(grdEntry.DataKeys[dr.RowIndex].Value); try { obj.IssueDate1 = Convert.ToDateTime(txtDate.Text).ToShortDateString(); } catch { } if (Convert.ToDouble(txtIssueAmount.Text) != 0) { obj.InAmount = Convert.ToDouble(txtIssueAmount.Text); obj.OutAmount = 0; obj.Balance = Convert.ToDouble(lblCurrentBalance.Text); try { obj.Rate = Convert.ToDouble(txtPrice.Text); } catch { } obj.Total = obj.Rate * obj.InAmount; obj.Remarks = txtRemarks.Text; obj.Op = 1; obj.SiteFuelIssue(obj); } } pnlExisting.Visible = true; pnlNew.Visible = false; }
/* * Op=1 Insert data * Op=2 Delete data * Op=3 Get All data By Date * Op=4 Get data by Site & Date */ public DataSet SiteFuelIssue(clsSiteFuelIssue obj) { try { connect(); SqlParameter[] param = new SqlParameter[11]; param[0] = new SqlParameter("@ID", obj._ID); param[1] = new SqlParameter("@SiteID", obj._SiteID); param[2] = new SqlParameter("@IssueDate1", obj._IssueDate1); param[3] = new SqlParameter("@IssueDate2", obj._IssueDate2); param[4] = new SqlParameter("@InAmount", obj._InAmount); param[5] = new SqlParameter("@OutAmount", obj._OutAmount); param[6] = new SqlParameter("@Balance", obj._Balance); param[7] = new SqlParameter("@Rate", obj._Rate); param[8] = new SqlParameter("@Total", obj._Total); param[9] = new SqlParameter("@Remarks", obj._Remarks); param[10] = new SqlParameter("@Op", obj._Op); DataSet ds = SqlHelper.ExecuteDataset(co, "procSiteFuelIssue", param); return(ds);; } catch { return(null); } finally { co.Close(); } }
public void GetLastFuelBalance(int SiteID) { clsSiteFuelIssue obj = new clsSiteFuelIssue(); obj.SiteID = SiteID; obj.Op = 6; DataTable dt = obj.SiteFuelIssue(obj).Tables[0]; Context.Response.Write(JsonConvert.SerializeObject(dt)); }
void LoadDataForEntry() { clsSiteFuelIssue obj = new clsSiteFuelIssue(); obj.Op = 5; DataTable dt = obj.SiteFuelIssue(obj).Tables[0]; grdEntry.DataSource = dt; grdEntry.DataBind(); }
public void GetFuelIssueReport(int SiteID, string IssueDate1, string IssueDate2) { clsSiteFuelIssue obj = new clsSiteFuelIssue(); obj.SiteID = SiteID; obj.IssueDate1 = IssueDate1; obj.IssueDate2 = IssueDate2; obj.Op = 4; DataTable dt = obj.SiteFuelIssue(obj).Tables[0]; Context.Response.Write(JsonConvert.SerializeObject(dt)); }
protected void btnShow_Click(object sender, EventArgs e) { clsSiteFuelIssue obj = new clsSiteFuelIssue(); obj.Op = 4; try { obj.IssueDate1 = Convert.ToDateTime(txtDateFrom.Text).ToShortDateString(); } catch { } try { obj.IssueDate2 = Convert.ToDateTime(txtDateTo.Text).ToShortDateString(); } catch { } obj.SiteID = Convert.ToInt32(ddlSite.SelectedValue); DataTable dt = obj.SiteFuelIssue(obj).Tables[0]; grdData.DataSource = dt; grdData.DataBind(); }
public void SaveFuelIssue(int SiteID, string IssueDate, double InAmount, double OutAmount, double Balance, double Rate, double Total, string Remarks) { clsSiteFuelIssue obj = new clsSiteFuelIssue(); obj.SiteID = SiteID; obj.IssueDate1 = IssueDate; obj.InAmount = InAmount; obj.OutAmount = OutAmount; obj.Balance = Balance; obj.Rate = Rate; obj.Total = Total; obj.Remarks = Remarks; obj.Op = 1; obj.SiteFuelIssue(obj); string Message = "Saved"; Context.Response.Write(JsonConvert.SerializeObject(Message)); }
void LoadFuel() { clsSiteFuelIssue obj = new clsSiteFuelIssue(); obj.Op = 6; obj.SiteID = Convert.ToInt32(Request.Cookies["SiteID"].Value); DataTable dt = obj.SiteFuelIssue(obj).Tables[0]; if (dt.Rows.Count > 0) { txtAvailableFuel.Text = dt.Rows[0]["Balance"].ToString(); } else { txtAvailableFuel.Text = "0"; } txtFuelIssued.Text = "0"; txtFuelBalance.Text = txtAvailableFuel.Text; }
protected void btnSave_Click(object sender, EventArgs e) { clsMachineryUsage obj = new clsMachineryUsage(); obj.SiteID = Convert.ToInt32(Request.Cookies["SiteID"].Value); 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(Request.Cookies["SiteID"].Value); 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(Request.Cookies["SiteID"].Value); 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(); }