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_TransactionDetail emp = db.tt_TransactionDetail.Where(x => x.TransactionDetail_PK == id).FirstOrDefault <tt_TransactionDetail>(); emp.Status_FK = 2; db.SaveChanges(); return(Json(new { success = true, message = "Deleted Successfully" }, JsonRequestBehavior.AllowGet)); } }
public ActionResult AddOrEdit(tt_TransactionDetail td) { using (HELLOWEntities db = new HELLOWEntities()) { if (td.TransactionDetail_PK == 0) { td.Status_FK = 1; db.tt_TransactionDetail.Add(td); db.SaveChanges(); return(Json(new { success = true, message = "Saved Successfully" }, JsonRequestBehavior.AllowGet)); } else { td.Status_FK = 1; db.Entry(td).State = EntityState.Modified; db.SaveChanges(); return(Json(new { success = true, message = "Updated Successfully" }, JsonRequestBehavior.AllowGet)); } } }