private static void AddNotes(KeepDbContext context)
{
context.Notes.Add(new Note {
CategoryId = 1, ReminderId = 1, NoteTitle = "Technology", NoteContent = "ASP.NET Core", NoteStatus = "Started", CreatedBy = "John"
});
context.SaveChanges();
}
private static void AddUsers(KeepDbContext context)
{
context.Users.Add(new User {
UserId = "John", UserName = "******", Password = "******", Contact = "9812345670"
});
context.SaveChanges();
}
private static void AddReminders(KeepDbContext context)
{
context.Reminders.Add(new Reminder {
ReminderName = "Email", ReminderDescription = "Email reminder", ReminderType = "notification", CreatedBy = "John"
});
context.SaveChanges();
}
private static void AddCategories(KeepDbContext context)
{
context.Categories.Add(new Category {
CategoryName = "Testing", CategoryDescription = "Unit Testing", CategoryCreatedBy = "John"
});
context.SaveChanges();
}
/// <summary>
/// 新增记录
/// </summary>
/// <param name="params"></param>
/// <returns></returns>
public ServiceResult CreateBill(BillEntity @params)
{
try
{
using (KeepDbContext context = new KeepDbContext()) {
@params.Id = Guid.NewGuid();
@params.CreateDate = DateTime.Now;
context.Bill.Add(@params);
context.SaveChanges();
return(new ServiceResult());
}
}
catch (Exception ex)
{
ComLogger.ErrorTag("CreateBill", ex.InnerException.StackTrace);
return(new ServiceResult(1, ex.Message));
}
}
/// <summary>
/// 删除记录
/// </summary>
/// <param name="params"></param>
/// <returns></returns>
public ServiceResult DeleteBill(BillEntity @params)
{
try
{
using (KeepDbContext context = new KeepDbContext())
{
BillEntity entity = context.Bill.SingleOrDefault(x => x.Id == @params.Id);
if (entity == null)
{
return(new ServiceResult(1, "entity is null"));
}
context.Bill.Remove(entity);
context.SaveChanges();
return(new ServiceResult());
}
}
catch (Exception ex)
{
ComLogger.ErrorTag("DeleteBill", ex.InnerException.StackTrace);
return(new ServiceResult(1, ex.Message));
}
}