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