public bool Save(int id, int idArea, string descripcion, string sigla)
{
bool resultado = false;
SubAreaBE obj = new SubAreaBE();
obj.Id = id;
obj.IdArea = idArea;
obj.Descripcion = descripcion;
obj.Sigla = sigla;
SubAreaBL bl = new SubAreaBL();
if (obj.Id == 0)
{
//FALTA: utilizar usuario
obj.UsuarioCreacion = User.Identity.Name;
resultado = bl.Insert(connstring, obj);
}
else
{
//FALTA: utilizar usuario
obj.UsuarioModificacion = User.Identity.Name;
resultado = bl.Update(connstring, obj);
}
return(resultado);
}
public List <SubAreaBE> GetByIdArea(int IdArea)
{
List <SubAreaBE> oLista = new List <SubAreaBE>();
string connectionString = ConfigurationManager.ConnectionStrings["DB_Valua"].ConnectionString;
SqlConnection con = new SqlConnection();
con.ConnectionString = connectionString;
con.Open();
string nombreProcedure = "SubAreaGetByIdArea";
SqlCommand cmd = new SqlCommand(nombreProcedure, con);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter Sp1 = new SqlParameter("@IdArea", IdArea);
cmd.Parameters.Add(Sp1);
using (IDataReader dataReader = cmd.ExecuteReader())
{
while (dataReader.Read())
{
SubAreaBE oSubArea = new SubAreaBE();
oSubArea.Id = Convert.ToInt32(dataReader["IdSubArea"].ToString());
oSubArea.Descripcion = dataReader["Descripcion"].ToString();
oLista.Add(oSubArea);
}
}
return(oLista);
}
public bool Delete(DBHelper pDBHelper, SubAreaBE pSubArea)
{
DBHelper.Parameters[] colParameters = null;
try
{
colParameters = new DBHelper.Parameters[] {
new DBHelper.Parameters("@ID", pSubArea.Id == Constantes.INT_NULO ? (object)DBNull.Value : pSubArea.Id),
new DBHelper.Parameters("@USUARIOMODIFICACION", string.IsNullOrEmpty(pSubArea.UsuarioModificacion) ? (object)DBNull.Value : pSubArea.UsuarioModificacion)
};
pDBHelper.CreateDBParameters(colParameters);
int lfilasAfectadas = pDBHelper.ExecuteNonQuery(pDBHelper.concatOwner("SubAreaDelete"), CommandType.StoredProcedure, Utility.ConnectionState.KeepOpen, ParameterError.notInclude, CleanParameters.preserve);
return(lfilasAfectadas > 0);
}
catch (Exception ex)
{
throw ex;
}
finally
{
colParameters = null;
if (pDBHelper != null && pDBHelper.Command.Transaction == null)
{
pDBHelper.Dispose();
}
}
}
public bool Delete(string connstring, SubAreaBE obj)
{
try
{
DBHelper _oDBHelper = new DBHelper(connstring, Providers.SqlServer);
return(SubAreaDA.Instanse.Delete(_oDBHelper, obj));
}
catch (Exception ex)
{
throw ex;
}
}
public bool Delete(int id)
{
bool resultado = false;
SubAreaBE obj = new SubAreaBE();
obj.Id = id;
SubAreaBL bl = new SubAreaBL();
//FALTA: utilizar usuario
obj.UsuarioModificacion = User.Identity.Name;
resultado = bl.Delete(connstring, obj);
return(resultado);
}
public List <SubAreaBE> GetAll(DBHelper pDBHelper)
{
List <SubAreaBE> lst = null;
SubAreaBE obj = null;
DBHelper.Parameters[] colParameters = null;
lst = new List <SubAreaBE>();
try
{
// Parámetros
colParameters = new DBHelper.Parameters[] {
};
pDBHelper.ClearParameter();
pDBHelper.CreateDBParameters(colParameters);
using (IDataReader dr = pDBHelper.ExecuteReader(pDBHelper.concatOwner("SubAreaGetAll"), CommandType.StoredProcedure, Utility.ConnectionState.CloseOnExit))
{
// Leyendo reader
while (dr.Read())
{
obj = new SubAreaBE();
obj.Id = int.Parse(dr["IdSubArea"].ToString());
obj.Descripcion = dr["Descripcion"].ToString();
obj.Sigla = dr["Sigla"].ToString();
obj.IdArea = int.Parse(dr["IdArea"].ToString());
obj.Area = dr["Area"].ToString();
obj.IdDepartamento = int.Parse(dr["IdDepartamento"].ToString());
obj.Departamento = dr["Departamento"].ToString();
obj.IdEmpresa = int.Parse(dr["IdEmpresa"].ToString());
obj.UsuarioModificacion = dr["UsuarioModificacionConfidencial"].ToString() == "1" ?
ConfigurationManager.AppSettings["UsuarioAdministracion"].ToString() :
dr["UsuarioModificacion"].ToString();
obj.UsuarioCreacion = dr["UsuarioCreacionConfidencial"].ToString() == "1" ?
ConfigurationManager.AppSettings["UsuarioAdministracion"].ToString() :
dr["UsuarioCreacion"].ToString();
if (string.IsNullOrEmpty(dr["FechaCreacion"].ToString()))
{
obj.FechaCreacion = null;
}
else
{
obj.FechaCreacion = DateTime.Parse(dr["FechaCreacion"].ToString());
}
if (string.IsNullOrEmpty(dr["FechaModificacion"].ToString()))
{
obj.FechaModificacion = null;
}
else
{
obj.FechaModificacion = DateTime.Parse(dr["FechaModificacion"].ToString());
}
lst.Add(obj);
}
}
return(lst);
}
catch (Exception ex)
{
throw ex;
}
finally
{
colParameters = null;
if (pDBHelper != null && pDBHelper.Command.Transaction == null)
{
pDBHelper.Dispose();
}
}
}
