Beispiel #1
0
        public int GetCountOfTotalValueGradingFactors(Guid CommodityGradeId)
        {
            Nullable <int> count = null;

            try
            {
                count = GradingFactorDAL.GetGradingFactorInTotalValueCount(CommodityGradeId);
                return((int)count);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
Beispiel #2
0
        public bool Update(GradingFactorBLL oldGF)
        {
            bool           isSaved = false;
            SqlTransaction tran    = null;
            SqlConnection  conn    = null;

            try
            {
                conn    = Connection.getConnection();
                tran    = conn.BeginTransaction();
                isSaved = GradingFactorDAL.Update(this, tran);
                int At = -1;
                if (isSaved == true)
                {
                    AuditTrailBLL objAT = new AuditTrailBLL();
                    At = objAT.saveAuditTrail(this, oldGF, WFStepsName.GradingFactorUpdate.ToString(), UserBLL.GetCurrentUser(), "Update Grading Factor");
                }
                if (At == 1)
                {
                    tran.Commit();
                    return(true);
                }
                else
                {
                    tran.Rollback();
                    return(false);
                }
            }
            catch (Exception ex)
            {
                tran.Rollback();
                throw new Exception("Unable to saved reocrd", ex);
            }
            finally
            {
                tran.Dispose();
                if (conn.State == ConnectionState.Open)
                {
                    conn.Close();
                }
            }
        }
Beispiel #3
0
 public List <GradingFactorBLL> Search(String Name, Nullable <Guid> GradingfactorTypeId, Nullable <GradingFactorStatus> Status)
 {
     return(GradingFactorDAL.Search(Name, GradingfactorTypeId, Status));
 }
Beispiel #4
0
 public List <GradingFactorBLL> GetGradingFactors(Guid CommodityGradeId)
 {
     return(GradingFactorDAL.GetGradingFactors(CommodityGradeId));
 }