public ActionResult CreateDaily(InputDaily input)
{
try
{
using (HELLOWEntities db = new HELLOWEntities())
{
var data = (from daily in db.tt_Daily
where daily.Status_FK == 1 && daily.SheetNum == input.sheetnum
select new Daily {
Daily_PK = daily.Daily_PK, InsertDate = daily.Date
}).FirstOrDefault();
if (data != null)
{
return(Json(new { success = false, message = "Nomor Kertas Sudah di Input, Tanggal :" + data.InsertDate.ToString("dd MMMM yyyy") }, JsonRequestBehavior.AllowGet));
}
tt_Daily dail = new tt_Daily();
DateTime datehehe = Convert.ToDateTime(input.daily);
dail.Date = datehehe;
dail.SheetNum = input.sheetnum;
dail.Recorder_FK = input.recorder;
dail.Status_FK = 1;
db.tt_Daily.Add(dail);
db.SaveChanges();
return(Json(new { success = true, message = "Saved Successfully" }, JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
return(Json(new { success = false, message = ex.Message }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult Delete(int id)
{
using (HELLOWEntities db = new HELLOWEntities())
{
tt_Daily emp = db.tt_Daily.Where(x => x.Daily_PK == id).FirstOrDefault <tt_Daily>();
emp.Status_FK = 2;
List <tt_Transaction> hehe = db.tt_Transaction.Where(x => x.Daily_FK == id).ToList();
hehe.ForEach(x => x.Status_FK = 2);
db.SaveChanges();
return(Json(new { success = true, message = "Deleted Successfully" }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult Edit(tt_DailyView td)
{
DateTime temp;
using (HELLOWEntities db = new HELLOWEntities())
{
tt_Daily dail = db.tt_Daily.Where(x => x.Daily_PK == td.Daily_PK).FirstOrDefault <tt_Daily>();
if (DateTime.TryParse(td.Date, out temp))
{
dail.Date = temp;
dail.Recorder_FK = td.Recorder_FK;
dail.SheetNum = td.SheetNum;
}
db.SaveChanges();
return(Json(new { success = true, message = "Updated Successfully" }, JsonRequestBehavior.AllowGet));
}
}
