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