public static int Delete(Guid id, bool rollback = false) { try { using (SurveyEntities dc = new SurveyEntities()) { DbContextTransaction transaction = null; if (rollback) { transaction = dc.Database.BeginTransaction(); } tblActivation updaterow = dc.tblActivations.FirstOrDefault(q => q.Id == id); if (updaterow != null) { dc.tblActivations.Remove(updaterow); } else { throw new Exception("Row was not found"); } if (rollback) { transaction.Rollback(); } return(dc.SaveChanges()); } } catch (Exception ex) { throw ex; } }
public static int Insert(Activation activation, bool rollback = false) { try { using (SurveyEntities dc = new SurveyEntities()) { DbContextTransaction transaction = null; if (rollback) { transaction = dc.Database.BeginTransaction(); } tblActivation newrow = new tblActivation() { Id = Guid.NewGuid(), QuestionId = activation.QuestionId, StartDate = activation.StartDate, EndDate = activation.EndDate, ActivationCode = activation.ActivationCode }; dc.tblActivations.Add(newrow); activation.Id = newrow.Id; if (rollback) { transaction.Rollback(); } return(dc.SaveChanges()); } } catch (Exception ex) { throw ex; } }
public int Delete() { try { using (SurveyEntities dc = new SurveyEntities()) { //If the Id is set, get the result in the table where it matches if (this.Id != Guid.Empty) { tblActivation activation = dc.tblActivations.Where(a => a.Id == this.Id).FirstOrDefault(); //If a row was retrieved, change if (activation != null) { dc.tblActivations.Remove(activation); return(dc.SaveChanges()); } else { throw new Exception("Could not find Activation row with this ID"); } } else { throw new Exception("Id not set on Activation"); } } } catch (Exception ex) { throw ex; } }
public int Insert() { int result = 0; try { using (SurveyEntities dc = new SurveyEntities()) { //Activation new activation and set properties tblActivation activation = new tblActivation(); activation.Id = Guid.NewGuid(); activation.EndDate = this.EndDate; activation.StartDate = this.StartDate; activation.QuestionId = this.QuestionId; activation.ActivationCode = this.ActivationCode; this.Id = activation.Id; //Add activation to the table dc.tblActivations.Add(activation); //Commit the changes result = dc.SaveChanges(); return(result); } } catch (Exception ex) { throw ex; } }
public void LoadByQuestionId(Guid questionId) { try { using (SurveyEntities dc = new SurveyEntities()) { tblActivation activation = dc.tblActivations.FirstOrDefault(a => a.QuestionId == questionId); //If a row was retrieved, change if (activation != null) { this.Id = activation.Id; this.EndDate = activation.EndDate; this.StartDate = activation.StartDate; this.ActivationCode = activation.ActivationCode; this.QuestionId = activation.QuestionId; } else { throw new Exception("Could not find Activation row with this ID"); } } } catch (Exception ex) { throw ex; } }
public void DeleteTest() { using (SurveyEntities dc = new SurveyEntities()) { tblActivation activation = dc.tblActivations.FirstOrDefault(a => a.ActivationCode == "updat"); dc.tblActivations.Remove(activation); dc.SaveChanges(); tblActivation retrievedActivation = dc.tblActivations.FirstOrDefault(a => a.ActivationCode == "updat"); Assert.IsNull(retrievedActivation); } }
public void InsertTest() { using (SurveyEntities dc = new SurveyEntities()) { tblActivation activation = new tblActivation(); activation.Id = Guid.NewGuid(); activation.StartDate = DateTime.Now; activation.EndDate = DateTime.Now.AddYears(10); activation.QuestionId = dc.tblQuestions.FirstOrDefault(q => q.Text == "Who sprouts mung beans in their desk drawers?").Id; activation.ActivationCode = "utest"; dc.tblActivations.Add(activation); dc.SaveChanges(); tblActivation retrievedActivation = dc.tblActivations.FirstOrDefault(a => a.ActivationCode == "utest"); Assert.AreEqual(activation.Id, retrievedActivation.Id); } }
public static int Update(Activation activation, bool rollback = false) { try { using (SurveyEntities dc = new SurveyEntities()) { DbContextTransaction transaction = null; if (rollback) { transaction = dc.Database.BeginTransaction(); } tblActivation updaterow = dc.tblActivations.FirstOrDefault(q => q.Id == activation.Id); if (updaterow != null) { updaterow.QuestionId = activation.QuestionId; updaterow.StartDate = activation.StartDate; updaterow.EndDate = activation.EndDate; updaterow.ActivationCode = activation.ActivationCode; } else { throw new Exception("Row was not found"); } if (rollback) { transaction.Rollback(); } return(dc.SaveChanges()); } } catch (Exception ex) { throw ex; } }
public static Activation GetActivation(Guid questionId) { try { using (SurveyEntities dc = new SurveyEntities()) { tblActivation row = new tblActivation(); row = dc.tblActivations.FirstOrDefault(q => q.QuestionId == questionId); if (row == null) { return(null); } Activation activation = new Activation { Id = row.Id, QuestionId = row.QuestionId, StartDate = row.StartDate, EndDate = row.EndDate, ActivationCode = row.ActivationCode }; return(activation); } } catch (Exception ex) { throw ex; } }
public void LoadById() { try { using (SurveyEntities dc = new SurveyEntities()) { //If the Id is set, get the result in the table where it matches if (this.Id != Guid.Empty) { tblActivation activation = dc.tblActivations.FirstOrDefault(a => a.Id == this.Id); //If a row was retrieved, change if (activation != null) { this.Id = activation.Id; this.EndDate = activation.EndDate; this.StartDate = activation.StartDate; this.ActivationCode = activation.ActivationCode; this.QuestionId = activation.QuestionId; } else { throw new Exception("Could not find Activation row with this ID"); } } else { throw new Exception("Id not set on Activation"); } } } catch (Exception ex) { throw ex; } }