public IActionResult Insert(KaryawanModel data)
{
var dp = new DataProcess();
string msg = "";
var response = dp.Insert(data, ref msg);
return(RedirectToAction("Index", "Home"));
}
public bool Insert(KaryawanModel data, ref string msg)
{
string time = DateTime.Now.ToString("h:mm:ss tt");
var dateGabung = data.Bulan + "/" + data.Date + "/" + data.year + " " + time;
var dateJadi = DateTime.Parse(dateGabung);
var query = string.Format(@"
INSERT INTO Tbl_Karyawan (Nama, NIK, Posisi, TanggalLahir, Divisi, JenisKelamin)
VALUES ('{0}', {1}, '{2}', '{3}', '{4}', '{5}')
", data.Nama, data.NIK, data.Posisi, dateJadi, data.Divisi, data.JenisKelamin);
var result = ExecuteQueryWithParam(query, new List <SqlParameter>(), ref msg);
if (msg.Length > 0)
{
return(false);
}
return(true);
}
public async Task <IActionResult> EditKaryawanAsync(KaryawanModel editKaryawanModel)
{
if (ModelState.IsValid)
{
var result = await _karyawanRepository.UpdateKaryawan(editKaryawanModel);
if (result.Succeeded)
{
return(Json(new { type = "msg", messageType = "information", message = "Employee successfully changed!!" }));
}
}
ModelState.AddModelError("editKaryawanModel.NIK", "Invalid NIK!");
var modelState = ModelState.Select(p => new { key = p.Key, errors = p.Value.Errors.Select(e => e.ErrorMessage) })
.ToDictionary(kv => kv.key, kv => kv.errors);
string errors = JsonConvert.SerializeObject(modelState);
return(Json(new { type = "error", data = errors }));
}
