public MembershipType GetMembershipType(string typename, bool typeadd = false)
{
MembershipType mtype = null;
using (SystemMapEntities db = new SystemMapEntities())
{
mtype = db.membership_types
.Where(mt => mt.typename == typename)
.Select(mt => new MembershipType
{
typeId = mt.memtypeid,
name = mt.typename,
description = mt.descr,
iconUrl = mt.iconurl
})
.SingleOrDefault();
if (mtype == null && typeadd && !String.IsNullOrEmpty(typename) && !String.IsNullOrWhiteSpace(typename))
{
membership_types natype = new membership_types {
typename = typename
};
db.membership_types.Add(natype);
db.SaveChanges();
mtype = new MembershipType {
typeId = natype.memtypeid, name = typename
};
}
}
return(mtype);
}
public void UpdateMembershipType(MembershipType udata)
{
using (SystemMapEntities db = new SystemMapEntities())
{
membership_types utype = db.membership_types
.Where(mt => mt.memtypeid == udata.typeId)
.SingleOrDefault();
if (utype != null)
{
utype.typename = udata.name;
utype.descr = udata.description;
utype.iconurl = udata.iconUrl;
db.SaveChanges();
}
}
}
public MembershipType AddMembershipType(MembershipType mtype)
{
MembershipType typeval = null;
using (SystemMapEntities db = new SystemMapEntities())
{
//check that we don't already have this name
int ecount = db.membership_types.Where(n => n.typename == mtype.name).Count();
if (ecount == 0)
{
//Go ahead and add it
membership_types addtype = new membership_types {
typename = mtype.name, descr = mtype.description, iconurl = mtype.iconUrl
};
db.membership_types.Add(addtype);
db.SaveChanges();
typeval = new MembershipType {
typeId = addtype.memtypeid, name = addtype.typename, description = addtype.descr, iconUrl = addtype.iconurl
};
}
else
{
typeval = db.membership_types
.Where(n => n.typename == mtype.name)
.Select(n => new MembershipType
{
typeId = n.memtypeid,
name = n.typename,
description = n.descr,
iconUrl = n.iconurl
})
.FirstOrDefault();
}
}
return(typeval);
}
