public bool Delete(int ID) { using (DBSHYMONEYV1Context context = new DBSHYMONEYV1Context()) { IntellisenseModel model = context.Intellisense.Where(x => x.Id == ID).FirstOrDefault(); if (model != null) { DateTime now = DateTime.Now; model.ModifyBy = tmpUserId; model.ModifyDate = now; model.State = "N"; context.SaveChanges(); return(true); } else { throw new Exception("Record not found for deletion."); } } }
public IntellisenseModel Save(IntellisenseModel input) { using (DBSHYMONEYV1Context context = new DBSHYMONEYV1Context()) { IntellisenseModel model = context.Intellisense.Where(x => x.Id == input.Id).FirstOrDefault(); DateTime now = DateTime.Now; if (model == null) { model = new IntellisenseModel() { Title = input.Title, SumSum = input.SumSum, SumAccountDate = input.SumAccountDate, SumInputDate = input.SumInputDate, SumDueDate = input.SumDueDate, CreateDate = now, CreateBy = tmpUserId, ModifyDate = now, ModifyBy = tmpUserId, State = "Y" }; context.Intellisense.Add(model); } else { model.Title = input.Title; model.SumSum = input.SumSum; model.ModifyDate = now; model.ModifyBy = tmpUserId; } if (context.SaveChanges() >= 1) { return(model); } else { return(null); } } }
public IActionResult Save([FromBody] IntellisenseModel INTELLISENSE) { return(Json(repo.Save(INTELLISENSE))); }