public List <v_ManteNotaAbono> ListarAbono(int usuario) { string cnx = db.Database.Connection.ConnectionString; con = new SqlConnection(cnx); string findAll = "select*from v_ManteNotaAbono where Id_Vendedor='" + usuario + "' ORDER BY Numero_Abono asc"; try { comando = new SqlCommand(findAll, con); con.Open(); reader = comando.ExecuteReader(); List <v_ManteNotaAbono> mer = new List <v_ManteNotaAbono>(); while (reader.Read()) { v_ManteNotaAbono merca = new v_ManteNotaAbono(); merca.Id_Abono = Convert.ToInt32(reader[0].ToString()); merca.Direccion = reader[3].ToString(); merca.Monto = Convert.ToDecimal(reader[4].ToString()); merca.Numero_Abono = reader[1].ToString(); merca.RazonSocial = reader[15].ToString(); merca.Fecha = Convert.ToDateTime(reader[5]).ToString("dd-MM-yyyy"); mer.Add(merca); } return(mer); } catch (Exception ex) { throw ex; } finally { con.Close(); } }
public List <v_ManteNotaAbono> BuscarNotaAbonoxfecha(string fi, string ff, string id) { string cnx = db.Database.Connection.ConnectionString; con = new SqlConnection(cnx); string findAll = ""; if (id != "0") { findAll = "select * from v_ManteNotaAbono where Fecha between '" + fi + "'and '" + ff + "' and Id_Cliente ='" + id + "'ORDER BY Numero_Abono asc"; } else { findAll = "select * from v_ManteNotaAbono where Fecha between '" + fi + "'and '" + ff + "'ORDER BY Numero_Abono asc"; } try { comando = new SqlCommand(findAll, con); con.Open(); reader = comando.ExecuteReader(); List <v_ManteNotaAbono> mer = new List <v_ManteNotaAbono>(); while (reader.Read()) { v_ManteNotaAbono merca = new v_ManteNotaAbono(); merca.Id_Abono = Convert.ToInt32(reader[0].ToString()); merca.Direccion = reader[3].ToString(); merca.Monto = Convert.ToDecimal(reader[4].ToString()); merca.Numero_Abono = reader[1].ToString(); merca.RazonSocial = reader[15].ToString(); merca.Fecha = Convert.ToDateTime(reader[5]).ToString("dd-MM-yyyy"); merca.Nombres = reader[10].ToString(); string ide = reader[14].ToString(); if (ide == "3") { merca.estado = reader[12].ToString() + " " + reader[13].ToString(); } else { merca.estado = reader[12].ToString(); } mer.Add(merca); } return(mer); } catch (Exception ex) { throw ex; } finally { con.Close(); } }