public List <LOGIN> GethiveMembers(int hiveId) { using (var db = new MonzonEntities()) { return(db.LOGIN.Where(l => l.PROFILE.BIZ_ID != "PUB" && l.HIVE_ID == hiveId).ToList()); } }
public LOGIN GetLeader() { using (var db = new MonzonEntities()) { return(db.LOGIN.Include(l => l.PROFILE).FirstOrDefault(l => l.PROFILE.BIZ_ID == "LED")); } }
public List <LOGIN> GetMembers() { using (var db = new MonzonEntities()) { return(db.LOGIN.Where(l => l.PROFILE.BIZ_ID != "PUB" && l.PROFILE.BIZ_ID != "ADM" && l.HIVE_ID == null).ToList()); } }
public List <LOGIN> GetR4Members() { using (var db = new MonzonEntities()) { return(db.LOGIN.Include(l => l.PROFILE).Where(l => l.PROFILE.BIZ_ID == "R4").ToList()); } }
protected void Unnamed9_Click(object sender, EventArgs e) { if (txtEmailNew.Text != txtEmailNewRepeat.Text) { //LOS EMAILS NO COINCIDEN return; } if (!ValidEmail(txtEmailNew.Text)) { //NO ES UN MAIL VALIDO } var user = (LOGIN)Session["USER"]; if (user != null) { using (var db = new MonzonEntities()) { var dbUser = db.LOGIN.FirstOrDefault(l => l.UNIQUE_ID == user.UNIQUE_ID); dbUser.EMAIL = txtEmailNew.Text; db.LOGIN.Attach(dbUser); db.Entry(dbUser).State = EntityState.Modified; db.SaveChanges(); } } }
public LOGIN CheckUser(LOGIN login) { using (var db = new MonzonEntities()) { return(db.LOGIN.Include(l => l.PROFILE).FirstOrDefault(l => l.LOGIN1 == login.LOGIN1 && l.PASSWORD == login.PASSWORD)); } }
protected void Unnamed13_Click(object sender, EventArgs e) { var user = (LOGIN)Session["USER"]; if (user != null) { using (var db = new MonzonEntities()) { var dbUser = db.LOGIN.FirstOrDefault(l => l.UNIQUE_ID == user.UNIQUE_ID); if (txtPasswordNew.Text == dbUser.PASSWORD) { if (txtPasswordNew.Text != txtPasswordNewRepeat.Text) { //LAS PASSWORD NUEVAS NO COINCIDEN } else { dbUser.PASSWORD = txtPasswordNew.Text; db.LOGIN.Attach(dbUser); db.Entry(dbUser).State = EntityState.Modified; db.SaveChanges(); } } else { //LA PASSWORD ANTIGUA NO ES CORRECTA } } } }
public List <PLACE> GetPlaces() { using (var db = new MonzonEntities()) { return(db.PLACE.Include(p => p.PLACE_TYPE).Where(p => !p.DELETED).ToList()); } }
public POST GetPost(int idPost) { using (var db = new MonzonEntities()) { return(db.POST.FirstOrDefault(p => p.UNIQUE_ID == idPost)); } }
public List <POST> GetDescendingDate(int page, int pageSize) { using (var db = new MonzonEntities()) { return(db.POST.OrderByDescending(x => x.POST_DATE).Skip((page - 1) * pageSize).Take(pageSize).ToList()); } }
public List <PLACE> GetHives() { using (var db = new MonzonEntities()) { return(null); //return db.PLACE.Where(p => !p.DELETED && p.HIVE_ID != null).ToList(); } }
/// <summary> /// Get an entity by its unique identifier /// </summary> /// <param name="entity">Entity unique identifier</param> /// <returns>The entity</returns> public T New(T entity) { try { using (var context = new MonzonEntities()) { entity = context.Set <T>().Add(entity); } } catch (Exception ex) { throw new Exception(string.Format("Error creating entity"), ex); } return(entity); }
/// <summary> /// Returns the entity number of rows /// </summary> /// <returns>Entity number of rows</returns> public long Count() { long count; try { using (MonzonEntities context = new MonzonEntities()) { count = context.Set <T>().Count(); } } catch (Exception ex) { throw new Exception("Error reading entity number of rows", ex); } return(count); }
/// <summary> /// Get an entity by its unique identifier /// </summary> /// <param name="id">Entity unique identifier</param> /// <returns>The entity</returns> public T Get(long id) { T entity; try { using (var context = new MonzonEntities()) { entity = context.Set <T>().Find(id); } } catch (Exception ex) { throw new Exception(string.Format("Error getting entity with id {0}", id), ex); } return(entity); }
protected void Unnamed5_Click(object sender, EventArgs e) { var user = (LOGIN)Session["USER"]; if (user != null) { using (var db = new MonzonEntities()) { var dbUser = db.LOGIN.FirstOrDefault(l => l.UNIQUE_ID == user.UNIQUE_ID); dbUser.FIRST_NAME = txtName.Text; dbUser.LAST_NAME = txtSurname.Text; dbUser.PHONE = txtPhone.Text; db.LOGIN.Attach(dbUser); db.Entry(dbUser).State = EntityState.Modified; db.SaveChanges(); } } }
public bool PasswordRecovery(LOGIN login, string random) { using (var ts = new TransactionScope()) { using (var db = new MonzonEntities()) { login.PASSWORD = random; db.LOGIN.Attach(login); db.SaveChanges(); } MailMessage mail = new MailMessage("*****@*****.**", login.EMAIL); SmtpClient client = new SmtpClient { Port = 25, DeliveryMethod = SmtpDeliveryMethod.Network, UseDefaultCredentials = false, Host = "smtp.google.com" }; mail.Subject = "this is a test email."; mail.Body = "this is my test email body"; client.Send(mail); ts.Complete(); return(true); } }