//Private Methods
private List <MembershipTypeModel> GetMembershipTypeModelsFromTable(Table table)
{
var results = new List <MembershipTypeModel>();
foreach (var row in table.Rows)
{
var model = new MembershipTypeModel();
model.Restriction = new RestrictionModel();
model.MembershipTypeName = row.ContainsKey("MembershipTypeName") ? row["MembershipTypeName"] : string.Empty;
if (row.ContainsKey("MaxSearchesPerDay"))
{
int maxSearchesPerDay = 0;
if (int.TryParse(row["MaxSearchesPerDay"], out maxSearchesPerDay))
{
model.Restriction.MaxSearchesPerDay = maxSearchesPerDay;
}
}
if (row.ContainsKey("MaxApplicationsPerDay"))
{
int maxApplicationsPerDay = 0;
if (int.TryParse(row["MaxApplicationsPerDay"], out maxApplicationsPerDay))
{
model.Restriction.MaxApplicationsPerDay = maxApplicationsPerDay;
}
}
results.Add(model);
}
return(results);
}
//public List<MembershipTypeModel> GetAnnouncementsByEffectiveDates(DateTime validFrom, DateTime validTo)
//{
// List<MembershipTypeModel> membershipTypeModels = new List<MembershipTypeModel>();
// foreach (MembershipType membershipType in clubmembershipDataContext.MembershipTypes.Where
// (x => x.ValidFrom >= validFrom && x.ValidTo <= validTo))
// {
// membershipTypeModels.Add(MapDbObjectToModel(membershipType));
// }
// return membershipTypeModels;
//}
//public List<MembershipTypeModel> GetAnnouncementsByEventDate(DateTime eventDate)
//{
// List<MembershipTypeModel> membershipTypeModels = new List<MembershipTypeModel>();
// foreach (MembershipType membershipType in clubmembershipDataContext.MembershipTypes.Where
// (x => x.EventDateTime.HasValue && x.EventDateTime.Value.Date == eventDate.Date))
// {
// membershipTypeModels.Add(MapDbObjectToModel(membershipType));
// }
// return membershipTypeModels;
//}
public void InsertMembershipType(MembershipTypeModel membershipTypeModel)
{
membershipTypeModel.IDMembershipType = Guid.NewGuid();
clubmembershipDataContext.MembershipTypes.InsertOnSubmit(MapModelToDbObject(membershipTypeModel));
clubmembershipDataContext.SubmitChanges();
}
public void InsertMembershipType(MembershipTypeModel member)
{
member.IDMembershipType = Guid.NewGuid();
dbContext.MembershipTypes.InsertOnSubmit(member.MapObject <Models.DBObjects.MembershipType>());
dbContext.SubmitChanges();
}
public MembershipTypeModel GetMembershipTypeByID(Guid id)
{
MembershipTypeModel membershipTypeModel = new MembershipTypeModel();
MembershipType membershipType = clubmembershipDataContext.MembershipTypes.FirstOrDefault(x => x.IDMembershipType == id);
return(MapDbObjectToModel(membershipType));
}
public void UpdateMembershiptype(MembershipTypeModel membershipTypeModel)
{
Models.DBObjects.MembershipType exisitngmembershipType = dbContext.MembershipTypes.FirstOrDefault(x => x.IDMembershipType == membershipTypeModel.IDMembershipType);
if (exisitngmembershipType != null)
{
exisitngmembershipType.UpdateObject(membershipTypeModel);
dbContext.SubmitChanges();
}
}
public void UpdateMembershipType(MembershipTypeModel membershipTypeModel)
{
Models.DBObjects.MembershipType existingAnnouncement = clubmembershipDataContext.MembershipTypes.FirstOrDefault
(x => x.IDMembershipType == membershipTypeModel.IDMembershipType);
if (existingAnnouncement != null)
{
existingAnnouncement.IDMembershipType = membershipTypeModel.IDMembershipType;
existingAnnouncement.Name = membershipTypeModel.Name;
existingAnnouncement.Description = membershipTypeModel.Description;
existingAnnouncement.SubscriptionLengthInMonths = membershipTypeModel.SubscriptionLengthInMonths;
clubmembershipDataContext.SubmitChanges();
}
}
private MembershipType MapModelToDbObject(MembershipTypeModel membershipTypeModel)
{
MembershipType dbMembershipTypeModel = new MembershipType();
if (membershipTypeModel != null)
{
dbMembershipTypeModel.IDMembershipType = membershipTypeModel.IDMembershipType;
dbMembershipTypeModel.Name = membershipTypeModel.Name;
dbMembershipTypeModel.Description = membershipTypeModel.Description;
dbMembershipTypeModel.SubscriptionLengthInMonths = membershipTypeModel.SubscriptionLengthInMonths;
return(dbMembershipTypeModel);
}
return(null);
}
private MembershipTypeModel MapDbObjectToModel(MembershipType membershipType)
{
MembershipTypeModel membershipTypeModel = new MembershipTypeModel();
if (membershipType != null)
{
membershipTypeModel.IDMembershipType = membershipType.IDMembershipType;
membershipTypeModel.Name = membershipType.Name;
membershipTypeModel.Description = membershipType.Description;
membershipTypeModel.SubscriptionLengthInMonths = membershipType.SubscriptionLengthInMonths;
return(membershipTypeModel);
}
return(null);
}
