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)));
}
