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 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); }