public async Task AddAsync(Models.Ogrenci ogrenci) { Random rnd = new Random(); string fakulteNo = "12"; string bolumNo = "10"; ogrenci.No = "G" + DateTime.Now.Year.ToString().Substring(2, 2) + fakulteNo + bolumNo + rnd.Next(100, 999); using (IDbConnection dbConnection = _connection) { string query = @"INSERT INTO [dbo].[Ogrenci] ( [No], [Ad], [Soyad], [Gsm], [Eposta], [Durum], [CreatedDate], [ModifiedDate]) VALUES ( @No, @Ad, @Soyad, @Gsm, @Eposta, @Durum, @CreatedDate, @ModifiedDate)"; await dbConnection.ExecuteAsync(query, ogrenci); } }
public async Task ModifiedAsync(Models.Ogrenci ogrenci) { using (IDbConnection dbConnection = _connection) { string query = @"UPDATE [dbo].[Ogrenci] SET Ad = @Ad, Soyad = @Soyad, Gsm = @Gsm, Eposta = @Eposta, Durum = @Durum, ModifiedDate = @ModifiedDate WHERE Id =@Id"; await dbConnection.ExecuteAsync(query, ogrenci); } }
public async Task AddAsync(OgrenciRequest ogrenciRequest) { Models.Ogrenci ogrenci = new Models.Ogrenci() { Ad = ogrenciRequest.Ad, No = ogrenciRequest.No, Soyad = ogrenciRequest.Soyad, CreatedDate = DateTime.Now, Gsm = ogrenciRequest.Gsm, Eposta = ogrenciRequest.Eposta, Durum = ogrenciRequest.Durum, ModifiedDate = DateTime.Now }; await _ogrenciRepository.AddAsync(ogrenci); }
public ActionResult OgrenciEkle(Models.Ogrenci kayit) { if (ModelState.IsValid) { var islemSonuc = _repository.Kaydet(kayit); if (islemSonuc.BasariliMi) { return(RedirectToAction("OgrenciListesi")); } else { ModelState.AddModelError("", islemSonuc.Mesaj); return(OgrenciEkle()); } } else { return(OgrenciEkle()); } }