public ListResponse <VadeModel> VadeListesi()
        {
            ListResponse <VadeModel> response = new ListResponse <VadeModel>();

            using (var db = new BenimKredimModel())
            {
                response.Entities = db.BankCredits.Where(x => x.CreditTypeId == (int)BankCreditType.Car)
                                    .Select(x => new VadeModel {
                    Vade = x.InstalmentCount
                })
                                    .Distinct().OrderBy(x => x.Vade)
                                    .ToList();

                response.TotalCount = response.Entities.Count();
            }

            return(response);
        }
示例#2
0
        static void Main(string[] args)
        {
            using (var db = new BenimKredimModel())
            {
                try
                {
                    Banks bank = new Banks()
                    {
                        Name = "Garanti", InsertByUser = 1, InsertDate = DateTime.Now
                    };
                    db.Banks.Add(bank);

                    db.SaveChanges();
                }
                catch (Exception)
                {
                    throw;
                }
            }
        }
        public ListResponse <TasitKredisiModel> List(TasitKredisiSearchRequest request)
        {
            ListResponse <TasitKredisiModel> response = new ListResponse <TasitKredisiModel>();

            if (request.Vade == 0 || request.Tutar == 0)
            {
                return(response);
            }


            using (var db = new BenimKredimModel())
            {
                response.Entities = db.BankCredits.Where(x => x.CreditTypeId == (int)BankCreditType.Car & x.InstalmentCount == request.Vade)
                                    .Select(x => new TasitKredisiModel()
                {
                    BankaAdi    = x.Bank.Name,
                    VadeOrani   = x.ProfitRate,
                    VadeliTutar = (request.Tutar + request.Tutar * x.ProfitRate)
                })
                                    .ToList();
            }

            return(response);
        }