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