private void BindgvMilkAnalysis()
{
try
{
MilkAnalysisBL objMilkAnalysisBl = new MilkAnalysisBL();
var objResult = objMilkAnalysisBl.MilkAnalysis_SelectAll();
if (objResult != null)
{
if (objResult.ResultDt.Rows.Count > 0)
{
gvMilkAnalysis.DataSource = objResult.ResultDt;
gvMilkAnalysis.DataBind();
PanelVisibilityMode(true, false);
}
else
{
PanelVisibilityMode(false, true);
ClearAll();
}
}
}
catch (Exception ex)
{
throw ex;
}
}
//public void MilkAnalysisGrid()
//{
// try
// {
// ApplicationResult objResult = new ApplicationResult();
// DateTime dtFromDateTime = Convert.ToDateTime(txtFromDate.Text);//DateTime.ParseExact(txtFromDate.Text + " " + txtFromDate.Text, "dd/MM/yyyy HH:mm:ss",
// //CultureInfo.InvariantCulture);
// DateTime dtToDateTime = Convert.ToDateTime(txtToDate.Text);//DateTime.ParseExact(txtToDate.Text + " " + txtToDate.Text, "dd/MM/yyyy HH:mm:ss",
// //CultureInfo.InvariantCulture);
// objResult = new MilkAnalysisBL().MilkAnalysis_SelectAll_DateWise(dtFromDateTime, dtToDateTime);
// //ViewState["DataTableMilkStorage"] = objResult.ResutlDs.Tables[0];
// gvMilkAnalysis.DataSource = objResult.ResultDt;
// gvMilkAnalysis.DataBind();
// //gvTotalQty.DataSource = objResult.ResutlDs.Tables[1];
// //gvTotalQty.DataBind();
// if (gvMilkAnalysis.Rows.Count > 0)
// {
// gvMilkAnalysis.Visible = imgbtnPDF.Visible = imgbtnExcel.Visible = divExport.Visible = true;
// divExport.Visible = true;
// }
// else
// {
// gvMilkAnalysis.Visible = imgbtnPDF.Visible = imgbtnExcel.Visible = divExport.Visible = false;
// divExport.Visible = true;
// gvMilkAnalysis.DataSource = null;
// gvMilkAnalysis.DataBind();
// // 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>");
// }
//}
#endregion
#region Bind MilkAnalysis
private void BindgvMilkAnalysis()
{
try
{
MilkAnalysisBL objMilkAnalysisBl = new MilkAnalysisBL();
DateTime dtFromDateTime = DateTime.ParseExact(txtFromDate.Text, "dd/MM/yyyy",
CultureInfo.InvariantCulture);
DateTime dtToDateTime = DateTime.ParseExact(txtToDate.Text, "dd/MM/yyyy",
CultureInfo.InvariantCulture);
var objResult = objMilkAnalysisBl.MilkAnalysisReport_SelectAll(dtFromDateTime, dtToDateTime);
if (objResult != null)
{
if (objResult.ResultDt.Rows.Count > 0)
{
gvMilkAnalysis.DataSource = objResult.ResultDt;
gvMilkAnalysis.DataBind();
divExport.Visible = true;
}
else
{
divExport.Visible = false;
}
}
}
catch (Exception ex)
{
throw ex;
}
}
protected void gvMilkAnalysis_OnRowCommand(object sender, GridViewCommandEventArgs e)
{
try
{
MilkAnalysisBL objMilkAnalysisBL = new MilkAnalysisBL();
if (e.CommandName == "Edit1")
{
ViewState["Mode"] = "Edit";
ViewState["ID"] = e.CommandArgument.ToString();
var objResult = objMilkAnalysisBL.MilkAnalysis_Select(Convert.ToInt32(ViewState["ID"].ToString()));
if (objResult != null)
{
if (objResult.ResultDt.Rows.Count > 0)
{
txtDate.Text = objResult.ResultDt.Rows[0][MilkAnalysisBO.MILKANALYSIS_DATE].ToString();
txtTime.Text = objResult.ResultDt.Rows[0][MilkAnalysisBO.MILKANALYSIS_TIME].ToString();
ddlSiloId.SelectedValue = objResult.ResultDt.Rows[0][MilkAnalysisBO.MILKANALYSIS_SILOID].ToString();
txtProductType.Text = objResult.ResultDt.Rows[0][MilkAnalysisBO.MILKANALYSIS_PRODUCTTYPE].ToString();
txtSampleId.Text = objResult.ResultDt.Rows[0][MilkAnalysisBO.MILKANALYSIS_SAMPLEID].ToString();
txtFat.Text = objResult.ResultDt.Rows[0][MilkAnalysisBO.MILKANALYSIS_FAT].ToString();
txtSNF.Text = objResult.ResultDt.Rows[0][MilkAnalysisBO.MILKANALYSIS_SNF].ToString();
txtSugar.Text = objResult.ResultDt.Rows[0][MilkAnalysisBO.MILKANALYSIS_SUGAR].ToString();
txtTS.Text = objResult.ResultDt.Rows[0][MilkAnalysisBO.MILKANALYSIS_TS].ToString();
txtAcidity.Text = objResult.ResultDt.Rows[0][MilkAnalysisBO.MILKANALYSIS_ACIDITY].ToString();
txtTemp.Text = objResult.ResultDt.Rows[0][MilkAnalysisBO.MILKANALYSIS_TEMP].ToString();
txtOT.Text = objResult.ResultDt.Rows[0][MilkAnalysisBO.MILKANALYSIS_OT].ToString();
txtRemark.Text = objResult.ResultDt.Rows[0][MilkAnalysisBO.MILKANALYSIS_REMARK].ToString();
//txtVehicleId.Text = objResult.ResultDt.Rows[0][MilkAnalysisBO.MILKANALYSIS_REMARK].ToString();
//txtVehicleNo.Text = objResult.ResultDt.Rows[0][MilkAnalysisBO.MILKANALYSIS_REMARK].ToString();
//txtRouteNo.Text = objResult.ResultDt.Rows[0][MilkAnalysisBO.MILKANALYSIS_REMARK].ToString();
//txtCob.Text = objResult.ResultDt.Rows[0][MilkAnalysisBO.MILKANALYSIS_REMARK].ToString();
//txtAlcohol.Text = objResult.ResultDt.Rows[0][MilkAnalysisBO.MILKANALYSIS_REMARK].ToString();
//txtNeutralizer.Text = objResult.ResultDt.Rows[0][MilkAnalysisBO.MILKANALYSIS_REMARK].ToString();
//txtUrea.Text = objResult.ResultDt.Rows[0][MilkAnalysisBO.MILKANALYSIS_REMARK].ToString();
//txtSalt.Text = objResult.ResultDt.Rows[0][MilkAnalysisBO.MILKANALYSIS_REMARK].ToString();
//txtStarch.Text = objResult.ResultDt.Rows[0][MilkAnalysisBO.MILKANALYSIS_REMARK].ToString();
//txtFpd.Text = objResult.ResultDt.Rows[0][MilkAnalysisBO.MILKANALYSIS_REMARK].ToString();
PanelVisibilityMode(false, true);
}
}
}
else if (e.CommandName == "Delete1")
{
var objResult = objMilkAnalysisBL.MilkAnalysis_Delete(Convert.ToInt32(e.CommandArgument.ToString()), Convert.ToInt32(Session[ApplicationSession.Userid].ToString()), System.DateTime.UtcNow.AddHours(5.5).ToString());
if (objResult.Status == ApplicationResult.CommonStatusType.Success)
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Record Deleted Successfully.');</script>");
BindgvMilkAnalysis();
}
else
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('You can not delete this Reception because it is in used.');</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 btnSave_OnClick(object sender, EventArgs e)
{
try
{
MilkAnalysisBO objMilkAnalysisBO = new MilkAnalysisBO();
MilkAnalysisBL objMilkAnalysisBl = new MilkAnalysisBL();
objMilkAnalysisBO.Date = Convert.ToDateTime(txtDate.Text);
objMilkAnalysisBO.Time = Convert.ToDateTime(txtTime.Text);
objMilkAnalysisBO.SiloId = Convert.ToInt32(ddlSiloId.SelectedValue);
objMilkAnalysisBO.ProductType = txtProductType.Text.Trim();
objMilkAnalysisBO.SampleId = txtSampleId.Text.Trim();
objMilkAnalysisBO.FAT = float.Parse(txtFat.Text.Trim());
objMilkAnalysisBO.SNF = float.Parse(txtSNF.Text.Trim());
objMilkAnalysisBO.Sugar = float.Parse(txtSugar.Text.Trim());
objMilkAnalysisBO.TS = float.Parse(txtTS.Text.Trim());
objMilkAnalysisBO.Acidity = txtAcidity.Text.Trim();
objMilkAnalysisBO.Temp = float.Parse(txtTemp.Text.Trim());
objMilkAnalysisBO.OT = txtOT.Text.Trim();
// objMilkAnalysisBO.VehicleId = txtVehicleId.Text.Trim();
//objMilkAnalysisBO.VehicleNo = txtVehicleNo.Text.Trim();
//objMilkAnalysisBO.RouteNo = txtRouteNo.Text.Trim();
//objMilkAnalysisBO.COB = txtCob.Text.Trim();
//objMilkAnalysisBO.AlcoholNo = txtAlcohol.Text.Trim();
//objMilkAnalysisBO.Neutralizer = txtNeutralizer.Text.Trim();
//objMilkAnalysisBO.Urea = txtUrea.Text.Trim();
//objMilkAnalysisBO.Salt = txtSalt.Text.Trim();
//objMilkAnalysisBO.Starch = txtStarch.Text.Trim();
//objMilkAnalysisBO.FPD = txtFpd.Text.Trim();
objMilkAnalysisBO.UserId = Convert.ToInt32(Session[ApplicationSession.Userid]);
objMilkAnalysisBO.Remark = txtRemark.Text.Trim();
objMilkAnalysisBO.IsDeleted = 0;
if (ViewState["Mode"].ToString() == "Save")
{
objMilkAnalysisBO.CreatedBy = Convert.ToInt32(Session[ApplicationSession.Userid]);
objMilkAnalysisBO.CreatedDate = DateTime.UtcNow.AddHours(5.5);
var objResult = objMilkAnalysisBl.MilkAnalysis_Insert(objMilkAnalysisBO);
if (objResult != null)
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Record Saved Successfully.');</script>");
ClearAll();
BindgvMilkAnalysis();
}
}
else if (ViewState["Mode"].ToString() == "Edit")
{
objMilkAnalysisBO.LastModifiedBy = Convert.ToInt32(Session[ApplicationSession.Userid]);
objMilkAnalysisBO.LastModifiedDate = DateTime.UtcNow.AddHours(5.5);
objMilkAnalysisBO.Id = Convert.ToInt32(ViewState["ID"].ToString());
var objResult = objMilkAnalysisBl.MilkAnalysis_Update(objMilkAnalysisBO);
if (objResult != null)
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Record Updated Successfully.');</script>");
ClearAll();
BindgvMilkAnalysis();
}
}
}
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>");
}
}
