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