public JsonResult EditHolidays(DateTime id, DateTime start, string htype, byte wday, string remarks, short insid)
{
string message = "";
try
{
HRP_HOLIDAY hrp_holiday = db.HRP_HOLIDAY.Find(id);
if (hrp_holiday != null)
{
db.HRP_HOLIDAY.Remove(hrp_holiday);
db.SaveChanges();
hrp_holiday.HOLDATE = start;
hrp_holiday.HOLTYPE = htype;
hrp_holiday.WORKDAY = wday;
hrp_holiday.HOLREMARKS = remarks;
hrp_holiday.INSERTDT = DateTime.Now;
db.HRP_HOLIDAY.Add(hrp_holiday);
db.SaveChanges();
}
}
catch (Exception ex)
{
message = "failed";
}
return(new JsonResult {
Data = message, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public JsonResult DeleteHolidays(DateTime id)
{
string message = "";
try
{
HRP_HOLIDAY hrp_holiday = db.HRP_HOLIDAY.Find(id);
if (hrp_holiday != null)
{
db.HRP_HOLIDAY.Remove(hrp_holiday);
db.SaveChanges();
}
else
{
message = "failedyyyy";
}
}
catch (Exception ex)
{
message = "failed";
}
return(new JsonResult {
Data = message, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public JsonResult Create_Holiday(HRP_HOLIDAY holidyinfo)
{
string message = "";
try
{
if (ModelState.IsValid)
{
using (ProductionPlannerEntities dc = new ProductionPlannerEntities())
{
if (holidyinfo != null)
{
dc.HRP_HOLIDAY.Add(holidyinfo);
dc.SaveChanges();
}
else
{
message = "failed";
}
}
}
else
{
message = "failed";
}
}
catch (Exception ex)
{
message = "failed" + ex.ToString();
}
return(new JsonResult {
Data = message, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public ActionResult Create(DateTime hdate, string htype, byte wday, string remarks)
{
HRP_HOLIDAY hrp_holiday = new HRP_HOLIDAY();
hrp_holiday.HOLDATE = hdate;
hrp_holiday.HOLTYPE = htype;
hrp_holiday.WORKDAY = wday;
hrp_holiday.HOLREMARKS = remarks;
hrp_holiday.INSERTBY = 1;
hrp_holiday.INSERTDT = DateTime.Now;
try
{
if (ModelState.IsValid)
{
db.HRP_HOLIDAY.Add(hrp_holiday);
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
catch (Exception ex)
{
TempData["msg"] = "<script>alert('error to save data !!');</script>";
}
return(View("Index"));
}
// POST: /Holiday/Delete/5
//[HttpPost, ActionName("Delete")]
//[ValidateAntiForgeryToken]
public ActionResult DeleteConfirmed(DateTime id)
{
HRP_HOLIDAY hrp_holiday = db.HRP_HOLIDAY.Find(id);
db.HRP_HOLIDAY.Remove(hrp_holiday);
db.SaveChanges();
TempData["msg"] = "<script>alert('Deleted Holiday Information Succesfully !!');</script>";
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "HOLDATE,HOLTYPE,WDAYBEFOREHDAY,WDAYAFTERHDAY,WORKDAY,HOLREMARKS,INSERTBY,INSERTDT,UPDATEBY,UPDATEDT")] HRP_HOLIDAY hrp_holiday)
{
if (ModelState.IsValid)
{
db.Entry(hrp_holiday).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(hrp_holiday));
}
// GET: /Holiday/Delete/5
public ActionResult Delete(DateTime id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
HRP_HOLIDAY hrp_holiday = db.HRP_HOLIDAY.Find(id);
if (hrp_holiday == null)
{
return(HttpNotFound());
}
return(View(hrp_holiday));
}
