protected void btnSave_OnClick(object sender, EventArgs e)
{
try
{
PowderProductionBo objPowderProductionBO = new PowderProductionBo();
PowderProductionBl objPowderProductionBl = new PowderProductionBl();
objPowderProductionBO.Date = Convert.ToDateTime(txtDate.Text);
objPowderProductionBO.ProductType = Convert.ToDateTime(txtProductType.Text);
objPowderProductionBO.BatchNo = txtBatchNo.Text;
objPowderProductionBO.ProductionTime = Convert.ToDateTime(txtProductionTime.Text.Trim());
objPowderProductionBO.PackQuantity = Convert.ToInt32(txtPackQuantity.Text.Trim());
objPowderProductionBO.TypePacking = txtTypePacking.Text.Trim();
objPowderProductionBO.NoOfUnits = Convert.ToInt32(txtNOU.Text.Trim());
objPowderProductionBO.QualityParameter = txtQualityParameters.Text.Trim();
objPowderProductionBO.UserId = Convert.ToInt32(Session[ApplicationSession.Userid]);
objPowderProductionBO.Remark = txtRemark.Text.Trim();
objPowderProductionBO.IsDeleted = 0;
if (ViewState["Mode"].ToString() == "Save")
{
objPowderProductionBO.CreatedBy = Convert.ToInt32(Session[ApplicationSession.Userid]);
objPowderProductionBO.CreatedDate = DateTime.UtcNow.AddHours(5.5);
var objResult = objPowderProductionBl.PowderProduction_Insert(objPowderProductionBO);
if (objResult != null)
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Record Saved Successfully.');</script>");
ClearAll();
BindgvPowderProduction();
}
}
else if (ViewState["Mode"].ToString() == "Edit")
{
objPowderProductionBO.LastModifiedBy = Convert.ToInt32(Session[ApplicationSession.Userid]);
objPowderProductionBO.LastModifiedDate = DateTime.UtcNow.AddHours(5.5);
objPowderProductionBO.Id = Convert.ToInt32(ViewState["ID"].ToString());
var objResult = objPowderProductionBl.PowderProduction_Update(objPowderProductionBO);
if (objResult != null)
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Record Updated Successfully.');</script>");
ClearAll();
BindgvPowderProduction();
}
}
}
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>");
}
}
/// <summary>
/// To Update details of PowderProduction in PowderProduction table
/// Created By : Pavan, 08/07/2017
/// Modified By :
/// </summary>
public ApplicationResult PowderProduction_Update(PowderProductionBo objPowderProductionBO)
{
try
{
pSqlParameter = new SqlParameter[13];
pSqlParameter[0] = new SqlParameter("@Id", SqlDbType.Int);
pSqlParameter[0].Direction = ParameterDirection.Input;
pSqlParameter[0].Value = objPowderProductionBO.Id;
pSqlParameter[1] = new SqlParameter("@ProductType", SqlDbType.DateTime);
pSqlParameter[1].Direction = ParameterDirection.Input;
pSqlParameter[1].Value = objPowderProductionBO.ProductType;
pSqlParameter[2] = new SqlParameter("@BatchNo", SqlDbType.VarChar);
pSqlParameter[2].Direction = ParameterDirection.Input;
pSqlParameter[2].Value = objPowderProductionBO.BatchNo;
pSqlParameter[3] = new SqlParameter("@ProductionTime", SqlDbType.DateTime);
pSqlParameter[3].Direction = ParameterDirection.Input;
pSqlParameter[3].Value = objPowderProductionBO.ProductionTime;
pSqlParameter[4] = new SqlParameter("@PackQuantity", SqlDbType.Int);
pSqlParameter[4].Direction = ParameterDirection.Input;
pSqlParameter[4].Value = objPowderProductionBO.PackQuantity;
pSqlParameter[5] = new SqlParameter("@TypeOfpacking", SqlDbType.VarChar);
pSqlParameter[5].Direction = ParameterDirection.Input;
pSqlParameter[5].Value = objPowderProductionBO.TypePacking;
pSqlParameter[6] = new SqlParameter("@NoOfUnits", SqlDbType.Int);
pSqlParameter[6].Direction = ParameterDirection.Input;
pSqlParameter[6].Value = objPowderProductionBO.NoOfUnits;
pSqlParameter[7] = new SqlParameter("@QualityParameter", SqlDbType.VarChar);
pSqlParameter[7].Direction = ParameterDirection.Input;
pSqlParameter[7].Value = objPowderProductionBO.QualityParameter;
pSqlParameter[8] = new SqlParameter("@UserId", SqlDbType.Int);
pSqlParameter[8].Direction = ParameterDirection.Input;
pSqlParameter[8].Value = objPowderProductionBO.UserId;
pSqlParameter[9] = new SqlParameter("@Remarks", SqlDbType.VarChar);
pSqlParameter[9].Direction = ParameterDirection.Input;
pSqlParameter[9].Value = objPowderProductionBO.Remark;
pSqlParameter[10] = new SqlParameter("@Date", SqlDbType.DateTime);
pSqlParameter[10].Direction = ParameterDirection.Input;
pSqlParameter[10].Value = objPowderProductionBO.Date;
pSqlParameter[11] = new SqlParameter("@LastModifiedBy", SqlDbType.Int);
pSqlParameter[11].Direction = ParameterDirection.Input;
pSqlParameter[11].Value = objPowderProductionBO.LastModifiedBy;
pSqlParameter[12] = new SqlParameter("@LastModifiedDate", SqlDbType.DateTime);
pSqlParameter[12].Direction = ParameterDirection.Input;
pSqlParameter[12].Value = objPowderProductionBO.LastModifiedDate;
sSql = "usp_tbl_PowderProduction_Update";
DataTable dtResult = new DataTable();
dtResult = Database.ExecuteDataTable(CommandType.StoredProcedure, sSql, pSqlParameter);
ApplicationResult objResults = new ApplicationResult(dtResult);
objResults.Status = ApplicationResult.CommonStatusType.Success;
return(objResults);
}
catch (Exception ex)
{
throw ex;
}
finally
{
objPowderProductionBO = null;
}
}
