private void BindLabReportWMP()
{
try
{
LabReportWMPBl objLabReportWMPBl = new LabReportWMPBl();
var objResult = objLabReportWMPBl.LabReportWMP_SelectAll();
if (objResult != null)
{
if (objResult.ResultDt.Rows.Count > 0)
{
gvLabReportWMP.DataSource = objResult.ResultDt;
gvLabReportWMP.DataBind();
PanelVisibilityMode(true, false);
}
else
{
PanelVisibilityMode(false, true);
}
}
}
catch (Exception ex)
{
throw ex;
}
}
protected void gvLabReportWMP_OnRowCommand(object sender, GridViewCommandEventArgs e)
{
try
{
LabReportWMPBl objLabReportWMPBL = new LabReportWMPBl();
if (e.CommandName == "Edit1")
{
ViewState["Mode"] = "Edit";
ViewState["LabReportWMPID"] = e.CommandArgument.ToString();
var objResult = objLabReportWMPBL.LabReportWMP_Select(Convert.ToInt32(ViewState["LabReportWMPID"].ToString()));
if (objResult != null)
{
if (objResult.ResultDt.Rows.Count > 0)
{
txtDate.Text = objResult.ResultDt.Rows[0][LabReportWMPBo.LABREPORTWMP_DATE].ToString();
txtTypeofPowder.Text = objResult.ResultDt.Rows[0][LabReportWMPBo.LABREPORTWMP_TYPEOFPOWDER].ToString();
txtTime.Text = objResult.ResultDt.Rows[0][LabReportWMPBo.LABREPORTWMP_TIME].ToString();
txtBatchNo.Text = objResult.ResultDt.Rows[0][LabReportWMPBo.LABREPORTWMP_BATCHNO].ToString();
txtBagNos.Text = objResult.ResultDt.Rows[0][LabReportWMPBo.LABREPORTWMP_BAGNOS].ToString();
txtWeight.Text = objResult.ResultDt.Rows[0][LabReportWMPBo.LABREPORTWMP_WEIGHT].ToString();
txtAppearance.Text = objResult.ResultDt.Rows[0][LabReportWMPBo.LABREPORTWMP_APPEARANCE].ToString();
txtMoisture.Text = objResult.ResultDt.Rows[0][LabReportWMPBo.LABREPORTWMP_MOISTURE].ToString();
txtTotalSolids.Text = objResult.ResultDt.Rows[0][LabReportWMPBo.LABREPORTWMP_TOTALSOLID].ToString();
txtBulkDensity.Text = objResult.ResultDt.Rows[0][LabReportWMPBo.LABREPORTWMP_BULKDENSITY].ToString();
txtMilkFat.Text = objResult.ResultDt.Rows[0][LabReportWMPBo.LABREPORTWMP_MILKFAT].ToString();
txtAcidity.Text = objResult.ResultDt.Rows[0][LabReportWMPBo.LABREPORTWMP_ACIDITY].ToString();
txtWettability.Text = objResult.ResultDt.Rows[0][LabReportWMPBo.LABREPORTWMP_WETTABILITY].ToString();
txtScorchedparticle.Text = objResult.ResultDt.Rows[0][LabReportWMPBo.LABREPORTWMP_SCORCHEDPARTICLE].ToString();
txtSolIndex.Text = objResult.ResultDt.Rows[0][LabReportWMPBo.LABREPORTWMP_SOLINDEX].ToString();
txtCoffeeTest.Text = objResult.ResultDt.Rows[0][LabReportWMPBo.LABREPORTWMP_COFFETEST].ToString();
txtFlavour.Text = objResult.ResultDt.Rows[0][LabReportWMPBo.LABREPORTWMP_FLAVOUR].ToString();
txtProtein.Text = objResult.ResultDt.Rows[0][LabReportWMPBo.LABREPORTWMP_PROTEIN].ToString();
txtAsh.Text = objResult.ResultDt.Rows[0][LabReportWMPBo.LABREPORTWMP_ASH].ToString();
txtLumpiness.Text = objResult.ResultDt.Rows[0][LabReportWMPBo.LABREPORTWMP_LUMPINESS].ToString();
txtAdultration.Text = objResult.ResultDt.Rows[0][LabReportWMPBo.LABREPORTWMP_ADULTRATION].ToString();
PanelVisibilityMode(false, true);
}
}
}
else if (e.CommandName == "Delete1")
{
var objResult = objLabReportWMPBL.LabReportWMP_Delete(Convert.ToInt32(e.CommandArgument.ToString()), Convert.ToInt32(Session[ApplicationSession.Userid].ToString()), DateTime.UtcNow.AddHours(5.5).ToString());
if (objResult.Status == ApplicationResult.CommonStatusType.Success)
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Record Deleted Successfully.');</script>");
// PanelVisibilityMode(true, false);
BindLabReportWMP();
}
else
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('You can not delete this LabReportWMP 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
{
LabReportWMPBo objLabReportWMPBo = new LabReportWMPBo();
//ApplicationResult objResult = new ApplicationResult();
LabReportWMPBl objLabReportWMPBl = new LabReportWMPBl();
objLabReportWMPBo.Date = DateTime.ParseExact(txtDate.Text.Trim(), "dd/MM/yyyy", CultureInfo.InvariantCulture);
objLabReportWMPBo.TypeOfPowder = (txtTypeofPowder.Text.Trim());
objLabReportWMPBo.Time = DateTime.ParseExact(txtTime.Text.Trim(), "HH:mm:ss", CultureInfo.InvariantCulture);
objLabReportWMPBo.BatchNo = txtBatchNo.Text.Trim();
objLabReportWMPBo.BagNos = Convert.ToInt32(txtBatchNo.Text.Trim());
objLabReportWMPBo.Weight = float.Parse(txtWeight.Text.Trim());
objLabReportWMPBo.Appearance = txtAppearance.Text.Trim();
objLabReportWMPBo.Moisture = float.Parse(txtMoisture.Text.Trim());
objLabReportWMPBo.TotalSolid = float.Parse(txtTotalSolids.Text.Trim());
objLabReportWMPBo.BulkDensity = float.Parse(txtBulkDensity.Text.Trim());
objLabReportWMPBo.MilkFat = float.Parse(txtMilkFat.Text.Trim());
objLabReportWMPBo.Acidity = txtAcidity.Text.Trim();
objLabReportWMPBo.Wettability = txtWettability.Text.Trim();
objLabReportWMPBo.ScorchedParticle = txtScorchedparticle.Text.Trim();
objLabReportWMPBo.SolIndex = txtSolIndex.Text.Trim();
objLabReportWMPBo.CoffeTest = txtCoffeeTest.Text.Trim();
objLabReportWMPBo.Flavour = txtFlavour.Text.Trim();
objLabReportWMPBo.Protein = txtProtein.Text != "" ? float.Parse(txtProtein.Text.Trim(), CultureInfo.InvariantCulture) : 0;
objLabReportWMPBo.ASH = txtAsh.Text != "" ? float.Parse(txtAsh.Text.Trim(), CultureInfo.InvariantCulture) : 0;
objLabReportWMPBo.Lumpiness = txtLumpiness.Text.Trim();
objLabReportWMPBo.Adultration = txtAdultration.Text.Trim();
objLabReportWMPBo.UserId = Convert.ToInt32(Session[ApplicationSession.Userid]);
switch (ViewState["Mode"].ToString())
{
case "Save":
objLabReportWMPBo.CreatedBy = Convert.ToInt32(Session[ApplicationSession.Userid]);
objLabReportWMPBo.CreatedDate = DateTime.UtcNow.AddHours(5.5);
break;
case "Edit":
objLabReportWMPBo.LastModifiedBy = Convert.ToInt32(Session[ApplicationSession.Userid]);
objLabReportWMPBo.LastModifiedDate = DateTime.UtcNow.AddHours(5.5);
break;
}
if (ViewState["Mode"].ToString() == "Save")
{
var objResult = objLabReportWMPBl.LabReportWMP_Insert(objLabReportWMPBo);
if (objResult.Status == ApplicationResult.CommonStatusType.Success)
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Record Saved Successfully.');</script>");
ClearAll();
BindLabReportWMP();
//PanelVisibilityMode(true, false);
}
}
else if (ViewState["Mode"].ToString() == "Edit")
{
objLabReportWMPBo.Id = Convert.ToInt32(ViewState["LabReportWMPID"].ToString());
var objResult = objLabReportWMPBl.LabReportWMP_Update(objLabReportWMPBo);
if (objResult.Status == ApplicationResult.CommonStatusType.Success)
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Record Updated Successfully.');</script>");
ClearAll();
BindLabReportWMP();
// PanelVisibilityMode(true, 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>");
}
}
