private static List<ContactoModel> GetById(Guid id) { var lContactos = new List<ContactoModel>(); try { using (AgendaEntities dbContext = new AgendaEntities()) { var rContactos = dbContext.Contacto.Where(x => (bool)x.Activo && x.Id == id).ToList(); rContactos.ForEach(x => lContactos.Add(new ContactoModel() { ApellidoMaterno = x.ApellidoMaterno, ApellidoPaterno = x.ApellidoPaterno, Direccion = x.Direccion, Email = x.Email, Nombre = x.Nombre, Telefono = x.Telefono })); return lContactos; } } catch { return lContactos; } }
/// <summary> /// Returns a list of events from the Database based on a time choice /// </summary> /// <param name="date"></param> /// <param name="dayOrWeek"></param> /// <returns></returns> public List <Event> GetRecordsFromDB(DateTime date, string dayOrWeek) { List <Event> events = null; AgendaEntities context = new AgendaEntities(); DateTime limitDate = date.Date.AddDays(7); try { if (dayOrWeek.ToLower() == "day") { events = context.Events.Where(e => e.Date == date.Date).ToList(); } else if (dayOrWeek.ToLower() == "week") { events = context.Events.Where(e => e.Date >= date.Date.Date && e.Date < limitDate.Date).ToList(); } else if (dayOrWeek.ToLower() == "all") { events = context.Events.Where(e => e.Id > 0).ToList(); } }catch (Exception e) { MessageBox.Show("Exception Details: " + e); } return(events); }
/// <summary> /// Will return TRUE if the user introduced data is matching with the data from database /// </summary> /// <param name="username"></param> /// <param name="password"></param> /// <returns></returns> public bool ValidateUser(string username, string password) { bool validation = true; AgendaEntities db = new AgendaEntities(); try { if (username != string.Empty || password != string.Empty) { var user = db.USER.Where(u => u.Username == username).FirstOrDefault(); if (user != null) { if (user.Password.Equals(password)) { return(validation); } } } else { return(!validation); } } catch (Exception e) { MessageBox.Show("Exception Details: " + e); } return(!validation); }
// GET: api/MK_SCORE_PARTY public IQueryable <MK_SCORE_PARTY> GetMK_SCORE_PARTY() { ImportBillVotesByAgenda(); using (AgendaEntities db = new AgendaEntities()) { // http://www.asp.net/web-api/overview/data/using-web-api-with-entity-framework/part-5 var MK_SCORE_PARTYs = from mk_s in db.MK_SCORE join mk_p in db.MK_TO_PARTY on mk_s.mk equals mk_p.mk select new MK_SCORE_PARTY() { IdMK_SCORE = mk_s.Id, mk = mk_s.mk, mkName = mk_s.MK1.mk_name, party = mk_p.party, partyName = mk_p.PARTY1.party1, fromDate = mk_s.fromDate, toDate = mk_s.toDate, knessetNumber = mk_p.knessetNumber, score = mk_s.score, volume = mk_s.volume, agendaId = mk_s.agendaId, agendaName = mk_s.AGENDA.name }; return(MK_SCORE_PARTYs); } }
public static bool Excluir(Pessoa p) { try { AgendaEntities db = new AgendaEntities(); Pessoa pa = new Pessoa(); pa = db.Pessoas.Find(p.Email); if (pa != null) { db.Pessoas.Remove(pa); } else { return(false); } db.SaveChanges(); return(true); } catch (Exception) { throw; } }
private static List<ContactoModel> GetBy_Email(string email) { var lContactos = new List<ContactoModel>(); try { if (string.IsNullOrEmpty(email)) return lContactos; using (AgendaEntities dbContext = new AgendaEntities()) { var rContactos = dbContext.Contacto.Where(x => (bool)x.Activo && x.Email.Trim().ToUpper() == email.Trim().ToUpper()).ToList(); rContactos.ForEach(x => lContactos.Add(new ContactoModel() { ApellidoMaterno = x.ApellidoMaterno, ApellidoPaterno = x.ApellidoPaterno, Direccion = x.Direccion, Email = x.Email, Nombre = x.Nombre, Telefono = x.Telefono })); return lContactos; } } catch { return lContactos; } }
public Tarea getTaskById(int Id) { var task = new Tarea(); using (var conexion = new AgendaEntities()) { task = conexion.Tareas.FirstOrDefault(x => x.ID == Id); } return(task); }
public List <Tarea> getallTask() { var List = new List <Tarea>(); using (var conexion = new AgendaEntities()) { List = conexion.Tareas.ToList(); } return(List); }
/// <summary> /// recalculate the general score of every agenda /// </summary> private void recalculate(DateTime from, DateTime to) { using (AgendaEntities db = new AgendaEntities()) { foreach (AGENDA a in db.AGENDA) { recalculate(a.Id, from, to); } } }
public static OperationResult Create(ContactoModel contacto) { try { #region Validaciones if (contacto == null) return new OperationResult() { Message = "El objeto Contacto viene vacío"}; if (string.IsNullOrEmpty(contacto.Nombre)) return new OperationResult() { Message = "El nombre es requerido" }; if (string.IsNullOrEmpty(contacto.ApellidoPaterno)) return new OperationResult() { Message = "El apellido paterno es requerido" }; if (string.IsNullOrEmpty(contacto.Telefono)) return new OperationResult() { Message = "El teléfono es requerido" }; if (contacto.Nombre.Length > 50) return new OperationResult() { Message = "El nombre debe tener 50 caracteres como máximo" }; if (contacto.ApellidoPaterno.Length > 50) return new OperationResult() { Message = "El apellido debe tener 50 caracteres como máximo" }; if (!string.IsNullOrEmpty(contacto.ApellidoMaterno)) { if (contacto.ApellidoMaterno.Length > 50) return new OperationResult() { Message = "El apellido debe tener 50 caracteres como máximo" }; } if (contacto.Telefono.Length > 16) return new OperationResult() { Message = "El teléfono debe tener 16 caracteres como máximo" }; if (!string.IsNullOrEmpty(contacto.Direccion)) { if (contacto.Direccion.Length > 100) return new OperationResult() { Message = "La dirección debe tener 100 caracteres como máximo" }; } var contactosTel = GetBy_Tel(contacto.Telefono); if (contactosTel.Any()) return new OperationResult() { Message = "El número de teléfono ya ha sido registrado anteriormente." }; var contactosEmail = GetBy_Email(contacto.Email); if (contactosEmail.Any()) return new OperationResult() { Message = "El correo electrónico ya ha sido registrado anteriormente." }; #endregion using (AgendaEntities dbContext = new AgendaEntities()) { dbContext.Contacto.Add(new Contacto() { Activo = true, ApellidoMaterno = contacto.ApellidoMaterno, ApellidoPaterno = contacto.ApellidoPaterno, Direccion = contacto.Direccion, Email = contacto.Email, FechaCreacion = DateTime.Now, Id = Guid.NewGuid(), Nombre = contacto.Nombre, Telefono = contacto.Telefono }); dbContext.SaveChanges(); return new OperationResult() { Success = true }; } } catch (Exception ex) { return new OperationResult() { Message = ex.Message }; // Normalmente se manda un error genérico, pero se deja así por fines de que es una evaluación } }
public bool addTask(Tarea task) { var retorno = false; using (var conexion = new AgendaEntities()) { conexion.Tareas.Add(task); conexion.SaveChanges(); retorno = true; } return(retorno); }
public static List <Pessoa> Listar() { try { AgendaEntities db = new AgendaEntities(); return(db.Pessoas.ToList()); } catch (Exception) { throw; } }
public bool updateTask(int ID) { var retorno = false; using (var conexion = new AgendaEntities()) { var t = conexion.Tareas.FirstOrDefault(x => x.ID == ID); t.estado = (t.estado) ? false : true; conexion.SaveChanges(); retorno = true; } return(retorno); }
public bool deletedTask(int ID) { var retorno = false; using (var conexion = new AgendaEntities()) { var t = conexion.Tareas.FirstOrDefault(x => x.ID == ID); conexion.Tareas.Remove(t); conexion.SaveChanges(); retorno = true; } return(retorno); }
public static Pessoa Pesquisar(String email) { try { AgendaEntities db = new AgendaEntities(); return(db.Pessoas.Find(email)); } catch (Exception) { throw; } }
protected void RegisterUser_CreatedUser(object sender, EventArgs e) { AgendaEntities agenda = new AgendaEntities(); Usuarios usuarios = new Usuarios(); usuarios.Nome = RegisterUser.UserName.ToString(); usuarios.Email = RegisterUser.Email.ToString(); usuarios.Senha = RegisterUser.Password.ToString(); agenda.AddToUsuarios(usuarios); agenda.SaveChanges(); Response.Redirect("Login.aspx"); }
public static Pessoa Pesquisar(Guid userid) { try { AgendaEntities db = new AgendaEntities(); return(db.Pessoas.Find(userid)); } catch (Exception) { throw; } }
public static Pessoa Pesquisar(string email) { try { AgendaEntities db = new AgendaEntities(); Pessoa pa = new Pessoa(); pa = db.Pessoas.Find(email); return(pa); } catch (Exception) { throw; } }
public static bool Inserir(Pessoa p) { try { AgendaEntities db = new AgendaEntities(); db.Pessoas.Add(p); db.SaveChanges(); return(true); } catch (Exception) { throw; } }
protected void LoginButton_Click(object sender, EventArgs e) { AgendaEntities agenda = new AgendaEntities(); string login = LoginUser.UserName.ToString(); string senha = LoginUser.Password.ToString(); var usr = agenda.Usuarios.Where(u => u.Email.Equals(login) && u.Senha.Equals(senha)).FirstOrDefault(); if (usr != null) { FormsAuthentication.SetAuthCookie(usr.Nome.ToString(), false); Session["codigo"] = usr.Id.ToString(); Session["usuario"] = usr.Nome.ToString(); Response.Redirect("~/Contatos.aspx"); } }
public static Pessoa Pesquisar(String email) { try { AgendaEntities db = new AgendaEntities(); Pessoa pa = new Pessoa(); // Para alterar o registro é necessário ler primeiro e depois fazer modificações pa = db.Pessoas.Find(email); return(pa); } catch (Exception) { throw; } }
/// <summary> /// Will delete a record(event) from the database based on a given ID /// </summary> /// <param name="id"></param> public void DeleteRecordFromDB(int id) { AgendaEntities context = new AgendaEntities(); try { var eventToRemove = context.Events.FirstOrDefault(e => e.Id == id); if (eventToRemove != null) { context.Events.Remove(eventToRemove); context.SaveChanges(); } }catch (Exception e) { MessageBox.Show("Exception Details: " + e); } }
public static bool Inserir(Pessoa p) { try { AgendaEntities db = new AgendaEntities(); if (pnAgenda.Pesquisar(p.Email) != null) { return(false); } db.Pessoas.Add(p); db.SaveChanges(); return(true); } catch (Exception) { throw; } }
public static bool Excluir(Pessoa p) { try { AgendaEntities db = new AgendaEntities(); Pessoa pa = new Pessoa(); // Para excluir o registro é necessário ler primeiro e depois fazer modificações pa = db.Pessoas.Find(p.Email); db.Pessoas.Remove(pa); db.SaveChanges(); return(true); } catch (Exception) { throw; } }
public static bool Alterar(Pessoa p) { try { AgendaEntities db = new AgendaEntities(); Pessoa pa = new Pessoa(); pa = db.Pessoas.Find(p.UserID); pa.Idade = p.Idade; pa.Nome = p.Nome; db.SaveChanges(); return(true); } catch (Exception) { throw; } }
public static OperationResult Delete(Guid id) { try { using (AgendaEntities dbContext = new AgendaEntities()) { var rContactos = dbContext.Contacto.Where(x => (bool)x.Activo && x.Id == id).ToList(); if (!rContactos.Any()) return new OperationResult() { Message = "El contacto con el id ingresado no existe. Verifique." }; rContactos.First().Activo = false; dbContext.SaveChanges(); return new OperationResult() { Success = true }; } } catch(Exception ex) // Normalmente se manda un error genérico, pero se deja así por fines de que es una evaluación { return new OperationResult() { Message = ex.Message }; } }
public static ResponseContactoModel Get(int numRegistros, int numPagina, string filter) { var rContactos_ = new ResponseContactoModel(); try { using (AgendaEntities dbContext = new AgendaEntities()) { if (string.IsNullOrEmpty(filter)) filter = ""; var rContactos = dbContext.Contacto.Where(x => (bool)x.Activo && (((x.Nombre ?? "") + " " + (x.ApellidoPaterno ?? "") + " " + (x.ApellidoMaterno ?? "")).Contains(filter) || x.Email.Contains(filter) || x.Telefono.Contains(filter) || x.Direccion.Contains(filter))) .OrderByDescending(x => x.FechaCreacion).ToList(); rContactos_.TotalGlobal = rContactos.Count(); rContactos = rContactos.Skip((numPagina - 1) * numRegistros) .Take(numRegistros).ToList(); rContactos.ForEach(x => rContactos_.ListContactos.Add(new ContactoModel() { ApellidoMaterno = x.ApellidoMaterno, ApellidoPaterno = x.ApellidoPaterno, Direccion = x.Direccion, Email = x.Email, Nombre = x.Nombre, Telefono = x.Telefono, Id = x.Id })); return rContactos_; } } catch { return rContactos_; // Normalmente se manda un error genérico, pero se deja así por fines de que es una evaluación } }
/// <summary> /// Will edit a record(event) from the database /// </summary> /// <param name="id"></param> /// <param name="name"></param> /// <param name="date"></param> /// <param name="time"></param> /// <param name="description"></param> public void UpdateRecord(int id, string name, DateTime date, DateTime time, string description) { try { using (var context = new AgendaEntities()) { var evnt = context.Events.SingleOrDefault(e => e.Id == id); if (evnt != null) { evnt.Name = name; evnt.Date = date; evnt.Time = time.TimeOfDay; evnt.Description = description; context.SaveChanges(); } } }catch (Exception e) { MessageBox.Show("Exception Details: " + e); } }
//[Route("MK_SCORE_PARTY/{agendaId}/orders")] public IHttpActionResult GetMK_SCORE_PARTY(int id) { var context = System.Web.HttpContext.Current; using (AgendaEntities db = new AgendaEntities()) { //ImportBillVotesByAgenda(id); //AGENDA_DTO aGENDA_DTO = db.AGENDA_DTO.Find(id); //AGENDA_DTO aMK_SCORE_PARTY = null; List <MK_SCORE_PARTY> aMK_SCORE_PARTY = (from mk_s in db.MK_SCORE join mk_p in db.MK_TO_PARTY on mk_s.mk equals mk_p.mk where mk_s.agendaId == id select new MK_SCORE_PARTY() { IdMK_SCORE = mk_s.Id, mk = mk_s.mk, mkName = mk_s.MK1.mk_name, party = mk_p.party, partyName = mk_p.PARTY1.party1, fromDate = mk_s.fromDate, toDate = mk_s.toDate, knessetNumber = mk_p.knessetNumber, score = mk_s.score, volume = mk_s.volume, agendaId = mk_s.agendaId, agendaName = mk_s.AGENDA.name }).ToList(); if (aMK_SCORE_PARTY == null) { ErrorLog.GetDefault(context).Log(new Error(new Exception(" GetMK_SCORE_PARTY(int id)-return NotFound"))); return(NotFound()); } ErrorLog.GetDefault(context).Log(new Error(new Exception(" GetMK_SCORE_PARTY(int id)-return Ok(aMK_SCORE_PARTY)"))); return(Ok(aMK_SCORE_PARTY)); } }
/// <summary> /// Will add a record into the Database containing data that describes an agenda event /// </summary> /// <param name="name"></param> /// <param name="date"></param> /// <param name="time"></param> /// <param name="description"></param> public void AddRecordToDB(string name, DateTime date, DateTime time, string description) { try { using (var context = new AgendaEntities()) { var evnt = new Event() { Name = name, Date = date, Time = time.TimeOfDay, Description = description }; context.Events.Add(evnt); context.SaveChanges(); } }catch (Exception e) { MessageBox.Show("Exception Details: " + e); } }