public int AdicionaMorador(moradores morador)
{
try
{
conservadoraEntities model = Conexao.getInstance();
IQueryable<moradores> i = from p in model.moradores select p;
IEnumerable<moradores> max = i.OrderBy(p => p.idmoradores);
if (max.Count() > 0)
morador.idmoradores = max.Last().idmoradores == null ? 1 : max.Last().idmoradores + 1;
else
morador.idmoradores = 1;
model.AddTomoradores(morador);
model.SaveChanges();
RegisterModel rm = new RegisterModel();
rm.UserName = morador.login;
rm.Password = morador.cpf;
rm.Email = morador.email;
AccountMembershipService ac = new AccountMembershipService();
ac.CreateUser(rm.UserName, rm.Password, rm.Email);
return morador.idmoradores;
}
catch (Exception e)
{
return -1;
}
}
public bool ClearPassword(moradores morador)
{
RegisterModel rm = new RegisterModel();
rm.UserName = morador.login;
rm.Password = morador.cpf;
rm.Email = morador.email;
AccountMembershipService ac = new AccountMembershipService();
return ac.ResertarSenha(rm.UserName, rm.Password);
}
public List<ata> RetornaAtasPorMorador(moradores mor)
{
conservadoraEntities model = Conexao.getInstance();
var q = from p in model.atas
join c in model.condominios_moradores on p.idcondominios equals c.idcondominios
join d in model.moradores on c.idmoradores equals d.idmoradores
where d.idmoradores == mor.idmoradores
|| p.idcondominios == (from x in model.condominios where x.Sindico == mor.idmoradores select x.idcondominios).FirstOrDefault()
select p;
return q.ToList();
}
public ActionResult Delete(int id, moradores collection)
{
try
{
// TODO: Add delete logic here
controle.Apagar(id);
return RedirectToAction("Index");
}
catch
{
return View();
}
}
public ActionResult Create(moradores collection)
{
try
{
Condominios controleCondominio = new Condominios();
// TODO: Add insert logic here
string[] s = Request.Params.GetValues("condominios");
List<condominio> lista = new List<condominio>();
foreach (string str in s)
lista.Add(controleCondominio.RetornaItem(Convert.ToInt32(str)));
int id = controle.AdicionaMorador(collection);
controle.Salvacondominios(lista, id);
return RedirectToAction("Index");
}
catch
{
return View();
}
}
public bool SalvaMorador(moradores morador)
{
try
{
conservadoraEntities model = Conexao.getInstance();
IQueryable<moradores> query = from p in model.moradores where p.idmoradores == morador.idmoradores select p;
moradores morador2 = query.First();
morador2.nome = morador.nome;
morador2.cpf = morador.cpf;
morador2.login = morador.login;
morador2.email = morador.email;
model.SaveChanges();
return true;
}
catch (Exception e)
{
return false;
}
}
public ActionResult Edit(int id, moradores collection)
{
try
{
// TODO: Add update logic here
controle.SalvaMorador(collection);
return RedirectToAction("Index");
}
catch
{
return View();
}
}
public bool SalvaMorador(moradores morador, string acesso)
{
if (acesso != Conexao.SenhaAcesso) throw new Exception();
return controle.SalvaMorador(morador);
}
public int AdicionaMorador(moradores morador, string acesso)
{
if (acesso != Conexao.SenhaAcesso) throw new Exception();
return controle.AdicionaMorador(morador);
}
/// <summary>
/// Deprecated Method for adding a new object to the moradores EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead.
/// </summary>
public void AddTomoradores(moradores moradores)
{
base.AddObject("moradores", moradores);
}
/// <summary>
/// Create a new moradores object.
/// </summary>
/// <param name="idmoradores">Initial value of the idmoradores property.</param>
public static moradores Createmoradores(global::System.Int32 idmoradores)
{
moradores moradores = new moradores();
moradores.idmoradores = idmoradores;
return moradores;
}
