public bool Update() { bool isSaved = false; SqlConnection conn = null; SqlTransaction tran = null; RequestforApprovedGRNCancelationBLL objEdit = new RequestforApprovedGRNCancelationBLL(); objEdit = objEdit.GetById(Id); try { conn = Connection.getConnection(); tran = conn.BeginTransaction(); isSaved = RequestforApprovedGRNCancelationDAL.Update(tran, this); if (isSaved == true) { string AppMode = Utility.GetApplicationName() + " - AppGRNCancel"; AuditTrailBLL objAT = new AuditTrailBLL(); if (objAT.saveAuditTrail(objEdit, this, AppMode, UserBLL.GetCurrentUser(), "Update-ApprovedGRNCancelRequest") == 1) { tran.Commit(); } else { tran.Rollback(); return(false); } } else { tran.Rollback(); return(false); } } 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 List <RequestforApprovedGRNCancelationBLL> Search(string GRNNo, string TrackingNo, Nullable <RequestforEditGRNStatus> status, Nullable <DateTime> from, Nullable <DateTime> to) { if ((string.IsNullOrEmpty(GRNNo) == true) && (string.IsNullOrEmpty(TrackingNo) == true) && (status == null) && (from == null) && (to == null) ) { throw new Exception("Please provide search parameter."); } List <RequestforApprovedGRNCancelationBLL> list = null; try { list = RequestforApprovedGRNCancelationDAL.Search(GRNNo, TrackingNo, status, from, to); } catch (Exception ex) { throw new Exception("Unable to Search please try agian", ex); } return(list); }
public bool Add() { int At = -1; bool isSaved = false; SqlConnection conn = new SqlConnection(); SqlTransaction tran; conn = Connection.getConnection(); tran = conn.BeginTransaction(); AuditTrailBLL objAt = new AuditTrailBLL(); try { string TrackingNo = ""; TrackingNo = WFTransaction.GetTransaction("ApprovedGRNCancel", tran); this.Id = Guid.NewGuid(); this.TrackingNo = TrackingNo; this.CreatedBy = UserBLL.GetCurrentUser(); this.CreatedTimestamp = DateTime.Now; isSaved = RequestforApprovedGRNCancelationDAL.save(tran, this); isSaved = WarehouseRecieptBLL.RequestCancel(this.GRNId, TrackingNo, this.Remark); if (isSaved == true) { At = objAt.saveAuditTrail(this, WFStepsName.CancelGRN.ToString(), UserBLL.GetCurrentUser(), "Add Approved GRN Cancelation Request"); if (At == 1) { tran.Commit(); } else { isSaved = false; } } else { isSaved = false; } if (isSaved != true) { if (TrackingNo != "") { WFTransaction.Close(TrackingNo); } tran.Rollback(); if (At == 1) { objAt.RoleBack(); } } } catch (Exception ex) { tran.Rollback(); if (At == 1) { objAt.RoleBack(); } throw new Exception("Unable to Add New record", ex); } finally { tran.Dispose(); if (conn.State == ConnectionState.Open) { conn.Close(); } conn.Dispose(); } return(isSaved); }
public bool CancelGRNCancellationRequest(string TrackingNo) { Utility.LogException(new Exception(TrackingNo)); bool isSaved = false; SqlConnection conn = null; SqlTransaction tran = null; RequestforApprovedGRNCancelationBLL objEdit = new RequestforApprovedGRNCancelationBLL(); objEdit = objEdit.GetByTrackingNo(TrackingNo); this.Id = objEdit.Id; this.GRNId = objEdit.GRNId; this.RequestedBy = objEdit.RequestedBy; this.DateRequested = objEdit.DateRequested;; this.Remark = objEdit.Remark; // set status to cancelled this.Status = RequestforApprovedGRNCancelationStatus.Cancelled; this.GRN_Number = objEdit.GRN_Number; try { conn = Connection.getConnection(); tran = conn.BeginTransaction(); isSaved = RequestforApprovedGRNCancelationDAL.Update(tran, this); if (isSaved == true) { WFTransaction.Close(TrackingNo); string AppMode = Utility.GetApplicationName() + " - AppGRNCancel"; AuditTrailBLL objAT = new AuditTrailBLL(); if (objAT.saveAuditTrail(objEdit, this, AppMode, UserBLL.GetCurrentUser(), "Update-ApprovedGRNCancelRequest") == 1) { tran.Commit(); } else { tran.Rollback(); return(false); } } else { tran.Rollback(); return(false); } } catch (Exception ex) { tran.Rollback(); throw ex; } finally { if (conn.State == ConnectionState.Open) { conn.Close(); } if (tran != null) { tran.Dispose(); } } return(isSaved); }
public RequestforApprovedGRNCancelationBLL GetByTrackingNo(string TrackingNo) { return(RequestforApprovedGRNCancelationDAL.GetByTrackingNo(TrackingNo)); }
public RequestforApprovedGRNCancelationBLL GetById(Guid Id) { return(RequestforApprovedGRNCancelationDAL.GetById(Id)); }