public MethodResponseDTO <List <fraseDTO> > ObtenerFrases() { try { var response = new MethodResponseDTO <List <fraseDTO> > { Code = 0 }; using (var context = new BlablablaSitioEntities()) { var DbFrasesLts = context.ctFrases.Where(x => x.estado == true). Select(x => new fraseDTO { Id = x.Id, enun1 = x.enun1, enun2 = x.enun2, correcta = x.correcta, opcion1 = x.opcion1, opcion2 = x.opcion2, opcion3 = x.opcion3 }).ToList(); response.Result = DbFrasesLts; } return(response); } catch (Exception ex) { return(new MethodResponseDTO <List <fraseDTO> > { Code = -100, Message = ex.Message }); } }
public MethodResponseDTO <bool> GuardarFrases(List <fraseDTO> frases) { try { var response = new MethodResponseDTO <bool> { Code = 0 }; using (var context = new BlablablaSitioEntities()) { var DbFrasesLts = context.ctFrases.ToList(); foreach (var objFrase in frases) { var frase = DbFrasesLts.Where(x => x.Id == objFrase.Id).ToList(); if (frase.Count > 0) { var DbFrase = context.ctFrases.Find(objFrase.Id); DbFrase.enun1 = objFrase.enun1; DbFrase.enun2 = objFrase.enun2; DbFrase.correcta = objFrase.correcta; DbFrase.opcion1 = objFrase.opcion1; DbFrase.opcion2 = objFrase.opcion2; DbFrase.opcion3 = objFrase.opcion3; DbFrase.estado = true; context.SaveChanges(); } else { var objCtFrase = new ctFrases { Id = objFrase.Id, enun1 = objFrase.enun1, enun2 = objFrase.enun2, correcta = objFrase.correcta, opcion1 = objFrase.opcion1, opcion2 = objFrase.opcion2, opcion3 = objFrase.opcion3, estado = true }; context.ctFrases.Add(objCtFrase); context.SaveChanges(); } context.SaveChanges(); } } return(response); } catch (Exception ex) { return(new MethodResponseDTO <bool> { Code = -100, Message = ex.Message }); } }
public MethodResponseDTO <bool> BorrarFrase(int idfrase, int tipo) { try { var response = new MethodResponseDTO <bool> { Code = 0 }; using (var context = new BlablablaSitioEntities()) { if (tipo == 1) { var DbFrase = context.ctFrases.Find(idfrase); if (DbFrase != null) { DbFrase.estado = false; context.SaveChanges(); } else { response.Code = -800; response.Message = "La frase que desa borrar no existe."; } } else { var DbFrase = context.ctFrasesSilabitos.Find(idfrase); if (DbFrase != null) { DbFrase.estado = false; context.SaveChanges(); } else { response.Code = -800; response.Message = "La frase que desa borrar no existe."; } } context.SaveChanges(); } return(response); } catch (Exception ex) { return(new MethodResponseDTO <bool> { Code = -100, Message = ex.Message }); } }
public MethodResponseDTO <bool> GuardarFrase(fraseDTO frase) { try { var response = new MethodResponseDTO <bool> { Code = 0 }; using (var context = new BlablablaSitioEntities()) { var DbFrase = context.ctFrases.Find(frase.Id); if (DbFrase != null) { DbFrase.enun1 = frase.enun1; DbFrase.enun2 = frase.enun2; DbFrase.correcta = frase.correcta; DbFrase.opcion1 = frase.opcion1; DbFrase.opcion2 = frase.opcion2; DbFrase.opcion3 = frase.opcion3; DbFrase.estado = true; context.SaveChanges(); } else { var objCtFrase = new ctFrases { Id = frase.Id, enun1 = frase.enun1, enun2 = frase.enun2, correcta = frase.correcta, opcion1 = frase.opcion1, opcion2 = frase.opcion2, opcion3 = frase.opcion3, estado = true }; context.ctFrases.Add(objCtFrase); } context.SaveChanges(); } return(response); } catch (Exception ex) { return(new MethodResponseDTO <bool> { Code = -100, Message = ex.Message }); } }