public bool Update() { bool isSaved = false; SqlConnection conn = null; SqlTransaction tran = null; ScalingBLL objScaling = new ScalingBLL(); objScaling = objScaling.GetById(this.Id); if (objScaling == null) { throw new Exception("Null Old Value Exception"); } try { conn = Connection.getConnection(); tran = conn.BeginTransaction(); isSaved = ScalingDAL.Update(this, tran); if (isSaved == true) { int at = -1; AuditTrailBLL objat = new AuditTrailBLL(); at = objat.saveAuditTrail(objScaling, this, WFStepsName.EditScaling.ToString(), UserBLL.GetCurrentUser(), "Update Scaling Information"); if (at == 1) { tran.Commit(); } else { isSaved = false; tran.Rollback(); } } } catch (Exception ex) { throw new Exception("An Error has ccured please try again. If the error persists Contact the Administrator", ex); } finally { if (tran != null) { tran.Dispose(); } if (conn.State == ConnectionState.Open) { conn.Close(); } } return(isSaved); }
public Guid GetScalingIdByGradingId(Guid Id) { ScalingBLL obj = new ScalingBLL(); Nullable <Guid> ScalingId = null; try { ScalingId = ScalingDAL.GetApprovedScalingIdByGradingId(Id); if (ScalingId != null) { return((Guid)ScalingId); } else { throw new Exception("Invalid Scaling Id."); } } catch (Exception ex) { throw ex; } }
public static float GetApprovedWeightByGradingId(Guid id) { ScalingBLL obj = new ScalingBLL(); Nullable <float> weight = null; try { weight = ScalingDAL.GetApprovedWeightInformationByGradingId(id); if (weight != null) { return((float)weight); } else { throw new Exception("Total Approved weight exception."); } } catch (Exception ex) { throw ex; } }