Example #1
0
        public async Task <bool> Update(tbl_ipos_pawneditem model)
        {
            try
            {
                using (var uow = _unitOfWorkFactory.Create())
                {
                    var result = await FindById(model.PawnedItemId);

                    if (result != null)
                    {
                        uow.PawnedItemRepository.Update(model);
                        await uow.SaveChangesAsync();

                        return(true);
                    }
                    else
                    {
                        return(false);
                    }
                }
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message);
            }
        }
Example #2
0
        public async Task <JsonResult> UpdatePawnedItem(tbl_ipos_pawneditem list)
        {
            try
            {
                bool   success = false;
                string message = "";

                if (string.IsNullOrEmpty(list.PawnedItemId.ToString()) || list.PawnedItemId.ToString() == "0")
                {
                    message = "Error saving data. Please contact administrator.";
                }
                else
                {
                    tbl_ipos_pawneditem model = null;

                    model = await _pawningService.FindById(list.PawnedItemId);

                    model.Status     = list.Status;
                    model.IsReleased = list.IsReleased;

                    var result = await _pawningService.Save(model);

                    success = result;
                    if (result)
                    {
                        message = "Successfully pawned.";
                    }
                    else
                    {
                        message = "Error saving data. Please contact administrator.";
                    }
                }

                return(Json(new { success = success, message = message }));
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message);
            }
        }
Example #3
0
        public async Task <JsonResult> SaveTransactionPawning(PawnshopTransactionModel model)
        {
            try
            {
                bool   success = false;
                string message = "";

                if (string.IsNullOrEmpty(model.TransactionId.ToString()) || model.TransactionId.ToString() == "0")
                {
                    tbl_ipos_pawnshop_transactions model1 = new tbl_ipos_pawnshop_transactions();
                    model1.TransactionNo   = model.TransactionNo;
                    model1.TransactionDate = model.TransactionDate;
                    model1.TransactionType = "Pawning";
                    model1.CustomerId      = model.CustomerId;
                    model1.Terminal        = "1";
                    model1.Status          = "On Process";
                    model1.ReviewedBy      = "";
                    model1.ApprovedBy      = "";
                    model1.CreatedBy       = "";
                    model1.CreatedAt       = DateTime.Now;

                    tbl_ipos_appraiseditem model2 = new tbl_ipos_appraiseditem();
                    model2.AppraiseDate          = DateTime.Now;
                    model2.AppraiseNo            = "";
                    model2.ItemTypeId            = model.ItemTypeId;
                    model2.ItemCategoryId        = model.ItemCategoryId;
                    model2.ItemName              = model.ItemName;
                    model2.Weight                = "";
                    model2.AppraisedValue        = 0;
                    model2.Remarks               = model.Remarks;
                    model2.CustomerFirstName     = model.first_name;
                    model2.CustomerLastName      = model.last_name;
                    model2.IsPawned              = false;
                    model2.CreatedAt             = DateTime.Now;
                    model2.CreatedBy             = "";
                    model2.PawnshopTransactionId = model.TransactionNo;

                    tbl_ipos_pawneditem model3 = new tbl_ipos_pawneditem();
                    model3.PawnedItemNo         = "";
                    model3.PawnedDate           = null;
                    model3.PawnedDate           = "";
                    model3.CustomerId           = "";
                    model3.PawnedItemContractNo = "";
                    model3.LoanableAmount       = "";
                    model3.InterestRate         = "";
                    model3.InterestAmount       = "";
                    model3.InitialPayment       = "";
                    model3.ServiceCharge        = "";
                    model3.Others             = "";
                    model3.IsInterestDeducted = "";
                    model3.NetCashOut         = "";
                    model3.TermsId            = "";
                    model3.ScheduleOfPayment  = "";
                    model3.NoOfPayments       = "";
                    model3.DueDateStart       = "";
                    model3.DueDateEnd         = "";
                    model3.Status             = "";
                    model3.IsReleased         = "";
                    model3.CreatedBy          = "";
                    model3.CreatedAt          = "";

                    var result = await _pawnshopTransactionService.SavePawnshopTransactions(model1);

                    var result1 = await _appraisalService.Save(model2);

                    success = result;
                    success = result1;

                    if (result)
                    {
                        tbl_ipos_no_generator noGenerator = new tbl_ipos_no_generator();
                        noGenerator = await _referenceService.FindByIdAndTerminalNoGenerator(1, "1");

                        noGenerator.No = Int32.Parse(model.TransactionNo) + 1;
                        await _referenceService.UpdateNoGenerator(noGenerator);

                        message = "Successfully saved.";
                    }
                    else
                    {
                        message = "Error saving data. Duplicate entry.";
                    }
                }

                return(Json(new { success = success, message = message }));
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message);
            }
        }
