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