public ActionResult Edit([Bind(Include = "idmatricula,nombre,nrc,creditos,idarea")] matricula matricula)
{
if (ModelState.IsValid)
{
MatriculaBLL.Update(matricula);
return(RedirectToAction("Index"));
}
ViewBag.idarea = new SelectList(AreaBLL.List(), "idarea", "nombre", matricula.idalumno);
return(View(matricula));
}
/*
* Metodo para actualizar una nota
*/
public async Task <bool> NotasUpdate(matricula notas)
{
var db = dbConnection();
var sql = @"UPDATE matricula SET nota1 = @nota1,
nota2 = @nota2,
nota3 = @nota3
WHERE idMatricula = @idMatricula";
var result = await db.ExecuteAsync(sql.ToString(), new { notas.nota1, notas.nota2, notas.nota3, notas.idMatricula });
return(result > 0);
}
public IHttpActionResult Post(matricula matricula)
{
try
{
MatriculaBLL.Create(matricula);
return(Content(HttpStatusCode.Created, "Alumno creado correctamente"));
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
// GET: matriculas/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
matricula matricula = MatriculaBLL.Get(id);
if (matricula == null)
{
return(HttpNotFound());
}
return(View(matricula));
}
// GET: matriculas/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
matricula matricula = MatriculaBLL.Get(id);
if (matricula == null)
{
return(HttpNotFound());
}
ViewBag.idarea = new SelectList(AreaBLL.List(), "idarea", "nombre", matricula.idalumno);
return(View(matricula));
}
private static void Config(matricula a, materia mt)
{
a.fecha = DateTime.Now;
a.estado = "1"; //Creada
if (a.tipo.Equals("P"))
{
a.costo = 0;
}
else if (a.tipo.Equals("S"))
{
a.costo = (decimal)(12.25 * mt.creditos);
}
else
{
a.costo = (decimal)(24.50 * mt.creditos);
}
}
/*
* Insertar una nota
*/
public async Task <bool> NotasInsert(matricula notas)
{
using (var conn = new SqlConnection(_configuration.Value))
{
var parameters = new DynamicParameters();
parameters.Add("idEstudiante", notas.idEstudiante, DbType.Int32);
parameters.Add("nota1", notas.nota1, DbType.Int32);
parameters.Add("nota1", notas.nota1, DbType.Int32);
parameters.Add("nota2", notas.nota2, DbType.Int32);
parameters.Add("nota3", notas.nota3, DbType.Int32);
const string query = @"INSERT INTO matricula (idMatricula, nota1, nota2, nota3)
VALUES ( @idMatricula, @nota1, @nota2, @nota3)";
await conn.ExecuteAsync(query, new {},
commandType : CommandType.Text);
}
return(true);
}
public static void Delete(int?id)
{
using (Entities db = new Entities())
{
using (var transaction = db.Database.BeginTransaction())
{
try
{
matricula matricula = db.matriculas.Find(id);
db.Entry(matricula).State = System.Data.Entity.EntityState.Deleted;
db.SaveChanges();
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
throw ex;
}
}
}
}
public static void Create(matricula a)
{
using (Entities db = new Entities())
{
using (var transaction = db.Database.BeginTransaction())
{
try
{
materia mt = db.materias.Find(a.idmateria);
Config(a, mt);
db.matriculas.Add(a);
db.SaveChanges();
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
throw ex;
}
}
}
}
public static void Update(matricula matricula)
{
using (Entities db = new Entities())
{
using (var transaction = db.Database.BeginTransaction())
{
try
{
materia mt = db.materias.Find(matricula.idmateria);
Config(matricula, mt);
db.matriculas.Attach(matricula);
db.Entry(matricula).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
throw ex;
}
}
}
}
