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