/// <summary> /// To Update details of LabReportDW in LabReportDW table /// Created By : Pavan, 08/07/2017 /// Modified By : /// </summary> public ApplicationResult LabReportDW_Update(LabReportDWBo objLabReportDWBO) { try { pSqlParameter = new SqlParameter[26]; pSqlParameter[0] = new SqlParameter("@Id", SqlDbType.Int); pSqlParameter[0].Direction = ParameterDirection.Input; pSqlParameter[0].Value = objLabReportDWBO.Id; pSqlParameter[1] = new SqlParameter("@TypeOfPowder", SqlDbType.VarChar); pSqlParameter[1].Direction = ParameterDirection.Input; pSqlParameter[1].Value = objLabReportDWBO.TypeOfPowder; pSqlParameter[2] = new SqlParameter("@Time", SqlDbType.DateTime); pSqlParameter[2].Direction = ParameterDirection.Input; pSqlParameter[2].Value = objLabReportDWBO.Time; pSqlParameter[3] = new SqlParameter("@BatchNo", SqlDbType.VarChar); pSqlParameter[3].Direction = ParameterDirection.Input; pSqlParameter[3].Value = objLabReportDWBO.BatchNo; pSqlParameter[4] = new SqlParameter("@BagNo", SqlDbType.Int); pSqlParameter[4].Direction = ParameterDirection.Input; pSqlParameter[4].Value = objLabReportDWBO.BagNos; pSqlParameter[5] = new SqlParameter("@Weight", SqlDbType.Float); pSqlParameter[5].Direction = ParameterDirection.Input; pSqlParameter[5].Value = objLabReportDWBO.Weight; pSqlParameter[6] = new SqlParameter("@Appearance", SqlDbType.VarChar); pSqlParameter[6].Direction = ParameterDirection.Input; pSqlParameter[6].Value = objLabReportDWBO.Appearance; pSqlParameter[7] = new SqlParameter("@Moisture", SqlDbType.Float); pSqlParameter[7].Direction = ParameterDirection.Input; pSqlParameter[7].Value = objLabReportDWBO.Moisture; pSqlParameter[8] = new SqlParameter("@TotalSolid", SqlDbType.Float); pSqlParameter[8].Direction = ParameterDirection.Input; pSqlParameter[8].Value = objLabReportDWBO.TotalSolid; pSqlParameter[9] = new SqlParameter("@BulkDensity", SqlDbType.Float); pSqlParameter[9].Direction = ParameterDirection.Input; pSqlParameter[9].Value = objLabReportDWBO.BulkDensity; pSqlParameter[10] = new SqlParameter("@MilkFat", SqlDbType.Float); pSqlParameter[10].Direction = ParameterDirection.Input; pSqlParameter[10].Value = objLabReportDWBO.MilkFat; pSqlParameter[11] = new SqlParameter("@Acidity", SqlDbType.VarChar); pSqlParameter[11].Direction = ParameterDirection.Input; pSqlParameter[11].Value = objLabReportDWBO.Acidity; pSqlParameter[12] = new SqlParameter("@Wettability", SqlDbType.VarChar); pSqlParameter[12].Direction = ParameterDirection.Input; pSqlParameter[12].Value = objLabReportDWBO.Wettability; pSqlParameter[13] = new SqlParameter("@ScorchedParticle", SqlDbType.VarChar); pSqlParameter[13].Direction = ParameterDirection.Input; pSqlParameter[13].Value = objLabReportDWBO.ScorchedParticle; pSqlParameter[14] = new SqlParameter("@SolIndex", SqlDbType.VarChar); pSqlParameter[14].Direction = ParameterDirection.Input; pSqlParameter[14].Value = objLabReportDWBO.SolIndex; pSqlParameter[15] = new SqlParameter("@CoffeTest", SqlDbType.VarChar); pSqlParameter[15].Direction = ParameterDirection.Input; pSqlParameter[15].Value = objLabReportDWBO.CoffeTest; pSqlParameter[16] = new SqlParameter("@Flavour", SqlDbType.VarChar); pSqlParameter[16].Direction = ParameterDirection.Input; pSqlParameter[16].Value = objLabReportDWBO.Flavour; pSqlParameter[17] = new SqlParameter("@Protein", SqlDbType.Float); pSqlParameter[17].Direction = ParameterDirection.Input; pSqlParameter[17].Value = objLabReportDWBO.Protein; pSqlParameter[18] = new SqlParameter("@ASH", SqlDbType.Float); pSqlParameter[18].Direction = ParameterDirection.Input; pSqlParameter[18].Value = objLabReportDWBO.ASH; pSqlParameter[19] = new SqlParameter("@Lumpiness", SqlDbType.VarChar); pSqlParameter[19].Direction = ParameterDirection.Input; pSqlParameter[19].Value = objLabReportDWBO.Lumpiness; pSqlParameter[20] = new SqlParameter("@Adultration", SqlDbType.VarChar); pSqlParameter[20].Direction = ParameterDirection.Input; pSqlParameter[20].Value = objLabReportDWBO.Adultration; pSqlParameter[21] = new SqlParameter("@UserId", SqlDbType.Int); pSqlParameter[21].Direction = ParameterDirection.Input; pSqlParameter[21].Value = objLabReportDWBO.UserId; pSqlParameter[22] = new SqlParameter("@Date", SqlDbType.DateTime); pSqlParameter[22].Direction = ParameterDirection.Input; pSqlParameter[22].Value = objLabReportDWBO.Date; pSqlParameter[23] = new SqlParameter("@LastModifiedDate", SqlDbType.DateTime); pSqlParameter[23].Direction = ParameterDirection.Input; pSqlParameter[23].Value = objLabReportDWBO.LastModifiedDate; pSqlParameter[24] = new SqlParameter("@LastModifiedBy", SqlDbType.Int); pSqlParameter[24].Direction = ParameterDirection.Input; pSqlParameter[24].Value = objLabReportDWBO.LastModifiedBy; pSqlParameter[25] = new SqlParameter("@Sugar", SqlDbType.Float); pSqlParameter[25].Direction = ParameterDirection.Input; pSqlParameter[25].Value = objLabReportDWBO.Sugar; sSql = "usp_tbl_LabReportDW_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 { objLabReportDWBO = null; } }
protected void btnSave_OnClick(object sender, EventArgs e) { try { LabReportDWBo objLabReportDWBo = new LabReportDWBo(); //ApplicationResult objResult = new ApplicationResult(); LabReportDWBl objLabReportDWBl = new LabReportDWBl(); objLabReportDWBo.Date = DateTime.ParseExact(txtDate.Text.Trim(), "dd/MM/yyyy", CultureInfo.InvariantCulture); objLabReportDWBo.TypeOfPowder = (txtTypeofPowder.Text.Trim()); objLabReportDWBo.Time = DateTime.ParseExact(txtTime.Text.Trim(), "HH:mm:ss", CultureInfo.InvariantCulture); objLabReportDWBo.BatchNo = txtBatchNo.Text.Trim(); objLabReportDWBo.BagNos = Convert.ToInt32(txtBatchNo.Text.Trim()); objLabReportDWBo.Weight = float.Parse(txtWeight.Text.Trim()); objLabReportDWBo.Appearance = txtAppearance.Text.Trim(); objLabReportDWBo.Moisture = float.Parse(txtMoisture.Text.Trim()); objLabReportDWBo.TotalSolid = float.Parse(txtTotalSolids.Text.Trim()); objLabReportDWBo.BulkDensity = float.Parse(txtBulkDensity.Text.Trim()); objLabReportDWBo.MilkFat = float.Parse(txtMilkFat.Text.Trim()); objLabReportDWBo.Sugar = float.Parse(txtMilkFat.Text.Trim()); objLabReportDWBo.Acidity = txtAcidity.Text.Trim(); objLabReportDWBo.Wettability = txtWettability.Text.Trim(); objLabReportDWBo.ScorchedParticle = txtScorchedparticle.Text.Trim(); objLabReportDWBo.SolIndex = txtSolIndex.Text.Trim(); objLabReportDWBo.CoffeTest = txtCoffeeTest.Text.Trim(); objLabReportDWBo.Flavour = txtFlavour.Text.Trim(); objLabReportDWBo.Protein = float.Parse(txtProtein.Text.Trim()); objLabReportDWBo.ASH = float.Parse(txtAsh.Text.Trim()); objLabReportDWBo.Lumpiness = txtLumpiness.Text.Trim(); objLabReportDWBo.Adultration = txtAdultration.Text.Trim(); objLabReportDWBo.UserId = Convert.ToInt32(Session[ApplicationSession.Userid]); switch (ViewState["Mode"].ToString()) { case "Save": objLabReportDWBo.CreatedBy = Convert.ToInt32(Session[ApplicationSession.Userid]); objLabReportDWBo.CreatedDate = DateTime.UtcNow.AddHours(5.5); break; case "Edit": objLabReportDWBo.LastModifiedBy = Convert.ToInt32(Session[ApplicationSession.Userid]); objLabReportDWBo.LastModifiedDate = DateTime.UtcNow.AddHours(5.5); break; } if (ViewState["Mode"].ToString() == "Save") { var objResult = objLabReportDWBl.LabReportDW_Insert(objLabReportDWBo); if (objResult.Status == ApplicationResult.CommonStatusType.Success) { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Record Saved Successfully.');</script>"); ClearAll(); BindLabReportDW(); //PanelVisibilityMode(true, false); } } else if (ViewState["Mode"].ToString() == "Edit") { objLabReportDWBo.Id = Convert.ToInt32(ViewState["LabReportDWID"].ToString()); var objResult = objLabReportDWBl.LabReportDW_Update(objLabReportDWBo); if (objResult.Status == ApplicationResult.CommonStatusType.Success) { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Record Updated Successfully.');</script>"); ClearAll(); BindLabReportDW(); // 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>"); } }