private void BindLabReportDW()
{
try
{
LabReportDWBl objLabReportDWBl = new LabReportDWBl();
var objResult = objLabReportDWBl.LabReportDW_SelectAll();
if (objResult != null)
{
if (objResult.ResultDt.Rows.Count > 0)
{
gvLabReportDW.DataSource = objResult.ResultDt;
gvLabReportDW.DataBind();
PanelVisibilityMode(true, false);
}
else
{
PanelVisibilityMode(false, true);
}
}
}
catch (Exception ex)
{
throw ex;
}
}
protected void gvLabReportDW_OnRowCommand(object sender, GridViewCommandEventArgs e)
{
try
{
LabReportDWBl objLabReportDWBL = new LabReportDWBl();
if (e.CommandName == "Edit1")
{
ViewState["Mode"] = "Edit";
ViewState["LabReportDWID"] = e.CommandArgument.ToString();
var objResult = objLabReportDWBL.LabReportDW_Select(Convert.ToInt32(ViewState["LabReportDWID"].ToString()));
if (objResult != null)
{
if (objResult.ResultDt.Rows.Count > 0)
{
txtDate.Text = objResult.ResultDt.Rows[0][LabReportDWBo.LABREPORTDW_DATE].ToString();
txtTypeofPowder.Text = objResult.ResultDt.Rows[0][LabReportDWBo.LABREPORTDW_TYPEOFPOWDER].ToString();
txtTime.Text = objResult.ResultDt.Rows[0][LabReportDWBo.LABREPORTDW_TIME].ToString();
txtBatchNo.Text = objResult.ResultDt.Rows[0][LabReportDWBo.LABREPORTDW_BATCHNO].ToString();
txtBagNos.Text = objResult.ResultDt.Rows[0][LabReportDWBo.LABREPORTDW_BAGNOS].ToString();
txtWeight.Text = objResult.ResultDt.Rows[0][LabReportDWBo.LABREPORTDW_WEIGHT].ToString();
txtAppearance.Text = objResult.ResultDt.Rows[0][LabReportDWBo.LABREPORTDW_APPEARANCE].ToString();
txtMoisture.Text = objResult.ResultDt.Rows[0][LabReportDWBo.LABREPORTDW_MOISTURE].ToString();
txtTotalSolids.Text = objResult.ResultDt.Rows[0][LabReportDWBo.LABREPORTDW_TOTALSOLID].ToString();
txtBulkDensity.Text = objResult.ResultDt.Rows[0][LabReportDWBo.LABREPORTDW_BULKDENSITY].ToString();
txtMilkFat.Text = objResult.ResultDt.Rows[0][LabReportDWBo.LABREPORTDW_MILKFAT].ToString();
txtAcidity.Text = objResult.ResultDt.Rows[0][LabReportDWBo.LABREPORTDW_ACIDITY].ToString();
txtWettability.Text = objResult.ResultDt.Rows[0][LabReportDWBo.LABREPORTDW_WETTABILITY].ToString();
txtScorchedparticle.Text = objResult.ResultDt.Rows[0][LabReportDWBo.LABREPORTDW_SCORCHEDPARTICLE].ToString();
txtSolIndex.Text = objResult.ResultDt.Rows[0][LabReportDWBo.LABREPORTDW_SOLINDEX].ToString();
txtCoffeeTest.Text = objResult.ResultDt.Rows[0][LabReportDWBo.LABREPORTDW_COFFETEST].ToString();
txtFlavour.Text = objResult.ResultDt.Rows[0][LabReportDWBo.LABREPORTDW_FLAVOUR].ToString();
txtProtein.Text = objResult.ResultDt.Rows[0][LabReportDWBo.LABREPORTDW_PROTEIN].ToString();
txtAsh.Text = objResult.ResultDt.Rows[0][LabReportDWBo.LABREPORTDW_ASH].ToString();
txtLumpiness.Text = objResult.ResultDt.Rows[0][LabReportDWBo.LABREPORTDW_LUMPINESS].ToString();
txtAdultration.Text = objResult.ResultDt.Rows[0][LabReportDWBo.LABREPORTDW_ADULTRATION].ToString();
PanelVisibilityMode(false, true);
}
}
}
else if (e.CommandName == "Delete1")
{
var objResult = objLabReportDWBL.LabReportDW_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);
BindLabReportDW();
}
else
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('You can not delete this LabReportDW 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
{
LabReportDWBo objLabReportDWBo = new LabReportDWBo();
//ApplicationResult objResult = new ApplicationResult();
LabReportDWBl objLabReportDWBl = new LabReportDWBl();
objLabReportDWBo.Date = DateTime.ParseExact(txtDate.Text.Trim(), "dd/MM/yyyy", CultureInfo.InvariantCulture);
objLabReportDWBo.TypeOfPowder = (txtTypeofPowder.Text.Trim());
objLabReportDWBo.Time = DateTime.ParseExact(txtTime.Text.Trim(), "HH:mm:ss", CultureInfo.InvariantCulture);
objLabReportDWBo.BatchNo = txtBatchNo.Text.Trim();
objLabReportDWBo.BagNos = Convert.ToInt32(txtBatchNo.Text.Trim());
objLabReportDWBo.Weight = float.Parse(txtWeight.Text.Trim());
objLabReportDWBo.Appearance = txtAppearance.Text.Trim();
objLabReportDWBo.Moisture = float.Parse(txtMoisture.Text.Trim());
objLabReportDWBo.TotalSolid = float.Parse(txtTotalSolids.Text.Trim());
objLabReportDWBo.BulkDensity = float.Parse(txtBulkDensity.Text.Trim());
objLabReportDWBo.MilkFat = float.Parse(txtMilkFat.Text.Trim());
objLabReportDWBo.Sugar = float.Parse(txtMilkFat.Text.Trim());
objLabReportDWBo.Acidity = txtAcidity.Text.Trim();
objLabReportDWBo.Wettability = txtWettability.Text.Trim();
objLabReportDWBo.ScorchedParticle = txtScorchedparticle.Text.Trim();
objLabReportDWBo.SolIndex = txtSolIndex.Text.Trim();
objLabReportDWBo.CoffeTest = txtCoffeeTest.Text.Trim();
objLabReportDWBo.Flavour = txtFlavour.Text.Trim();
objLabReportDWBo.Protein = float.Parse(txtProtein.Text.Trim());
objLabReportDWBo.ASH = float.Parse(txtAsh.Text.Trim());
objLabReportDWBo.Lumpiness = txtLumpiness.Text.Trim();
objLabReportDWBo.Adultration = txtAdultration.Text.Trim();
objLabReportDWBo.UserId = Convert.ToInt32(Session[ApplicationSession.Userid]);
switch (ViewState["Mode"].ToString())
{
case "Save":
objLabReportDWBo.CreatedBy = Convert.ToInt32(Session[ApplicationSession.Userid]);
objLabReportDWBo.CreatedDate = DateTime.UtcNow.AddHours(5.5);
break;
case "Edit":
objLabReportDWBo.LastModifiedBy = Convert.ToInt32(Session[ApplicationSession.Userid]);
objLabReportDWBo.LastModifiedDate = DateTime.UtcNow.AddHours(5.5);
break;
}
if (ViewState["Mode"].ToString() == "Save")
{
var objResult = objLabReportDWBl.LabReportDW_Insert(objLabReportDWBo);
if (objResult.Status == ApplicationResult.CommonStatusType.Success)
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Record Saved Successfully.');</script>");
ClearAll();
BindLabReportDW();
//PanelVisibilityMode(true, false);
}
}
else if (ViewState["Mode"].ToString() == "Edit")
{
objLabReportDWBo.Id = Convert.ToInt32(ViewState["LabReportDWID"].ToString());
var objResult = objLabReportDWBl.LabReportDW_Update(objLabReportDWBo);
if (objResult.Status == ApplicationResult.CommonStatusType.Success)
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Record Updated Successfully.');</script>");
ClearAll();
BindLabReportDW();
// 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>");
}
}
