internal static EnumServices.UpdateResult UpdateMember(Members member)
{
using (var db = new CorePracticeWebAppContext())
{
try
{
var memberInDb = db.Members.Find(member.Id);
if (memberInDb != null)
{
memberInDb.City = member.City;
memberInDb.Country = member.Country;
memberInDb.DateofBap = member.DateofBap;
memberInDb.DateOfBirth = member.DateOfBirth;
memberInDb.FirstName = member.FirstName;
memberInDb.LastName = member.LastName;
memberInDb.State = member.State;
memberInDb.StreetAddress = member.StreetAddress;
memberInDb.IsActive = member.IsActive;
db.SaveChanges();
}
else
{
throw new KeyNotFoundException("Member not found");
}
}
catch (Exception e)
{
return(EnumServices.UpdateResult.fail);
}
return(EnumServices.UpdateResult.success);
}
}
internal static int AddMember(Members member)
{
using (var db = new CorePracticeWebAppContext())
{
try
{
db.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].[Members] ON");
db.Members.Add(member);
db.SaveChanges();
db.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].[Members] OFF");
}
catch (Exception e)
{
}
}
return(member.Id);
}