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; } }