public int CambiarPassword(string Password, string NewPassword, int UsuarioId) { int usu = 0; using (var context = new VeterinariaBDContext()) { using (var transaction = context.Database.BeginTransaction()) { try { usu = context.Database.ExecuteSqlCommand( "UPDATE Usuario set Password = '******' WHERE Password = @Password AND UsuarioId = @UsuarioId", new SqlParameter("Password", Password), new SqlParameter("UsuarioId", UsuarioId) ); context.Configuration.ValidateOnSaveEnabled = false; context.SaveChanges(); transaction.Commit(); } catch (Exception e) { transaction.Rollback(); throw new Exception(e.Message); } } } return(usu); }
/* * Eliminar 0 -- Eliminado * Restaurar 1 -- Activo */ public int CambiarEstado(int estado, int UsuarioId) { int usu = 0; using (var context = new VeterinariaBDContext()) { using (var transaction = context.Database.BeginTransaction()) { try { usu = context.Database.ExecuteSqlCommand( "UPDATE Usuario set Estado = " + estado + " WHERE UsuarioId = @UsuarioId", new SqlParameter("UsuarioId", UsuarioId) ); context.Configuration.ValidateOnSaveEnabled = false; context.SaveChanges(); transaction.Commit(); } catch (Exception e) { transaction.Rollback(); throw new Exception(e.Message); } } } return(usu); }
public void CrudEspecie() { using (var context = new VeterinariaBDContext()) { using (var transaction = context.Database.BeginTransaction()) { try { if (this.EspecieId == 0) { context.Entry(this).State = EntityState.Added; } else { context.Entry(this).State = EntityState.Modified; } context.SaveChanges(); transaction.Commit(); } catch (Exception e) { transaction.Rollback(); new Exception(e.Message); } } } }
public void CrudCliente() { using (var context = new VeterinariaBDContext()) { using (var transaction = context.Database.BeginTransaction()) { try { StringBuilder name = new StringBuilder(); name.Append(this.Nombre); name.Append(" "); name.Append(this.Apellido); if (this.ClienteId == 0) { context.Entry(this).Entity.Estado = 1;//Activo = 1, De Baja = 0 context.Entry(this).Entity.NombreCompleto = name.ToString(); context.Entry(this).State = EntityState.Added; } else { context.Entry(this).Entity.NombreCompleto = name.ToString(); context.Entry(this).State = EntityState.Modified; } context.SaveChanges(); transaction.Commit(); } catch (Exception e) { transaction.Rollback(); new Exception(e.Message); } } } }
public int CambiarEstado(int ConsultaId, int estado) { int c = 0; using (var context = new VeterinariaBDContext()) { using (var transaction = context.Database.BeginTransaction()) { try { c = context.Database.ExecuteSqlCommand( "UPDATE Consulta set Estado = " + estado + " WHERE ConsultaId = @ConsultaId", new SqlParameter("ConsultaId", ConsultaId) ); context.Configuration.ValidateOnSaveEnabled = false; context.SaveChanges(); transaction.Commit(); } catch (Exception e) { transaction.Rollback(); Message = e.Message; } } } return(c); }
/* * public List<Diagnostico> GetAllDiagnosticos() * { * using (var context = new VeterinariaBDContext()) * { * try * { * var data = (from d in context.Diagnostico * join c in context.Consulta on d.ConsultaId equals c.ConsultaId * join u in context.Usuario on d.VeterinarioId equals u.UsuarioId * join cli in context.Cliente on c.ClienteId equals cli.ClienteId * join m in context.Mascota on c.MascotaId equals m.MascotaId * select new { * Cliente = cli.Nombre+' '+cli.Apellido, * Veterinario = u.Nombre+' '+u.Apellido, * FechaDiagnostico = d.FechaDiagnostico, * DiagnosticoId = d.DiagnosticoId * }); * * } * catch (Exception) * { * throw; * } * } * * return data; * } */ public void registrarDiagnostico(int VeterinarioId, int ConsultaId) { using (var context = new VeterinariaBDContext()) { using (var transaction = context.Database.BeginTransaction()) { try { context.Entry(this).Entity.FechaDiagnostico = DateTime.Now; context.Entry(this).Entity.VeterinarioId = VeterinarioId; context.Entry(this).Entity.ConsultaId = ConsultaId; context.Entry(this).State = EntityState.Added; /* * foreach (var r in this.Receta) * context.Entry(r).State = EntityState.Unchanged; */ context.Database.ExecuteSqlCommand( "UPDATE Consulta set Estado = 2 WHERE ConsultaId = @ConsultaId", new SqlParameter("ConsultaId", ConsultaId) ); transaction.Commit(); context.SaveChanges(); } catch (Exception) { transaction.Rollback(); throw; } } } }
public void CrudMascota() { using (var context = new VeterinariaBDContext()) { using (var transaction = context.Database.BeginTransaction()) { try { if (this.MascotaId == 0) { context.Entry(this).Entity.Estado = 1;//Vivo = 1, Fallecido = 0, Enfermo = 2 context.Entry(this).State = EntityState.Added; } else { context.Entry(this).State = EntityState.Modified; } context.SaveChanges(); transaction.Commit(); Message = "Registro guardado"; } catch (Exception e) { transaction.Rollback(); Message = e.Message; } } } }
public int CrudConsulta(int id) { int crud = 0; using (var context = new VeterinariaBDContext()) { using (var transaction = context.Database.BeginTransaction()) { try { if (this.ConsultaId == 0) { context.Entry(this).Entity.CajeroId = id; context.Entry(this).Entity.Estado = 1;//Por atender = 1, Anulada = 0, Atendida = 2 context.Entry(this).Entity.FechaRegistro = DateTime.Now; context.Entry(this).State = EntityState.Added; crud = 1; } else { context.Configuration.AutoDetectChangesEnabled = false; context.Configuration.ValidateOnSaveEnabled = false; context.Entry(this).State = EntityState.Modified; context.Entry(this).Property(x => x.CajeroId).IsModified = false; context.Entry(this).Property(x => x.Estado).IsModified = false; context.Entry(this).Property(x => x.FechaRegistro).IsModified = false; crud = 2; } context.SaveChanges(); transaction.Commit(); } catch (Exception e) { transaction.Rollback(); Message = e.Message; } } } return(crud); }
public void CrudUsuario() { using (var context = new VeterinariaBDContext()) { using (var transaction = context.Database.BeginTransaction()) { try { if (this.UsuarioId == 0) { context.Entry(this).Entity.Estado = 1; //Activo = 1, Eliminado = 0 context.Entry(this).Entity.Password = "******"; //Clave por defecto -- Luego el usuario puede modificarlo context.Entry(this).State = EntityState.Added; } else { context.Configuration.AutoDetectChangesEnabled = false; context.Configuration.ValidateOnSaveEnabled = false; context.Entry(this).State = EntityState.Modified; context.Entry(this).Property(x => x.Password).IsModified = false; context.Entry(this).Property(x => x.Estado).IsModified = false; } context.SaveChanges(); transaction.Commit(); } catch (Exception e) { transaction.Rollback(); throw new Exception(e.Message); } } } }