public ActionResult Delete(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tbl_pmsTxTimeSheet tbl_pmsTxTimeSheet = db.tbl_pmsTxTimeSheet.Find(id);
if (tbl_pmsTxTimeSheet == null)
{
return(HttpNotFound());
}
return(View(tbl_pmsTxTimeSheet));
}
public async Task <tbl_pmsTxTimeSheet> Delete(string id)
{
if (id == null)
{
return(null); // await new HttpStatusCodeResult(HttpStatusCode.BadRequest);
}
tbl_pmsTxTimeSheet tbl_pmsTxTimeSheet = await _context.tbl_pmsTxTimeSheet.FindAsync(id);
if (tbl_pmsTxTimeSheet == null)
{
return(null); //await HttpNotFound();
}
return(tbl_pmsTxTimeSheet);
}
public async Task <tbl_pmsTxTimeSheet> Edit(string timeSheet_ID)
{
if (timeSheet_ID == null)
{
return(null);//new HttpStatusCodeResult(HttpStatusCode.BadRequest);
}
tbl_pmsTxTimeSheet tbl_pmsTxTimeSheet = await _context.tbl_pmsTxTimeSheet.Where(p => p.timeSheet_ID == timeSheet_ID).FirstOrDefaultAsync();
if (tbl_pmsTxTimeSheet == null)
{
return(null); //HttpNotFound();
}
//ViewBag.isCancel = tbl_pmsTxTimeSheet.isCancelled;
//ViewBag.timeSheet_ID = tbl_pmsTxTimeSheet.timeSheet_ID;
//ViewBag.subTask_ID = new SelectList(_context.tbl_genMasSubTask, "subTask_ID", "subTaskName", tbl_pmsTxTimeSheet.subTask_ID);
//var vResult = _context.tbl_pmsTxTask.Where(p => p.status_ID != "2" && p.assignedUser_ID == sUser_ID);
//ViewBag.task_ID = new SelectList(vResult, "task_ID", "taskReference");
return(tbl_pmsTxTimeSheet);
}
public ActionResult Edit(string timeSheet_ID)
{
if (timeSheet_ID == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tbl_pmsTxTimeSheet tbl_pmsTxTimeSheet = db.tbl_pmsTxTimeSheet.Where(p => p.timeSheet_ID == timeSheet_ID).FirstOrDefault();
if (tbl_pmsTxTimeSheet == null)
{
return(HttpNotFound());
}
ViewBag.isCancel = tbl_pmsTxTimeSheet.isCancelled;
ViewBag.timeSheet_ID = tbl_pmsTxTimeSheet.timeSheet_ID;
ViewBag.subTask_ID = new SelectList(db.tbl_genMasSubTask, "subTask_ID", "subTaskName", tbl_pmsTxTimeSheet.subTask_ID);
var vResult = db.tbl_pmsTxTask.Where(p => p.status_ID != "2" && p.assignedUser_ID == sUser_ID);
ViewBag.task_ID = new SelectList(vResult, "task_ID", "taskReference");
return(View(tbl_pmsTxTimeSheet));
}
public async Task <tbl_pmsTxTimeSheet> SaveTimeSheet(TimeSheet oTimeSheet)
{
string Message = "";
try
{
tbl_pmsTxTimeSheet oTimeSheets = new tbl_pmsTxTimeSheet(oTimeSheet.timeSheet_ID,
oTimeSheet.timeSheetDate, oTimeSheet.subTask_ID, oTimeSheet.totalUtilizedHours,
oTimeSheet.remarks != null ? oTimeSheet.remarks : "",
false, sUser_ID, sUser_ID, sUser_ID, sUser_ID,
DateTime.Now, DateTime.Now, DateTime.Now,
sCompany_ID, sCompanyBranch_ID);
_context.tbl_pmsTxTimeSheet.Add(oTimeSheets);
await _context.SaveChangesAsync();
return(oTimeSheets);
}
catch (Exception ex)
{
Message = ex.Message + "\n\n" + ex.Data;
}
return(null);
}
public JsonResult SaveTimeSheet(TimeSheet oTimeSheet)
{
bool status = false;
string TimeSheetID = "";
string Message = "";
try
{
if (ModelState.IsValid)
{
if (sUser_ID != null && sCompany_ID != null && sCompanyBranch_ID != null)
{
oTimeSheet.timeSheet_ID = tbl_AutoCode.AutoCode((int)enumFormNames.TimeSheet);
if (oTimeSheet.timeSheet_ID != null)
{
tbl_pmsTxTimeSheet oTimeSheets = new tbl_pmsTxTimeSheet(oTimeSheet.timeSheet_ID, oTimeSheet.timeSheetDate, oTimeSheet.subTask_ID, oTimeSheet.totalUtilizedHours, oTimeSheet.remarks != null ? oTimeSheet.remarks : "",
false, sUser_ID, sUser_ID, sUser_ID, sUser_ID, DateTime.Now, DateTime.Now, DateTime.Now, sCompany_ID, sCompanyBranch_ID);
db.tbl_pmsTxTimeSheet.Add(oTimeSheets);
TimeSheetID = oTimeSheet.timeSheet_ID;
db.SaveChanges();
foreach (var oDetail in oTimeSheet.TimeSheetDetails)
{
var Task = db.tbl_pmsTxTask.FirstOrDefault(p => p.task_ID == oDetail.task_ID);
Task.status_ID = oDetail.status_ID;
tbl_pmsTxTimeSheet_Detail oTimeSheets_Detail = new tbl_pmsTxTimeSheet_Detail();
oTimeSheets_Detail.task_ID = oDetail.task_ID;
oTimeSheets_Detail.line_No = oDetail.line_No;
oTimeSheets_Detail.timeSheet_ID = oTimeSheet.timeSheet_ID;
oTimeSheets_Detail.remarks = oDetail.remarks != null ? oDetail.remarks : "";
oTimeSheets_Detail.utilizedHours = oDetail.utilizedHours;
oTimeSheets_Detail.status_ID = oDetail.status_ID;
db.tbl_pmsTxTimeSheet_Detail.Add(oTimeSheets_Detail);
}
//db.tbl_pmsTxTimeSheet_Detail.AddRange(oTimeSheet.TimeSheetDetails);
db.SaveChanges();
Message = "Time Sheet Saved Successfully...!";
status = true;
}
else
{
Message = "Time Sheet ID is Empty...!";
status = false;
}
}
else
{
string sHeader = "Your Session is Expired";
Message = sHeader.ToUpper() + ", \nPlease Reload This Page...!";
status = false;
}
}
else
{
Message = "Model State Invalid...!";
status = false;
}
}
catch (Exception ex)
{
Message = ex.Message + "\n\n" + ex.Data;
status = false;
}
return(new JsonResult {
Data = new { status = status, TimeSheetID = TimeSheetID, Message = Message }
});
}
