public int Update() { try { using (MusicEntities dc = new MusicEntities()) { //Retrieve the record from the DB tblGroupMember groupmember = dc.tblGroupMembers.FirstOrDefault(c => c.Id == this.Id); //Update the properties groupmember.GroupId = this.GroupId; groupmember.PerformerId = this.PerformerId; groupmember.Instrument = this.Instrument; groupmember.StartDate = this.StartDate; groupmember.EndDate = this.EndDate; //Save the changes return(dc.SaveChanges()); } } catch (Exception ex) { throw ex; } }
//Insert the groupmember into the db, and generate a new Id for it. public int Insert() { try { using (MusicEntities dc = new MusicEntities()) { //Create a new Id this.Id = Guid.NewGuid(); //Set the properties tblGroupMember groupmember = new tblGroupMember { Id = this.Id, GroupId = this.GroupId, PerformerId = this.PerformerId, Instrument = this.Instrument, StartDate = this.StartDate, EndDate = this.EndDate, }; //Add it to the table and save changes dc.tblGroupMembers.Add(groupmember); return(dc.SaveChanges()); } } catch (Exception ex) { throw ex; } }
//Retrieve the groupmember from the database with this Id public void LoadById() { try { using (MusicEntities dc = new MusicEntities()) { //Retrieve from the db tblGroupMember groupmember = dc.tblGroupMembers.FirstOrDefault(p => p.Id == this.Id); //Set this groupmember's properties this.GroupId = groupmember.GroupId != null ? groupmember.GroupId : Guid.Empty; this.PerformerId = groupmember.PerformerId != null ? groupmember.PerformerId : Guid.Empty; this.PerformerId = groupmember.Instrument != null ? groupmember.Instrument : Guid.Empty; this.StartDate = groupmember.StartDate; if (groupmember.EndDate.HasValue) { this.EndDate = groupmember.EndDate.Value; } } } catch (Exception ex) { throw ex; } }
public void DeleteTest() { using (MusicEntities dc = new MusicEntities()) { DateTime startTime = Convert.ToDateTime("04/24/3000"); tblGroupMember groupmember = dc.tblGroupMembers.FirstOrDefault(a => a.StartDate == startTime); dc.tblGroupMembers.Remove(groupmember); dc.SaveChanges(); tblGroupMember retrievedGroupMember = dc.tblGroupMembers.FirstOrDefault(a => a.StartDate == groupmember.StartDate); Assert.IsNull(retrievedGroupMember); } }
public void UpdateTest() { using (MusicEntities dc = new MusicEntities()) { DateTime startTime = Convert.ToDateTime("04/24/3000"); tblGroupMember groupmember = dc.tblGroupMembers.FirstOrDefault(a => a.StartDate == startTime); groupmember.EndDate = DateTime.Now.AddDays(5); dc.SaveChanges(); tblGroupMember retrievedGroupMember = dc.tblGroupMembers.FirstOrDefault(a => a.StartDate == groupmember.StartDate); Assert.IsNotNull(retrievedGroupMember); } }
public void InsertTest() { using (MusicEntities dc = new MusicEntities()) { tblGroupMember groupmember = new tblGroupMember(); groupmember.Id = Guid.NewGuid(); groupmember.PerformerId = dc.tblPerformers.FirstOrDefault(p => p.FirstName == "Hunter").Id; groupmember.GroupId = dc.tblGroups.FirstOrDefault(p => p.Name == "Concert Band").Id; groupmember.StartDate = Convert.ToDateTime("04/24/3000"); groupmember.EndDate = DateTime.Now.AddDays(2); groupmember.Instrument = dc.tblInstruments.FirstOrDefault(p => p.Description == "Saxophone").Id; dc.tblGroupMembers.Add(groupmember); dc.SaveChanges(); tblGroupMember retrievedGroupMember = dc.tblGroupMembers.FirstOrDefault(a => a.StartDate == groupmember.StartDate); Assert.AreEqual(groupmember.Id, retrievedGroupMember.Id); } }
public int Delete() { try { using (MusicEntities dc = new MusicEntities()) { //Retrieve it from the DB tblGroupMember groupmember = dc.tblGroupMembers.FirstOrDefault(p => p.Id == this.Id); //Remove the groupmember dc.tblGroupMembers.Remove(groupmember); //Save the changes return(dc.SaveChanges()); } } catch (Exception ex) { throw ex; } }
internal bool CreateGroup(GroupModel objReq) { try { using (var db = new WizzDataContext()) { tblGroup groupObj = new tblGroup(); groupObj = db.tblGroups.FirstOrDefault(x => x.groupId == objReq.groupId); //if (groupData != null) //{ // db.tblGroups.DeleteOnSubmit(groupData); //} if (groupObj == null) { groupObj = new tblGroup(); groupObj.groupName = objReq.groupName; groupObj.fkAdminId = objReq.userId; groupObj.createdDate = DateTime.UtcNow; groupObj.updatedDate = DateTime.UtcNow; groupObj.isActive = true; groupObj.timeSlot = objReq.timeSlot; groupObj.subjectName = objReq.subjectName; groupObj.groupId = objReq.groupId; groupObj.groupPic = objReq.groupPic; db.tblGroups.InsertOnSubmit(groupObj); db.SubmitChanges(); } else { groupObj.groupName = objReq.groupName; groupObj.fkAdminId = objReq.userId; groupObj.createdDate = DateTime.UtcNow; groupObj.updatedDate = DateTime.UtcNow; groupObj.isActive = true; groupObj.timeSlot = objReq.timeSlot; groupObj.subjectName = objReq.subjectName; groupObj.groupId = objReq.groupId; groupObj.groupPic = objReq.groupPic; } List<string> groupMems = new List<string>(); List<tblGroupMember> memObjList = new List<tblGroupMember>(); int groupId = Convert.ToInt32(groupObj.pkId); foreach (string n in objReq.groupMembers) { tblGroupMember memObj = new tblGroupMember(); memObj.fkGroupId = groupId; memObj.fkUserId = Convert.ToInt32(n); memObj.createdDate = DateTime.UtcNow; memObj.updatedDate = DateTime.UtcNow; memObj.isDelete = false; memObjList.Add(memObj); } db.tblGroupMembers.InsertAllOnSubmit(memObjList); db.SubmitChanges(); return true; } } catch (Exception ex) { return false; } }