public List <BancoFinanciera> getFinancieraall(string cuenta_usuario) { try { using (SqlConnection sqlConn = new SqlConnection(this.strConn)) { sqlConn.Open(); SqlCommand cmd = new SqlCommand(strConn, sqlConn); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.CommandText = "sp_r_bancofinancierausuario"; cmd.Parameters.AddWithValue("@cuenta_usuario", cuenta_usuario); SqlDataReader reader = cmd.ExecuteReader(); List <BancoFinanciera> lBancofinanciera = new List <BancoFinanciera>(); while (reader.Read()) { BancoFinanciera mBancofinanciera = new BancoFinanciera(); mBancofinanciera.Codigo_banco = reader["codigo_banco"].ToString().Trim(); mBancofinanciera.Nombre = reader["nombre"].ToString().Trim(); mBancofinanciera.Check = Convert.ToBoolean(reader["chk"].ToString().Trim()); lBancofinanciera.Add(mBancofinanciera); mBancofinanciera = null; } return(lBancofinanciera); } } catch (Exception ex) { throw ex; } }
public List <BancoFinanciera> getallBancoallfinancieraconces() { try { using (SqlConnection sqlConn = new SqlConnection(this.strConn)) { sqlConn.Open(); SqlCommand cmd = new SqlCommand(strConn, sqlConn); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.CommandText = "sp_r_bancoallfinancieraconces"; SqlDataReader reader = cmd.ExecuteReader(); List <BancoFinanciera> lBancofinanciera = new List <BancoFinanciera>(); while (reader.Read()) { BancoFinanciera mBancofinanciera = new BancoFinanciera(); mBancofinanciera.Codigo = reader["codigo_banco"].ToString().Trim(); mBancofinanciera.Nombre = reader["nombre"].ToString().Trim(); lBancofinanciera.Add(mBancofinanciera); mBancofinanciera = null; } return(lBancofinanciera); } } catch (Exception ex) { throw ex; } }
public List <BancoFinanciera> getallBancoallfinancieracliente2(int id_clientef) { try { using (SqlConnection sqlConn = new SqlConnection(this.strConn)) { sqlConn.Open(); SqlCommand cmd = new SqlCommand(strConn, sqlConn); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.CommandText = "sp_r_Clientefinancieraxcliente"; SqlParameter oParam = cmd.Parameters.AddWithValue("@id_cliente", id_clientef); SqlDataReader reader = cmd.ExecuteReader(); List <BancoFinanciera> lBancofinanciera = new List <BancoFinanciera>(); while (reader.Read()) { BancoFinanciera mBancofinanciera = new BancoFinanciera(); mBancofinanciera.Codigo = reader["id_cliente"].ToString().Trim(); mBancofinanciera.Nombre = reader["nombre"].ToString().Trim(); lBancofinanciera.Add(mBancofinanciera); mBancofinanciera = null; } return(lBancofinanciera); } } catch (Exception ex) { throw ex; } }
public BancoFinanciera gettipodocbanco(string codigo) { try { using (SqlConnection sqlConn = new SqlConnection(this.strConn)) { sqlConn.Open(); SqlCommand cmd = new SqlCommand(strConn, sqlConn); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.CommandText = "get_tipodocumento"; cmd.Parameters.AddWithValue("@id", codigo); SqlDataReader reader = cmd.ExecuteReader(); BancoFinanciera mBancofinanciera = new BancoFinanciera(); if (reader.Read()) { mBancofinanciera.Codigo = reader["CodigoTipoParametro"].ToString(); mBancofinanciera.Nombre = reader["ValorAlfanumerico"].ToString(); } return(mBancofinanciera); } } catch (Exception ex) { throw ex; } }
public BancoFinanciera getBancofinanciera(string codigo) { try { using (SqlConnection sqlConn = new SqlConnection(this.strConn)) { sqlConn.Open(); SqlCommand cmd = new SqlCommand(strConn, sqlConn); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.CommandText = "sp_r_bancofinancierabycodigo"; cmd.Parameters.AddWithValue("@codigo", codigo); SqlDataReader reader = cmd.ExecuteReader(); BancoFinanciera mBancofinanciera = new BancoFinanciera(); if (reader.Read()) { mBancofinanciera.Codigo = reader["codigo_banco"].ToString(); mBancofinanciera.Nombre = reader["nombre"].ToString(); } else { mBancofinanciera = null; } return(mBancofinanciera); } } catch (Exception ex) { throw ex; } }
protected void gr_dato_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { BancoFinanciera mbfinan = new BancoFinanciera(); mbfinan.Codigo = "0"; mbfinan.Nombre = "Seleccionar"; List <BancoFinanciera> lbancof = new BancofinancieraBC().getallbancoallfinanciera(); lbancof.Add(mbfinan); DropDownList dl2 = (DropDownList)e.Row.FindControl("dl_financiera"); dl2.DataSource = lbancof; dl2.DataValueField = "codigo"; dl2.DataTextField = "nombre"; dl2.DataBind(); dl2.SelectedValue = "0"; //dl2.SelectedValue = gr_dato.DataKeys[e.Row.RowIndex].Values[0].ToString(); } }
public string add_bancofinanciera(string codigo, string nombre) { BancoFinanciera mbancofinanciera = new BancoFinanciera(); mbancofinanciera.Codigo = codigo; mbancofinanciera.Nombre = nombre; return(new BancofinancieraDAC().add_bancofinanciera(mbancofinanciera)); }
public string add_bancofinanciera(BancoFinanciera bancofinanciera) { using (SqlConnection sqlConn = new SqlConnection(this.strConn)) { sqlConn.Open(); try { SqlCommand Cmd = new SqlCommand("sp_add_bancofinanciera", sqlConn); Cmd.CommandType = CommandType.StoredProcedure; SqlParameter oParam = Cmd.Parameters.AddWithValue("@codigo", bancofinanciera.Codigo); oParam = Cmd.Parameters.AddWithValue("@nombre", bancofinanciera.Nombre); Cmd.ExecuteNonQuery(); sqlConn.Close(); } catch (Exception ex) { throw ex; } } return(""); }
private void getallTipooperacion() { DataTable dt = new DataTable(); dt.Columns.Add(new DataColumn("id_inventario")); dt.Columns.Add(new DataColumn("banco")); dt.Columns.Add(new DataColumn("ctacte")); dt.Columns.Add(new DataColumn("taloncheque")); dt.Columns.Add(new DataColumn("numero_cheque")); dt.Columns.Add(new DataColumn("montoini")); dt.Columns.Add(new DataColumn("fecha_movimiento")); dt.Columns.Add(new DataColumn("tipo_movimiento")); dt.Columns.Add(new DataColumn("fecha_rendicion")); dt.Columns.Add(new DataColumn("monto_rendido")); dt.Columns.Add(new DataColumn("rendido")); dt.Columns.Add(new DataColumn("solicitante")); dt.Columns.Add(new DataColumn("url_rendir")); dt.Columns.Add(new DataColumn("Nomina")); dt.Columns.Add(new DataColumn("folio")); List <Cheques> lcheques = new chequesBC().getCta_Cte(this.txt_desde.Text, this.txt_hasta.Text, Convert.ToInt16(this.dl_tipo_movimiento.SelectedValue), this.dl_rendido.SelectedValue); foreach (Cheques cheuq in lcheques) { DataRow dr = dt.NewRow(); BancoFinanciera mbancofinanciera = new BancoFinanciera(); BancoFinanciera banco = new BancofinancieraBC().getBancofinanciera(cheuq.Banco.ToString()); BancoFinanciera mtipodoc = new BancoFinanciera(); BancoFinanciera documento = new BancofinancieraBC().gettipodocbanco(cheuq.Tipo_movimiento.ToString()); CuentaBanco mcuentabanco = new CuentaBanco(); CuentaBanco ctacte = new CuentabancoBC().getcuentabancobycuenta(cheuq.Banco.ToString(), Convert.ToInt32(cheuq.Ctacte)); dr["id_inventario"] = cheuq.Id_inventario; dr["banco"] = banco.Nombre; dr["ctacte"] = ctacte.Numero_cuenta; dr["taloncheque"] = cheuq.Talonario; dr["numero_cheque"] = cheuq.Num_cheq; dr["rendido"] = cheuq.Rendido; dr["montoini"] = cheuq.Monto_inicial; dr["tipo_movimiento"] = documento.Nombre; dr["fecha_movimiento"] = cheuq.Fecha_movimiento.ToString("dd-MM-yyyy"); dr["fecha_rendicion"] = cheuq.Fecha_rendicion.ToString("dd-MM-yyyy"); dr["monto_rendido"] = cheuq.Monto_rendido.ToString(); dr["solicitante"] = cheuq.Solicitante.Trim(); dr["Nomina"] = cheuq.Nomina.Trim(); dr["folio"] = cheuq.Folio.Trim(); dr["url_rendir"] = "mrendicioncheque.aspx?id=" + FuncionGlobal.FuctionEncriptar(cheuq.Id_inventario.ToString().Trim()) + "&rendido=" + FuncionGlobal.FuctionEncriptar(cheuq.Rendido.Trim()); dt.Rows.Add(dr); } this.gr_dato.DataSource = dt; this.gr_dato.DataBind(); }