public List <GradingDisputeBLL> GetGradingDisputePendingCoding(Guid WarehouseId) { List <GradingDisputeBLL> list = new List <GradingDisputeBLL>(); GradingDisputeBLL obj = new GradingDisputeBLL(); list = obj.GetGradingDisputePendingCoding(WarehouseId); return(list); }
public SamplingResultBLL GetSamplesResultsPendingCodingByTrackingNo(Guid WarehouseId, string TrackingNo) { SamplingResultBLL list = new SamplingResultBLL(); list = SamplingResultDAL.GetSamplesResultsPendingCodingByTrackingNo(WarehouseId, TrackingNo); if (list == null) { GradingDisputeBLL objGD = new GradingDisputeBLL(); list = objGD.GetGradingDisputePendingCodingByTrackingNo(TrackingNo); } return(list); }
public GradingDisputeBLL GetByTransactionNo(string TranNo) { GradingDisputeBLL obj = new GradingDisputeBLL(); try { obj = GradingDisputeDAL.GetByTranNo(TranNo); return(obj); } catch (Exception ex) { throw ex; } }
public GradingDisputeBLL GetById(Guid Id) { GradingDisputeBLL obj = new GradingDisputeBLL(); try { obj = GradingDisputeDAL.GetById(Id); return(obj); } catch (Exception ex) { throw ex; } }
public bool Edit(GradingDisputeBLL objOld) { bool isSaved = false; SqlConnection conn; SqlTransaction tran; conn = Connection.getConnection(); tran = conn.BeginTransaction(); try { isSaved = GradingDisputeDAL.UpdateGradingDisputeBLL(this, tran); if (isSaved == true) { //Update the WF step after cheking the status is set to approved. if (this.Status == 2) { WFTransaction.WorkFlowManager(this.TrackingNo); HttpContext.Current.Session["EditGradeDisputeTranNo"] = this.TrackingNo; } else if (this.Status == 3) { HttpContext.Current.Session["EditGradeDisputeTranNo"] = this.TrackingNo; } AuditTrailBLL ATobj = new AuditTrailBLL(); ATobj.saveAuditTrail(objOld, this, WFStepsName.EditGradeDispute.ToString(), UserBLL.GetCurrentUser(), "Edit Grade Dispute"); tran.Commit(); tran.Dispose(); conn.Close(); return(true); } else { tran.Rollback(); tran.Dispose(); conn.Close(); return(false); } } catch (Exception ex) { tran.Rollback(); tran.Dispose(); conn.Close(); throw ex; } }
private static List <TransactionDetail> getDislayName(string[] TranArr, string FlowName, string StepName) { string str = ""; List <TransactionDetail> list; for (int i = 0; i < TranArr.Count(); i++) { if (i < TranArr.Count() - 1) { str += "'" + TranArr[i].ToString() + "' ,"; } else { str += "'" + TranArr[i].ToString() + "'"; } } list = new List <TransactionDetail>(); if (StepName == WFStepName.AddSamplingResult.ToString()) { SamplingBLL objSampling = new SamplingBLL(); if (FlowName.Trim().ToUpper() == "WRCM".ToUpper()) { TranArr = objSampling.GetMixedSamplingCodeBylistTrackingNo(str); } else { TranArr = objSampling.GetSamplingCodeBylistTrackingNo(str); } if (TranArr != null) { for (int x = 0; x < TranArr.Count(); x++) { string[] temp = TranArr[x].Split('*'); list.Add(new TransactionDetail(temp[0].Trim(), temp[1].Trim())); } } return(list); } else if (StepName == WFStepName.GenerateGradingCode.ToString()) { SamplingResultBLL objSampling = new SamplingResultBLL(); TranArr = objSampling.GetSamplingResultCodeBylistTrackingNo(str); if (TranArr != null) { if (TranArr != null) { for (int x = 0; x < TranArr.Count(); x++) { string[] temp = TranArr[x].Split('*'); list.Add(new TransactionDetail(temp[0].Trim(), temp[1].Trim())); } } } // regrading GradingDisputeBLL objGradeDispute = new GradingDisputeBLL(); TranArr = objGradeDispute.GetReGradingRequestbyTrackingNo(str); if (TranArr != null) { if (TranArr != null) { for (int x = 0; x < TranArr.Count(); x++) { string[] temp = TranArr[x].Split('*'); list.Add(new TransactionDetail(temp[0].Trim(), temp[1].Trim())); } } } return(list); } else if (StepName == WFStepName.AddGradingResult.ToString()) { GradingBLL objSampling = new GradingBLL(); TranArr = objSampling.GetGradingResultCodeBylistTrackingNo(str); if (TranArr != null) { for (int x = 0; x < TranArr.Count(); x++) { string[] temp = TranArr[x].Split('*'); list.Add(new TransactionDetail(temp[0].Trim(), temp[1].Trim())); } } return(list); } else if (StepName == WFStepName.GradingResultCA.ToString()) { GradingBLL objSampling = new GradingBLL(); TranArr = objSampling.GetGradingResultCodeBylistTrackingNo(str); if (TranArr != null) { for (int x = 0; x < TranArr.Count(); x++) { string[] temp = TranArr[x].Split('*'); list.Add(new TransactionDetail(temp[0].Trim(), temp[1].Trim())); } } return(list); } else if (StepName == WFStepName.PreWeighTruck.ToString() || StepName == WFStepName.AddUnloadingInfo.ToString()) { GradingResultBLL obj = new GradingResultBLL(); TranArr = obj.GetGradingResultResultCodeBylistTrackingNo(str); if (TranArr != null) { for (int x = 0; x < TranArr.Count(); x++) { string[] temp = TranArr[x].Split('*'); list.Add(new TransactionDetail(temp[0].Trim(), temp[1].Trim())); } } return(list); } else if (StepName == WFStepName.PostWeighTruck.ToString() || StepName == WFStepName.AddScalingInfo.ToString()) { //TODO _ check hwewe //post Weight que No. GradingResultBLL obj = new GradingResultBLL(); TranArr = obj.GetGradingResultResultCodeBylistTrackingNo(str); if (TranArr != null) { for (int x = 0; x < TranArr.Count(); x++) { string[] temp = TranArr[x].Split('*'); list.Add(new TransactionDetail(temp[0].Trim(), temp[1].Trim())); } } return(list); } else if (StepName == WFStepName.AddGRN.ToString()) { GRNBLL obj = new GRNBLL(); TranArr = obj.GetGradingResultResultCodeBylistTrackingNo(str); if (TranArr != null) { for (int x = 0; x < TranArr.Count(); x++) { string[] temp = TranArr[x].Split('*'); list.Add(new TransactionDetail(temp[0].Trim(), temp[1].Trim())); } } return(list); } else if (StepName == WFStepName.GRNAcceptance.ToString() && FlowName == "WHEditAppGRN") { GRNBLL obj = new GRNBLL(); TranArr = obj.GetGRNNoBylistEditTrackingNo(str); if (TranArr != null) { for (int x = 0; x < TranArr.Count(); x++) { string[] temp = TranArr[x].Split('*'); list.Add(new TransactionDetail(temp[0].Trim(), temp[1].Trim())); } } return(list); } else if (StepName == WFStepName.GRNAcceptance.ToString() && FlowName != "WHEditAppGRN") { GRNBLL obj = new GRNBLL(); TranArr = obj.GetGRNNoBylistTrackingNo(str); if (TranArr != null) { for (int x = 0; x < TranArr.Count(); x++) { string[] temp = TranArr[x].Split('*'); list.Add(new TransactionDetail(temp[0].Trim(), temp[1].Trim())); } } return(list); } //Update GRN else if (StepName == WFStepName.UpdateGRNNo.ToString()) { GRNBLL obj = new GRNBLL(); TranArr = obj.GetGRNNoBylistTrackingNo(str); if (TranArr != null) { for (int x = 0; x < TranArr.Count(); x++) { string[] temp = TranArr[x].Split('*'); list.Add(new TransactionDetail(temp[0].Trim(), temp[1].Trim())); } } return(list); } else if (StepName == WFStepName.WarehouseManagerAppr.ToString() && FlowName == "WHEditAppGRN") { GRNBLL obj = new GRNBLL(); TranArr = obj.GetGRNNoBylistEditTrackingNo(str); if (TranArr != null) { for (int x = 0; x < TranArr.Count(); x++) { string[] temp = TranArr[x].Split('*'); list.Add(new TransactionDetail(temp[0].Trim(), temp[1].Trim())); } } return(list); } else if (StepName == WFStepName.EditGRN.ToString() || StepName == WFStepName.WarehouseManagerAppr.ToString()) { GRNBLL obj = new GRNBLL(); TranArr = obj.GetGRNNoBylistTrackingNo(str); if (TranArr != null) { for (int x = 0; x < TranArr.Count(); x++) { string[] temp = TranArr[x].Split('*'); list.Add(new TransactionDetail(temp[0].Trim(), temp[1].Trim())); } } return(list); } else if (StepName == WFStepsName.EditGradingResult.ToString()) { string strTr; GradingDisputeBLL objGrDisp = new GradingDisputeBLL(); TranArr = objGrDisp.GetReGradingRequestbyTrackingNo(str); if (TranArr != null) { for (int x = 0; x < TranArr.Count(); x++) { string[] temp = TranArr[x].Split('*'); list.Add(new TransactionDetail(temp[0].Trim(), temp[1].Trim())); } } return(list); } else if (StepName.ToUpper().Trim() == "CodeSampRec".ToUpper().Trim()) { GradingBLL objSampling = new GradingBLL(); TranArr = objSampling.GetGradingResultCodeBylistTrackingNo(str); if (TranArr != null) { for (int x = 0; x < TranArr.Count(); x++) { string[] temp = TranArr[x].Split('*'); list.Add(new TransactionDetail(temp[0].Trim(), temp[1].Trim())); } } return(list); } else { for (int x = 0; x < TranArr.Count(); x++) { list.Add(new TransactionDetail(TranArr[x].Trim(), TranArr[x].Trim())); } return(list); } }
public static void LoadVariables(string msg, string TrackingNo) { TrackingNo = TrackingNo.Trim(); if (msg.Trim() == WFStepsName.AddDriverInformation.ToString()) { CommodityDepositeRequestBLL objCDR = new CommodityDepositeRequestBLL(); objCDR = objCDR.GetCommodityDepositeDetailByTrackingNo(TrackingNo); if (objCDR != null) { HttpContext.Current.Session["CommodityRequestId"] = objCDR.Id; } else { throw new Exception("Can't load page variables,please try again."); } } else if (msg.Trim() == WFStepsName.AddVoucherInfo.ToString()) { CommodityDepositeRequestBLL objCDR = new CommodityDepositeRequestBLL(); objCDR = objCDR.GetCommodityDepositeDetailByTrackingNo(TrackingNo); if (objCDR != null) { HttpContext.Current.Session["CommodityRequestId"] = objCDR.Id; } else { throw new Exception("Can't load page variables,please try again."); } } else if (msg.Trim() == WFStepsName.AddDriverInformation.ToString()) { CommodityDepositeRequestBLL objCDR = new CommodityDepositeRequestBLL(); objCDR = objCDR.GetCommodityDepositeDetailByTrackingNo(TrackingNo); if (objCDR != null) { HttpContext.Current.Session["CommodityRequestId"] = objCDR.Id; } else { throw new Exception("Can't load page variables,please try again."); } } else if (msg.Trim() == WFStepsName.AddVoucherInfo.ToString()) { CommodityDepositeRequestBLL objCDR = new CommodityDepositeRequestBLL(); objCDR = objCDR.GetCommodityDepositeDetailByTrackingNo(TrackingNo); if (objCDR != null) { HttpContext.Current.Session["CommodityRequestId"] = objCDR.Id; } else { throw new Exception("Can't load page variables,please try again."); } } else if (msg.Trim() == WFStepsName.GetSampleTicket.ToString()) { } else if (msg.Trim() == WFStepsName.AddSamplingResult.ToString()) { List <SamplingBLL> list = new List <SamplingBLL>(); SamplingBLL obj = new SamplingBLL(); list = obj.GetSamplesPenndingResultByTrackingNo(UserBLL.GetCurrentWarehouse(), TrackingNo); if (list != null) { if (list.Count == 1) { obj = list[0]; HttpContext.Current.Session["SamplingReasultAddId"] = obj.Id; } } } else if (msg.Trim() == WFStepsName.AddSampleCoding.ToString()) { //SamplingResultBLL obj = new SamplingResultBLL(); //obj = obj.GetSamplesResultsPendingCodingByTrackingNo(UserBLL.GetCurrentWarehouse(), TrackingNo); //if (obj != null) //{ // if (string.IsNullOrEmpty(obj.TrackingNo) != true) // { // HttpContext.Current.Session["GenerateCodeSampleId"] = obj.Id; // } // else // { // throw new Exception("Unable to get Record"); // } //} SamplingResultBLL objGrading = new SamplingResultBLL(); objGrading = objGrading.GetSamplesResultsPendingCodingByTrackingNo(UserBLL.GetCurrentWarehouse(), TrackingNo); if (objGrading != null) { if (string.IsNullOrEmpty(objGrading.TrackingNo) != true) { HttpContext.Current.Session["GradingCodeId"] = objGrading.SamplingResultCode; } } } else if (msg.Trim() == WFStepsName.GenerateGradingCode.ToString()) { SamplingResultBLL objGrading = new SamplingResultBLL(); objGrading = objGrading.GetSamplesResultsPendingCodingByTrackingNo(UserBLL.GetCurrentWarehouse(), TrackingNo); if (objGrading != null) { if (string.IsNullOrEmpty(objGrading.TrackingNo) != true) { HttpContext.Current.Session["GradingCodeId"] = objGrading.SamplingResultCode; HttpContext.Current.Session["GradingCodeTrackingNo"] = TrackingNo.ToString(); } } } else if (msg.Trim() == WFStepsName.CodeSampRec.ToString()) { GradingBLL objGrading = new GradingBLL(); List <GradingBLL> list = new List <GradingBLL>(); list = objGrading.GetGradingsPendingCodeReceivingByTrackingNo(UserBLL.GetCurrentWarehouse(), TrackingNo); if (list != null) { if (list.Count == 1) { objGrading = list[0]; HttpContext.Current.Session["CodeSampleRecivedGradingId"] = objGrading.Id; } } } else if (msg.Trim() == WFStepsName.AddGradingResult.ToString()) { GradingBLL objGrading = new GradingBLL(); List <GradingBLL> list = new List <GradingBLL>(); list = objGrading.GetGradingsPendingResultByTrackingNo(UserBLL.GetCurrentWarehouse(), TrackingNo); if (list != null) { if (list.Count == 1) { objGrading = list[0]; HttpContext.Current.Session["GradingRecivedGradingId"] = objGrading.Id; } } } else if (msg.Trim() == WFStepsName.GradingResultCA.ToString()) { GradingResultBLL objGrading = new GradingResultBLL(); objGrading = objGrading.GetGradingResultByTrackingNo(TrackingNo); if (objGrading != null) { if (objGrading.ID != null) { HttpContext.Current.Session["GRID"] = objGrading.ID; } } } else if (msg.Trim() == WFStepsName.PreWeighTruck.ToString()) { GradingResultBLL objGrading = new GradingResultBLL(); List <GradingResultBLL> list = new List <GradingResultBLL>(); list = objGrading.GetAcceptedresultsPendingUnloadingByTrackingNo(UserBLL.GetCurrentWarehouse(), TrackingNo); if (list != null) { if (list.Count == 1) { objGrading = list[0]; HttpContext.Current.Session["AddUnLoadingId"] = objGrading.ID; HttpContext.Current.Session["AddUnLoadingIdGradingCode"] = objGrading.GradingCode; } } } else if (msg.Trim() == WFStepsName.AddUnloadingInfo.ToString()) { GradingResultBLL objGrading = new GradingResultBLL(); List <GradingResultBLL> list = new List <GradingResultBLL>(); list = objGrading.GetAcceptedresultsPendingUnloadingByTrackingNo(UserBLL.GetCurrentWarehouse(), TrackingNo); if (list != null) { if (list.Count == 1) { objGrading = list[0]; HttpContext.Current.Session["AddUnLoadingId"] = objGrading.ID; HttpContext.Current.Session["AddUnLoadingIdGradingCode"] = objGrading.GradingCode; } } } else if (msg.Trim() == WFStepsName.PostWeighTruck.ToString()) { GradingResultBLL objGrading = new GradingResultBLL(); List <GradingResultBLL> list = new List <GradingResultBLL>(); list = objGrading.GetAcceptedresultsPendingScalingByTrackingNo(UserBLL.GetCurrentWarehouse(), TrackingNo); if (list != null) { if (list.Count == 1) { objGrading = list[0]; HttpContext.Current.Session["AddScalingGradingCode"] = objGrading.GradingCode; } } } else if (msg.Trim() == WFStepsName.AddScalingInfo.ToString()) { GradingResultBLL objGrading = new GradingResultBLL(); List <GradingResultBLL> list = new List <GradingResultBLL>(); list = objGrading.GetAcceptedresultsPendingScalingByTrackingNo(UserBLL.GetCurrentWarehouse(), TrackingNo); if (list != null) { if (list.Count == 1) { objGrading = list[0]; HttpContext.Current.Session["AddScalingGradingCode"] = objGrading.GradingCode; } } } // ADD GRN else if (msg.Trim() == WFStepsName.AddGRN.ToString()) { GradingResultBLL objGrading = new GradingResultBLL(); objGrading = objGrading.GetGradingResultByTrackingNo(TrackingNo); if (objGrading != null) { if (objGrading.ID != null) { HttpContext.Current.Session["GRNID"] = TrackingNo; // objGrading.ID; } } } else if (msg.Trim() == WFStepsName.GRNAcceptance.ToString()) { GRNBLL objGRN = new GRNBLL(); objGRN = objGRN.GetbyByTrackingNo(TrackingNo); if (objGRN != null) { if (objGRN.Id != null) { HttpContext.Current.Session["GRNID"] = objGRN.Id; } else { throw new Exception("Invalid GRN Id"); } } } else if (msg.Trim() == WFStepsName.ClientAcceptance.ToString()) { RequestforEditGRNBLL objGRN = new RequestforEditGRNBLL(); objGRN = objGRN.GetByTrackingNo(TrackingNo); if (objGRN != null) { if (objGRN.Id != null) { HttpContext.Current.Session["GRNID"] = objGRN.GRNId; } else { throw new Exception("Invalid GRN Id"); } } } //Update GRN else if (msg.Trim() == WFStepsName.UpdateGRNNo.ToString()) { GRNBLL objGRN = new GRNBLL(); objGRN = objGRN.GetbyByTrackingNo(TrackingNo); if (objGRN != null) { if (objGRN.GRN_Number != null) { HttpContext.Current.Session["GRNIDUpdateGRNNo"] = objGRN.Id; HttpContext.Current.Session["TrackingNoUpdateGRNNo"] = TrackingNo; } } } else if (msg.Trim() == WFStepsName.EditGRN.ToString()) { GRNBLL objGRN = new GRNBLL(); objGRN = objGRN.GetbyByTrackingNo(TrackingNo); if (objGRN != null) { if (objGRN.GRN_Number != null) { HttpContext.Current.Session["GRNID"] = objGRN.Id; HttpContext.Current.Session["GRNTrackingNo"] = TrackingNo; } } } else if (msg.Trim() == WFStepsName.WarehouseManagerAppr.ToString()) { RequestforEditGRNBLL objGRN = new RequestforEditGRNBLL(); objGRN = objGRN.GetByTrackingNo(TrackingNo); if (objGRN != null) { if (objGRN.Id != null) { HttpContext.Current.Session["GRNID"] = objGRN.GRNId; HttpContext.Current.Session["GRNTrackingNo"] = TrackingNo; } else { throw new Exception("Invalid GRN Id"); } } } else if (msg.Trim() == WFStepsName.EditGradeDispute.ToString()) { GradingDisputeBLL objGradeDispute = new GradingDisputeBLL(); objGradeDispute = objGradeDispute.GetByTransactionNo(TrackingNo); if (objGradeDispute != null) { if (objGradeDispute.Id != null) { HttpContext.Current.Session["EditGradeDisputeId"] = objGradeDispute.Id; } } } else if (msg.Trim() == WFStepsName.ApproveReSampling.ToString()) { ReSamplingBLL objReSampling = new ReSamplingBLL(); objReSampling = objReSampling.GetByTrackingNo(TrackingNo); if (objReSampling != null) { if (objReSampling.Id != null) { HttpContext.Current.Session["ResamplingEdit"] = objReSampling.Id; } } } else if (msg.Trim() == WFStepsName.WHAppGRNEdit.ToString()) { RequestforEditGRNBLL obj = new RequestforEditGRNBLL(); obj = obj.GetByTrackingNo(TrackingNo); if (obj != null) { if (obj.Id != null) { HttpContext.Current.Session["GRNEditRequestId"] = obj.Id; } } } else if (msg.Trim() == WFStepsName.OpenGRNForEdit.ToString()) { RequestforEditGRNBLL obj = new RequestforEditGRNBLL(); obj = obj.GetByTrackingNo(TrackingNo); if (obj != null) { if (obj.Id != null) { HttpContext.Current.Session["OpenGRNEditId"] = obj.Id; } } } else if (msg.Trim() == WFStepsName.EditWHR.ToString().Trim()) { RequestforEditGRNBLL obj = new RequestforEditGRNBLL(); obj = obj.GetByTrackingNo(TrackingNo); if (obj != null) { if (obj.GRNId != null) { HttpContext.Current.Session["ReCreateGRNID"] = obj.GRNId; HttpContext.Current.Session["ReCreateGRNTrackingNo"] = TrackingNo; } } } else if (msg.Trim() == "ApproveCancelationRequest".ToString().Trim() || (msg.Trim() == "CancelGRN")) { RequestforApprovedGRNCancelationBLL obj = new RequestforApprovedGRNCancelationBLL(); obj = obj.GetByTrackingNo(TrackingNo); if (obj != null) { if (obj.GRNId != null) { HttpContext.Current.Session["CancelGRNTrackingNo"] = TrackingNo; HttpContext.Current.Session["GRNID"] = obj.GRNId; } } } else if (msg.Trim() == WFStepsName.EditGradingResult.ToString().Trim()) { GradingResultBLL objGradingResult = new GradingResultBLL(); HttpContext.Current.Session["GRID"] = null; objGradingResult = objGradingResult.GetGradingResultByTrackingNo(TrackingNo.Trim()); if (objGradingResult != null) { HttpContext.Current.Session["GRID"] = objGradingResult.ID.ToString(); } else { objGradingResult = new GradingResultBLL(); objGradingResult = objGradingResult.GetGradingResultByTrackingNoForGradeDispute(TrackingNo.Trim()); if (objGradingResult != null) { HttpContext.Current.Session["GRID"] = objGradingResult.ID.ToString(); } } } else if (msg.Trim() == "UpdateClientNo") { //NoClient CommodityDepositeRequestBLL objCDR = new CommodityDepositeRequestBLL(); objCDR = objCDR.GetCommodityDepositeDetailByTrackingNo(TrackingNo); if (objCDR != null) { HttpContext.Current.Session["CommodityRequestId"] = objCDR.Id; } else { throw new Exception("Can't load page variables,please try again."); } } }