public BindingList <InvoiceDetailModel> BLGetInvoiceDetail(int invoiceId, int?invoiceDetailId)
{
DAInvoiceDetail dac = new DAInvoiceDetail();
DataTable dt = new DataTable();
dt = dac.GetInvoiceDetail(invoiceId, invoiceDetailId);
BindingList <InvoiceDetailModel> list = new BindingList <InvoiceDetailModel>();
for (int i = 0; i < dt.Rows.Count; i++)
{
InvoiceDetailModel detail = new InvoiceDetailModel();
detail.invoiceDetailId = Convert.ToInt32(dt.Rows[i]["InvoiceDetailId"].ToString());
detail.invoiceId = Convert.ToInt32(dt.Rows[i]["InvoiceId"].ToString());
detail.itemId = Convert.ToInt32(dt.Rows[i]["itemId"].ToString());
detail.itemName = dt.Rows[i]["ItemName"].ToString();
detail.qtty = Convert.ToDecimal(dt.Rows[i]["Qtty"].ToString());
detail.price = Convert.ToDecimal(dt.Rows[i]["Price"].ToString());
detail.amount = Convert.ToDecimal(dt.Rows[i]["Amount"].ToString());
detail.observation = dt.Rows[i]["Observation"].ToString();
detail.status = 3;
detail.unique = detail.RandomString(8);
list.Add(detail);
}
return(list);
}
public List <InvoiceDetailModel> GetInvoiceDetail(int invoiceId)
{
List <InvoiceDetailModel> invoice = new List <InvoiceDetailModel>();
DAInvoice dAInvoice = new DAInvoice();
DAInvoiceDetail dAInvoiceDetail = new DAInvoiceDetail();
DataTable data = dAInvoiceDetail.GetInvoiceDetail(invoiceId);
for (int i = 0; i < data.Rows.Count; i++)
{
invoice.Add(new InvoiceDetailModel
{
InvoiceId = Convert.ToInt32(data.Rows[i]["InvoiceId"]),
InvoiceDetailId = Convert.ToInt32(data.Rows[i]["InvoiceDetailId"]),
ItemId = Convert.ToInt32(data.Rows[i]["ItemId"]),
Qtty = Convert.ToDouble(data.Rows[i]["Qtty"]),
UnitPrice = Convert.ToDouble(data.Rows[i]["UnitPrice"]),
Amount = Convert.ToDouble(data.Rows[i]["Amount"]),
Observations = data.Rows[i]["Observations"].ToString(),
ItemName = data.Rows[i]["ItemName"].ToString()
});
}
return(invoice);
}
public List <ItemModel> GetItem()
{
List <ItemModel> item = new List <ItemModel>();
DAInvoiceDetail dAInvoiceDetail = new DAInvoiceDetail();
DataTable data = dAInvoiceDetail.GetItem();
for (int i = 0; i < data.Rows.Count; i++)
{
item.Add(new ItemModel
{
ItemId = Convert.ToInt32(data.Rows[i]["ItemId"]),
ItemName = data.Rows[i]["ItemName"].ToString(),
});
}
return(item);
}
public void BLPrepareInvoiceDetail(BindingList <InvoiceDetailModel> listDetail)
{
DAInvoiceDetail da = new DAInvoiceDetail();
da.PrepareInvoiceDetail(listDetail);
}
public void UpdateDetail(int invoiceId, int invoiceDetailId, string itemName, double qtty, double price, double amount, string observations)
{
DAInvoiceDetail da = new DAInvoiceDetail();
da.Update(invoiceId, invoiceDetailId, itemName, qtty, price, amount, observations);
}
public void DeleteDetail(int invoiceId, int invoiceDetailId)
{
DAInvoiceDetail da = new DAInvoiceDetail();
da.Delete(invoiceId, invoiceDetailId);
}
