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