public DTO.Evento GetEventoById(int idEvento) { using (var db = new SemanaTecnologiaEntities()) { return db.Evento .Where(c => c.PK_EVENT == idEvento) .Select(c => new DTO.Evento() { DATE = c.DATE, DESCRIPTION = c.DESCRIPTION, END_TIME = c.END_TIME, FK_PALESTRANTE = c.FK_PALESTRANTE, HOUR = c.HOUR, LOCATION = c.LOCATION, NAME = c.NAME, NSLOTS = c.NSLOTS, PK_EVENT = c.PK_EVENT, START_TIME = c.START_TIME, TYPE = c.TYPE }).FirstOrDefault(); } }
public DTO.Palestrante CreateNewPalestrante(DTO.Palestrante palestrante) { using (var db = new SemanaTecnologiaEntities()) { var PalestranteRow = db.Palestrante.Create(); PalestranteRow.NAME = palestrante.NAME; PalestranteRow.EMAIL = palestrante.EMAIL; PalestranteRow.CV = palestrante.CV; PalestranteRow.CITY = palestrante.CITY; PalestranteRow.TEL = palestrante.TEL; PalestranteRow.TITRATION = palestrante.TITRATION; db.Palestrante.Add(PalestranteRow); db.SaveChanges(); palestrante.PK_PALESTRANTE = PalestranteRow.PK_PALESTRANTE; return palestrante; } }
public DTO.Participante CreateNewParticipante(DTO.Participante participante) { using (var db = new SemanaTecnologiaEntities()) { var ParticipanteROW = db.Participante.Create(); ParticipanteROW.PK_PARTICIPANTE = participante.PK_PARTICIPANTE; ParticipanteROW.COURSE = participante.COURSE; ParticipanteROW.EMAIL = participante.EMAIL; ParticipanteROW.LOGIN = participante.LOGIN; ParticipanteROW.NAME = participante.NAME; ParticipanteROW.PASSWORD = participante.PASSWORD; ParticipanteROW.PERIOD = participante.PERIOD; ParticipanteROW.PROFILE = participante.PROFILE; ParticipanteROW.TEL = participante.TEL; db.Participante.Add(ParticipanteROW); db.SaveChanges(); return participante; } }
public List<DTO.Insc_Evento> GetAllInscricoesByIdEvento(int idEvento) { using (var db = new SemanaTecnologiaEntities()) { return db.Insc_Evento .Where(c => c.FK_EVENTO == idEvento) .Select(c => new DTO.Insc_Evento { FK_INSCRICAO = c.FK_INSCRICAO }).ToList(); } }
public DTO.Inscricao GetIdParticipantes(int idInscricao) { using (var db = new SemanaTecnologiaEntities()) { return db.Inscricao .Where(c => c.PK_INSCRICAO == idInscricao) .Select(c => new DTO.Inscricao { CPF = c.CPF, DATE = c.DATE, PK_INSCRICAO = c.PK_INSCRICAO }).FirstOrDefault(); } }
public List<DTO.Inscricao> GetIncricoesByParticipantes(string idAluno) { using (var db = new SemanaTecnologiaEntities()) { return db.Inscricao .Where(c => c.CPF == idAluno) .Select(c => new DTO.Inscricao { CPF = c.CPF, DATE = c.DATE, PK_INSCRICAO = c.PK_INSCRICAO }).ToList(); } }
public DTO.Insc_Evento GetCodEventoById(int idInscricao) { using (var db = new SemanaTecnologiaEntities()) { return db.Insc_Evento .Where(c => c.FK_INSCRICAO == idInscricao) .Select(c => new DTO.Insc_Evento { FK_EVENTO = c.FK_EVENTO, FK_INSCRICAO = c.FK_INSCRICAO, FK_INSC_EVENTO = c.PK_INSC_EVENTO }).FirstOrDefault(); } }
public DTO.Palestrante GetPalestranteById(int idPalestrante) { using (var db = new SemanaTecnologiaEntities()) { return db.Palestrante .Where(c => c.PK_PALESTRANTE == idPalestrante) .Select(c => new DTO.Palestrante() { CITY = c.CITY, CV = c.CV, EMAIL = c.EMAIL, NAME = c.NAME, PK_PALESTRANTE = c.PK_PALESTRANTE, TITRATION = c.TITRATION, TEL = c.TEL }).FirstOrDefault(); } }
public DTO.Insc_Evento CreateNewInscEvento(DTO.Insc_Evento insc_Evento) { using (var db = new SemanaTecnologiaEntities()) { var Insc_EventoRow = db.Insc_Evento.Create(); Insc_EventoRow.FK_EVENTO = insc_Evento.FK_EVENTO; Insc_EventoRow.FK_INSCRICAO = insc_Evento.FK_INSCRICAO; db.Insc_Evento.Add(Insc_EventoRow); db.SaveChanges(); insc_Evento.FK_INSC_EVENTO = Insc_EventoRow.PK_INSC_EVENTO; return insc_Evento; } }
public List<DTO.Palestrante> GetAllPalestrantes() { using (var db = new SemanaTecnologiaEntities()) { return db.Palestrante .Select(c => new DTO.Palestrante() { CITY = c.CITY, CV = c.CV, EMAIL = c.EMAIL, NAME = c.NAME, TEL = c.TEL, PK_PALESTRANTE = c.PK_PALESTRANTE, TITRATION = c.TITRATION }) .ToList(); } }
public DTO.Inscricao CreateNewInscricao(DTO.Inscricao inscricao) { using (var db = new SemanaTecnologiaEntities()) { var InscricaoROW = db.Inscricao.Create(); InscricaoROW.CPF = inscricao.CPF; InscricaoROW.DATE = inscricao.DATE; db.Inscricao.Add(InscricaoROW); db.SaveChanges(); inscricao.PK_INSCRICAO = InscricaoROW.PK_INSCRICAO; return inscricao; } }
public List<DTO.Participante> GetAllPArticipantes() { using (var db = new SemanaTecnologiaEntities()) { return db.Participante .Select(c => new DTO.Participante() { COURSE = c.COURSE, EMAIL = c.EMAIL, LOGIN = c.LOGIN, NAME = c.NAME, PASSWORD = c.PASSWORD, PERIOD = c.PERIOD, PK_PARTICIPANTE = c.PK_PARTICIPANTE, PROFILE = c.PROFILE, TEL = c.TEL }) .ToList(); } }
public DTO.Participante GetParticipante(string idParticipante) { using (var db = new SemanaTecnologiaEntities()) { return db.Participante .Where(c => c.PK_PARTICIPANTE == idParticipante) .Select(c => new DTO.Participante { COURSE = c.COURSE, EMAIL = c.EMAIL, NAME = c.NAME, LOGIN = c.LOGIN, PASSWORD = c.PASSWORD, PERIOD = c.PERIOD, PK_PARTICIPANTE = c.PK_PARTICIPANTE, PROFILE = c.PROFILE, TEL=c.TEL }).FirstOrDefault(); } }
public List<DTO.Evento> GetAllEventos() { using (var db = new SemanaTecnologiaEntities()) { return db.Evento .Select(c => new DTO.Evento() { DATE = c.DATE, DESCRIPTION = c.DESCRIPTION, END_TIME = c.END_TIME, FK_PALESTRANTE = c.FK_PALESTRANTE, HOUR = c.HOUR, LOCATION = c.LOCATION, NAME = c.NAME, NSLOTS = c.NSLOTS, PK_EVENT = c.PK_EVENT, START_TIME = c.START_TIME, TYPE = c.START_TIME }) .ToList(); } }
public DTO.Evento CreateNewEvento(DTO.Evento evento) { using (var db = new SemanaTecnologiaEntities()) { var EventoRow = db.Evento.Create(); EventoRow.DATE = evento.DATE; EventoRow.DESCRIPTION = evento.DESCRIPTION; EventoRow.END_TIME = evento.END_TIME; EventoRow.FK_PALESTRANTE = evento.FK_PALESTRANTE; EventoRow.HOUR = evento.HOUR; EventoRow.LOCATION = evento.LOCATION; EventoRow.NAME = evento.NAME; EventoRow.NSLOTS = evento.NSLOTS; EventoRow.START_TIME = evento.START_TIME; EventoRow.TYPE = evento.TYPE; db.Evento.Add(EventoRow); db.SaveChanges(); evento.PK_EVENT = EventoRow.PK_EVENT; return evento; } }