void LoadGrid()
{
clsDailyProgressReport obj = new clsDailyProgressReport();
obj.Op = 5;
if (txtDate.Text != "")
{
obj.EntryDate1 = txtDate.Text;
}
else
{
obj.EntryDate1 = DateTime.Today.ToShortDateString();
}
obj.SiteID = Convert.ToInt32(ddlSite.SelectedValue);
obj.Shift = Convert.ToInt32(ddlShift.SelectedValue);
DataTable dt = obj.DailyProgressReport(obj).Tables[0];
if (dt.Rows.Count == 0)
{
obj.Op = 6;
dt = obj.DailyProgressReport(obj).Tables[0];
}
dt.Columns.Add("SL");
for (int i = 0; i < dt.Rows.Count; i++)
{
dt.Rows[i]["SL"] = i + 1;
}
grd.DataSource = dt;
grd.DataBind();
}
/*
* Op=1 Insert data
* Op=2 Replace data
* Op=3 Delete data
* Op=4 Read data by date and Site
* Op=5 Find Duplicate Entry
* Op=6 Get Data For Grid*/
//ID, SiteID, SiteMachineID, EntryDate, Shift, StartReading, CloseReading, FuelIssued, TotalReading, BreakDown, Remarks
public DataSet DailyProgressReport(clsDailyProgressReport obj)
{
try
{
connect();
SqlParameter[] param = new SqlParameter[13];
param[0] = new SqlParameter("@ID", obj._ID);
param[1] = new SqlParameter("@SiteID", obj._SiteID);
param[2] = new SqlParameter("@SiteMachineID", obj._SiteMachineID);
param[3] = new SqlParameter("@EntryDate1", obj._EntryDate1);
param[4] = new SqlParameter("@EntryDate2", obj._EntryDate2);
param[5] = new SqlParameter("@Shift", obj._Shift);
param[6] = new SqlParameter("@StartReading", obj._StartReading);
param[7] = new SqlParameter("@CloseReading", obj._CloseReading);
param[8] = new SqlParameter("@FuelIssued", obj._FuelIssued);
param[9] = new SqlParameter("@TotalReading", obj._TotalReading);
param[10] = new SqlParameter("@BreakDown", obj._BreakDown);
param[11] = new SqlParameter("@Remarks", obj._Remarks);
param[12] = new SqlParameter("@Op", obj._Op);
DataSet ds = SqlHelper.ExecuteDataset(co, "procDailyProgressReport", param);
return(ds);
}
catch
{
return(null);
}
finally
{
co.Close();
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
clsDailyProgressReport obj = new clsDailyProgressReport();
foreach (GridViewRow dr in grd.Rows)
{
HiddenField hdID = (HiddenField)dr.FindControl("hdID");
Label lblMachine = (Label)dr.FindControl("lblMachine");
HiddenField hdSiteMachineID = (HiddenField)dr.FindControl("hdSiteMachineID");
Label lblLogNo = (Label)dr.FindControl("lblLogNo");
TextBox txtOpenReading = (TextBox)dr.FindControl("txtOpenReading");
TextBox txtCloseReading = (TextBox)dr.FindControl("txtCloseReading");
TextBox txtTotalReading = (TextBox)dr.FindControl("txtTotalReading");
TextBox txtFuelIssued = (TextBox)dr.FindControl("txtFuelIssued");
Label lblDamage = (Label)dr.FindControl("lblDamage");
HiddenField hdBreakdown = (HiddenField)dr.FindControl("hdBreakdown");
TextBox txtRemarks = (TextBox)dr.FindControl("txtRemarks");
//ID, SiteID, SiteMachineID, EntryDate, Shift, StartReading, CloseReading, FuelIssued, TotalReading, BreakDown, Remarks
obj.SiteID = Convert.ToInt32(ddlSite.SelectedValue);
obj.SiteMachineID = Convert.ToInt32(hdSiteMachineID.Value);
obj.EntryDate1 = Convert.ToDateTime(txtDate.Text).ToShortDateString();
obj.Shift = Convert.ToInt32(ddlShift.SelectedValue);
obj.StartReading = Convert.ToDouble(txtOpenReading.Text);
obj.CloseReading = Convert.ToDouble(txtCloseReading.Text);
obj.FuelIssued = Convert.ToDouble(txtFuelIssued.Text);
obj.TotalReading = Convert.ToDouble(txtTotalReading.Text);
obj.BreakDown = Convert.ToInt32(hdBreakdown.Value);
obj.Remarks = txtRemarks.Text;
if (Convert.ToInt32(hdID.Value) == 0)
{
obj.Op = 1;
}
else
{
obj.Op = 2;
obj.ID = Convert.ToInt32(hdID.Value);
}
obj.DailyProgressReport(obj);
ScriptManager.RegisterClientScriptBlock(this.Page, this.Page.GetType(), "alert", "alert('Data Saved')", true);
}
LoadGrid();
}
public void GetDPRBySiteAndDate(int SiteID, int SiteMachineID, string EntryDate1, string EntryDate2)
{
clsDailyProgressReport obj = new clsDailyProgressReport();
obj.EntryDate1 = EntryDate1;
obj.EntryDate2 = EntryDate2;
obj.SiteID = SiteID;
obj.SiteMachineID = SiteMachineID;
if (SiteMachineID == 0)
{
obj.Op = 4;
}
else
{
obj.Op = 7;
}
DataTable dt = obj.DailyProgressReport(obj).Tables[0];
Context.Response.Write(JsonConvert.SerializeObject(dt));
}
void LoadDataMachinewise()
{
clsDailyProgressReport obj = new clsDailyProgressReport();
obj.SiteID = Convert.ToInt32(ddlSite.SelectedValue);
obj.SiteMachineID = Convert.ToInt32(ddlMachine.SelectedValue);
obj.EntryDate1 = Convert.ToDateTime(txtDateFrom.Text).ToShortDateString();
obj.EntryDate2 = Convert.ToDateTime(txtDateTo.Text).ToShortDateString();
obj.Op = 7;
DataTable dt = obj.DailyProgressReport(obj).Tables[0];
double Total = 0;
double TotalFuel = 0;
LiteralControl lc = new LiteralControl();
lc.Text = lc.Text + "<table width='100%' border='1'>";
lc.Text = lc.Text + "<tr style='border:none 0 #fff;'><td colspan='12' align='center'><h3>T.K. Engineering Consortium Pvt. Ltd.</h3></td></tr>";
lc.Text = lc.Text + "<tr style='border:none 0 #fff;'><td colspan='12' align='center'><h4>Site: " + dt.Rows[0]["Site"].ToString() + "</h4></td></tr>";
lc.Text = lc.Text + "<tr style='border:none 0 #fff;'><td colspan='3'>From Date: " + txtDateFrom.Text + "</td><td colspan='6'></td><td colspan='3'>To Date: " + txtDateTo.Text + "</td></tr>";
lc.Text = lc.Text + "<tr style='border:none 0 #fff;'><td colspan='4'>Machine: " + dt.Rows[0]["Machine"] + "</td><td colspan='4'>Log No: " + dt.Rows[0]["LogNo"] + "</td><td colspan='4'>Registration No: " + dt.Rows[0]["RegistrationNo"] + "</td></tr>";
lc.Text = lc.Text + "<tr style='background:#ccc;'><td>Serial</td><td>Date</td><td colspan='2'>Shift</td><td colspan='2'>Starting Reading</td><td colspan='2'>Closing Reading</td><td colspan='2'>Fuel Issued</td><td colspan='2'>Total Reading</td></tr>";
int i = 0;
foreach (DataRow dr in dt.Rows)
{
i++;
lc.Text = lc.Text + "<tr><td>" + i.ToString() + "</td><td>" + Convert.ToDateTime(dr["EntryDate"]).ToShortDateString() + "</td>";
lc.Text = lc.Text + "<td colspan='2'>" + dr["Shift"] + "</td><td colspan='2'>" + dr["StartReading"] + "</td><td colspan='2'>" + dr["CloseReading"] + "</td>";
lc.Text = lc.Text + "<td colspan='2'>" + dr["FuelIssued"] + "</td><td colspan='2'>" + dr["TotalReading"] + "</td></tr>";
Total = Total + Convert.ToDouble(dr["TotalReading"]);
TotalFuel = TotalFuel + Convert.ToDouble(dr["FuelIssued"]);
}
lc.Text = lc.Text + "<tr style='background:#ccc'><td colspan='8'>Total</td><td colspan='2'>" + TotalFuel.ToString() + "</td><td colspan='2'>" + Total.ToString() + "</td></tr>";
lc.Text = lc.Text + "<tr style='background:#ddd'><td colspan='8'>Average</td><td colspan='2'>" + (TotalFuel / dt.Rows.Count).ToString() + "</td><td colspan='2'>" + (Total / dt.Rows.Count).ToString() + "</td></tr>";
lc.Text = lc.Text + "</table>";
pnlDetailMachine.Controls.Add(lc);
}
void LoadDataSitewise()
{
clsDailyProgressReport obj = new clsDailyProgressReport();
double Total = 0;
double TotalFuel = 0;
LiteralControl lc = new LiteralControl();
lc.Text = lc.Text + "<table width='100%' border='1'>";
lc.Text = lc.Text + "<tr style='border:none 0 #fff;'><td colspan='12' align='center'><h3>T.K. Engineering Consortium Pvt. Ltd.</h3></td></tr>";
lc.Text = lc.Text + "<tr style='border:none 0 #fff;'><td colspan='12' align='center'><h4>Site: " + ddlSite.SelectedItem.Text + "</h4></td></tr>";
lc.Text = lc.Text + "<tr style='border:none 0 #fff;'><td colspan='3'>From Date: " + txtDateFrom.Text + "</td><td colspan='6'></td><td colspan='3'>To Date: " + txtDateTo.Text + "</td></tr>";
lc.Text = lc.Text + "<tr style='background:#ccc;'><td>Serial</td><td colspan='3'>Machine</td><td colspan='2'>Log No</td><td colspan='2'>Registration No</td><td colspan='2'>Fuel Issued</td><td colspan='2'>Total Reading</td></tr>";
int i = 0;
DataTable dtDetail = new DataTable();
dtDetail.Columns.Add("Serial");
dtDetail.Columns.Add("Machine");
dtDetail.Columns.Add("LogNo");
dtDetail.Columns.Add("RegNo");
dtDetail.Columns.Add("Fuel");
dtDetail.Columns.Add("Reading");
foreach (ListItem li in ddlMachine.Items)
{
i++;
obj.SiteID = Convert.ToInt32(ddlSite.SelectedValue);
obj.SiteMachineID = Convert.ToInt32(li.Value);
obj.EntryDate1 = Convert.ToDateTime(txtDateFrom.Text).ToShortDateString();
obj.EntryDate2 = Convert.ToDateTime(txtDateTo.Text).ToShortDateString();
obj.Op = 7;
DataTable dt = obj.DailyProgressReport(obj).Tables[0];
double Reading = 0;
double Fuel = 0;
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
Reading = Reading + Convert.ToDouble(dr["TotalReading"]);
Fuel = Fuel + Convert.ToDouble(dr["FuelIssued"]);
}
dtDetail.Rows.Add(dtDetail.NewRow());
dtDetail.Rows[dtDetail.Rows.Count - 1][0] = i.ToString();
dtDetail.Rows[dtDetail.Rows.Count - 1][1] = dt.Rows[0]["Machine"];
dtDetail.Rows[dtDetail.Rows.Count - 1][2] = dt.Rows[0]["LogNo"];
dtDetail.Rows[dtDetail.Rows.Count - 1][3] = dt.Rows[0]["RegistrationNo"];
dtDetail.Rows[dtDetail.Rows.Count - 1][4] = Fuel.ToString();
dtDetail.Rows[dtDetail.Rows.Count - 1][5] = Reading.ToString();
Total = Total + Reading;
TotalFuel = TotalFuel + Fuel;
}
}
foreach (DataRow dr in dtDetail.Rows)
{
lc.Text = lc.Text + "<tr><td>" + dr["Serial"] + "</td><td colspan='3'>" + dr["Machine"] + "</td><td colspan='2'>" + dr["LogNo"] + "</td>";
lc.Text = lc.Text + "<td colspan='2'>" + dr["RegNo"] + "</td><td colspan='2'>" + dr["Fuel"] + "</td><td colspan='2'>" + dr["Reading"] + "</td></tr>";
}
lc.Text = lc.Text + "<tr style='background:#ccc'><td colspan='8'>Total</td><td colspan='2'>" + TotalFuel.ToString() + "</td><td colspan='2'>" + Total.ToString() + "</td></tr>";
lc.Text = lc.Text + "</table>";
pnlDetailSite.Controls.Add(lc);
}
