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);
}
}
}
}