public static ClassDTO ToDto(DAL.Class c) { return(new ClassDTO() { classId = c.classId, className = c.className }); }
public async Task <IActionResult> Add(DAL.Class @class) { await _class.AddClass(@class); await AddLog(@class.NAME + " adlı sınıf eklendi."); return(RedirectToAction("Add", new { success = true })); }
public async Task <IActionResult> Edit(DAL.Class @class) { await _class.EditClass(@class); await AddLog(@class.NAME + " adlı sınıf güncellendi."); return(RedirectToAction("Edit", new { id = @class.CLASSID, success = true })); }
public DAL.Class GetClass(DAL.Class @class) { var query = "SELECT TOP 1 * FROM CLASS WHERE CLASSID=@CLASSID"; var parameters = new { CLASSID = @class.CLASSID }; return(_connection.GetConnection().Query <DAL.Class>(query, parameters).SingleOrDefault()); }
public async Task DeleteClass(DAL.Class @class) { var query = "DELETE FROM CLASS WHERE CLASSID=@CLASSID"; var parameters = new { CLASSID = @class.CLASSID }; await Execute(query, parameters); }
public async Task AddClass(DAL.Class @class) { var query = "INSERT INTO CLASS(CODE,NAME,SORT,STATUS) VALUES(@CODE,@NAME,@SORT,@STATUS)"; var parameters = new { CODE = @class.CODE, NAME = @class.NAME, SORT = @class.SORT, STATUS = @class.STATUS }; await Execute(query, parameters); }
public async Task EditClass(DAL.Class @class) { var query = "UPDATE CLASS SET CODE=@CODE,NAME=@NAME,SORT=@SORT,STATUS=@STATUS WHERE CLASSID=@CLASSID"; var parameters = new { CODE = @class.CODE, NAME = @class.NAME, SORT = @class.SORT, STATUS = @class.STATUS, CLASSID = @class.CLASSID }; await Execute(query, parameters); }
public async Task <IActionResult> Delete() { if (!string.IsNullOrEmpty(RouteData.Values["id"].ToString())) { var id = int.Parse(RouteData.Values["id"].ToString()); var @class = new DAL.Class { CLASSID = id }; await _class.DeleteClass(@class); await AddLog(id + " numaralı sınıf silindi."); } return(RedirectToAction("Index")); }
public IActionResult Edit() { var data = new DAL.Class { CLASSID = int.Parse(RouteData.Values["id"].ToString()) }; var classItem = _class.GetClass(data); if (!string.IsNullOrEmpty(Request.Query["success"])) { ViewData["alert"] = "swal('Sınıf Düzenle', 'Sınıf düzenlendi.', 'success');"; } return(View(classItem)); }