protected void btnSave_OnClick(object sender, EventArgs e)
{
try
{
if (txtVehicleNo.Text == hfVehicleNo.Value)
{
LabReportBo objLabReportBo = new LabReportBo();
ApplicationResult objResult = new ApplicationResult();
LabReportBl objLabReportBl = new LabReportBl();
objLabReportBo.LabDate = txtLabDate.Text.Trim();
objLabReportBo.VehicleId = Convert.ToInt32(hfVehicleId.Value);
objLabReportBo.VehicleCode = txtVehicleId.Text;
// objLabReportBo.RouteId = Convert.ToInt32(ddlRouteNo.SelectedValue);
objLabReportBo.ProductId = Convert.ToInt32(ddlProduct.SelectedValue);
objLabReportBo.OT = (ddlOT.SelectedValue != "-1") ? Convert.ToInt32(ddlOT.SelectedValue) : -1;
objLabReportBo.Temp = (txtTemp.Text != "") ? Convert.ToDouble(txtTemp.Text) : 0.0;
objLabReportBo.Fat = (txtFat.Text != "") ? Convert.ToDouble(txtFat.Text) : 0.0;
objLabReportBo.SNF = (txtSNF.Text != "") ? Convert.ToDouble(txtSNF.Text) : 0.0;
objLabReportBo.Acidity = (txtAcidity.Text != "") ? Convert.ToDouble(txtAcidity.Text) : 0.0;
objLabReportBo.COB = (ddlCOB.SelectedValue != "-1") ? ddlCOB.SelectedValue : "-1";
objLabReportBo.AlcoholNo = txtAlcoholNo.Text;
objLabReportBo.Neutralizer = (ddlNeutralizer.SelectedValue != "-1") ? ddlNeutralizer.SelectedValue : "-1";
objLabReportBo.Urea = (ddlUrea.SelectedValue != "-1") ? ddlUrea.SelectedValue : "-1";
objLabReportBo.Salt = (ddlSalt.SelectedValue != "-1") ? ddlSalt.SelectedValue : "-1";
objLabReportBo.Startch = (ddlStartch.SelectedValue != "-1") ? ddlStartch.SelectedValue : "-1";
objLabReportBo.FPD = txtFPD.Text;
objLabReportBo.Status = Convert.ToInt32(ddlStatus.SelectedValue);
if (ViewState["Mode"].ToString() == "Save")
{
objLabReportBo.CreatedBy = Convert.ToInt32(Session[ApplicationSession.Userid]);
objLabReportBo.CreatedDate = DateTime.UtcNow.AddHours(5.5);
objResult = objLabReportBl.LabReport_Insert(objLabReportBo);
if (objResult.Status == ApplicationResult.CommonStatusType.Success)
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Record Saved Successfully.');</script>");
ClearAll();
getDatesofMonth();
PanelVisibilityMode(true, false);
}
}
else if (ViewState["Mode"].ToString() == "Edit")
{
objLabReportBo.Id = Convert.ToInt32(ViewState["ID"].ToString());
objLabReportBo.LastModifiedBy = Convert.ToInt32(Session[ApplicationSession.Userid]);
objLabReportBo.LastModifiedDate = DateTime.UtcNow.AddHours(5.5);
objResult = objLabReportBl.LabReport_Update(objLabReportBo);
if (objResult.Status == ApplicationResult.CommonStatusType.Success)
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Record Updated Successfully.');</script>");
ClearAll();
getDatesofMonth();
PanelVisibilityMode(true, false);
}
}
}
else
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Vehicle No is not exist.');</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>");
}
}
/// <summary>
/// To Update details of LabReport in LabReport table
/// Created By : Chintan, 19-12-2015
/// Modified By :
/// </summary>
public ApplicationResult LabReport_Update(LabReportBo objLabReportBo)
{
try
{
pSqlParameter = new SqlParameter[21];
pSqlParameter[0] = new SqlParameter("@Id", SqlDbType.Int);
pSqlParameter[0].Direction = ParameterDirection.Input;
pSqlParameter[0].Value = objLabReportBo.Id;
pSqlParameter[1] = new SqlParameter("@LabDate", SqlDbType.VarChar);
pSqlParameter[1].Direction = ParameterDirection.Input;
pSqlParameter[1].Value = objLabReportBo.LabDate;
pSqlParameter[2] = new SqlParameter("@VehicleId", SqlDbType.Int);
pSqlParameter[2].Direction = ParameterDirection.Input;
pSqlParameter[2].Value = objLabReportBo.VehicleId;
pSqlParameter[3] = new SqlParameter("@VehicleCode", SqlDbType.VarChar);
pSqlParameter[3].Direction = ParameterDirection.Input;
pSqlParameter[3].Value = objLabReportBo.VehicleCode;
pSqlParameter[4] = new SqlParameter("@RouteId", SqlDbType.Int);
pSqlParameter[4].Direction = ParameterDirection.Input;
pSqlParameter[4].Value = objLabReportBo.RouteId;
pSqlParameter[5] = new SqlParameter("@ProductId", SqlDbType.Int);
pSqlParameter[5].Direction = ParameterDirection.Input;
pSqlParameter[5].Value = objLabReportBo.ProductId;
pSqlParameter[6] = new SqlParameter("@OT", SqlDbType.Int);
pSqlParameter[6].Direction = ParameterDirection.Input;
pSqlParameter[6].Value = objLabReportBo.OT;
pSqlParameter[7] = new SqlParameter("@Temp", SqlDbType.Real);
pSqlParameter[7].Direction = ParameterDirection.Input;
pSqlParameter[7].Value = objLabReportBo.Temp;
pSqlParameter[8] = new SqlParameter("@Fat", SqlDbType.Real);
pSqlParameter[8].Direction = ParameterDirection.Input;
pSqlParameter[8].Value = objLabReportBo.Fat;
pSqlParameter[9] = new SqlParameter("@SNF", SqlDbType.Real);
pSqlParameter[9].Direction = ParameterDirection.Input;
pSqlParameter[9].Value = objLabReportBo.SNF;
pSqlParameter[10] = new SqlParameter("@Acidity", SqlDbType.Real);
pSqlParameter[10].Direction = ParameterDirection.Input;
pSqlParameter[10].Value = objLabReportBo.Acidity;
pSqlParameter[11] = new SqlParameter("@COB", SqlDbType.VarChar);
pSqlParameter[11].Direction = ParameterDirection.Input;
pSqlParameter[11].Value = objLabReportBo.COB;
pSqlParameter[12] = new SqlParameter("@AlcoholNo", SqlDbType.VarChar);
pSqlParameter[12].Direction = ParameterDirection.Input;
pSqlParameter[12].Value = objLabReportBo.AlcoholNo;
pSqlParameter[13] = new SqlParameter("@Neutralizer", SqlDbType.VarChar);
pSqlParameter[13].Direction = ParameterDirection.Input;
pSqlParameter[13].Value = objLabReportBo.Neutralizer;
pSqlParameter[14] = new SqlParameter("@Urea", SqlDbType.VarChar);
pSqlParameter[14].Direction = ParameterDirection.Input;
pSqlParameter[14].Value = objLabReportBo.Urea;
pSqlParameter[15] = new SqlParameter("@Salt", SqlDbType.VarChar);
pSqlParameter[15].Direction = ParameterDirection.Input;
pSqlParameter[15].Value = objLabReportBo.Salt;
pSqlParameter[16] = new SqlParameter("@Startch", SqlDbType.VarChar);
pSqlParameter[16].Direction = ParameterDirection.Input;
pSqlParameter[16].Value = objLabReportBo.Startch;
pSqlParameter[17] = new SqlParameter("@FPD", SqlDbType.VarChar);
pSqlParameter[17].Direction = ParameterDirection.Input;
pSqlParameter[17].Value = objLabReportBo.FPD;
pSqlParameter[18] = new SqlParameter("@Status", SqlDbType.Int);
pSqlParameter[18].Direction = ParameterDirection.Input;
pSqlParameter[18].Value = objLabReportBo.Status;
pSqlParameter[19] = new SqlParameter("@LastModifiedBy", SqlDbType.Int);
pSqlParameter[19].Direction = ParameterDirection.Input;
pSqlParameter[19].Value = objLabReportBo.LastModifiedBy;
pSqlParameter[20] = new SqlParameter("@LastModifiedDate", SqlDbType.DateTime);
pSqlParameter[20].Direction = ParameterDirection.Input;
pSqlParameter[20].Value = objLabReportBo.LastModifiedDate;
sSql = "usp_tbl_LabReport_Update";
int iResult = Database.ExecuteNonQuery(CommandType.StoredProcedure, sSql, pSqlParameter);
if (iResult > 0)
{
ApplicationResult objResults = new ApplicationResult();
objResults.Status = ApplicationResult.CommonStatusType.Success;
return(objResults);
}
else
{
ApplicationResult objResults = new ApplicationResult();
objResults.Status = ApplicationResult.CommonStatusType.Failure;
return(objResults);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
objLabReportBo = null;
}
}
