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