/// <summary>
/// To Update details of MilkAnalysis in MilkAnalysis table
/// Created By : Pavan, 08/07/2017
/// Modified By :
/// </summary>
public ApplicationResult MilkAnalysis_Update(MilkAnalysisBO objMilkAnalysisBO)
{
try
{
pSqlParameter = new SqlParameter[27];
pSqlParameter[0] = new SqlParameter("@Id", SqlDbType.Int);
pSqlParameter[0].Direction = ParameterDirection.Input;
pSqlParameter[0].Value = objMilkAnalysisBO.Id;
pSqlParameter[1] = new SqlParameter("@Time", SqlDbType.DateTime);
pSqlParameter[1].Direction = ParameterDirection.Input;
pSqlParameter[1].Value = objMilkAnalysisBO.Time;
pSqlParameter[2] = new SqlParameter("@SiloId", SqlDbType.Int);
pSqlParameter[2].Direction = ParameterDirection.Input;
pSqlParameter[2].Value = objMilkAnalysisBO.SiloId;
pSqlParameter[3] = new SqlParameter("@ProductType", SqlDbType.VarChar);
pSqlParameter[3].Direction = ParameterDirection.Input;
pSqlParameter[3].Value = objMilkAnalysisBO.ProductType;
pSqlParameter[4] = new SqlParameter("@SampleId", SqlDbType.VarChar);
pSqlParameter[4].Direction = ParameterDirection.Input;
pSqlParameter[4].Value = objMilkAnalysisBO.SampleId;
pSqlParameter[5] = new SqlParameter("@FAT", SqlDbType.Float);
pSqlParameter[5].Direction = ParameterDirection.Input;
pSqlParameter[5].Value = objMilkAnalysisBO.FAT;
pSqlParameter[6] = new SqlParameter("@SNF", SqlDbType.Float);
pSqlParameter[6].Direction = ParameterDirection.Input;
pSqlParameter[6].Value = objMilkAnalysisBO.SNF;
pSqlParameter[7] = new SqlParameter("@Sugar", SqlDbType.Float);
pSqlParameter[7].Direction = ParameterDirection.Input;
pSqlParameter[7].Value = objMilkAnalysisBO.Sugar;
pSqlParameter[8] = new SqlParameter("@TS", SqlDbType.Float);
pSqlParameter[8].Direction = ParameterDirection.Input;
pSqlParameter[8].Value = objMilkAnalysisBO.TS;
pSqlParameter[9] = new SqlParameter("@Acidity", SqlDbType.VarChar);
pSqlParameter[9].Direction = ParameterDirection.Input;
pSqlParameter[9].Value = objMilkAnalysisBO.Acidity;
pSqlParameter[10] = new SqlParameter("@Temp", SqlDbType.Float);
pSqlParameter[10].Direction = ParameterDirection.Input;
pSqlParameter[10].Value = objMilkAnalysisBO.Temp;
pSqlParameter[11] = new SqlParameter("@OT", SqlDbType.VarChar);
pSqlParameter[11].Direction = ParameterDirection.Input;
pSqlParameter[11].Value = objMilkAnalysisBO.OT;
pSqlParameter[12] = new SqlParameter("@UserId", SqlDbType.Int);
pSqlParameter[12].Direction = ParameterDirection.Input;
pSqlParameter[12].Value = objMilkAnalysisBO.UserId;
pSqlParameter[13] = new SqlParameter("@Remarks", SqlDbType.VarChar);
pSqlParameter[13].Direction = ParameterDirection.Input;
pSqlParameter[13].Value = objMilkAnalysisBO.Remark;
pSqlParameter[14] = new SqlParameter("@Date", SqlDbType.DateTime);
pSqlParameter[14].Direction = ParameterDirection.Input;
pSqlParameter[14].Value = objMilkAnalysisBO.Date;
pSqlParameter[15] = new SqlParameter("@LastModifiedBy", SqlDbType.Int);
pSqlParameter[15].Direction = ParameterDirection.Input;
pSqlParameter[15].Value = objMilkAnalysisBO.LastModifiedBy;
pSqlParameter[16] = new SqlParameter("@LastModifiedDate", SqlDbType.DateTime);
pSqlParameter[16].Direction = ParameterDirection.Input;
pSqlParameter[16].Value = objMilkAnalysisBO.LastModifiedDate;
pSqlParameter[17] = new SqlParameter("@VehicleId", SqlDbType.VarChar);
pSqlParameter[17].Direction = ParameterDirection.Input;
pSqlParameter[17].Value = objMilkAnalysisBO.VehicleId;
pSqlParameter[18] = new SqlParameter("@VehicleNo", SqlDbType.VarChar);
pSqlParameter[18].Direction = ParameterDirection.Input;
pSqlParameter[18].Value = objMilkAnalysisBO.VehicleNo;
pSqlParameter[19] = new SqlParameter("@RouteNo", SqlDbType.VarChar);
pSqlParameter[19].Direction = ParameterDirection.Input;
pSqlParameter[19].Value = objMilkAnalysisBO.RouteNo;
pSqlParameter[20] = new SqlParameter("@COB", SqlDbType.VarChar);
pSqlParameter[20].Direction = ParameterDirection.Input;
pSqlParameter[20].Value = objMilkAnalysisBO.COB;
pSqlParameter[21] = new SqlParameter("@AlcoholNo", SqlDbType.VarChar);
pSqlParameter[21].Direction = ParameterDirection.Input;
pSqlParameter[21].Value = objMilkAnalysisBO.AlcoholNo;
pSqlParameter[22] = new SqlParameter("@Neutralizer", SqlDbType.VarChar);
pSqlParameter[22].Direction = ParameterDirection.Input;
pSqlParameter[22].Value = objMilkAnalysisBO.Neutralizer;
pSqlParameter[23] = new SqlParameter("@Urea", SqlDbType.VarChar);
pSqlParameter[23].Direction = ParameterDirection.Input;
pSqlParameter[23].Value = objMilkAnalysisBO.Urea;
pSqlParameter[24] = new SqlParameter("@Salt", SqlDbType.VarChar);
pSqlParameter[24].Direction = ParameterDirection.Input;
pSqlParameter[24].Value = objMilkAnalysisBO.Salt;
pSqlParameter[25] = new SqlParameter("@Starch", SqlDbType.VarChar);
pSqlParameter[25].Direction = ParameterDirection.Input;
pSqlParameter[25].Value = objMilkAnalysisBO.Starch;
pSqlParameter[26] = new SqlParameter("@FPD", SqlDbType.VarChar);
pSqlParameter[26].Direction = ParameterDirection.Input;
pSqlParameter[26].Value = objMilkAnalysisBO.FPD;
sSql = "usp_tbl_MilkAnalysis_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
{
objMilkAnalysisBO = null;
}
}
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>");
}
}
