public async Task <ActionResult> DeleteEmp([Bind] EmpBasicInfoVM ebi) { try { var emp = await db.EmpBasicInfo.FindAsync(ebi.EmpID); db.EmpBasicInfo.Remove(emp); await db.SaveChangesAsync(); return(Json(new { message = "Delete successful" })); } catch (Exception EX) { Dictionary <string, object> content = new Dictionary <string, object>(); content.Add("ErrorMessage", $"Data Can't be loaded. {EX.Message}"); return(Json(content)); } }
public async Task <ActionResult> GetEmployeeByID(int id) { try { EmpBasicInfoVM evm = await db.EmpBasicInfo.Select(p => new EmpBasicInfoVM { EmpID = p.EmpID, Name = p.Name, Email = p.Email, Phone = p.Phone, Address = p.Address }).Where(i => i.EmpID == id).FirstOrDefaultAsync(); return(Json(evm, JsonRequestBehavior.AllowGet)); } catch (Exception EX) { Dictionary <string, object> content = new Dictionary <string, object>(); content.Add("ErrorMessage", $"Data Can't be loaded. {EX.Message}"); return(Json(content)); } }
public async Task <ActionResult> EditEmp([Bind] EmpBasicInfoVM evm) { try { if (ModelState.IsValid) { EmpBasicInfo ebi = new EmpBasicInfo(); ebi.EmpID = evm.EmpID; ebi.Name = evm.Name; ebi.Email = evm.Email; ebi.Phone = evm.Phone; ebi.Address = evm.Address; db.Entry(ebi).State = EntityState.Modified; await db.SaveChangesAsync(); } return(Json(new { Message = "Create sucessfully" })); } catch (Exception EX) { Dictionary <string, object> content = new Dictionary <string, object>(); content.Add("ErrorMessage", $"Data Can't be Edit. {EX.Message}"); return(Json(content)); } }