Example #4
0
        public async Task <JsonResult> SavePawnedItem(tbl_ipos_pawneditem list)
        {
            try
            {
                tbl_ipos_pawneditem model = null;

                bool   success = false;
                string message = "";

                if (string.IsNullOrEmpty(list.PawnedItemId.ToString()) || list.PawnedItemId.ToString() == "0")
                {
                    //DateTime dt = DateTime.ParseExact(item.AppraiseDate, "yyyy/MM/dd", CultureInfo.InvariantCulture);

                    model = new tbl_ipos_pawneditem();
                    model.PawnedItemId         = list.PawnedItemId;
                    model.PawnedItemNo         = list.PawnedItemNo;
                    model.PawnedDate           = list.PawnedDate;
                    model.CustomerId           = list.CustomerId;
                    model.PawnedItemContractNo = list.PawnedItemContractNo;
                    model.LoanableAmount       = list.LoanableAmount;
                    model.InterestRate         = list.InterestRate;
                    model.InterestAmount       = list.InterestAmount;
                    model.InitialPayment       = list.InitialPayment;
                    model.ServiceCharge        = list.ServiceCharge;
                    model.Others             = list.Others;
                    model.IsInterestDeducted = list.IsInterestDeducted;
                    model.NetCashOut         = list.NetCashOut;
                    model.TermsId            = list.TermsId;
                    model.ScheduleOfPayment  = list.ScheduleOfPayment;
                    model.NoOfPayments       = list.NoOfPayments;
                    model.DueDateStart       = list.DueDateStart;
                    model.DueDateEnd         = list.DueDateEnd; //DateTime.Parse(list.DueDateEnd);
                    model.Status             = "Pending";
                    model.IsReleased         = false;
                    model.CreatedBy          = "";
                    model.CreatedAt          = DateTime.Now;

                    var result = await _pawningService.Save(model);

                    success = result;
                    if (result)
                    {
                        message = "Successfully saved.";
                    }
                    else
                    {
                        message = "Error saving data. Duplicate entry.";
                    }
                }
                else
                {
                    model = await _pawningService.FindById(list.PawnedItemId);

                    model.LoanableAmount     = list.LoanableAmount;
                    model.InterestRate       = list.InterestRate;
                    model.InterestAmount     = list.InterestAmount;
                    model.InitialPayment     = list.InitialPayment;
                    model.ServiceCharge      = list.ServiceCharge;
                    model.Others             = list.Others;
                    model.IsInterestDeducted = list.IsInterestDeducted;
                    model.NetCashOut         = list.NetCashOut;
                    model.TermsId            = list.TermsId;
                    model.ScheduleOfPayment  = list.ScheduleOfPayment;
                    model.NoOfPayments       = list.NoOfPayments;
                    model.DueDateStart       = list.DueDateStart;
                    model.DueDateEnd         = list.DueDateEnd;
                    model.Status             = list.Status;
                    model.IsReleased         = list.IsReleased;

                    var result = await _pawningService.Save(model);

                    success = result;
                    if (result)
                    {
                        message = "Successfully updated.";
                    }
                    else
                    {
                        message = "Error saving data. Please contact administrator.";
                    }
                }

                return(Json(new { success = success, message = message }));
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message);
            }
        }
