public string DeleteMember(int id) { string rpta; Memberships_levels member = new Memberships_levels(); try { using (var ctx = new transshipEntities()) { member = ctx.Memberships_levels.FirstOrDefault(x => x.membershipId == id); if (member != null) { ctx.Entry(member).State = EntityState.Deleted; ctx.SaveChanges(); rpta = "ok"; } else { rpta = "fail"; } } } catch (Exception e) { LogBook.TextLog.Info(string.Format("{0} {1}", e.Message, e.InnerException != null ? e.InnerException.Message : string.Empty)); throw e; } return rpta; }
public HttpResponseMessage Put(Memberships_levels model) { try { BOMemberShip_Levels member = new BOMemberShip_Levels(); Memberships_levels memb; memb = member.UpdateMemberShip(model); return(Request.CreateResponse(HttpStatusCode.OK, memb)); } catch (Exception e) { ErrorMessage mensaje = new ErrorMessage("2.1", "Exception to update memberShip levels - " + e.GetBaseException().Message, e.ToString()); return(Request.CreateResponse(HttpStatusCode.InternalServerError, mensaje)); } }
public Memberships_levels SaveMemberShip(Memberships_levels model) { var member = new Memberships_levels(); try { using (var ctx = new transshipEntities()) { member = ctx.Memberships_levels.Add(model); ctx.SaveChanges(); return member; } } catch (Exception e) { LogBook.TextLog.Info(string.Format("{0} {1}", e.Message, e.InnerException != null ? e.InnerException.Message : string.Empty)); throw e; } }
public Memberships_levels UpdateMember(Memberships_levels model) { Memberships_levels member = new Memberships_levels(); member = model; try { using (var ctx = new transshipEntities()) { ctx.Entry(member).State = EntityState.Modified; ctx.SaveChanges(); return member; } } catch (Exception e) { LogBook.TextLog.Info(string.Format("{0} {1}", e.Message, e.InnerException != null ? e.InnerException.Message : string.Empty)); throw e; } }
public Payments getUser(string email) { var user = new Payments(); Payments p; Memberships_levels m = new Memberships_levels(); try { using (var ctx = new transshipEntities()) { //ctx.Configuration.LazyLoadingEnabled = false; //list = ctx.Memberships_levels.Include("customers").ToList(); var query = (from us in ctx.users join cs in ctx.customers on us.customerId equals cs.customerId join os in ctx.countries on cs.countryId equals os.CountryID where us.email == email select new { status = cs.status, company_name = cs.company_name, customerId = cs.customerId, address1 = cs.address1, address2 = cs.address2, state = cs.state, city = cs.city, Country = os.CountryName, countryId = os.CountryID, expired = cs.expiration_date, contactName = us.full_name, zipcod = cs.zipcode, userId = us.userId, role = us.role, UserType = us.user_type, email = us.email, password = us.password, logo = cs.logo }); foreach (var q in query) { p = new Payments(); p.country = q.Country; p.countryId = q.countryId; p.company_name = q.company_name; p.address1 = q.address1; p.address2 = q.address2; p.city = q.city; if (q.expired != null) { p.expired = q.expired; } else { p.expired = null; } p.contactName = q.contactName; p.zipcode = q.zipcod; p.customerId = q.customerId; p.role = q.role; p.userType = q.UserType; p.userId = q.userId; p.Email = q.email; p.password = TransShip.Security.Security.Decrypt(q.password, new RijndaelManaged(), KEY); p.status = q.status; p.state = q.state; p.logo = q.logo; user = p; } if (user.customerId == 0) { var query2 = (from us in ctx.users where us.email == email select new { userId = us.userId, role = us.role, UserType = us.user_type, email = us.email, password = us.password }); foreach (var q in query2) { p = new Payments(); p.role = q.role; p.userType = q.UserType; p.userId = q.userId; p.Email = q.email; p.password = TransShip.Security.Security.Decrypt(q.password, new RijndaelManaged(), KEY); user = p; } } return(user); } } catch (Exception e) { LogBook.TextLog.Info(string.Format("{0} {1}", e.Message, e.InnerException != null ? e.InnerException.Message : string.Empty)); throw e; } }
public Memberships_levels UpdateMemberShip(Memberships_levels members) { return(member.UpdateMember(members)); }
public Memberships_levels SaveMemberShip(Memberships_levels members) { return(member.SaveMemberShip(members)); }