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