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();
}
