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();
}
