public bool CancelGRN(Guid GRNId, string TrackingNo, RequestforApprovedGRNCancelationStatus status) { bool isSaved = false; GRNBLL objGRN = new GRNBLL(); objGRN = objGRN.GetbyGRN_Number(GRNId); GRNStatus GRNstatus = (GRNStatus)objGRN.Status; if (status == RequestforApprovedGRNCancelationStatus.Cancelled) { GRNstatus = GRNStatus.Cancelled; } if (objGRN != null) { if (GRNstatus == GRNStatus.Cancelled) { isSaved = objGRN.Update(objGRN.GRN_Number, GRNstatus, objGRN, TrackingNo, DateTime.Now); } if (isSaved == true) { ECXWF.CMessage mess = WFTransaction.Request(TrackingNo); WFTransaction.WorkFlowManager(TrackingNo, mess); isSaved = true; } } else { throw new Exception("Unable to find GRN"); } return(isSaved); }
private void LoadGRNInformation(Guid GRN) { LoadGRNType(); GRNBLL obj = new GRNBLL(); obj = obj.GetbyGRN_Number(GRN); if (obj != null) { if (obj.GRN_Number != "") { this.hfGRNID.Value = obj.Id.ToString(); this.lblGRN.Text = obj.GRN_Number; this.lblTrackingNo.Text = obj.TrackingNo; this.lblProductionYear.Text = obj.ProductionYear.ToString(); this.lblCode.Text = obj.GradingCode; this.lblDateDeposited.Text = obj.DateDeposited.ToShortDateString(); this.lblBags.Text = obj.TotalNumberOfBags.ToString(); this.lblGrossWeight.Text = obj.GrossWeight.ToString(); this.lblNetWeight.Text = obj.NetWeight.ToString(); this.lblOriginalQuantity.Text = obj.OriginalQuantity.ToString(); this.lblCurrentQuantity.Text = obj.CurrentQuantity.ToString(); lblGRNCreatedDate.Text = obj.GRNCreatedDate.ToShortDateString(); cmpSampGen.ValueToCompare = obj.CreatedTimestamp.ToShortDateString(); this.lblCommodityGrade.Text = CommodityGradeBLL.GetCommodityGradeNameById(obj.CommodityGradeId); ClientBLL objClient = new ClientBLL(); //objClient = ClientBLL.GetClinet(obj.ClientId); //this.lblClinet.Text = objClient.ClientName; LoadSampling(obj.GradingId); LoadGrading(obj.GradingId); LoadDepositeRequest(obj.CommodityRecivingId); this.cboGRNType.SelectedValue = obj.GRNTypeId.ToString(); BagTypeBLL objBag = new BagTypeBLL(); objBag.GetBagTypeById(obj.BagTypeId); this.lblBagType.Text = objBag.BagTypeName; this.cboStatus.SelectedValue = obj.Status.ToString(); if (obj.ClientAccepted == true) { this.cboClientAccpted.SelectedValue = "1"; } else { this.cboClientAccpted.SelectedValue = "2"; } this.txtClientAcceptedTimeStamp.Text = obj.ClientAcceptedTimeStamp.ToString(); this.hfStatus.Value = obj.Status.ToString(); if (this.cboStatus.SelectedValue == "4" && this.cboStatus.SelectedValue == "5" && this.cboStatus.SelectedValue == "6") { this.cboStatus.Enabled = false; this.cboClientAccpted.Enabled = false; this.btnAdd.Enabled = false; this.txtClientAcceptedTimeStamp.Enabled = false; this.txtClientAcceptedTimeStamp.Visible = false; this.cboClientAccpted.Visible = false; this.btnAdd.Visible = false; this.lblmsg.Text = "The Client can not accpet or reject this GRN as the status of the GRN is not new or approved."; } } } }
private void LoadData(Guid GRNId) { GRNBLL objGRN = new GRNBLL(); objGRN = objGRN.GetbyGRN_Number(GRNId); if (objGRN != null) { this.txtGRNNo.Text = objGRN.GRN_Number.ToString(); } }
protected void Page_Load(object sender, EventArgs e) { this.Page.DataBind(); if (IsPostBack != true) { Nullable <Guid> GRN_number = null; if (Session["GRNID"] != null) { try { //Get Commodity deposite Request Id from the GRN; GRN_number = new Guid(Session["GRNID"].ToString()); if (Session["GRNTrackingNo"] != null) { this.lblCurrentTrackingNo.Text = Session["GRNTrackingNo"].ToString(); } else { GRNBLL objGRN = new GRNBLL(); objGRN = objGRN.GetbyGRN_Number((Guid)GRN_number); if (objGRN != null) { GradingBLL objGrading = new GradingBLL(); objGrading = objGrading.GetById(objGRN.GradingId); this.lblCurrentTrackingNo.Text = objGrading.TrackingNo; } } LoadGRNInformation((Guid)GRN_number); LoadStatus(); Session["GRNID"] = null; Session["GRNTrackingNo"] = null; } catch (Exception ex) { throw ex; } LoadServices(); } this.btnAdd.Attributes.Add("btnGRNService_Click", "ValidateGRNService"); if (Session["msg"] != null) { ECXWF.CMessage mess = (ECXWF.CMessage)Session["msg"]; if (mess.Name == "EditGRN") { this.pnl.Visible = false; } } } }
private void LoadGRNInformation(Guid GRNId) { LoadGRNType(); GRNBLL obj = new GRNBLL(); obj = obj.GetbyGRN_Number(GRNId); if (obj != null) { if (obj.GRN_Number != "") { this.hfGRNId.Value = obj.Id.ToString(); this.lblGRN.Text = obj.GRN_Number; this.lblTrackingNo.Text = obj.TrackingNo; //this.lblProductionYear.Text = obj.ProductionYear.ToString(); this.lblCode.Text = obj.GradingCode; this.lblDateDeposited.Text = obj.DateDeposited.ToShortDateString(); this.lblBags.Text = obj.TotalNumberOfBags.ToString(); this.lblGrossWeight.Text = obj.GrossWeight.ToString(); this.lblNetWeight.Text = obj.NetWeight.ToString(); this.lblOriginalQuantity.Text = obj.OriginalQuantity.ToString(); this.lblCurrentQuantity.Text = obj.CurrentQuantity.ToString(); this.lblCommodityGrade.Text = CommodityGradeBLL.GetCommodityGradeNameById(obj.CommodityGradeId); ClientBLL objClient = new ClientBLL(); LoadSampling(obj.GradingId); LoadGrading(obj.GradingId); LoadDepositeRequest(obj.CommodityRecivingId); GetGRNServices(GRNId); this.cboGRNType.SelectedValue = obj.GRNTypeId.ToString(); BagTypeBLL objBag = new BagTypeBLL(); objBag.GetBagTypeById(obj.BagTypeId); this.lblBagType.Text = objBag.BagTypeName; this.hfStatus.Value = obj.Status.ToString(); if (obj.ClientAcceptedTimeStamp != null) { this.txtClientAcceptedTimeStamp.Text = obj.ClientAcceptedTimeStamp.ToShortDateString(); } this.chkClientAccepted.Checked = obj.ClientAccepted; if (this.chkClientAccepted.Checked != true) { //TOdo- GRN Statas. } if (this.cboStatus.SelectedValue == "6" || this.cboStatus.SelectedValue == "3") { this.cboStatus.Enabled = false; this.btnAdd.Enabled = false; } } } }
protected void btnAdd_Click(object sender, EventArgs e) { if (this.cboStatus.SelectedValue == "6")// need to consume the webservice. { bool isSaved = false; GRNBLL objGRN = new GRNBLL(); objGRN = objGRN.GetbyGRN_Number(new Guid(this.hfGRNId.Value.ToString())); objGRN.ApprovedTimeStamp = DateTime.Now; objGRN.TrackingNo = this.lblCurrentTrackingNo.Text; objGRN.ManagerApprovedDateTime = DateTime.Parse(this.txtMADate.Text + " " + this.txtTime.Text); isSaved = objGRN.Update(this.lblGRN.Text, (GRNStatus)int.Parse(this.cboStatus.SelectedValue), objGRN, objGRN.TrackingNo, objGRN.ManagerApprovedDateTime); if (isSaved == true) { this.lblmsg.Text = "GRN Updated Successfully"; LoadGRNInformation(new Guid(this.hfGRNId.Value.ToString())); Response.Redirect("ListInbox.aspx"); } else { this.lblmsg.Text = "Can not update the GRN."; } } else if (this.cboStatus.SelectedValue == "3") { GRNBLL objGRN = new GRNBLL(); objGRN = objGRN.GetbyGRN_Number(new Guid(this.hfGRNId.Value.ToString())); bool isSaved = objGRN.Update(objGRN.GRN_Number, GRNStatus.Cancelled, objGRN, objGRN.TrackingNo, objGRN.ManagerApprovedDateTime); if (isSaved == false) { this.lblmsg.Text = "Can not update the GRN."; return; } else { this.lblmsg.Text = "GRN Cancelled."; } } }
private void LoadData(Guid GRNID) { // load GRN Data GRNBLL objGRN = new GRNBLL(); objGRN = objGRN.GetbyGRN_Number(GRNID); if (objGRN != null) { if (objGRN.Id != null) { this.hfGRNID.Value = objGRN.Id.ToString(); } else { throw new Exception("Unable to Load GRN Related Data."); } if (objGRN.CommodityRecivingId != null) { hfReceivigRequestId.Value = objGRN.CommodityRecivingId.ToString(); //Load Commodity Deposite Information. LoadDepositeRequest(objGRN.CommodityRecivingId); } if (objGRN.TrackingNo != "") { hfTrackingNo.Value = objGRN.TrackingNo; this.lblTrackingNo.Text = objGRN.TrackingNo; } if (objGRN.VoucherId != null) { hfVoucherId.Value = objGRN.VoucherId.ToString(); } this.lblGRN_Number.Text = objGRN.GRN_Number; LoadSampling(objGRN.GradingId); LoadGrading(objGRN.GradingId); LoadUnloading(objGRN.GradingId); ScalingInformation(objGRN.GradingId); LoadNetWeight(); LoadQuantity(); LoadVoucherInformation(objGRN.CommodityRecivingId); } }
protected void Page_Load(object sender, EventArgs e) { if (Session["GRNIDUpdateGRNNo"] != null) { if (Session["TrackingNoUpdateGRNNo"] != null) { ViewState["TrackingNo"] = Session["TrackingNoUpdateGRNNo"].ToString(); } else { ViewState["TrackingNo"] = -1; } Session["TrackingNoUpdateGRNNo"] = null; Guid Id = new Guid(Session["GRNIDUpdateGRNNo"].ToString()); Session["GRNIDUpdateGRNNo"] = null; GRNBLL objGRN = new GRNBLL(); objGRN = objGRN.GetbyGRN_Number(Id); this.lblNewGRN.Text = objGRN.GRN_Number; ViewState["GRNId"] = objGRN.Id.ToString(); } }
private void rptGRN_ReportStart(object sender, EventArgs e) { if (HttpContext.Current.Session["GRNIDPrint"] == null) { throw new Exception("Session expired"); } Guid GRNId = Guid.Empty; GRNId = new Guid(HttpContext.Current.Session["GRNIDPrint"].ToString()); Guid GradingId = Guid.Empty; GRNBLL objGRN = new GRNBLL(); objGRN = objGRN.GetbyGRN_Number(GRNId); GradingId = objGRN.GradingId; this.lblGRN_No.Text = objGRN.GRN_Number; this.lblClient.Text = ClientBLL.GetClinetNameById(objGRN.ClientId); this.lblCommodityGrade.Text = CommodityGradeBLL.GetCommodityGradeNameById(objGRN.CommodityGradeId); this.lblWarehouse.Text = WarehouseBLL.GetWarehouseNameById(objGRN.WarehouseId); this.lblOriginalQuantity.Text = objGRN.OriginalQuantity.ToString(); this.lblNetWeight.Text = objGRN.NetWeight.ToString(); this.lblDateDeposited.Text = objGRN.DateDeposited.ToShortDateString(); this.lblTimeDeposited.Text = objGRN.DateDeposited.ToShortTimeString(); this.lblNoBags.Text = objGRN.TotalNumberOfBags.ToString(); //Bag Type BagTypeBLL objBt = new BagTypeBLL(); objBt.GetBagTypeById(objGRN.BagTypeId); lblBagType.Text = objBt.BagTypeName; //Driver Information List <DriverInformationBLL> list = null; DriverInformationBLL objDI = new DriverInformationBLL(); list = objDI.GetActiveDriverInformationByReceivigRequestId(objGRN.CommodityRecivingId); if (list != null) { string driverName = ""; string plateNo = ""; string driverLicense = ""; string licensceIssuedPlace = ""; foreach (DriverInformationBLL o in list) { if (driverName == "") { driverName = o.DriverName; } else { driverName += "," + o.DriverName; } if (plateNo == "") { if (String.IsNullOrEmpty(o.TrailerPlateNumber) != true) { plateNo = o.PlateNumber + "-" + o.TrailerPlateNumber; } else { plateNo = o.PlateNumber; } } else { if (String.IsNullOrEmpty(o.TrailerPlateNumber) != true) { plateNo += " , " + o.PlateNumber + "-" + o.TrailerPlateNumber; } else { plateNo += " , " + o.PlateNumber; } } if (driverLicense == "") { driverLicense = o.LicenseNumber; } else { driverLicense += " , " + o.LicenseNumber; } if (licensceIssuedPlace == "") { licensceIssuedPlace = o.LicenseIssuedPlace; } else { licensceIssuedPlace += " , " + o.LicenseIssuedPlace; } } this.lblDriverName.Text = driverName; this.lblPlateNo.Text = plateNo; this.lblDriverLicense.Text = driverLicense; this.lblPlaceIssued.Text = licensceIssuedPlace; } // Scaling ScalingBLL objScaling = new ScalingBLL(); objScaling = objScaling.GetById(objGRN.ScalingId); if (objScaling != null) { if (objScaling.WeigherId != null) { try { this.lblWeigherName.Text = UserRightBLL.GetUserNameByUserId(objScaling.WeigherId); } catch { } } } // Sampler SamplerBLL objSampler = new SamplerBLL(); objSampler = objSampler.GetActiveSamplingSupBySamplingId(objGRN.SamplingTicketId); if (objSampler != null) { this.lblSampler.Text = UserRightBLL.GetUserNameByUserId(objSampler.SamplerId); } //Graders GradingByBLL objGrader = new GradingByBLL(); this.lblGrader.Text = objGrader.GetSupGraderNameByGradingId(objGRN.GradingId); if (objGRN.ApprovedBy != null) { try { this.lblApprovedBy.Text = UserRightBLL.GetUserNameByUserId(objGRN.ApprovedBy); } catch { } } if (objGRN.ApprovedTimeStamp != null) { this.lblDateAproved.Text = objGRN.ApprovedTimeStamp.ToShortDateString(); } rpt = new rptGrading(GradingId); rptGS = new rptGRNService(GRNId); this.txtDateGenerated.Text = DateTime.Now.ToString(); ScalingBLL objSacling = new ScalingBLL(); objSacling = objSacling.GetById(objGRN.ScalingId); if (objSacling != null) { this.lblScaleTicketNo.Text = objSacling.ScaleTicketNumber; } this.subReport1.Report = rpt; this.subReport2.Report = this.rptGS; }
protected void gvGRN_RowCommand(object sender, GridViewCommandEventArgs e) { // Label id = (Label)row.FindControl("lblGRN"); int index = Convert.ToInt32(e.CommandArgument); GridViewRow rw = this.gvGRN.Rows[index]; if (e.CommandName == "View") { if (rw != null) { Label id = (Label)rw.FindControl("lblId"); if (id != null) { Session["GRNID"] = id.Text; Response.Redirect("ViewGRN.aspx"); } } } //Update GRN No if (e.CommandName == "cmdGRNNoUpdate") { Label id = (Label)rw.FindControl("lblId"); if (id != null) { //Session["GRNIDUpdateGRNNo"] = id.Text; //Response.Redirect("UpdateGRNNumber.aspx"); } } else if (e.CommandName == "cmdPrint") { if (rw != null) { Label id = (Label)rw.FindControl("lblId"); if (id != null) { Session["GRNIDPrint"] = id.Text; StringBuilder sb = new StringBuilder(); sb.Append("<script>"); sb.Append("window.open('rptGRN.aspx"); sb.Append("', '', 'toolbar=0');"); sb.Append("</scri"); sb.Append("pt>"); ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "ShowReport", sb.ToString(), false); } } } else if (e.CommandName == "Edit") { if (rw != null) { Label id = (Label)rw.FindControl("lblId"); Label lblStatus = (Label)rw.FindControl("lblStatus"); if (lblStatus != null) { if (lblStatus.Text.ToUpper() != "NEW" && lblStatus.Text.ToUpper() != "OpenForEdit".ToUpper()) { Session["GRNIDRequestCD"] = id.Text; Response.Redirect("AddApprovedGRNEditRequest.aspx"); } else if (lblStatus.Text.ToUpper() == "OpenForEdit".ToUpper()) { Session["ReCreateGRNID"] = id.Text; Response.Redirect("ReCreateGRN.aspx"); } else if (lblStatus.Text.ToUpper() == "NEW") { Session["ReCreateGRNID"] = id.Text; GRNBLL objGRN = new GRNBLL(); objGRN = objGRN.GetbyGRN_Number(new Guid(id.Text)); Session["ReCreateGRNTrackingNo"] = objGRN.TrackingNo; Response.Redirect("ReCreateGRN.aspx"); } else { Session["GRNID"] = id.Text; Response.Redirect("ViewGRN.aspx"); } } } } else if (e.CommandName == "cmdCancel") { if (rw != null) { Label id = (Label)rw.FindControl("lblId"); Label lblStatus = (Label)rw.FindControl("lblStatus"); if (lblStatus != null) { if (lblStatus.Text.ToUpper() == "NEW" || lblStatus.Text.ToUpper() == "ClientAccepted".ToUpper() || lblStatus.Text.ToUpper() == "ClientRejected".ToUpper()) { Session["GRNID"] = id.Text; Response.Redirect("ViewGRN.aspx"); } else if (lblStatus.Text.ToUpper() == "ManagerApproved".ToUpper()) { Session["ApprovedGRNCancelationID"] = id.Text; Response.Redirect("RequestApprovedGRNCancelation.aspx"); } } } } }