//[ValidateAntiForgeryToken]
public ActionResult UpdateTimePeriodForSignal(TimePeriodForSignal TimePeriodForSignalInfoForUpdate)
{
try
{
TimePeriodForSignal TimePeriodForSignal_Check = db.TimePeriodForSignal.Where(s => s.TimePeriodForSignalID == TimePeriodForSignalInfoForUpdate.TimePeriodForSignalID).FirstOrDefault();
if (TimePeriodForSignal_Check == null)
{
//TempData["AlreadyInsert"] = "TimePeriodForSignal Already Added. Choose different TimePeriodForSignal. ";
return(Json(new { UpdateSuccess = false, AlreadyInsert = true }, JsonRequestBehavior.AllowGet));
}
TimePeriodForSignal TimePeriodForSignal_Check_IfDuplicateDataExist = db.TimePeriodForSignal.Where(s => s.TimePeriodForSignalID != TimePeriodForSignalInfoForUpdate.TimePeriodForSignalID && s.SignalSign == TimePeriodForSignalInfoForUpdate.SignalSign).FirstOrDefault();
if (TimePeriodForSignal_Check_IfDuplicateDataExist != null)
{
//TempData["AlreadyInsert"] = "TimePeriodForSignal Already Added. Choose different TimePeriodForSignal. ";
return(Json(new { UpdateSuccess = false, DuplicateSignExist = true }, JsonRequestBehavior.AllowGet));
}
var TimePeriodForSignal_db = db.TimePeriodForSignal.Where(s => s.TimePeriodForSignalID == TimePeriodForSignalInfoForUpdate.TimePeriodForSignalID);
TimePeriodForSignalInfoForUpdate.CreatedBy = TimePeriodForSignal_db.FirstOrDefault().CreatedBy;
TimePeriodForSignalInfoForUpdate.CreatedDate = TimePeriodForSignal_db.FirstOrDefault().CreatedDate;
TimePeriodForSignalInfoForUpdate.UpdateBy = AppUtils.GetLoginEmployeeName();
TimePeriodForSignalInfoForUpdate.UpdateDate = AppUtils.GetDateTimeNow();
db.Entry(TimePeriodForSignal_db.SingleOrDefault()).CurrentValues.SetValues(TimePeriodForSignalInfoForUpdate);
db.SaveChanges();
TempData["UpdateSucessOrFail"] = "Update Successfully.";
var temp = TimePeriodForSignal_db.ToList();
var TimePeriodForSignal_Return = TimePeriodForSignal_db.Select(s =>
new
{
TimePeriodForSignalID = s.TimePeriodForSignalID,
UpToHours = s.UpToHours,
SignalSign = s.SignalSign
});
var JSON = Json(new { UpdateSuccess = true, TimePeriodForSignalUpdateInformation = TimePeriodForSignal_Return }, JsonRequestBehavior.AllowGet);
JSON.MaxJsonLength = int.MaxValue;
return(JSON);
}
catch
{
TempData["UpdateSucessOrFail"] = "Update Fail.";
return(Json(new { UpdateSuccess = false, TimePeriodForSignalUpdateInformation = "" }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult DeleteTimePeriodForSignal(int TimePeriodForSignalID)
{
try
{
TimePeriodForSignal TimePeriodForSignal = db.TimePeriodForSignal.Find(TimePeriodForSignalID);
db.TimePeriodForSignal.Remove(TimePeriodForSignal);
db.SaveChanges();
return(Json(new { DeleteStatus = true, TimePeriodForSignalID = TimePeriodForSignalID }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(new { DeleteStatus = false, TimePeriodForSignalID = TimePeriodForSignalID }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult InsertTimePeriodForSignalFromPopUp(TimePeriodForSignal TimePeriodForSignal_Client)
{
TimePeriodForSignal TimePeriodForSignal_Check = db.TimePeriodForSignal.Where(s => s.SignalSign == TimePeriodForSignal_Client.SignalSign).FirstOrDefault();
if (TimePeriodForSignal_Check != null)
{
TempData["AlreadyInsert"] = "Time Period For Signal Already Added. Choose different TimePeriodForSignal. ";
return(Json(new { SuccessInsert = false, AlreadyInsert = true }, JsonRequestBehavior.AllowGet));
}
TimePeriodForSignal TimePeriodForSignal_Return = new TimePeriodForSignal();
try
{
TimePeriodForSignal_Client.UpToHours = TimePeriodForSignal_Client.UpToHours;
TimePeriodForSignal_Client.SignalSign = TimePeriodForSignal_Client.SignalSign;
TimePeriodForSignal_Client.CreatedBy = AppUtils.GetLoginEmployeeName();
TimePeriodForSignal_Client.CreatedDate = AppUtils.GetDateTimeNow();
TimePeriodForSignal_Return = db.TimePeriodForSignal.Add(TimePeriodForSignal_Client);
db.SaveChanges();
if (TimePeriodForSignal_Return.TimePeriodForSignalID > 0)
{
// TempData["SaveSucessOrFail"] = "Save Successfully.";
return(Json(new { SuccessInsert = true, TimePeriodForSignal = TimePeriodForSignal_Return }, JsonRequestBehavior.AllowGet));
}
else
{
// TempData["SaveSucessOrFail"] = "Save Failed.";
return(Json(new { SuccessInsert = false }, JsonRequestBehavior.AllowGet));
}
}
catch
{
return(Json(new { SuccessInsert = false }, JsonRequestBehavior.AllowGet));
}
}