protected void btnGo_OnClick(object sender, EventArgs e)
{
try
{
DataTable dtRes = createDT();
LogBl objLogBl = new LogBl();
DateTime dtFromDateTime = DateTime.ParseExact(txtFromDate.Text, "dd/MM/yyyy", CultureInfo.InvariantCulture);
DateTime dtToDateTime = DateTime.ParseExact(txtToDate.Text, "dd/MM/yyyy", CultureInfo.InvariantCulture);
var objResult = objLogBl.SugarsyrpReport(dtFromDateTime, dtToDateTime);
for (int i = 0; i < objResult.ResutlDs.Tables[0].Rows.Count; i++)
{
DataRow dr = dtRes.NewRow();
dr["Id"] = objResult.ResutlDs.Tables[0].Rows[i]["Id"].ToString();
dr["Date"] = objResult.ResutlDs.Tables[1].Rows[i]["Date"].ToString();
dr["Time"] = objResult.ResutlDs.Tables[1].Rows[i]["Time"].ToString();
dr["VatNo"] = objResult.ResutlDs.Tables[0].Rows[i]["VatNo"].ToString();
dr["QtyWaterTaken"] = objResult.ResutlDs.Tables[0].Rows[i]["QtyWaterTaken"].ToString();
dr["SugarQtyTaken"] = objResult.ResutlDs.Tables[0].Rows[i]["SugarQtyTaken"].ToString();
dr["BatchStartTime"] = objResult.ResutlDs.Tables[1].Rows[i]["BatchStartTime"].ToString();
dr["BatchStopTime"] = objResult.ResutlDs.Tables[1].Rows[i]["BatchStopTime"].ToString();
dr["BatchTotalTime"] = objResult.ResutlDs.Tables[1].Rows[i]["BatchTotalTime"].ToString();
dr["Tank"] = objResult.ResutlDs.Tables[0].Rows[i]["Tank"].ToString();
dr["SugarSilo"] = objResult.ResutlDs.Tables[1].Rows[i]["SugarSilo"].ToString();
dr["WaterQty"] = objResult.ResutlDs.Tables[1].Rows[i]["WaterQty"].ToString();
dr["SugarQty"] = objResult.ResutlDs.Tables[1].Rows[i]["SugarQty"].ToString();
dr["BatchTemp"] = objResult.ResutlDs.Tables[1].Rows[i]["BatchTemp"].ToString();
dr["TransferSiloNo"] = objResult.ResutlDs.Tables[1].Rows[i]["TransferSiloNo"].ToString();
dr["SugarSyrupTransferQty"] = objResult.ResutlDs.Tables[1].Rows[i]["SugarSyrupTransferQty"].ToString();
dr["TransferStartTime"] = objResult.ResutlDs.Tables[1].Rows[i]["TransferStartTime"].ToString();
dr["TransferStopTime"] = objResult.ResutlDs.Tables[1].Rows[i]["TransferStopTime"].ToString();
dr["TransferTotalTime"] = objResult.ResutlDs.Tables[1].Rows[i]["TransferTotalTime"].ToString();
dtRes.Rows.Add(dr);
}
//var objSweetMilk = objLogBl.SweetMilkReport(dtFromDateTime, dtToDateTime);
if (dtRes.Rows.Count > 0)
{
gvSugarSyrup.DataSource = dtRes;
gvSugarSyrup.DataBind();
divExport.Visible = divExport1.Visible = true;
divRecord.Visible = false;
for (int i = 0; i < gvSugarSyrup.Rows.Count; i++)
{
TextBox txt = (TextBox)gvSugarSyrup.Rows[i].FindControl("txtQtySugar");
txt.Text = dtRes.Rows[i]["SugarQtyTaken"].ToString();
TextBox txt2 = (TextBox)gvSugarSyrup.Rows[i].FindControl("txtID");
txt2.Text = dtRes.Rows[i]["Id"].ToString();
}
}
else
{
divExport.Visible = divExport1.Visible = false;
divRecord.Visible = true;
}
}
catch (Exception ex)
{
log.Error("Error", ex);
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp",
"<script>alert('Oops! There is some technical Problem. Contact to your Administrator.');</script>");
}
}
