private void Form1_Load(object sender, EventArgs e)
{
//Initialize Controller
m_AppController = new AppController();
/* Note that the DataProvider class is static, so it doesn't
* get instantiated. */
//Get Group Harga List
CommandGetGroupHarga getGroupHarga = new CommandGetGroupHarga();
m_List = (GrouphargaList)m_AppController.ExecuteCommand(getGroupHarga);
//Bind to datasource
bindingSource1.DataSource = m_List;
}
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 override object Execute()
{
GrouphargaList list = new GrouphargaList();
return(list);
}
public CommandDeleteGroupHarga(GrouphargaList listItem, GroupHargaItem deleteItem)
{
m_groupList = listItem;
m_Item = deleteItem;
}
