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); }
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); }