public SpotterSummaryViewModel GetSpotterMaster(string spotterRefNum)
        {
            glog.Debug("GetSpotterMaster: Entry");
            var result = new ResultViewModel();

            using (var db = new MainDbContext())
            {
                try
                {
                    var SpotterSummary = new SpotterSummaryViewModel();
                    var Summary        = db.Spotter_Master.Where(w => w.SpotterRefNumber == spotterRefNum).FirstOrDefault();
                    if (Summary != null)
                    {
                        SpotterSummary.Amount          = Math.Round((decimal)Summary.Amount, 2);
                        SpotterSummary.PreparationDate = Summary.PreparationDate.ToString("dd/MM/yyyy", CultureInfo.InvariantCulture);
                        SpotterSummary.SpotterID       = Summary.SpotterID;
                        SpotterSummary.Status          = Summary.Status;
                        SpotterSummary.CreatedBy       = Summary.CreatedBy;
                        SpotterSummary.CreatedDate     = Summary.CreatedDate.ToString();
                    }

                    return(SpotterSummary);
                }
                catch (Exception ex)
                {
                    glog.Error("GetSpotterMaster Exception: " + ex.Message + ex.InnerException);
                    result.Status  = 0;
                    result.Message = "Please contact MIS, error: " + ex.Message;
                    return(new SpotterSummaryViewModel());
                }
            }
        }
예제 #2
0
        public ApprovalSpotterDetails GetApprovalSpotterDetails(string SpotterRefNo, string strStatus)
        {
            ApprovalSpotterDetails obj = new ApprovalSpotterDetails();

            using (var db = new MainDbContext())
            {
                try
                {
                    glog.Debug("GetApprovalSpotterDetails: Entry");

                    var SpotterSummary = new SpotterSummaryViewModel();
                    var Summary        = db.Spotter_Master.Where(w => w.SpotterRefNumber == SpotterRefNo).FirstOrDefault();
                    var Reason         = db.Spotter_Detail.Where(w => w.SpotterId == Summary.SpotterID).FirstOrDefault().RejectionReason;
                    if (Summary != null)
                    {
                        obj.SpotterSummary.SpotterRefNumber = Summary.SpotterRefNumber;
                        obj.SpotterSummary.Amount           = Math.Round((decimal)Summary.Amount, 2);
                        obj.SpotterSummary.ApprovedAmount   = Math.Round((decimal)Summary.ApprovedAmount, 2);
                        obj.SpotterSummary.PreparationDate  = Summary.PreparationDate.ToString("dd/MM/yyyy", CultureInfo.InvariantCulture);
                        obj.SpotterSummary.SpotterID        = Summary.SpotterID;
                        obj.SpotterSummary.Status           = Summary.Status;
                        obj.SpotterSummary.CreatedBy        = Summary.CreatedBy;
                        obj.SpotterSummary.CreatedDate      = Summary.CreatedDate.ToString();
                        obj.SpotterSummary.RejectReason     = Reason;
                    }

                    var outstandingSpotterFee = new List <OutstandingSpotterFeeViewModel>();
                    outstandingSpotterFee = _clsPayment.RetrieveSpotterFeeByRefNumber(SpotterRefNo, strStatus);

                    obj.OutstandingFee = outstandingSpotterFee;
                }
                catch (Exception ex)
                {
                    var result = new ResultViewModel();
                    glog.Error("GetApprovalSpotterDetails Exception: " + ex.Message);
                    result.Status  = 0;
                    result.Message = "Please contact MIS, error: " + ex.Message;
                    glog.Debug("GetApprovalSpotterDetails: Exit");
                }
            }
            glog.Debug("GetApprovalSpotterDetails: Exit");
            return(obj);
        }