public int Eliminar(BE.Turno beTurno)
{
try
{
string sp = "SpTbTurnoEliminar";
int rowsAffected = 0;
using (SqlConnection cnn = new SqlConnection(ConnectionManager.ConexionLocal))
{
cnn.Open();
SqlCommand cmd = new SqlCommand(sp, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@IDTURNO", beTurno.IdTurno));
rowsAffected = cmd.ExecuteNonQuery();
}
return(rowsAffected);
}
catch (Exception ex)
{
throw ex;
}
}
public List <BE.Turno> Listar()
{
List <BE.Turno> lst = new List <BE.Turno>();
try
{
var daTurno = new DA.Turno();
DataTable dt = daTurno.Listar();
for (int i = 0; i < dt.Rows.Count; i++)
{
var beTurno = new BE.Turno();
DataRow dr = dt.Rows[i];
daTurno.Cargar(ref beTurno, ref dr);
lst.Add(beTurno);
}
return(lst);
}
catch (Exception ex)
{
throw ex;
}
}
public int Actualizar(BE.Turno beTurno)
{
try
{
string sp = "SpTbTurnoActualizar";
int rowsAffected = 0;
using (SqlConnection cnn = new SqlConnection(ConnectionManager.ConexionLocal))
{
cnn.Open();
SqlCommand cmd = new SqlCommand(sp, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@IDTURNO", beTurno.IdTurno));
cmd.Parameters.Add(new SqlParameter("@NUMERO", beTurno.Numero));
cmd.Parameters.Add(new SqlParameter("@HORAINICIAL", beTurno.HoraInicial));
cmd.Parameters.Add(new SqlParameter("@HORAFINAL", beTurno.HoraFinal));
cmd.Parameters.Add(new SqlParameter("@ACTIVO", beTurno.Activo));
rowsAffected = cmd.ExecuteNonQuery();
}
return(rowsAffected);
}
catch (Exception ex)
{
throw ex;
}
}
public void Cargar(ref BE.Turno beTurno, ref DataRow dr)
{
try
{
beTurno.IdTurno = dr["IdTurno"] == DBNull.Value ? 0 : int.Parse(dr["IdTurno"].ToString());
beTurno.Numero = dr["Numero"] == DBNull.Value ? 0 : int.Parse(dr["Numero"].ToString());
beTurno.HoraInicial = dr["HoraInicial"] == DBNull.Value ? "00:00:00" : dr["HoraInicial"].ToString();
beTurno.HoraFinal = dr["HoraFinal"] == DBNull.Value ? "00:00:00" : dr["HoraFinal"].ToString();
beTurno.Activo = dr["Activo"] == DBNull.Value ? false : bool.Parse(dr["Activo"].ToString());
}
catch (Exception ex)
{
throw ex;
}
}
public bool Obtener(ref BE.Turno beTurno)
{
bool exists = false;
try
{
var daTurno = new DA.Turno();
exists = daTurno.Obtener(ref beTurno);
return(exists);
}
catch (Exception ex)
{
throw ex;
}
}
public int Eliminar(BE.Turno beTurno)
{
int rowsAffected = 0;
try
{
var daTurno = new DA.Turno();
rowsAffected = daTurno.Eliminar(beTurno);
return(rowsAffected);
}
catch (Exception ex)
{
throw ex;
}
}
public int Insertar(ref BE.Turno beTurno)
{
int rowsAffected = 0;
try
{
var daTurno = new DA.Turno();
rowsAffected = daTurno.Insertar(ref beTurno);
return(rowsAffected);
}
catch (Exception ex)
{
throw ex;
}
}
public bool Obtener(ref BE.Turno beTurno)
{
bool rpta = false;
try
{
string sp = "SpTbTurnoObtener";
DataTable dt = new DataTable();
using (SqlConnection cnn = new SqlConnection(ConnectionManager.ConexionLocal))
{
cnn.Open();
SqlCommand cmd = new SqlCommand(sp, cnn);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataAdapter dad = new SqlDataAdapter(cmd);
dad.SelectCommand.Parameters.Add(new SqlParameter("@IDTURNO", beTurno.IdTurno));
dad.Fill(dt);
if ((dt.Rows.Count == 1))
{
DataRow dr = dt.Rows[0];
Cargar(ref beTurno, ref dr);
rpta = true;
}
return(rpta);
}
}
catch (Exception ex)
{
throw ex;
}
}