/// <summary> /// To Update details of ProductDispatch in ProductDispatch table /// Created By : Pavan, 08/07/2017 /// Modified By : /// </summary> public ApplicationResult ProductDispatch_Update(ProductDispatchBo objProductDispatchBO) { try { pSqlParameter = new SqlParameter[17]; pSqlParameter[0] = new SqlParameter("@Id", SqlDbType.Int); pSqlParameter[0].Direction = ParameterDirection.Input; pSqlParameter[0].Value = objProductDispatchBO.Id; pSqlParameter[1] = new SqlParameter("@DeliveryChallan", SqlDbType.VarChar); pSqlParameter[1].Direction = ParameterDirection.Input; pSqlParameter[1].Value = objProductDispatchBO.DeliveryChallan; pSqlParameter[2] = new SqlParameter("@VehicleNo", SqlDbType.VarChar); pSqlParameter[2].Direction = ParameterDirection.Input; pSqlParameter[2].Value = objProductDispatchBO.VehicleNo; pSqlParameter[3] = new SqlParameter("@BatchNo", SqlDbType.VarChar); pSqlParameter[3].Direction = ParameterDirection.Input; pSqlParameter[3].Value = objProductDispatchBO.BatchNo; pSqlParameter[4] = new SqlParameter("@BagNos", SqlDbType.Int); pSqlParameter[4].Direction = ParameterDirection.Input; pSqlParameter[4].Value = objProductDispatchBO.BagNos; pSqlParameter[5] = new SqlParameter("@ProductType", SqlDbType.VarChar); pSqlParameter[5].Direction = ParameterDirection.Input; pSqlParameter[5].Value = objProductDispatchBO.ProductType; pSqlParameter[6] = new SqlParameter("@FAT", SqlDbType.Float); pSqlParameter[6].Direction = ParameterDirection.Input; pSqlParameter[6].Value = objProductDispatchBO.FAT; pSqlParameter[7] = new SqlParameter("@Moisture", SqlDbType.Float); pSqlParameter[7].Direction = ParameterDirection.Input; pSqlParameter[7].Value = objProductDispatchBO.Moisture; pSqlParameter[8] = new SqlParameter("@QualityParamter", SqlDbType.VarChar); pSqlParameter[8].Direction = ParameterDirection.Input; pSqlParameter[8].Value = objProductDispatchBO.QualityParamter; pSqlParameter[9] = new SqlParameter("@Acidity", SqlDbType.VarChar); pSqlParameter[9].Direction = ParameterDirection.Input; pSqlParameter[9].Value = objProductDispatchBO.Acidity; pSqlParameter[10] = new SqlParameter("@QtyDispatch", SqlDbType.Float); pSqlParameter[10].Direction = ParameterDirection.Input; pSqlParameter[10].Value = objProductDispatchBO.QtyDispatch; pSqlParameter[11] = new SqlParameter("@DespatchedTo", SqlDbType.VarChar); pSqlParameter[11].Direction = ParameterDirection.Input; pSqlParameter[11].Value = objProductDispatchBO.DespatchedTo; pSqlParameter[12] = new SqlParameter("@UserId", SqlDbType.Int); pSqlParameter[12].Direction = ParameterDirection.Input; pSqlParameter[12].Value = objProductDispatchBO.UserId; pSqlParameter[13] = new SqlParameter("@Date", SqlDbType.DateTime); pSqlParameter[13].Direction = ParameterDirection.Input; pSqlParameter[13].Value = objProductDispatchBO.Date; pSqlParameter[14] = new SqlParameter("@LastModifiedDate", SqlDbType.DateTime); pSqlParameter[14].Direction = ParameterDirection.Input; pSqlParameter[14].Value = objProductDispatchBO.LastModifiedDate; pSqlParameter[15] = new SqlParameter("@LastModifiedBy", SqlDbType.Int); pSqlParameter[15].Direction = ParameterDirection.Input; pSqlParameter[15].Value = objProductDispatchBO.LastModifiedBy; pSqlParameter[16] = new SqlParameter("@Time", SqlDbType.DateTime); pSqlParameter[16].Direction = ParameterDirection.Input; pSqlParameter[16].Value = objProductDispatchBO.Time; sSql = "usp_tbl_ProductDispatch_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 { objProductDispatchBO = null; } }
protected void btnSave_OnClick(object sender, EventArgs e) { try { ProductDispatchBo objProductDispatchBo = new ProductDispatchBo(); //ApplicationResult objResult = new ApplicationResult(); ProductDispatchBl objProductDispatchBl = new ProductDispatchBl(); objProductDispatchBo.Date = DateTime.ParseExact(txtDate.Text.Trim(), "dd/MM/yyyy", CultureInfo.InvariantCulture); objProductDispatchBo.Time = DateTime.ParseExact(txtTime.Text.Trim(), "HH:mm:ss", CultureInfo.InvariantCulture); objProductDispatchBo.DeliveryChallan = (txtDeliveryChallan.Text.Trim()); objProductDispatchBo.VehicleNo = txtVehicleno.Text.Trim(); objProductDispatchBo.BatchNo = txtBatchNo.Text.Trim(); objProductDispatchBo.BagNos = Convert.ToInt32(txtBagNos.Text.Trim()); objProductDispatchBo.ProductType = txtProducttype.Text.Trim(); objProductDispatchBo.FAT = float.Parse(txtFAT.Text.Trim()); objProductDispatchBo.Moisture = float.Parse(txtMoisture.Text.Trim()); objProductDispatchBo.Acidity = txtAcidity.Text.Trim(); objProductDispatchBo.QualityParamter = txtQualityParameter.Text.Trim(); objProductDispatchBo.QtyDispatch = txtQtyDispatched.Text.Trim(); objProductDispatchBo.DespatchedTo = txtDespatchedtoplace.Text.Trim(); objProductDispatchBo.UserId = Convert.ToInt32(Session[ApplicationSession.Userid]); switch (ViewState["Mode"].ToString()) { case "Save": objProductDispatchBo.CreatedBy = Convert.ToInt32(Session[ApplicationSession.Userid]); objProductDispatchBo.CreatedDate = DateTime.UtcNow.AddHours(5.5); break; case "Edit": objProductDispatchBo.LastModifiedBy = Convert.ToInt32(Session[ApplicationSession.Userid]); objProductDispatchBo.LastModifiedDate = DateTime.UtcNow.AddHours(5.5); break; } if (ViewState["Mode"].ToString() == "Save") { var objResult = objProductDispatchBl.ProductDispatch_Insert(objProductDispatchBo); if (objResult.Status == ApplicationResult.CommonStatusType.Success) { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Record Saved Successfully.');</script>"); ClearAll(); BindProductDispatch(); //PanelVisibilityMode(true, false); } } else if (ViewState["Mode"].ToString() == "Edit") { objProductDispatchBo.Id = Convert.ToInt32(ViewState["ProductDispatchID"].ToString()); var objResult = objProductDispatchBl.ProductDispatch_Update(objProductDispatchBo); if (objResult.Status == ApplicationResult.CommonStatusType.Success) { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Record Updated Successfully.');</script>"); ClearAll(); BindProductDispatch(); // 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>"); } }