public ActionResult Create(string result) { InputTransaksi input = new JavaScriptSerializer().Deserialize <InputTransaksi>(result); using (HELLOWEntities db = new HELLOWEntities()) { tt_Transaction transaction = new tt_Transaction(); transaction.Mesin_FK = input.mesin; transaction.Daily_FK = input.daily; transaction.KodeWarna_FK = input.kodewarna; transaction.Status_FK = 1; transaction.Penambahan = input.Penambahan; transaction.CreatedDate = DateTime.Now; db.tt_Transaction.Add(transaction); db.SaveChanges(); foreach (var item in input.transdetail) { tt_TransactionDetail tdet = new tt_TransactionDetail(); tdet.Transaction_FK = transaction.Transaction_PK; tdet.Operator_FK = db.tm_Operator.Where(x => x.NoOperator == item.nooperator).FirstOrDefault().Operator_PK; tdet.HasilKain = item.hasil; tdet.Status_FK = 1; db.tt_TransactionDetail.Add(tdet); db.SaveChanges(); } return(Json(new { success = true, message = "Saved Successfully" }, JsonRequestBehavior.AllowGet)); } }
public ActionResult Delete(int id) { using (HELLOWEntities db = new HELLOWEntities()) { tt_Transaction hehe = db.tt_Transaction.Where(x => x.Transaction_PK == id).FirstOrDefault(); hehe.Status_FK = 2; db.SaveChanges(); return(Json(new { success = true, message = "Deleted Successfully" }, JsonRequestBehavior.AllowGet)); } }
public ActionResult Edit(tt_Transaction td) { using (HELLOWEntities db = new HELLOWEntities()) { td.Status_FK = 1; db.Entry(td).State = EntityState.Modified; db.SaveChanges(); return(Json(new { success = true, message = "Updated Successfully" }, JsonRequestBehavior.AllowGet)); } }
public ActionResult AddOrEdit(tt_Transaction emp) { using (OCBCTestEntities1 db = new OCBCTestEntities1()) { if (emp.TransactionID == 0) { db.tt_Transaction.Add(emp); db.SaveChanges(); return(Json(new { success = true, message = "Saved Successfully" }, JsonRequestBehavior.AllowGet)); } else { db.Entry(emp).State = EntityState.Modified; db.SaveChanges(); return(Json(new { success = true, message = "Updated Successfully" }, JsonRequestBehavior.AllowGet)); } } }