}//DELETE public MateriaModel GetMateriaId(int idMateria) { try { string Query = "GetMateriasById"; SqlCommand cmd = new SqlCommand(Query, conn); SqlDataAdapter adapter = new SqlDataAdapter(cmd); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@idMateria", idMateria); DataSet dsMateria = new DataSet(); adapter.Fill(dsMateria); if (dsMateria.Tables[0].Rows.Count > 0) { DataRow dr = dsMateria.Tables[0].Rows[0]; MateriaModel Materia = new MateriaModel(dr); return(Materia); } else { MateriaModel Materia = new MateriaModel(); return(Materia); } } catch (Exception) { throw; } }//GET MATERIA BY ID
public bool DeleteMateria(MateriaModel materia) { var menu = new MenuService(); var optionMenu = new OptionMenuService(); try { using (var context = new UniversidadeContext()) { var materiaDB = context.Materias.Where(w => w.MateriaDesc == materia.MateriaDesc).SingleOrDefault(); if (materiaDB != null) { context.Remove(materiaDB); context.SaveChanges(); return(true); } else { return(false); } } } catch (Exception) { throw; } }
public virtual void Insertar(MateriaModel model, HttpContextBase context) { Dictionary <string, object> parameters = new Dictionary <string, object>(); parameters.Add("@nombre", model.Nombre); try { MateriaModel dup = this.ObtenerMaterias(new QueryExpresion($"lcase({SqlUtil.SurroundColumn("Nombre")}) = @nombre"), new Dictionary <string, object>() { { "@nombre", model.Nombre.ToLower() } }, context)?.FirstOrDefault(); //buscar por duplicados if (dup != null) { throw new Exception(string.Format(CatalogoRes.MateriaYaExisteFmt, dup.Nombre)); } DataConnection.Instance.ExecuteNonQuery(SqlResource.SqlMateriasInsert, parameters, context); ulong id = (ulong)DataConnection.Instance.ExecuteScalar(SqlResource.SqlLastInsertedId, default(Dictionary <string, object>), context, transaction: null); model.ID = (long)id; this.RemoveValueIfExists(this.GetOrCreateKey(context), nameof(ObtenerMaterias)); } catch (Exception ex) { throw ex; } }
private void listarMaterias() { MateriaModel materiaModel = new MateriaModel(); this.dgv_BuscarMateria.DataSource = materiaModel.listarMaterias(); this.cmb_Materia.DataSource = materiaModel.listarMaterias(); this.cmb_Materia.DisplayMember = "nombre"; this.cmb_Materia.ValueMember = "codigo"; }
public ActionResult EditarMateria(int id) { MateriaModel model = new MateriaModel(); using (CursoEntities db = new CursoEntities()) { var emateria = db.MateriasTs.Find(id); model.nombre_materia = emateria.nombre_materia; model.id_materia = emateria.id_materia; } return(View(model)); }
protected virtual List <MateriaModel> LlenarMateriasDelCatalogo(IDataReader reader, long catalogo_id) { List <MateriaModel> result = new List <MateriaModel>(); while (reader.Read()) { MateriaModel nc = new MateriaModel(); nc.Fill(reader); result.Add(nc); } return(result); }
protected virtual List <MateriaModel> LlenarModelos(IDataReader reader) { List <MateriaModel> result = new List <MateriaModel>(); while (reader.Read()) { MateriaModel nc = new MateriaModel(); nc.Fill(reader); result.Add(nc); } return(result); }
public ActionResult Editar(int id, MateriaModel collection) { try { this.materiaLogic.Save(this.MateriaToBusiness(collection, Business.Entities.BusinessEntity.States.Modified)); return(RedirectToAction("Index")); } catch (Exception ex) { return(View()); } }
public ActionResult Nuevo(MateriaModel collection) { try { this.materiaLogic.Save(this.MateriaToBusiness(collection, Business.Entities.BusinessEntity.States.New)); return(RedirectToAction("Index")); } catch { return(View()); } }
public void AtualizaMateria(MateriaModel MateriaModelo) { foreach (MateriaModel Materia in listaMaterias) { if (Materia.NumeroMateria == MateriaModelo.NumeroMateria) { listaMaterias.Remove(Materia); listaMaterias.Add(MateriaModelo); break; } } }
public void TestDeleteMateriaERROR() { var materiaRepository = new MateriaRepository(); var materiaModel = new MateriaModel() { MateriaDesc = "Matemática", MateriaDataCad = DateTime.Parse("10/10/2000"), materiaSitacao = "A" }; Assert.AreEqual(materiaRepository.DeleteMateria(materiaModel), false); }
public ActionResult UpdateMateria(MateriaModel m) { try { materias.UpdateMateria(m.IdMateria, m.Nombre, m.Costo); } catch (Exception) { throw; } return(Content("1")); }
public Business.Entities.Materia MateriaToBusiness(MateriaModel model, Business.Entities.BusinessEntity.States estado) { Business.Entities.Materia materia = new Business.Entities.Materia(); materia.Descripcion = model.Descripcion; materia.HSSemanales = model.HSSemanales; materia.HSTotales = model.HSTotales; materia.IDPlan = model.IDPlan; materia.State = estado; if (estado == Business.Entities.BusinessEntity.States.Modified) { materia.ID = model.ID; } return(materia); }
public ActionResult EditaMateria(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } MateriaModel materiaAtt = materia.listaMaterias.Where(x => x.NumeroMateria == id).FirstOrDefault(); if (materiaAtt == null) { return(HttpNotFound()); } return(View(materiaAtt)); }
public MateriaModel GetMateria(int NumeroMateria) { MateriaModel _MateriaModel = null; foreach (MateriaModel _Materia in listaMaterias) { if (_Materia.NumeroMateria == NumeroMateria) { _MateriaModel = _Materia; } } return(_MateriaModel); }
public ActionResult EditaMateria(MateriaModel model) { if (ModelState.IsValid) { var materiaAtt = materia.listaMaterias.Where(x => x.NumeroMateria == model.NumeroMateria).FirstOrDefault(); if (materiaAtt == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } materiaAtt.NomeMateria = model.NomeMateria; materiaAtt.NumeroMateria = model.NumeroMateria; return(RedirectToAction("Index")); } return(View(model)); }
public IHttpActionResult Post(MateriaModel materia) { try { if (!ModelState.IsValid) { return(BadRequest()); } _materiaRules.Insert(_mapper.Map <Materia>(materia)); return(Ok(materia)); } catch (Exception ex) { return(InternalServerError(ex)); } }
private SelectList obtenListadoMaterias(HORARIO hAux) { SelectList listado; List <MateriaModel> listaMaterias = new List <MateriaModel>(); foreach (MATERIA mAux in db.MATERIA) { MateriaModel mat = new MateriaModel(); mat.idMateria = Convert.ToInt32(mAux.ID_MATERIA); mat.displayText = mAux.NOMBRE; listaMaterias.Add(mat); } listado = new SelectList(listaMaterias, "idMateria", "displayText", hAux.ID_MATERIA); return(listado); }
public ActionResult Edit(int id) { MateriaModel model = materias.GetMateriaId(id); try { var materia = materias.GetMateriaId(id); model.IdMateria = materia.IdMateria; model.Nombre = materia.Nombre; } catch (Exception) { throw; } return(View(model)); }
public EditarViewModel(int a) //para materias { _mat = new MateriaModel(); this.a = a; if (a == 1) { _visible = true; _texto = "ingrese parametro de entrada"; } else { _texto = "ingrese la materia a eliminar"; _visible = false; } GuardarElementoCommand = new Command(GuardarElemento); EliminarElementoCommand = new Command(EliminarElemento); }
public ActionResult SaveMateria(MateriaModel m) { MateriaModel mat = new MateriaModel(); try { mat.Nombre = m.Nombre; mat.Costo = m.Costo; materias.InsertMateria(mat.Nombre, mat.Costo); } catch (Exception) { throw; } return(Content("1")); }
public void TestDeleteNotaOK() { var notaRepository = new NotaRepository(); var alunoRepository = new AlunoRepository(); var materiaRepository = new MateriaRepository(); var alunoModel = new AlunoModel() { AlunoCPF = 99689899082, AlunoNome = "Logan", AlunoSobrenome = "Da Silva", AlunoCurso = "Geografia", AlunoNascimento = Convert.ToDateTime("10/02/1998"), }; alunoRepository.CreateAluno(alunoModel); alunoRepository.VerificaCPFAluno(alunoModel.AlunoCPF.ToString(), out int?idAluno); var materiaModel = new MateriaModel() { MateriaDesc = "Matemática", MateriaDataCad = DateTime.Parse("10/10/2000"), materiaSitacao = "A" }; materiaRepository.CreateMateria(materiaModel); materiaRepository.VerificaMateriaCadastrada(materiaModel.MateriaDesc, out int?idMateria); var notaModel = new NotasAlunoModel() { AlunoID = Convert.ToInt32(idAluno), MateriaID = Convert.ToInt32(idMateria), notaMateria = 100 }; notaRepository.SalvaNotaMateriaAluno(notaModel); Assert.AreEqual(notaRepository.DeletaNotaMateriaAluno(notaModel), true); notaRepository.DeletaNotaMateriaAluno(notaModel); alunoRepository.DeleteAluno(alunoModel); materiaRepository.DeleteMateria(materiaModel); }
private void txt_BuscarMateria_TextChanged(object sender, EventArgs e) { MateriaModel materiaModel = new MateriaModel(); try { if (this.chk_LuAlu.Checked == true && this.chk_NombreAlu.Checked == false) { dgv_Alumnos.DataSource = materiaModel.filtrarMaterias("XCodigo", txt_BuscarAlumno.Text); } if (this.chk_NombreAlu.Checked == true && this.chk_LuAlu.Checked == false) { dgv_Alumnos.DataSource = materiaModel.filtrarMaterias("XNombre", txt_BuscarAlumno.Text); } } catch (Exception ex) { MessageBox.Show("Error cuando Filtras" + ex.Message, "Atencion", MessageBoxButtons.OK, MessageBoxIcon.Warning); throw; } }
public ActionResult NuevaMateria(MateriaModel model) { try { if (ModelState.IsValid) { using (CursoEntities db = new CursoEntities()) { var materia = new MateriasT(); materia.nombre_materia = model.nombre_materia; db.MateriasTs.Add(materia); db.SaveChanges(); } return(Redirect("Materia/")); } return(View(model)); } catch (Exception ex) { throw new Exception(ex.Message); } }
public ActionResult EditarMateria(MateriaModel model) { try { if (ModelState.IsValid) { using (CursoEntities db = new CursoEntities()) { var emateria = db.MateriasTs.Find(model.id_materia); emateria.nombre_materia = model.nombre_materia; db.Entry(emateria).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } return(Redirect("/")); } return(View(model)); } catch (Exception ex) { throw new Exception(ex.Message); } }
public ActionResult AdicionaMateria(MateriaModel _MateriaModel) { materia.CriaMateria(_MateriaModel); TempData["ListaMaterias"] = materia.listaMaterias; return(View()); }
public ActionResult NewMateria(MateriaModel m) { return(View()); }
protected virtual List <T> FillCatalogoListExcel <T>(IDataReader reader, SeriesDataService serieDs, IEnumerable <SerieModel> seriesList, MateriasDataService materiaDs, IEnumerable <MateriaModel> materiasList, bool limitarStrings, HttpContextBase context) where T : CatalogoModel, new() { List <T> result = new List <T>(); long count = 0; while (reader.Read()) { T nc = new T(); //--------------------------\\ nc.Contenido = Convert.IsDBNull(reader["Contenido"]) ? null : reader["Contenido"].ToString(); nc.Año = Convert.IsDBNull(reader["Año"]) ? (short?)null : Convert.ToInt16(reader["Año"]); //Año nc.Fecha = Convert.IsDBNull(reader["Fecha"]) ? (DateTime?)null : (DateTime)reader["Fecha"]; nc.Folio = Convert.IsDBNull(reader["Folio"]) ? null : reader["Folio"].ToString(); if (seriesList.Count() > 0) { SerieModel serie = seriesList.FirstOrDefault(sm => sm.Nombre.Trim().Equals(reader["Series"].ToString().Trim())); if (serie == null) { serie = new SerieModel() { Nombre = reader["Series"].ToString() }; serieDs.Insertar(serie, context); } nc.IdSerie = serie?.ID; nc.SeriesNombre = serie?.Nombre; } if (materiasList.Count() > 0) { string materiaExt = Convert.IsDBNull(reader["Materias"]) ? null : reader["Materias"].ToString(); if (!string.IsNullOrEmpty(materiaExt)) { nc.ListaMaterias = new List <MateriaModel>(); string[] valoresSeparados = null; if (materiaExt.Contains(" / ")) { valoresSeparados = materiaExt.Split(new string[] { " / " }, StringSplitOptions.RemoveEmptyEntries); } else { valoresSeparados = new string[] { materiaExt }; } foreach (string item in valoresSeparados) { MateriaModel materia = materiasList.FirstOrDefault(m => m.Nombre.Trim().Equals(item.Trim())); if (materia == null) { materia = new MateriaModel() { Nombre = item }; materiaDs.Insertar(materia, context); } nc.ListaMaterias.Add(materia); } } } nc.Libro = Convert.IsDBNull(reader["Libro"]) ? (int?)null : Convert.ToInt32(reader["Libro"]); nc.Lugar = Convert.IsDBNull(reader["Lugar"]) ? null : reader["Lugar"].ToString(); nc.NumCaja = Convert.IsDBNull(reader["Caja"]) ? null : reader["Caja"].ToString(); nc.NumCarpeta = Convert.IsDBNull(reader["Carpeta"]) ? (int?)null : Convert.ToInt32(reader["Carpeta"]); nc.NumExpediente = Convert.IsDBNull(reader["Expediente"]) ? null : reader["Expediente"].ToString(); nc.NumTomo = Convert.IsDBNull(reader["Tomo"]) ? (int?)null : Convert.ToInt32(reader["Tomo"]); nc.Observaciones = Convert.IsDBNull(reader["Observaciones"]) ? null : reader["Observaciones"].ToString(); //nc.Materias = Convert.IsDBNull(reader["Materias"]) ? null : reader["Materias"].ToString(); nc.Origen = 1; nc.ID = count++; //--------------------------\\ result.Add(nc); } return(result); }
public void CriaMateria(MateriaModel MateriaModelo) { listaMaterias.Add(MateriaModelo); }
private void listarMaterias() { MateriaModel materiaModel = new MateriaModel(); this.dgv_Materias.DataSource = materiaModel.listarMaterias(); }