public bool Actualizar(BE.Comprometido beComprometido)
{
try
{
string sp = "SpTbComprometidoActualizar";
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("@IDCOMPROMETIDO", beComprometido.IdComprometido));
cmd.Parameters.Add(new SqlParameter("@ANHO", beComprometido.Anho));
cmd.Parameters.Add(new SqlParameter("@MES", beComprometido.Mes));
cmd.Parameters.Add(new SqlParameter("@IDSALA", beComprometido.Sala.IdSala));
cmd.Parameters.Add(new SqlParameter("@CODIGOEMPLEADO", beComprometido.CodigoEmpleado));
cmd.Parameters.Add(new SqlParameter("@COMPROMETIDO", beComprometido.Estado));
rowsAffected = cmd.ExecuteNonQuery();
cnn.Close();
}
return(rowsAffected > 0 ? true : false);
}
catch (Exception ex)
{
throw ex;
}
}
private BE.UI.Comprometido BeToUi(BE.Comprometido beComprometido)
{
var uiComprometido = new BE.UI.Comprometido();
uiComprometido.Id = beComprometido.IdComprometido;
uiComprometido.SalaId = beComprometido.Sala.IdSala;
uiComprometido.SalaNombre = beComprometido.Sala.Nombre;
uiComprometido.Anho = beComprometido.Anho;
uiComprometido.Mes = beComprometido.Mes;
uiComprometido.EmpleadoCodigo = beComprometido.CodigoEmpleado;
uiComprometido.EmpleadoNombreCompleto = new LN.Empleado().ObtenerNombreCompleto(beComprometido.CodigoEmpleado);
uiComprometido.Estado = beComprometido.Estado;
return(uiComprometido);
}
private BE.Comprometido UiToBe(BE.UI.Comprometido uiComprometido)
{
var beComprometido = new BE.Comprometido();
beComprometido.IdComprometido = uiComprometido.Id;
beComprometido.Anho = uiComprometido.Anho;
beComprometido.Mes = uiComprometido.Mes;
beComprometido.CodigoEmpleado = uiComprometido.EmpleadoCodigo;
beComprometido.Estado = uiComprometido.Estado;
beComprometido.Sala = new BE.Sala()
{
IdSala = uiComprometido.SalaId,
Nombre = uiComprometido.SalaNombre
};
return(beComprometido);
}
public BE.Comprometido Obtener(int idComprometido)
{
BE.Comprometido beComprometido = null;
try
{
string sp = "SpTbComprometidoObtener";
using (SqlConnection cnn = new SqlConnection(ConnectionManager.ConexionLocal))
{
cnn.Open();
SqlCommand cmd = new SqlCommand(sp, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@IDCOMPROMETIDO", idComprometido));
SqlDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
beComprometido = new BE.Comprometido();
beComprometido.IdComprometido = reader["IdComprometido"] == DBNull.Value ? 0 : int.Parse(reader["IdComprometido"].ToString());
beComprometido.Anho = reader["Anho"] == DBNull.Value ? 0 : int.Parse(reader["Anho"].ToString());
beComprometido.Mes = reader["Mes"] == DBNull.Value ? 0 : int.Parse(reader["Mes"].ToString());
beComprometido.CodigoEmpleado = reader["CodigoEmpleado"] == DBNull.Value ? "" : reader["CodigoEmpleado"].ToString();
beComprometido.Estado = reader["Comprometido"] == DBNull.Value ? false : bool.Parse(reader["Comprometido"].ToString());
beComprometido.Sala = new BE.Sala()
{
IdSala = reader["IdSala"] == DBNull.Value ? 0 : int.Parse(reader["IdSala"].ToString())
};
}
}
return(beComprometido);
}
catch (Exception ex)
{
throw ex;
}
}
public List <BE.Comprometido> Listar(int anho, int mes,
int?idSala = null, string codigoEmpleado = null)
{
var lstComprometido = new List <BE.Comprometido>();
try
{
string sp = "SpTbComprometidoListar";
using (SqlConnection cnn = new SqlConnection(ConnectionManager.ConexionLocal))
{
cnn.Open();
SqlCommand cmd = new SqlCommand(sp, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@ANHO", anho));
cmd.Parameters.Add(new SqlParameter("@MES", mes));
if (idSala == null || idSala == 0)
{
cmd.Parameters.Add(new SqlParameter("@IDSALA", DBNull.Value));
}
else
{
cmd.Parameters.Add(new SqlParameter("@IDSALA", (int)idSala));
}
if (codigoEmpleado == null || codigoEmpleado.Length == 0)
{
cmd.Parameters.Add(new SqlParameter("@CODIGOEMPLEADO", DBNull.Value));
}
else
{
cmd.Parameters.Add(new SqlParameter("@CODIGOEMPLEADO", codigoEmpleado));
}
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
var beComprometido = new BE.Comprometido();
beComprometido.IdComprometido = reader["IdComprometido"] == DBNull.Value ? 0 : int.Parse(reader["IdComprometido"].ToString());
beComprometido.Anho = reader["Anho"] == DBNull.Value ? 0 : int.Parse(reader["Anho"].ToString());
beComprometido.Mes = reader["Mes"] == DBNull.Value ? 0 : int.Parse(reader["Mes"].ToString());
beComprometido.CodigoEmpleado = reader["CodigoEmpleado"] == DBNull.Value ? "" : reader["CodigoEmpleado"].ToString();
beComprometido.Estado = reader["Comprometido"] == DBNull.Value ? false : bool.Parse(reader["Comprometido"].ToString());
beComprometido.Sala = new BE.Sala()
{
IdSala = reader["IdSala"] == DBNull.Value ? 0 : int.Parse(reader["IdSala"].ToString())
};
lstComprometido.Add(beComprometido);
}
}
return(lstComprometido);
}
catch (Exception ex)
{
throw ex;
}
}
