/// <summary>
/// Creado: Metodo para Consultar SubCategorias de Producto
/// </summary>
/// <param name="sid_ProductCategory"></param>
/// <param name="sName_Subcategory"></param>
/// <returns>dt</returns>
public DataTable ConsultarSubCategoria(string sid_ProductCategory, string sName_Subcategory)
{
oConn = new Conexion(1);
DataTable dt = oConn.ejecutarDataTable("UP_WEBXPLORA_AD_CONSULTASUBCATEGORIA", sid_ProductCategory, sName_Subcategory);
ESubCategoria oeSubCategoria = new ESubCategoria();
if (dt != null)
{
if (dt.Rows.Count > 0)
{
for (int i = 0; i <= dt.Rows.Count - 1; i++)
{
oeSubCategoria.id_Subcategory = Convert.ToInt64(dt.Rows[i]["id_Subcategory"].ToString().Trim());
oeSubCategoria.id_ProductCategory = dt.Rows[i]["id_ProductCategory"].ToString().Trim();
oeSubCategoria.Name_Subcategory = dt.Rows[i]["Name_Subcategory"].ToString().Trim();
oeSubCategoria.Subcategory_Status = Convert.ToBoolean(dt.Rows[i]["Subcategory_Status"].ToString().Trim());
oeSubCategoria.Subcategory_CreateBy = dt.Rows[i]["Subcategory_CreateBy"].ToString().Trim();
oeSubCategoria.Subcategory_DateBy = Convert.ToDateTime(dt.Rows[i]["Subcategory_DateBy"].ToString().Trim());
oeSubCategoria.Subcategory_ModiBy = dt.Rows[i]["Subcategory_ModiBy"].ToString().Trim();
oeSubCategoria.Subcategory_DateModiBy = Convert.ToDateTime(dt.Rows[i]["Subcategory_DateModiBy"].ToString().Trim());
}
}
oConn = null;
return(dt);
}
else
{
oConn = null;
return(null);
}
}
public bool Agregar(ESubCategoria obj)
{
SQLParameter[] parameters = new SQLParameter[2];
parameters[0] = new SQLParameter("@Categoria", obj.Categoria, SqlDbType.Int);
parameters[1] = new SQLParameter("@Nombre", obj.Nombre, SqlDbType.VarChar);
Response = Conexion.ExecuteProcedureB("USP_I_AgregarSubCategoria", parameters);
return(Response);
}
//----Metodo que permite Actualizar Subcategorias de producto
public ESubCategoria Actualizar_SubCategoria(long lid_Subcategory, string sid_ProductCategory, string sName_Subcategory, bool bSubcategory_Status,
string sSubcategory_ModiBy, DateTime tSubcategory_DateModiBy)
{
DSubCategoria odaSubCategoria = new DSubCategoria();
ESubCategoria oeaSubCategoria = odaSubCategoria.Actualizar_SubCategoria(lid_Subcategory, sid_ProductCategory, sName_Subcategory, bSubcategory_Status,
sSubcategory_ModiBy, tSubcategory_DateModiBy);
odaSubCategoria = null;
return(oeaSubCategoria);
}
//---Metodo de Consulta de SubCategorias de producto
public DataTable ConsultarSubCategoria(string sid_ProductCategory, string sName_Subcategory)
{
DSubCategoria odsSubCategoria = new DSubCategoria();
ESubCategoria oeSubCategoria = new ESubCategoria();
DataTable dtSubCategoria = odsSubCategoria.ConsultarSubCategoria(sid_ProductCategory, sName_Subcategory);
odsSubCategoria = null;
return(dtSubCategoria);
}
//----Metodo que permite registrar SubCategorias de producto
public ESubCategoria RegistrarSubCategoria(string sid_ProductCategory, string sName_Subcategory, bool bSubcategory_Status,
string sSubcategory_CreateBy, DateTime tSubcategory_DateBy, string sSubcategory_ModiBy, DateTime tSubcategory_DateModiBy)
{
DSubCategoria odrSubCategoria = new DSubCategoria();
ESubCategoria oeSubCategoria = odrSubCategoria.RegistrarSubCategoria(sid_ProductCategory, sName_Subcategory, bSubcategory_Status,
sSubcategory_CreateBy, tSubcategory_DateBy, sSubcategory_ModiBy, tSubcategory_DateModiBy);
odrSubCategoria = null;
return(oeSubCategoria);
}
/// <summary>
/// Creado: Metodo para Actualizar SubCategorias de Producto
/// </summary>
/// <param name="lid_Subcategory"></param>
/// <param name="sid_ProductCategory"></param>
/// <param name="sName_Subcategory"></param>
/// <param name="bSubcategory_Status"></param>
/// <param name="sSubcategory_ModiBy"></param>
/// <param name="tSubcategory_DateModiBy"></param>
/// <returns>oeaSubCategoria</returns>
public ESubCategoria Actualizar_SubCategoria(long lid_Subcategory, string sid_ProductCategory, string sName_Subcategory, bool bSubcategory_Status,
string sSubcategory_ModiBy, DateTime tSubcategory_DateModiBy)
{
oConn = new Conexion(1);
DataTable dt = oConn.ejecutarDataTable("UP_WEBXPLORA_AD_ACTUALIZARSUBCATEGORIA", lid_Subcategory, sid_ProductCategory, sName_Subcategory, bSubcategory_Status,
sSubcategory_ModiBy, tSubcategory_DateModiBy);
oConn = null;
ESubCategoria oeaSubCategoria = new ESubCategoria();
oeaSubCategoria.id_ProductCategory = sid_ProductCategory;
oeaSubCategoria.Name_Subcategory = sName_Subcategory;
oeaSubCategoria.Subcategory_Status = bSubcategory_Status;
oeaSubCategoria.Subcategory_ModiBy = sSubcategory_ModiBy;
oeaSubCategoria.Subcategory_DateModiBy = tSubcategory_DateModiBy;
return(oeaSubCategoria);
}
public List <ESubCategoria> Listar()
{
List <ESubCategoria> List = new List <ESubCategoria>();
DataTable data = new DataTable();
data = Conexion.ExecuteProcedureD("USP_S_ListarSubCategoria").Tables[0];
foreach (DataRow row in data.Rows)
{
ESubCategoria be = new ESubCategoria
{
ID = Convert.ToInt32(row[0]),
Categoria = Convert.ToInt32(row[1]),
Nombre = row[2].ToString()
};
List.Add(be);
}
return(List);
}
/// <summary>
/// Creado: Metodo para Registrar SubCategorias de Producto
/// </summary>
/// <param name="lid_Subcategory"></param>
/// <param name="sid_ProductCategory"></param>
/// <param name="sName_Subcategory"></param>
/// <param name="bSubcategory_Status"></param>
/// <param name="sSubcategory_CreateBy"></param>
/// <param name="tSubcategory_DateBy"></param>
/// <param name="sSubcategory_ModiBy"></param>
/// <param name="tSubcategory_DateModiBy"></param>
/// <returns>oerSubCategoria</returns>
public ESubCategoria RegistrarSubCategoria(string sid_ProductCategory, string sName_Subcategory, bool bSubcategory_Status,
string sSubcategory_CreateBy, DateTime tSubcategory_DateBy, string sSubcategory_ModiBy, DateTime tSubcategory_DateModiBy)
{
oConn = new Conexion(1);
DataTable dt = oConn.ejecutarDataTable("UP_WEBXPLORA_AD_REGISTER_SUBCATEGORIA", sid_ProductCategory, sName_Subcategory, bSubcategory_Status,
sSubcategory_CreateBy, tSubcategory_DateBy, sSubcategory_ModiBy, tSubcategory_DateModiBy);
oConn = null;
ESubCategoria oerSubCategoria = new ESubCategoria();
oerSubCategoria.id_ProductCategory = sid_ProductCategory;
oerSubCategoria.Name_Subcategory = sName_Subcategory;
oerSubCategoria.Subcategory_Status = bSubcategory_Status;
oerSubCategoria.Subcategory_CreateBy = sSubcategory_CreateBy;
oerSubCategoria.Subcategory_DateBy = tSubcategory_DateBy;
oerSubCategoria.Subcategory_ModiBy = sSubcategory_ModiBy;
oerSubCategoria.Subcategory_DateModiBy = tSubcategory_DateModiBy;
return(oerSubCategoria);
}
public List <ESubCategoria> ListarxCategoria(int categoria)
{
List <ESubCategoria> List = new List <ESubCategoria>();
SQLParameter[] parameters = new SQLParameter[1];
parameters[0] = new SQLParameter("@Categoria", categoria, SqlDbType.Int);
DataTable data = new DataTable();
data = Conexion.ExecuteProcedureD("USP_S_ListarSubCategoriaxCategoria", parameters).Tables[0];
foreach (DataRow row in data.Rows)
{
ESubCategoria be = new ESubCategoria
{
ID = Convert.ToInt32(row[0]),
Categoria = Convert.ToInt32(row[1]),
Nombre = row[2].ToString()
};
List.Add(be);
}
return(List);
}
private void Guardar()
{
ESubCategoria be = new ESubCategoria
{
ID = Convert.ToInt32(lblIdentificador.Text),
Categoria = Convert.ToInt32(CbxCategoria.SelectedValue),
Nombre = TxtNombre.Text
};
NSubCategoria bo = new NSubCategoria();
if (modificar == 0)
{
if (bo.Agregar(be))
{
TxtNombre.Text = "";
Listar();
Frm_Principal.Main.ChangeMessage("Sub Categoria agregado correctamente", "Success");
}
else
{
Frm_Principal.Main.ChangeMessage("Algo salio mal, Intente de nuevo", "Failed");
}
}
else if (modificar == 1)
{
if (bo.Modificar(be))
{
Listar();
Frm_Principal.Main.ChangeMessage("Sub Categoria modificado correctamente", "Success");
}
else
{
Frm_Principal.Main.ChangeMessage("Algo salio mal, Intente de nuevo", "Failed");
}
}
}
