public static bool Updates(tipoBeca p) { using (Entities db = new Entities()) { using (var transaction = db.Database.BeginTransaction()) { try { tipoBeca prm = new tipoBeca(); var order = db.tipoBecas.AsNoTracking().Where(s => s.idTipoBecas == p.idTipoBecas).FirstOrDefault(); prm.idTipoBecas = order.idTipoBecas; prm.nombre = p.nombre; prm.porcentaje_matricula = p.porcentaje_matricula; prm.requisitos_especificos = p.requisitos_especificos; prm.tipo_calificacion_necesaria = p.tipo_calificacion_necesaria; prm.documentos_respaldo = p.documentos_respaldo; db.Entry(prm).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); transaction.Commit(); return(true); } catch (Exception ex) { transaction.Rollback(); return(false); } } } }
public IHttpActionResult Put(tipoBeca tipoBeca) { try { TipoBecaBLL.Update(tipoBeca); return(Content(HttpStatusCode.Accepted, "Tipo de Beca actualizada correctamente")); } catch (Exception ex) { return(BadRequest(ex.Message)); } }
public IHttpActionResult Get(int id) { try { tipoBeca result = TipoBecaBLL.Get(id); if (result == null) { return(NotFound()); } return(Content(HttpStatusCode.OK, result)); } catch (Exception ex) { return(Content(HttpStatusCode.BadRequest, ex)); } }
public static void Create(tipoBeca tb) { using (Entities db = new Entities()) { using (var transaction = db.Database.BeginTransaction()) { try { db.tipoBecas.Add(tb); db.SaveChanges(); transaction.Commit(); } catch (Exception ex) { transaction.Rollback(); throw ex; } } } }
public static void Delete(int?id) { using (Entities db = new Entities()) { using (var transaction = db.Database.BeginTransaction()) { try { tipoBeca tipoBeca = db.tipoBecas.Find(id); db.Entry(tipoBeca).State = System.Data.Entity.EntityState.Deleted; db.SaveChanges(); transaction.Commit(); } catch (Exception ex) { transaction.Rollback(); throw ex; } } } }
public static void Update(tipoBeca tipoBeca) { using (Entities db = new Entities()) { using (var transaction = db.Database.BeginTransaction()) { try { db.tipoBecas.Attach(tipoBeca); db.Entry(tipoBeca).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); transaction.Commit(); } catch (Exception ex) { transaction.Rollback(); throw ex; } } } }