public bool Save(SqlTransaction tran) { bool isSaved = false; try { isSaved = TrucksMissingOnSamplingDAL.Insert(this, tran); if (isSaved == true) { int at = -1; AuditTrailBLL objAt = new AuditTrailBLL(); at = objAt.saveAuditTrail(this, WFStepsName.ConfirmTrucksForsamp.ToString(), UserBLL.GetCurrentUser(), "Missing On Confirmation"); if (at != 1) { isSaved = false; } } } catch (Exception ex) { throw ex; } return(isSaved); }
public bool UpdateStatus() { bool isSaved = false; SqlTransaction tran = null; SqlConnection conn = null; int at = -1; try { TrucksMissingOnSamplingBLL objNew = new TrucksMissingOnSamplingBLL(); TrucksMissingOnSamplingBLL objOld = TrucksMissingOnSamplingDAL.GetById(this.Id); objNew = objOld.Copy(objOld); objNew.Id = this.Id; objNew.Status = this.Status; conn = Connection.getConnection(); tran = conn.BeginTransaction(); isSaved = TrucksMissingOnSamplingDAL.SetStatus(objNew.Id, objNew.Status, tran); if (isSaved == true) { AuditTrailBLL objAt = new AuditTrailBLL(); at = objAt.saveAuditTrail(objNew, objOld, WFStepsName.TrucksMissingForSamp.ToString(), UserBLL.GetCurrentUser(), "Update Status Missing Traucks"); if (at == 1) { tran.Commit(); } else { tran.Rollback(); isSaved = false; } } else { isSaved = false; } } catch (Exception ex) { throw ex; } finally { if (tran != null) { tran.Dispose(); } if (conn.State == ConnectionState.Open) { conn.Close(); } } return(isSaved); }
public List <TrucksMissingOnSamplingBLL> GetAbsentTrucks(Guid Warehouseid) { return(TrucksMissingOnSamplingDAL.GetAbsentTrucks(Warehouseid)); }