Esempio n. 1
0
        public CommisionStructureLineVM GetCommisionStructureLineByID(int commisionStructureLineID)
        {
            try
            {
                tblCommisionStructureLine commisionStructureLineData = unitOfWork.TblCommisionStructureLineRepository.GetByID(commisionStructureLineID);

                CommisionStructureLineVM commisionStructureLineVM = new CommisionStructureLineVM();
                commisionStructureLineVM.CommisionStructureLineID = commisionStructureLineData.ComStructLineID;
                commisionStructureLineVM.CommisionStructureID     = commisionStructureLineData.ComStructID != null?Convert.ToInt32(commisionStructureLineData.ComStructID) : 0;

                if (commisionStructureLineVM.CommisionStructureID > 0)
                {
                    commisionStructureLineVM.CommisionStructureName = commisionStructureLineData.tblCommisionStructureHeader.ComStructName;
                }

                commisionStructureLineVM.RateCategoryID = commisionStructureLineData.RateCategoryID != null?Convert.ToInt32(commisionStructureLineData.RateCategoryID) : 0;

                if (commisionStructureLineVM.RateCategoryID > 0)
                {
                    commisionStructureLineVM.RateCategoryName = commisionStructureLineData.tblRateCategory.RateCategory;
                }

                commisionStructureLineVM.IsAgeConsider = commisionStructureLineData.IsAgeConsider;
                commisionStructureLineVM.AgeFrom       = commisionStructureLineData.AgeFrom != null?Convert.ToInt32(commisionStructureLineData.AgeFrom) : 0;

                commisionStructureLineVM.AgeTo = commisionStructureLineData.AgeTo != null?Convert.ToInt32(commisionStructureLineData.AgeTo) : 0;

                commisionStructureLineVM.IsFixed   = commisionStructureLineData.isFixed;
                commisionStructureLineVM.RateValue = commisionStructureLineData.RateValue != null?Convert.ToDouble(commisionStructureLineData.RateValue) : 0;

                commisionStructureLineVM.CreatedDate = commisionStructureLineData.CreatedDate != null?commisionStructureLineData.CreatedDate.ToString() : string.Empty;

                commisionStructureLineVM.ModifiedDate = commisionStructureLineData.ModifiedDate != null?commisionStructureLineData.ModifiedDate.ToString() : string.Empty;

                commisionStructureLineVM.CreatedBy = commisionStructureLineData.CreatedBy != null?Convert.ToInt32(commisionStructureLineData.CreatedBy) : 0;

                commisionStructureLineVM.ModifiedBy = commisionStructureLineData.ModifiedBy != null?Convert.ToInt32(commisionStructureLineData.ModifiedBy) : 0;

                return(commisionStructureLineVM);
            }
            catch (Exception ex)
            {
                throw;
            }
        }
Esempio n. 2
0
        public bool UpdateCommisionStructureLine(CommisionStructureLineVM commisionStructureLineVM)
        {
            using (var dbTransaction = unitOfWork.dbContext.Database.BeginTransaction())
            {
                try
                {
                    tblCommisionStructureLine commisionStructureLine = unitOfWork.TblCommisionStructureLineRepository.GetByID(commisionStructureLineVM.CommisionStructureLineID);
                    commisionStructureLine.ComStructID    = commisionStructureLineVM.CommisionStructureID;
                    commisionStructureLine.RateCategoryID = commisionStructureLineVM.RateCategoryID;
                    commisionStructureLine.IsAgeConsider  = commisionStructureLineVM.IsAgeConsider;

                    if (commisionStructureLine.IsAgeConsider)
                    {
                        commisionStructureLine.AgeFrom = commisionStructureLineVM.AgeFrom;
                        commisionStructureLine.AgeTo   = commisionStructureLineVM.AgeTo;
                    }
                    else
                    {
                        commisionStructureLine.AgeFrom = null;
                        commisionStructureLine.AgeTo   = null;
                    }

                    commisionStructureLine.isFixed      = commisionStructureLineVM.IsFixed;
                    commisionStructureLine.RateValue    = commisionStructureLineVM.RateValue;
                    commisionStructureLine.ModifiedDate = DateTime.Now;
                    commisionStructureLine.ModifiedBy   = commisionStructureLineVM.ModifiedBy;
                    unitOfWork.TblCommisionStructureLineRepository.Update(commisionStructureLine);
                    unitOfWork.Save();

                    //Complete the Transaction
                    dbTransaction.Commit();
                    return(true);
                }
                catch (Exception ex)
                {
                    //Roll back the Transaction
                    dbTransaction.Rollback();
                    return(false);
                }
            }
        }
Esempio n. 3
0
        public bool DeleteCommisionStructureLine(int commisionStructureLineID)
        {
            using (var dbTransaction = unitOfWork.dbContext.Database.BeginTransaction())
            {
                try
                {
                    tblCommisionStructureLine commisionStructureLine = unitOfWork.TblCommisionStructureLineRepository.GetByID(commisionStructureLineID);
                    unitOfWork.TblCommisionStructureLineRepository.Delete(commisionStructureLine);
                    unitOfWork.Save();

                    //Complete the Transaction
                    dbTransaction.Commit();
                    return(true);
                }
                catch (Exception ex)
                {
                    //Roll back the Transaction
                    dbTransaction.Rollback();
                    return(false);
                }
            }
        }