private void BindProductDispatch() { try { ProductDispatchBl objProductDispatchBl = new ProductDispatchBl(); var objResult = objProductDispatchBl.ProductDispatch_SelectAll(); if (objResult != null) { if (objResult.ResultDt.Rows.Count > 0) { gvProductDispatch.DataSource = objResult.ResultDt; gvProductDispatch.DataBind(); PanelVisibilityMode(true, false); } else { PanelVisibilityMode(false, true); } } } catch (Exception ex) { throw ex; } }
protected void gvProductDispatch_OnRowCommand(object sender, GridViewCommandEventArgs e) { try { ProductDispatchBl objProductDispatchBL = new ProductDispatchBl(); if (e.CommandName == "Edit1") { ViewState["Mode"] = "Edit"; ViewState["ProductDispatchID"] = e.CommandArgument.ToString(); var objResult = objProductDispatchBL.ProductDispatch_Select(Convert.ToInt32(ViewState["ProductDispatchID"].ToString())); if (objResult != null) { if (objResult.ResultDt.Rows.Count > 0) { txtDate.Text = objResult.ResultDt.Rows[0][ProductDispatchBo.PRODUCTDISPATCH_DATE].ToString(); txtTime.Text = objResult.ResultDt.Rows[0][ProductDispatchBo.PRODUCTDISPATCH_TIME].ToString(); txtDeliveryChallan.Text = objResult.ResultDt.Rows[0][ProductDispatchBo.PRODUCTDISPATCH_DELIVERYCHALLAN].ToString(); txtVehicleno.Text = objResult.ResultDt.Rows[0][ProductDispatchBo.PRODUCTDISPATCH_VEHICLENO].ToString(); txtBatchNo.Text = objResult.ResultDt.Rows[0][ProductDispatchBo.PRODUCTDISPATCH_BATCHNO].ToString(); txtBagNos.Text = objResult.ResultDt.Rows[0][ProductDispatchBo.PRODUCTDISPATCH_BAGNOS].ToString(); txtProducttype.Text = objResult.ResultDt.Rows[0][ProductDispatchBo.PRODUCTDISPATCH_PRODUCTTYPE].ToString(); txtFAT.Text = objResult.ResultDt.Rows[0][ProductDispatchBo.PRODUCTDISPATCH_FAT].ToString(); txtMoisture.Text = objResult.ResultDt.Rows[0][ProductDispatchBo.PRODUCTDISPATCH_MOISTURE].ToString(); txtAcidity.Text = objResult.ResultDt.Rows[0][ProductDispatchBo.PRODUCTDISPATCH_ACIDITY].ToString(); txtQualityParameter.Text = objResult.ResultDt.Rows[0][ProductDispatchBo.PRODUCTDISPATCH_QUALITYPARAMETER].ToString(); txtQtyDispatched.Text = objResult.ResultDt.Rows[0][ProductDispatchBo.PRODUCTDISPATCH_QTYDISPATCH].ToString(); txtDespatchedtoplace.Text = objResult.ResultDt.Rows[0][ProductDispatchBo.PRODUCTDISPATCH_DESPATCHEDTO].ToString(); PanelVisibilityMode(false, true); } } } else if (e.CommandName == "Delete1") { var objResult = objProductDispatchBL.ProductDispatch_Delete(Convert.ToInt32(e.CommandArgument.ToString()), Convert.ToInt32(Session[ApplicationSession.Userid].ToString()), DateTime.UtcNow.AddHours(5.5).ToString()); if (objResult.Status == ApplicationResult.CommonStatusType.Success) { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Record Deleted Successfully.');</script>"); // PanelVisibilityMode(true, false); BindProductDispatch(); } else { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('You can not delete this ProductDispatch because it is in used.');</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>"); } }
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>"); } }