public BillsView GetBillsView()
{
BillsView result =
new BillsView
{
BillTypes =
(from type in dataAccessor.BillTypes
orderby type.Id
select new BillTypeDto
{
Id = type.Id,
Name = type.Name
}).ToArray(),
Bills =
(from bill in dataAccessor.Bills
orderby bill.Date descending
select new BillDto
{
Id = bill.Id,
Date = bill.Date,
Description = bill.Description,
Amount = bill.Amount,
BillTypeId = bill.BillTypeId
}).ToArray()
};
return(result);
}
public static List <BillsView> GetBills(int idCompany) //yjs 010819
{
cadenaConexion = SelectCadena(idCompany);
List <BillsView> listabills = new List <BillsView>();
string sql = "select b.descripcion nombreCliente,a.*,replace(convert(NVARCHAR, a.dateDoc, 106), ' ', '/') fechaCorta " +
" from bills a inner join clientesCrud b on a.idCliente = b.idCliente ";
SqlConnection con = new SqlConnection(cadenaConexion);
con.Open();
SqlDataAdapter adapter = new SqlDataAdapter(sql, con);
DataSet dsResultado = new DataSet();
adapter.Fill(dsResultado, "VistaBill");
DataTable tblCliente;
tblCliente = dsResultado.Tables["VistaBill"];
foreach (DataRow drCurrent in tblCliente.Rows)
{
BillsView bill = new BillsView()
{
nombreCliente = (drCurrent["nombreCliente"].ToString()),
idBill = Int32.Parse(drCurrent["idBill"].ToString()),
billNo = drCurrent["billNo"].ToString(),
idCliente = Int32.Parse(drCurrent["idCliente"].ToString()),
pMethod = drCurrent["pMethod"].ToString(),
gTotal = float.Parse(drCurrent["gTotal"].ToString()),
dateDoc = DateTime.Parse(drCurrent["dateDoc"].ToString()),
fechaCorta = drCurrent["fechaCorta"].ToString()
};
listabills.Add(bill);
}
return(listabills);
}
public virtual ActionResult Bills()
{
BillsView model = billManagementService.GetBillsView();
return(View(model));
}
public static ResponseBill GetBill(int idBill, int idCompany) //yjs 010819
{
cadenaConexion = SelectCadena(idCompany);
List <BillsView> listabill = new List <BillsView>();
string sql = "select b.descripcion nombreCliente,a.*," +
"replace(convert(NVARCHAR, a.dateDoc, 106), ' ', '/') fechaCorta from bills a " +
"inner join clientesCrud b on a.idCliente = b.idCliente where a.idBill =" + idBill;
SqlConnection con = new SqlConnection(cadenaConexion);
con.Open();
SqlDataAdapter adapter = new SqlDataAdapter(sql, con);
DataSet dsResultado = new DataSet();
adapter.Fill(dsResultado, "VistaBill");
DataTable tblCliente;
tblCliente = dsResultado.Tables["VistaBill"];
foreach (DataRow drCurrent in tblCliente.Rows)
{
BillsView bill = new BillsView()
{
nombreCliente = (drCurrent["nombreCliente"].ToString()),
idBill = Int32.Parse(drCurrent["idBill"].ToString()),
billNo = drCurrent["billNo"].ToString(),
idCliente = Int32.Parse(drCurrent["idCliente"].ToString()),
pMethod = drCurrent["pMethod"].ToString(),
gTotal = float.Parse(drCurrent["gTotal"].ToString()),
dateDoc = DateTime.Parse(drCurrent["dateDoc"].ToString()),
fechaCorta = drCurrent["fechaCorta"].ToString()
};
listabill.Add(bill);
}
List <BillsDetailView> detail = new List <BillsDetailView>();
sql = "select a.billDetailId,a.billNo idBill,a.itemId,a.Quantity," +
"b.name itemName,b.price Precio,b.price * a.Quantity Total ";
sql = sql + "from billsDetail a ";
sql = sql + "inner join items b on a.itemID = b.itemId ";
sql = sql + "where a.billNo =" + idBill;
SqlDataAdapter adapter02 = new SqlDataAdapter(sql, con);
DataSet dsResultado02 = new DataSet();
adapter02.Fill(dsResultado02, "VistaDetail");
DataTable tblDetail;
tblDetail = dsResultado02.Tables["VistaDetail"];
foreach (DataRow drCurrent in tblDetail.Rows)
{
BillsDetailView deta = new BillsDetailView()
{
billDetailId = Int32.Parse(drCurrent["billDetailId"].ToString()),
idBill = Int32.Parse(drCurrent["idBill"].ToString()),
itemId = Int32.Parse(drCurrent["itemId"].ToString()),
Quantity = Int32.Parse(drCurrent["Quantity"].ToString()),
itemName = drCurrent["itemName"].ToString(),
Precio = float.Parse(drCurrent["precio"].ToString()),
Total = float.Parse(drCurrent["Total"].ToString())
};
detail.Add(deta);
}
var response = new ResponseBill();
response.bill = listabill;
response.detail = detail;
return(response);
}