Example #5
0
        public async Task <JsonResult> SavePawning(tbl_ipos_pawneditem model)
        {
            try
            {
                bool   success = false;
                string message = "";

                if (string.IsNullOrEmpty(model.PawnedItemId.ToString()) || model.PawnedItemId.ToString() == "0")
                {
                    tbl_ipos_pawneditem model1 = new tbl_ipos_pawneditem();
                    model1.PawnedItemNo         = model.PawnedItemNo;
                    model1.PawnedDate           = model.PawnedDate;
                    model1.TransactionNo        = model.TransactionNo;
                    model1.PawnedItemContractNo = model.PawnedItemContractNo;
                    model1.LoanableAmount       = model.LoanableAmount;
                    model1.InterestRate         = model.InterestRate;
                    model1.InterestAmount       = model.InterestAmount;
                    model1.InitialPayment       = model.InitialPayment;
                    model1.ServiceCharge        = model.ServiceCharge;
                    model1.Others             = model.Others;
                    model1.IsInterestDeducted = model.IsInterestDeducted;
                    model1.NetCashOut         = model.NetCashOut;
                    model1.TermsId            = model.TermsId;
                    model1.ScheduleOfPayment  = model.ScheduleOfPayment;
                    model1.NoOfPayments       = model.NoOfPayments;
                    model1.DueDateStart       = model.DueDateStart;
                    model1.DueDateEnd         = model.DueDateEnd;
                    model1.Status             = "";
                    model1.IsReleased         = false;
                    model1.CreatedBy          = "";
                    model1.CreatedAt          = DateTime.Now;

                    var result = await _pawningService.Save(model1);

                    success = result;

                    if (result)
                    {
                        tbl_ipos_pawnshop_transactions model2 = await _pawnshopTransactionService.FindByTransactionNo(model.TransactionNo);

                        model2.Status = "For approval";
                        await _pawnshopTransactionService.UpdatePawnshopTransactions(model2);

                        message = "Successfully saved.";
                    }
                    else
                    {
                        message = "Error saving data. Duplicate entry.";
                    }
                }
                else
                {
                    tbl_ipos_pawneditem model1 = new tbl_ipos_pawneditem();
                    model1 = await _pawningService.FindById(model.PawnedItemId);

                    model1.PawnedDate           = model.PawnedDate;
                    model1.TransactionNo        = model.TransactionNo;
                    model1.PawnedItemContractNo = model.PawnedItemContractNo;
                    model1.LoanableAmount       = model.LoanableAmount;
                    model1.InterestRate         = model.InterestRate;
                    model1.InterestAmount       = model.InterestAmount;
                    model1.InitialPayment       = model.InitialPayment;
                    model1.ServiceCharge        = model.ServiceCharge;
                    model1.Others             = model.Others;
                    model1.IsInterestDeducted = model.IsInterestDeducted;
                    model1.NetCashOut         = model.NetCashOut;
                    model1.TermsId            = model.TermsId;
                    model1.ScheduleOfPayment  = model.ScheduleOfPayment;
                    model1.NoOfPayments       = model.NoOfPayments;
                    model1.DueDateStart       = model.DueDateStart;
                    model1.DueDateEnd         = model.DueDateEnd;

                    var result = await _pawningService.Update(model1);

                    success = result;
                    if (result)
                    {
                        tbl_ipos_pawnshop_transactions model2 = await _pawnshopTransactionService.FindByTransactionNo(model.TransactionNo);

                        model2.Status = "For approval";
                        await _pawnshopTransactionService.UpdatePawnshopTransactions(model2);

                        message = "Successfully updated.";
                    }
                    else
                    {
                        message = "Error saving data. Please contact administrator.";
                    }
                }

                return(Json(new { success = success, message = message }));
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message);
            }
        }