public void ShowList(itemMasterList list)
{
string sql = "SELECT [ITEMCODE],[ITEMNAME],[ITEMSORT],[ITEMPRICE],[ITEMSATUAN] FROM [standArtInvoicingDB].[dbo].[ITEM]";
DataSet dataSet = DataProvider.GetDataSet(sql);
//Create variable for dataset table
DataTable itemTabel = dataSet.Tables[0];
itemMaster nextItem = null;
foreach (DataRow parentRow in itemTabel.Rows)
{
nextItem = new itemMaster();
nextItem.Code = parentRow["ITEMCODE"].ToString();
nextItem.Name = parentRow["ITEMNAME"].ToString();
nextItem.Sort = parentRow["ITEMSORT"].ToString();
nextItem.Price = Convert.ToDecimal(parentRow["ITEMPRICE"]);
nextItem.Satuan = parentRow["ITEMSATUAN"].ToString();
list.Add(nextItem);
}
dataSet.Dispose();
}
public void ListGroupHarga(GrouphargaList list)
{
string sql = "SELECT [GROUPCODE],[groupKET],[GROUPSTAT] FROM [standArtInvoicingDB].[dbo].[priceGroup]";
DataSet dataSet = DataProvider.GetDataSet(sql);
//Create variable for DataSet table
DataTable groupPriceTabel = dataSet.Tables[0];
GroupHargaItem nextGroup = null;
foreach (DataRow parentRow in groupPriceTabel.Rows)
{
nextGroup = new GroupHargaItem();
nextGroup.GroupCode = parentRow["GROUPCODE"].ToString();
nextGroup.Keterangan = parentRow["GROUPKET"].ToString();
nextGroup.Stat = Convert.ToBoolean(parentRow["GROUPSTAT"]);
list.Add(nextGroup);
}
dataSet.Dispose();
}
public void LoadInvoice(InvoiceList invoiceList)
{
//Build query to get Invoice's and their roti
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append(String.Format("SELECT [invoiceNo],[invoiceTgl],[slsmCode],[slsmName],[kurs],[nomorPO] ,[outletCode] ,[termsOfPayment],[nomorFakturPajak],[nomorKwitansi],[expiredDate],[subTotal],[ppn],[totalBersih] FROM [standArtInvoicingDB].[dbo].[Invoice]"));
sqlQuery.Append(string.Format("SELECT [invoiceNo],[itemCode],[itemName],[itemPrice],[itemQty] FROM[standArtInvoicingDB].[dbo].[InvoiceDetail]"));
//Get a data set from the query
DataSet dataSet = DataProvider.GetDataSet(sqlQuery.ToString());
//Create Variables for data set tables
DataTable invoiceTable = dataSet.Tables[0];
DataTable detailTable = dataSet.Tables[1];
//Create a data relation from invoice (parent table) to detail Invoice
DataColumn parentColumn = invoiceTable.Columns["invoiceNo"];
DataColumn childColumn = detailTable.Columns["invoiceNo"];
DataRelation invoiceToDetail = new DataRelation("invoiceToDetail", parentColumn, childColumn, false);
dataSet.Relations.Add(invoiceToDetail);
//Load InvoiceList from the data set
invoicePerItem nextInvoice = null;
InvoiceDetail nextRoti = null;
foreach (DataRow parentRow in invoiceTable.Rows)
{
////Create a new invoice
//bool createDatabaseRecord = false;
//nextInvoice = new invoicePerItem(createDatabaseRecord);
////Fill in invoice properties
//nextInvoice.InvoiceID = Convert.ToInt32(parentRow["invoiceID"]);
//nextInvoice.Nomor = parentRow["noInvoice"].ToString();
//nextInvoice.PeriodeBulan = Convert.ToDateTime(parentRow["periodeBulan"]);
//nextInvoice.SlsmCode = parentRow["slsmCode"].ToString();
//nextInvoice.SlsmName = parentRow["slsmName"].ToString();
////nextInvoice.SubTotal = Convert.ToDecimal(parentRow["subTotal"]);
//nextInvoice.PPN = Convert.ToInt32(parentRow["ppn"]);
////nextInvoice.Total = Convert.ToDecimal(parentRow["total"]);
//nextInvoice.IssuedData = Convert.ToDateTime(parentRow["issuedDate"]);
////Get Invoice Item
//DataRow[] childRows = parentRow.GetChildRows(invoiceToDetail);
////Create invoiceItem object foe each of the invoice
//foreach (DataRow childRow in childRows)
//{
// //Create a new item
// nextRoti = new rotiItem();
// //Fill in roti's properties
// nextRoti.ID = Convert.ToInt32(childRow["rotiID"]);
// nextRoti.Code = childRow["itemCode"].ToString();
// nextRoti.Name = childRow["itemName"].ToString();
// nextRoti.Qty = Convert.ToInt32(childRow["itemQty"]);
// nextRoti.Price = Convert.ToDecimal(childRow["itemPrice"]);
// //Add roti to invoice
// nextInvoice.Items.Add(nextRoti);
//}
////Add the invoice to the invoice List
//invoiceList.Add(nextInvoice);
}
//Dispose of the dataset
dataSet.Dispose();
}
