protected void btnGo_OnClick(object sender, EventArgs e)
{
try
{
LogBl objLogBl = new LogBl();
ReportBL objReportBl = new ReportBL();
//DateTime dtFromDateTime = DateTime.ParseExact(txtFromDate.Text + " " + txtFromTime.Text, "dd/MM/yyyy HH:mm:ss",
// CultureInfo.InvariantCulture);
var objResult = objReportBl.DailyMassBalanceReport(Convert.ToDateTime(txtFromDate.Text), Convert.ToDateTime(txtToDate.Text), Convert.ToInt32(ddlReport.SelectedValue));
gvMassBalanceReport.DataSource = objResult.ResultDt;
gvMassBalanceReport.DataBind();
if (gvMassBalanceReport.Rows.Count > 0)
{
divExport.Visible = true;
divNo.Visible = false;
}
else
{
divExport.Visible = false;
divNo.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>");
}
}
protected void btnGo_OnClick(object sender, EventArgs e)
{
try
{
LogBl objBL = new LogBl();
ApplicationResult objResult = new ApplicationResult();
DateTime dtFromDateTime = DateTime.ParseExact(txtFromDate.Text + " " + txtFromTime.Text, "dd/MM/yyyy HH:mm:ss",
CultureInfo.InvariantCulture);
DateTime dtToDateTime = DateTime.ParseExact(txtToDate.Text + " " + txtToTime.Text, "dd/MM/yyyy HH:mm:ss",
CultureInfo.InvariantCulture);
objResult = objBL.DryingProductionLog(dtFromDateTime, dtToDateTime);
if (objResult.ResultDt.Rows.Count > 1)
{
divNo.Visible = false;
gvDryingProductionLog.Visible = true;
gvDryingProductionLog.DataSource = objResult.ResultDt;
gvDryingProductionLog.DataBind();
}
else
{
divNo.Visible = true;
gvDryingProductionLog.Visible = false;
}
}
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>");
}
}
protected void btnGo_OnClick(object sender, EventArgs e)
{
try
{
LogBl objLogBl = new LogBl();
DateTime dtFromDateTime = DateTime.ParseExact(txtFromDate.Text + " " + txtFromTime.Text, "dd/MM/yyyy HH:mm:ss",
System.Globalization.CultureInfo.InvariantCulture);
DateTime dtToDateTime = DateTime.ParseExact(txtToDate.Text + " " + txtToTime.Text, "dd/MM/yyyy HH:mm:ss",
System.Globalization.CultureInfo.InvariantCulture);
var objResult = objLogBl.UtilityHotWaterStatusReport(dtFromDateTime, dtToDateTime);
gvReport2.DataSource = objResult.ResultDt;
gvReport2.DataBind();
if (gvReport2.Rows.Count > 0)
{
divExport.Visible = true;
divNo.Visible = false;
}
else
{
divExport.Visible = false;
divNo.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>");
}
}
protected void btnGo_OnClick(object sender, EventArgs e)
{
try
{
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);
var objResult = objLogBl.SweetMilkReport(dtFromDateTime, dtToDateTime);
if (objResult.ResultDt.Rows.Count > 0)
{
gvSweetMilk.DataSource = objResult.ResultDt;
gvSweetMilk.DataBind();
divExport.Visible = divExport.Visible = true;
gvSweetMilk.Visible = false;
for (int i = 0; i < gvSweetMilk.Rows.Count; i++)
{
TextBox txt = (TextBox)gvSweetMilk.Rows[i].FindControl("txtQtySugar");
txt.Text = objResult.ResultDt.Rows[i]["QtyOfSugarSyrup"].ToString();
}
}
else
{
divExport.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>");
}
}
protected void btnGo_Click(object sender, EventArgs e)
{
try
{
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.ChemicalConsumptionReport(dtFromDateTime, dtToDateTime);
gvChemicalConsumption.DataSource = objResult.ResutlDs.Tables[0];
gvChemicalConsumption.DataBind();
if (gvChemicalConsumption.Rows.Count > 0)
{
divExport.Visible = GridView.Visible = true;
// divChemical.Visible = true;
}
else
{
divExport.Visible = GridView.Visible = false;
// divChemical.Visible = true;
gvChemicalConsumption.DataSource = null;
gvChemicalConsumption.DataBind();
}
}
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>");
}
}
public void EvaporatorLog()
{
try
{
ApplicationResult objResult = new ApplicationResult();
objResult = new LogBl().EvaporatorLog_SelectAll(Convert.ToDateTime(txtFromDate.Text), Convert.ToDateTime(txtToDate.Text));
if (objResult.ResultDt.Rows.Count > 0)
{
gvEvaporatorLog.DataSource = objResult.ResultDt;
gvEvaporatorLog.DataBind();
imgPdfButton.Visible = imgExcelButton.Visible = true;
divExport.Visible = true;
}
else
{
imgPdfButton.Visible = imgExcelButton.Visible = false;
divExport.Visible = false;
// ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp",
//"<script>alert('No Record Found.');</script>");
}
}
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>");
}
}
protected void btnGo_Click(object sender, EventArgs e)
{
try
{
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.MilkStorageReport(dtFromDateTime, dtToDateTime);
gvMilkStorage.DataSource = objResult.ResultDt;
gvMilkStorage.DataBind();
if (gvMilkStorage.Rows.Count > 0)
{
divExport.Visible = GridView.Visible = true;
for (int i = 0; i < gvMilkStorage.Rows.Count; i++)
{
gvMilkStorage.Columns[0].Visible = false;
TextBox txtBatchID = (TextBox)gvMilkStorage.Rows[i].Cells[7].FindControl("BatchID");
TextBox txtFAT = (TextBox)gvMilkStorage.Rows[i].Cells[7].FindControl("FAT");
TextBox txtSNF = (TextBox)gvMilkStorage.Rows[i].Cells[7].FindControl("SNF");
TextBox txtTS = (TextBox)gvMilkStorage.Rows[i].Cells[7].FindControl("TS");
txtBatchID.Text = objResult.ResultDt.Rows[i]["BatchID"].ToString();
txtFAT.Text = objResult.ResultDt.Rows[i]["FAT"].ToString();
txtSNF.Text = objResult.ResultDt.Rows[i]["SNF"].ToString();
txtTS.Text = objResult.ResultDt.Rows[i]["TS"].ToString();
btnSave.Enabled = true;
}
// divChemical.Visible = true;
}
else
{
divExport.Visible = GridView.Visible = false;
// divChemical.Visible = true;
gvMilkStorage.DataSource = null;
gvMilkStorage.DataBind();
}
}
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>");
}
}
public LogController()
{
this.Bl = new LogBl();
}
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>");
}
}
