public JsonResult Res(EmployeeRecordModel record) { Session["EmployeeId"] = record.EmployeeId; Session["EmployeeRecordId"] = record.RecordId; return(Json(new { success = true }, JsonRequestBehavior.DenyGet)); }
public static bool InsertRecord(EmployeeRecordModel newRecord) { using (EmployeeContext db = new EmployeeContext()) { db.EmployeeRecords.Add(newRecord); db.SaveChanges(); return(true); } }
public JsonResult DeleteEmployeeRecord(EmployeeRecordModel deleteEmployeeRecord) { if (DeleteData.DeleteEmployeeRecord(deleteEmployeeRecord)) { return(Json(new { success = true }, JsonRequestBehavior.DenyGet)); } else { return(Json(new { success = false }, JsonRequestBehavior.DenyGet)); } }
public static EmployeeRecordModel SelectRecord(int selectedRecordId) { var record = new EmployeeRecordModel(); using (EmployeeContext db = new EmployeeContext()) { record = db.EmployeeRecords.Where(rec => rec.RecordId == selectedRecordId).First(); return(record); } }
public JsonResult InsertRecord(EmployeeRecordModel newRecord) { if (InsertData.InsertRecord(newRecord)) { return(Json(new { success = true }, JsonRequestBehavior.DenyGet)); } else { return(Json(new { success = false }, JsonRequestBehavior.DenyGet)); } }
public static bool DeleteEmployeeRecord(EmployeeRecordModel deleteEmployeeRecord) { using (EmployeeContext db = new EmployeeContext()) { var employeeRecord = db.EmployeeRecords.Where(rec => rec.RecordId == deleteEmployeeRecord.RecordId).First(); if (employeeRecord != null) { db.Entry(employeeRecord).State = EntityState.Deleted; db.SaveChanges(); return(true); } return(false); } }
public static bool UpdateEmployeeRecord(EmployeeRecordModel editEmployeeRecord) { using (EmployeeContext db = new EmployeeContext()) { var employeeRecord = db.EmployeeRecords.Where(rec => rec.RecordId == editEmployeeRecord.RecordId).First(); if (employeeRecord != null) { employeeRecord.RecordDate = editEmployeeRecord.RecordDate; employeeRecord.Action = editEmployeeRecord.Action; employeeRecord.Description = editEmployeeRecord.Description; employeeRecord.Position = editEmployeeRecord.Position; employeeRecord.ConfirmDocument = editEmployeeRecord.ConfirmDocument; db.Entry(employeeRecord).State = EntityState.Modified; db.SaveChanges(); return(true); } return(false); } }