private void BindgvMassBalance()
{
try
{
MassBalanceBl objMassBalanceBl = new MassBalanceBl();
var objResult = objMassBalanceBl.MassBalance_SelectAll();
if (objResult != null)
{
if (objResult.ResultDt.Rows.Count > 0)
{
gvMassBalance.DataSource = objResult.ResultDt;
gvMassBalance.DataBind();
PanelVisibilityMode(true, false);
}
else
{
PanelVisibilityMode(false, true);
}
}
}
catch (Exception ex)
{
throw ex;
}
}
protected void gvMassBalance_OnRowCommand(object sender, GridViewCommandEventArgs e)
{
try
{
MassBalanceBl objMassBalanceBl = new MassBalanceBl();
if (e.CommandName == "Edit1")
{
ViewState["Mode"] = "Edit";
ViewState["MassBalanceID"] = e.CommandArgument.ToString();
var objResult = objMassBalanceBl.MassBalance_Select(Convert.ToInt32(ViewState["MassBalanceID"].ToString()));
if (objResult != null)
{
if (objResult.ResultDt.Rows.Count > 0)
{
txtDate.Text = objResult.ResultDt.Rows[0][MassBalanceBO.MASSBALANCE_DATE].ToString();
txtMilkKg.Text = objResult.ResultDt.Rows[0][MassBalanceBO.MASSBALANCE_MILKKG].ToString();
txtMilkFAT.Text = objResult.ResultDt.Rows[0][MassBalanceBO.MASSBALANCE_FATMILKKG].ToString();
txtMilkSNF.Text = objResult.ResultDt.Rows[0][MassBalanceBO.MASSBALANCE_SNFMILKKG].ToString();
txtMilkSugar.Text = objResult.ResultDt.Rows[0][MassBalanceBO.MASSBALANCE_SUGARMILKKG].ToString();
txtQtyofPowder.Text = objResult.ResultDt.Rows[0][MassBalanceBO.MASSBALANCE_QTYOFPOWDER].ToString();
txtTSFAT.Text = objResult.ResultDt.Rows[0][MassBalanceBO.MASSBALANCE_FATQTY].ToString();
txtTSSNF.Text = objResult.ResultDt.Rows[0][MassBalanceBO.MASSBALANCE_SNFQTY].ToString();
txtTSSugar.Text = objResult.ResultDt.Rows[0][MassBalanceBO.MASSBALANCE_SUGARQTY].ToString();
txtTotalSolid.Text = objResult.ResultDt.Rows[0][MassBalanceBO.MASSBALANCE_TOTALSOLIDKG].ToString();
txtVariation.Text = objResult.ResultDt.Rows[0][MassBalanceBO.MASSBALANCE_VARIATION].ToString();
PanelVisibilityMode(false, true);
}
}
}
else if (e.CommandName == "Delete1")
{
var objResult = objMassBalanceBl.MassBalance_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);
BindgvMassBalance();
}
else
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('You can not delete this MassBalance 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>");
}
}
public DataTable BindMassBalance()
{
try
{
MassBalanceBl objMassBalanceBl = new MassBalanceBl();
var objResult = objMassBalanceBl.MassBalance_SelectAll();
if (objResult != null)
{
return(objResult.ResultDt);
}
else
{
return(null);
}
}
catch (Exception ex)
{
throw ex;
}
}
protected void btnSave_OnClick(object sender, EventArgs e)
{
try
{
MassBalanceBO objMassBalanceBO = new MassBalanceBO();
//ApplicationResult objResult = new ApplicationResult();
MassBalanceBl objMassBalanceBl = new MassBalanceBl();
objMassBalanceBO.Date = DateTime.ParseExact(txtDate.Text.Trim(), "dd/MM/yyyy", CultureInfo.InvariantCulture);
objMassBalanceBO.MilkKg = float.Parse(txtMilkKg.Text.Trim());
objMassBalanceBO.FATMilkKg = float.Parse(txtMilkFAT.Text.Trim());
objMassBalanceBO.SNFMilkKg = float.Parse(txtMilkSNF.Text.Trim());
objMassBalanceBO.SugarMilkKg = float.Parse(txtMilkSugar.Text.Trim());
objMassBalanceBO.QtyOfPowder = float.Parse(txtQtyofPowder.Text.Trim());
objMassBalanceBO.FATQty = float.Parse(txtTSFAT.Text.Trim());
objMassBalanceBO.SNFQty = float.Parse(txtTSSNF.Text.Trim());
objMassBalanceBO.SugarQty = float.Parse(txtTSSugar.Text.Trim());
objMassBalanceBO.TotalSolidKG = float.Parse(txtTotalSolid.Text.Trim());
objMassBalanceBO.Variation = float.Parse(txtVariation.Text.Trim());
objMassBalanceBO.UserId = Convert.ToInt32(Session[ApplicationSession.Userid]);
switch (ViewState["Mode"].ToString())
{
case "Save":
objMassBalanceBO.CreatedBy = Convert.ToInt32(Session[ApplicationSession.Userid]);
objMassBalanceBO.CreatedDate = DateTime.UtcNow.AddHours(5.5);
break;
case "Edit":
objMassBalanceBO.LastModifiedBy = Convert.ToInt32(Session[ApplicationSession.Userid]);
objMassBalanceBO.LastModifiedDate = DateTime.UtcNow.AddHours(5.5);
break;
}
if (ViewState["Mode"].ToString() == "Save")
{
var objResult = objMassBalanceBl.MassBalance_Insert(objMassBalanceBO);
if (objResult.Status == ApplicationResult.CommonStatusType.Success)
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Record Saved Successfully.');</script>");
ClearAll();
BindgvMassBalance();
// PanelVisibilityMode(true, false);
}
}
else if (ViewState["Mode"].ToString() == "Edit")
{
objMassBalanceBO.Id = Convert.ToInt32(ViewState["MassBalanceID"].ToString());
var objResult = objMassBalanceBl.MassBalance_Update(objMassBalanceBO);
if (objResult.Status == ApplicationResult.CommonStatusType.Success)
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Record Updated Successfully.');</script>");
ClearAll();
BindgvMassBalance();
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>");
}
}