public bool UpdateGRNNumber(Guid Id, String oldSystemGRNNumber, string newSystemGRNNumber, string TrackingNo) { bool isSaved = true; SqlTransaction trans; SqlConnection conn = new SqlConnection(); conn = Connection.getConnection(); trans = conn.BeginTransaction(); try { isSaved = GRNDAL.UpDateGRNNumber(Id, oldSystemGRNNumber, newSystemGRNNumber, trans); if (isSaved == true) { int at = -1; AuditTrailBLL objAt = new AuditTrailBLL(); if (TrackingNo != "-1") { WFTransaction.WorkFlowManager(TrackingNo); } at = objAt.saveAuditTrailStringFormat("New System:GRN_Number = " + newSystemGRNNumber, "Old System :GRN_Number = " + oldSystemGRNNumber, "GRN No. Update ", UserBLL.GetCurrentUser(), WFStepName.UpdateGRNNo.ToString()); if (at == 1) { trans.Commit(); return(true); } else { trans.Rollback(); return(false); } } else { trans.Rollback(); return(false); } } catch (Exception ex) { trans.Rollback(); throw ex; } finally { if (trans != null) { trans.Dispose(); } if (conn != null) { if (conn.State == ConnectionState.Open) { conn.Close(); } } } return(isSaved); }
public bool ReCreateGRN() { bool isSaved = false; SqlTransaction trans; SqlConnection conn = new SqlConnection(); conn = Connection.getConnection(); trans = conn.BeginTransaction(); string TrakingNo = ""; TrakingNo = this.TrackingNo; //RequestforEditGRNBLL objRequest = null; this.Status = (int)GRNStatus.New; //objRequest = RequestforEditGRNDAL.GetApprovedRequestByGRNID(this.Id); //if (objRequest != null) //{ // if (string.IsNullOrEmpty(objRequest.TrackingNo) == false) // { // TrakingNo = objRequest.TrackingNo; // } // else // { // throw new Exception("Unable to get GRN edit request data"); // } //} //else //{ // throw new Exception("Unable to get GRN edit request data"); //} try { isSaved = GRNDAL.ReCreate(this, trans); if (isSaved == true) { WFTransaction.WorkFlowManager(TrakingNo); } if (isSaved == true) { trans.Commit(); trans.Dispose(); conn.Close(); return(true); } } catch (Exception ex) { trans.Rollback(); trans.Dispose(); conn.Close(); throw ex; } return(false); }
public bool ClientAcceptance(string GRN_number, DateTime AccptedTimeStamp, bool CAStatus, string TrackingNo, GRNStatus prevStatus) { bool isSaved = false; SqlTransaction trans; SqlConnection conn = new SqlConnection(); conn = Connection.getConnection(); trans = conn.BeginTransaction(); int status; if (CAStatus == true) { status = 4; } else { status = 5; } try { isSaved = GRNDAL.ClientAcceptance(GRN_number, AccptedTimeStamp, CAStatus, status, trans); if (isSaved == true) { int At = -1; AuditTrailBLL objAt = new AuditTrailBLL(); string oldVal = "(GRNNo-" + GRN_number + ") , (Status-" + prevStatus.ToString() + ")"; string NewVal = "(GRNNo-" + GRN_number + ") , (Status-" + Status.ToString() + ")"; At = objAt.saveAuditTrailStringFormat(oldVal, NewVal, WFStepName.EditGRN.ToString(), UserBLL.GetCurrentUser(), "Change GRN Status"); if (At == 1) { WFTransaction.WorkFlowManager(TrackingNo); } else { isSaved = false; } } if (isSaved == true) { trans.Commit(); trans.Dispose(); conn.Close(); return(true); } } catch (Exception ex) { trans.Rollback(); trans.Dispose(); conn.Close(); throw ex; } return(false); }
public GRNBLL ApprovedGRNCancelGetbyByTrackingNo(string TrackingNo) { GRNBLL obj = new GRNBLL(); try { obj = GRNDAL.GetGRNbyGRNApprovedGRNCancelByTrackingNo(TrackingNo); return(obj); } catch (Exception ex) { throw ex; } }
public GRNBLL GetbyGRN_Number(Guid GRN_number) { GRNBLL obj = new GRNBLL(); try { obj = GRNDAL.GetGRNbyGRN_Number(GRN_number); return(obj); } catch (Exception ex) { throw ex; } }
public List <GRNBLL> GetPendingGRNByTrackingNo(Guid Warehouseid, string TrackingNo) { if (this.WarehouseId == null) { throw new Exception("Invalid WarehouseId Exception"); } try { List <GRNBLL> list = new List <GRNBLL>(); list = GRNDAL.GetGRNPendingCreationByTrackingNoByTrackingNo(Warehouseid, TrackingNo); return(list); } catch (Exception ex) { throw ex; } }
public GRNBLL GetbyByTrackingNo(string TrackingNo) { GRNBLL obj = new GRNBLL(); try { obj = GRNDAL.GetGRNbyTrackingNo(TrackingNo); if (obj == null) { obj = GRNDAL.GetGRNbyGRNEditTrackingNo(TrackingNo); } return(obj); } catch (Exception ex) { throw ex; } }
public bool CanCreateGRNforGradingId(Guid GradingId) { int count = -1; count = GRNDAL.GetCountByGradingId(GradingId); if (count == -1) { throw new IndeterminateGRNCountException("Can Not determine if a GRN is Created for this Code."); } else if (count > 0) { throw new MultipleGRNForSingleGradingCodeException(); } else { return(true); } }
public List <GRNListBLL> Search(string GRN, string TrackingNo, Nullable <Guid> ClientId, Nullable <Guid> CommodityId, Nullable <Guid> CommoidtyClassId, Nullable <Guid> CommodityGradeId, Nullable <GRNStatus> Status, Nullable <DateTime> From, Nullable <DateTime> To) { List <GRNListBLL> lstGRNlist = null; List <GRNBLL> GRNlist = new List <GRNBLL>(); // check search parameters are there. if ((string.IsNullOrEmpty(GRN) == true) && (string.IsNullOrEmpty(TrackingNo) == true) && (ClientId == null) && (CommodityId == null) && (CommoidtyClassId == null) && (CommodityGradeId == null) && (Status == null) && (From == null) && (To == null)) { throw (new NULLSearchParameterException("No Search parameter")); } GRNlist = GRNDAL.Search(GRN, TrackingNo, ClientId, CommodityId, CommodityClassId, CommodityGradeId, Status, From, To); if (GRNlist != null) { if (GRNlist.Count > 0) { lstGRNlist = new List <GRNListBLL>(); GRNListBLL oblGRNList = new GRNListBLL(); foreach (GRNBLL o in GRNlist) { GRNListBLL obj = new GRNListBLL(); obj.Id = o.Id; obj.GRN = o.GRN_Number; obj.CommodityId = o.CommodityId; obj.CommodityClassId = o.CommodityClassId; obj.CommodityGradeId = o.CommodityGradeId; obj.Status = (GRNStatus)o.Status; obj.ClinetName = ClientBLL.GetClinetNameById(o.ClientId); obj.OriginalQuantity = o.OriginalQuantity; obj.DateDeposited = Convert.ToDateTime(o.DateDeposited.ToShortDateString()); lstGRNlist.Add(obj); } } else { return(null); } } return(lstGRNlist); }
public bool HasGRN(string tableName, Guid Id) { int count = -1; try { count = GRNDAL.HasGRN(tableName, Id); if (count == 0) { return(false); } else { return(true); } } catch { return(true); } }
public bool AllowGRNEdit(RequestforEditGRNStatus oldStatus, RequestforEditGRNBLL old) { //Update Status accordingly. //Set GRN Status to On Edit bool isSaved = false; SqlConnection conn = null; SqlTransaction tran = null; try { conn = Connection.getConnection(); tran = conn.BeginTransaction(); isSaved = RequestforEditGRNDAL.Update(tran, this); isSaved = GRNDAL.UpdateGRNStatus(this.GRN_Number, GRNStatus.OpenForEdit, tran); if (this.Status == RequestforEditGRNStatus.Approved && oldStatus == RequestforEditGRNStatus.Approved) { // Update GRN Status to OpenForEdit if (isSaved == true) { int at = -1; AuditTrailBLL objat = new AuditTrailBLL(); at = objat.saveAuditTrail(old, this, WFStepsName.RequestforEditGRN.ToString(), UserBLL.GetCurrentUser(), "Open GRN for Edit"); if (at == 1) { WFTransaction.WorkFlowManager(this.TrackingNo); tran.Commit(); } else { tran.Rollback(); isSaved = false; } } else { isSaved = false; tran.Rollback(); } } else if (this.Status == RequestforEditGRNStatus.Cancelled) { WFTransaction.Close(this.TrackingNo); isSaved = true; } } catch (Exception ex) { tran.Rollback(); throw new Exception("Unable to update Data.", ex); } finally { if (conn.State == ConnectionState.Open) { conn.Close(); } if (tran != null) { tran.Dispose(); } } return(isSaved); }
public String[] GetGRNNoBylistEditTrackingNo(string TrackingNo) { return(GRNDAL.GetGRNNoBylistEditTrackingNoForGRN(TrackingNo)); }
public bool IsEditableGRN(string whereClause) { return(GRNDAL.IsEditableGRN(whereClause)); }
public static bool IsEditableGRNByTrackingNo(string TrackingNo) { return(GRNDAL.IsEditableGRNByTrackingNo(TrackingNo)); }
public bool Update(string GRN_number, GRNStatus Status, GRNBLL objGRN, string TrackingNo, DateTime ManagerApprovedDateTime) { bool isSaved = false; SqlTransaction trans; SqlConnection conn = new SqlConnection(); conn = Connection.getConnection(); trans = conn.BeginTransaction(); GRNStatus PreviousStatus; PreviousStatus = (GRNStatus)objGRN.Status; if (objGRN == null) { throw new Exception("Unable to Load GRN Data"); } else { if (objGRN.Id == null || objGRN.Id == Guid.Empty) { throw new Exception("Invalid Grading Information "); } } GradingBLL objGrading = new GradingBLL(); objGrading = objGrading.GetById(objGRN.GradingId); objGrading.TrackingNo = TrackingNo; if (Status != GRNStatus.Cancelled) { if (objGrading == null) { throw new Exception("Unable to Load GRN Data"); } else { if (objGrading.TrackingNo == "") { throw new Exception("Unable to Load GRN Data"); } else { TrackingNo = objGrading.TrackingNo; } } } try { if (Status == GRNStatus.ManagerApproved) { isSaved = GRNDAL.SetGRNStatus(GRN_number, Status, trans, ManagerApprovedDateTime); if (isSaved == true) { int At = -1; AuditTrailBLL objAt = new AuditTrailBLL(); string oldVal = "(GRNNo-" + GRN_number + ") , (Status-" + PreviousStatus.ToString() + ")"; string NewVal = "(GRNNo-" + GRN_number + ") , (Status-" + Status.ToString() + ")"; At = objAt.saveAuditTrailStringFormat(oldVal, NewVal, WFStepName.EditGRN.ToString(), UserBLL.GetCurrentUser(), "Change GRN Status"); if (At == 1) { WarehouseRecieptBLL objWarehouseReciept = new WarehouseRecieptBLL(objGRN); if (objWarehouseReciept.Save() == true) { WFTransaction.WorkFlowManager(TrackingNo); isSaved = true; } else { isSaved = false; } } else { isSaved = false; } } else { isSaved = false; } } else if (Status == GRNStatus.Cancelled) { //Canceling Update isSaved = false; isSaved = GRNDAL.SetGRNStatus(GRN_number, Status, trans, ManagerApprovedDateTime); if (isSaved == true) { int At = -1; AuditTrailBLL objAt = new AuditTrailBLL(); string oldVal = "(GRNNo-" + GRN_number + ") , (Status-" + PreviousStatus.ToString() + ")"; string NewVal = "(GRNNo-" + GRN_number + ") , (Status-" + Status.ToString() + ")"; At = objAt.saveAuditTrailStringFormat(oldVal, NewVal, WFStepName.EditGRN.ToString(), UserBLL.GetCurrentUser(), "Change GRN Status"); if (At == 1) { ECXWF.CMessage msg = WFTransaction.Request(TrackingNo); if (msg == null) { throw new Exception("Unable to get WF Data."); } else if (msg.Name.Trim() == "EditGRN") { WFTransaction.WorkFlowManager(TrackingNo, msg); isSaved = true; } } } } else { isSaved = false; } #region Depricatedcode //// Cancel Implemented by web service. //if (Status == GRNStatus.Cancelled) //{ // WarehouseRecieptBLL objWarehouseReciept = new WarehouseRecieptBLL(); // isSaved = GRNDAL.UpdateGRN(GRN_number, Status, trans); // if (isSaved == true) // { // //isSaved = objWarehouseReciept.Cancel(this.Id); // if (isSaved == true) // { // int At = -1; // AuditTrailBLL objAt = new AuditTrailBLL(); // string oldVal = "(GRNNo-" + GRN_number + ") , (Status-" + PreviousStatus.ToString() + ")"; // string NewVal = "(GRNNo-" + GRN_number + ") , (Status-" + Status.ToString() + ")"; // At = objAt.saveAuditTrailStringFormat(oldVal, NewVal, WFStepName.EditGRN.ToString(), UserBLL.GetCurrentUser(), "Change GRN Status"); // if (At == 1) // { // isSaved = true; // } // else // { // isSaved = false; // } // } // } // else // { // throw new Exception("Unable to Cancel GRN."); // } // if (isSaved == true) // { // WFTransaction.WorkFlowManager(TrackingNo); // } //} #endregion if (isSaved == true) { trans.Commit(); trans.Dispose(); conn.Close(); return(true); } else { trans.Rollback(); trans.Dispose(); conn.Close(); } } catch (Exception ex) { trans.Rollback(); throw ex; } finally { trans.Dispose(); conn.Close(); } return(false); }
/// <summary> /// Gets the net weight by deducting the tare /// </summary> /// <param name="GrossWeight"></param> /// <param name="BagTypeId"></param> /// <param name="NoBags"></param> /// <returns></returns> /// public Nullable <Guid> Add(List <GRNServiceBLL> listGRNService) { bool IsSaved = false; bool canCreate = false;; try { canCreate = this.CanCreateGRNforGradingId(this.GradingId); } catch (Exception ex) { throw ex; } if (canCreate == false) { return(null); } Nullable <Guid> id = null; SqlTransaction tran; string warehousecode; warehousecode = WarehouseBLL.GetWarehouseCode(this.WarehouseId); SqlConnection conn = new SqlConnection(); conn = Connection.getConnection(); tran = conn.BeginTransaction(); try { id = GRNDAL.InsertNewGRN(this, warehousecode, tran); if (id != null) { if (listGRNService != null) { GRNServiceBLL objSer = new GRNServiceBLL(); IsSaved = objSer.Save((Guid)id, listGRNService, tran); //Audit Trail Both GRN And GRN Service. int at = -1; AuditTrailBLL objAt = new AuditTrailBLL(); this.Id = (Guid)id; at = objAt.saveAuditTrail(this, WFStepsName.AddGRN.ToString(), UserBLL.GetCurrentUser(), "Add New GRN"); if (at == 1) { IsSaved = true; } else { IsSaved = false; } } else { IsSaved = true; } if (IsSaved == true) { WFTransaction.WorkFlowManager(this.TrackingNo); tran.Commit(); } else { tran.Rollback(); } } else { tran.Rollback(); } } catch (Exception ex) { tran.Rollback(); throw new Exception("Unable to update database.", ex); } finally { tran.Dispose(); conn.Close(); } return(id); }
public String[] GetGradingResultResultCodeBylistTrackingNo(string TrackingNo) { return(GRNDAL.GetParentCodeBylistTrackingNo(TrackingNo)); }