public ActionResult Delete(int id)
{
tappServiceRecord empServiceRecord = _db.tappServiceRecords.Find(id);
_db.tappServiceRecords.Remove(empServiceRecord);
_db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Create([Bind(Include = "EIC, dateFrom, dateTo, designation, statusName, " +
"officeServiceRec, branch, salaryPayroll, salaryServiceRec, paySchemeCode, paySchemeName, sepCause, officeCode")] tappServiceRecord tappServiceRecord)
{
if (ModelState.IsValid)
{
_db.tappServiceRecords.Add(tappServiceRecord);
_db.SaveChanges();
return(RedirectToAction("Index", "ServiceRecord"));
}
return(View());
}
/*public ActionResult Create([Bind(Include = "EIC, dateFrom, dateTo, positionCode, designation, subPositionCode, subPosition, statusName, " +
* "officeServiceRec, branch, salaryPayroll, salaryServiceRec, paySchemeCode, paySchemeName, sepCause, officeCode, SgStep")] tappServiceRecord tappServiceRecord)
* {
* if (ModelState.IsValid)
* {
* db.tappServiceRecords.Add(tappServiceRecord);
* db.SaveChanges();
* }
*
* return RedirectToAction("Index", "DataManagement");
* }*/
public ActionResult SaveNewServiceRecord(String EIC, DateTime dateFrom, string dateTo, String positionCode, String designation,
String subPositionCode, String subPosition, String statusName, String officeServiceRec, String branch, Decimal salaryPayroll,
Decimal salaryServiceRec, String paySchemeCode, String paySchemeName, String sepCause, String officeCode, String sgStep)
{
var has_error = false;
try
{
var serviceRec = new tappServiceRecord()
{
EIC = EIC,
dateFrom = dateFrom,
dateTo = dateTo != "" ? DateTime.ParseExact(dateTo, "MM/dd/yyyy", null).Date.ToString("yyyy-MM-dd"):"",
positionCode = positionCode,
designation = designation,
subPosition = subPosition,
subPositionCode = subPositionCode,
statusName = statusName,
officeServiceRec = officeServiceRec,
branch = branch,
salaryPayroll = salaryPayroll,
salaryServiceRec = salaryServiceRec,
paySchemeCode = paySchemeCode,
paySchemeName = paySchemeName,
sepCause = sepCause,
officeCode = officeCode,
SgStep = sgStep
};
db.tappServiceRecords.Add(serviceRec);
db.SaveChanges();
}
catch (Exception exception)
{
has_error = true;
return(Content(dateFrom + "\n\n" + dateTo + "\n\n" + exception.ToString()));
}
return(Content(has_error.ToString()));
}
