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