public ActionResult UpdateDailyReportLogInfo(tbl_dailyReport dailyReportLogInfoUpdate)
{
//db.Database.ExecuteSqlCommand("Insert into tbl_dailyReport Values({0},{1})",
// teamMemberAdd.dailyReportID, teamMemberAdd.userName);
db.Database.ExecuteSqlCommand(
"UPDATE tbl_dailyReport " +
"SET " +
"jobID = {1}, " +
"date = {2}, " +
"subJobID = {3}, " +
"startTime = {4}, " +
"endTime = {5}, " +
"lunchHours = {6}, " +
"equipment = {7}, " +
"dailyReportAuthor = {8} " +
"WHERE dailyReportID = {0}",
dailyReportLogInfoUpdate.dailyReportID, dailyReportLogInfoUpdate.jobID, dailyReportLogInfoUpdate.date, dailyReportLogInfoUpdate.subJobID,
dailyReportLogInfoUpdate.startTime, dailyReportLogInfoUpdate.endTime, dailyReportLogInfoUpdate.lunchHours,
dailyReportLogInfoUpdate.equipment, dailyReportLogInfoUpdate.dailyReportAuthor);
//return new EmptyResult();
return(Json(Url.Action("Index", "dailyReportAll")));
//return Json("complete");
}
public ActionResult AddDailyReport(tbl_dailyReport dailyReportAdd)
{
db.Database.ExecuteSqlCommand("Insert into tbl_dailyReport Values({0},{1},{2},{3},{4},{5},{6})",
dailyReportAdd.jobID, dailyReportAdd.date, dailyReportAdd.subJobID, dailyReportAdd.startTime, dailyReportAdd.endTime, dailyReportAdd.lunchHours, dailyReportAdd.equipment);
return(new EmptyResult());
//return RedirectToAction("Home", "Index");
//return Redirect("/Home");
}
public ActionResult UpdateCustomer(tbl_dailyReport custUpdate)
{
//db.Database.ExecuteSqlCommand("UPDATE cmps411.tbl_customer SET customerCode={0},name={1},address={2}, city={3}, state={4}, zipCode={5} WHERE id={6}",
// custUpdate.customerCode, custUpdate.name, custUpdate.address, custUpdate.city, custUpdate.state, custUpdate.zipCode, custUpdate.id);
//db.Database.ExecuteSqlCommand("UPDATE tbl_customers SET customerCode={0}, customerName={1}, address={2} WHERE id={3}",
// custUpdate.customerCode, custUpdate.customerName, custUpdate.address, custUpdate.id);
return(RedirectToAction("Index"));
}
public ActionResult UpdateDailyReportSubmissionStatus(tbl_dailyReport submissionStatusUpdate)
{
db.Database.ExecuteSqlCommand(
"UPDATE tbl_dailyReport " +
"SET " +
"submissionStatus = {1} " +
"WHERE dailyReportID = {0}",
submissionStatusUpdate.dailyReportID, submissionStatusUpdate.submissionStatus);
return(Json(Url.Action("Index", "dailyReportAll")));
}
public ActionResult DeleteCustomer(tbl_dailyReport custDelete)
{
//db.Database.ExecuteSqlCommand("DELETE FROM tbl_customers WHERE id=({0})", custDelete.id);
return(RedirectToAction("Index"));
}
public ActionResult DeleteDailyReport(tbl_dailyReport dailyReportDelete)
{
db.Database.ExecuteSqlCommand("DELETE FROM tbl_dailyReport WHERE jobID=({0})", dailyReportDelete.jobID);
return(RedirectToAction("Index"));
}
public ActionResult DeleteDailyReport(tbl_dailyReport dailyReportDelete)
{
db.Database.ExecuteSqlCommand("DELETE FROM tbl_dailyReport WHERE dailyReportID=({0})", dailyReportDelete.dailyReportID);
return(Json(Url.Action("Index", "DailyReportAll")));
}
