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; }