public void AddUserDataSet(int? UserId, int DataSetId, int ValidityPeriod, DateTime? UsedDateTime) { try { UserDataSet Uds; using (var dbContext = new ePharmaGuideContext()) { Uds = dbContext.UserDataSets.FirstOrDefault(s => s.DataSetId == DataSetId && s.UserId == UserId && s.isDisabled == false); if (Uds == null) { var AddUserDataSet = new UserDataSet { DateCreated = DateTime.Now, DateModified = DateTime.Now, DateSubscribed = UsedDateTime.Value.AddDays(ValidityPeriod), DataSetId = DataSetId, UserId = UserId.Value, ValidityPeriod = ValidityPeriod }; dbContext.UserDataSets.Add(AddUserDataSet); dbContext.SaveChanges(); } else { if (Uds.DateSubscribed < DateTime.Now || Uds.isDisabled) { Uds.DateSubscribed = DateTime.Now.AddDays(ValidityPeriod); Uds.DateModified = DateTime.Now; Uds.ValidityPeriod = ValidityPeriod; dbContext.Entry(Uds).State = System.Data.Entity.EntityState.Modified; dbContext.SaveChanges(); } else { Uds.DateSubscribed = Uds.DateSubscribed.AddDays(ValidityPeriod); Uds.DateModified = DateTime.Now; Uds.ValidityPeriod = ValidityPeriod; dbContext.Entry(Uds).State = System.Data.Entity.EntityState.Modified; dbContext.SaveChanges(); } } } } catch (Exception ex) { throw; } }
public void AddData(int UserId, int DataSetId) { using (var dbContext = new ePharmaGuideContext()) { UserDataSet Uds; var AddUserDataSet = new UserDataSet { DateCreated = DateTime.Now, DateModified = DateTime.Now, DateSubscribed = new DateTime(4015, 12, 1), DataSetId = DataSetId, UserId = UserId, ValidityPeriod = -1 }; dbContext.UserDataSets.Add(AddUserDataSet); dbContext.SaveChanges(); } }