private void bindingSource1_ListChanged(object sender, ListChangedEventArgs e) { // Exit if no project list if (m_List == null) { return; } // Get the item affected int index = e.NewIndex; RotiToChooseItem changedItem = null; if ((index > -1) && (index < m_List.Count)) { changedItem = m_List[index]; } // Get the type of change that occured ListChangedType changeType = e.ListChangedType; // Dispatch a change handler switch (changeType) { case ListChangedType.ItemChanged: CommandUpdateRoti updateRoti = new CommandUpdateRoti(changedItem); m_AppController.ExecuteCommand(updateRoti); break; case ListChangedType.ItemMoved: // Not supported in this app break; } }
private void saveToolStripButton_Click(object sender, EventArgs e) { //CommandSaveRotiList saveRoti = new CommandSaveRotiList(m_List); //m_AppController.ExecuteCommand(saveRoti); if (m_List == null) { return; } RotiToChooseItem changeItem = (RotiToChooseItem)bindingSource1.Current; if (changeItem == null) { return; } if (isNewRecord) { CommandInsertRoti newRoti = new CommandInsertRoti(changeItem); m_AppController.ExecuteCommand(newRoti); } else { CommandUpdateRoti updateRoti = new CommandUpdateRoti(changeItem); m_AppController.ExecuteCommand(updateRoti); } }
private void importBtn_Click(object sender, EventArgs e) { if (dataGridView1.DataSource == null) { return; } if (sourceTxt.Text == "" && sheetTxt.Text == "") { return; } foreach (DataGridViewRow row in dataGridView1.Rows) { if (row.Cells[7].Value.ToString() != null) { RotiToChooseItem myItem = new RotiToChooseItem(); myItem.ItemCode = row.Cells[0].Value.ToString(); myItem.ItemName = row.Cells[1].Value.ToString(); myItem.ItemSort = row.Cells[2].Value.ToString(); myItem.Brand = row.Cells[3].Value.ToString(); myItem.Jenis = row.Cells[4].Value.ToString(); myItem.Category = row.Cells[5].Value.ToString(); myItem.SubCategory = row.Cells[6].Value.ToString(); myItem.Price = Convert.ToDecimal(row.Cells[7].Value); CommandInsertRoti importData = new CommandInsertRoti(myItem); m_AppController.ExecuteCommand(importData); } } }
public void ListRotiToChoose(RotiToChooseList rotiList) { //Build a query string string sql = string.Format("SELECT ITEMCODE, ITEMNAME, ITEMSORT, Brand, Jenis, Category, SubCategory, Price, Stat FROM [ITEM]"); //Get a dataset from the query DataSet dataSet = DataProvider.GetDataSet(sql); //Create variables for dataset DataTable rotiTable = dataSet.Tables[0]; //Load roti list from the database RotiToChooseItem nextRoti = null; foreach (DataRow parent in rotiTable.Rows) { nextRoti = new RotiToChooseItem(); nextRoti.ItemCode = parent["itemCode"].ToString(); nextRoti.ItemName = parent["itemName"].ToString(); nextRoti.ItemSort = parent["itemSort"].ToString(); nextRoti.Brand = parent["Brand"].ToString(); nextRoti.Jenis = parent["Jenis"].ToString(); nextRoti.Category = parent["Category"].ToString(); nextRoti.SubCategory = parent["SubCategory"].ToString(); nextRoti.Price = Convert.ToDecimal(parent["Price"]); nextRoti.Stat = Convert.ToBoolean(parent["Stat"]); //Add the data item to the data list rotiList.Add(nextRoti); } //Dispose of the dataset dataSet.Dispose(); }
internal void CreateDatabaseRecord(RotiToChooseItem newRoti) { string sql = "INSERT INTO ITEM " + "(ITEMCODE, ITEMNAME, ITEMSORT, Brand, Jenis, Category, SubCategory, Price, Stat)" + " VALUES " + "(@code, @name, @sort, @brand, @jenis, @category, @subcategory, @price, @stat)"; AddorUpdateDatabaseRecord(sql, newRoti); }
internal void UpdateDatabaseRecord(RotiToChooseItem updateRoti) { string sql = "UPDATE ITEM SET " + "ITEMNAME = @name, " + "ITEMSORT = @sort, " + "Brand = @brand, " + "Jenis = @jenis, " + "category = @category, " + "subcategory = @subcategory, " + "price = @price, " + "Stat = @stat " + "WHERE ITEMCODE = @code"; AddorUpdateDatabaseRecord(sql, updateRoti); }
private void bindingNavigatorDeleteItem_Click(object sender, EventArgs e) { if (m_List == null) { return; } var pesan = MessageBox.Show("Apakah Anda Yakin Ingin Menghapus ? ", "Penghapusan", MessageBoxButtons.YesNo, MessageBoxIcon.Exclamation); if (pesan == DialogResult.Yes) { foreach (DataGridViewRow row in dgViewRoti.SelectedRows) { RotiToChooseItem item = row.DataBoundItem as RotiToChooseItem; if (item != null) { CommandDeleteRoti deleteItem = new CommandDeleteRoti(m_List, item); m_AppController.ExecuteCommand(deleteItem); } } } }
protected void AddorUpdateDatabaseRecord(string sql, RotiToChooseItem itemMaster) { try { //Create and open a connection SqlConnection connection = new SqlConnection(m_ConnectionString); connection.Open(); //create and configure a command SqlCommand command = new SqlCommand(sql, connection); //Adding value through parameter command.CommandType = System.Data.CommandType.Text; command.Parameters.Clear(); command.Parameters.AddWithValue("@code", itemMaster.ItemCode); command.Parameters.AddWithValue("@name", itemMaster.ItemName); command.Parameters.AddWithValue("@sort", itemMaster.ItemSort); command.Parameters.AddWithValue("@brand", itemMaster.Brand); command.Parameters.AddWithValue("@jenis", itemMaster.Jenis); command.Parameters.AddWithValue("@category", itemMaster.Category); command.Parameters.AddWithValue("@subcategory", itemMaster.SubCategory); command.Parameters.AddWithValue("@price", itemMaster.Price); command.Parameters.AddWithValue("@stat", itemMaster.Stat); //execute the command command.ExecuteNonQuery(); //Close and dispose command.Dispose(); connection.Close(); connection.Dispose(); } catch (SqlException ex) { MessageBox.Show(ex.Message.ToString()); } }
public CommandUpdateRoti(RotiToChooseItem item) { m_Item = item; }
public CommandDeleteRoti(RotiToChooseList list, RotiToChooseItem item) { m_List = list; m_Item = item; }
public CommandInsertRoti(RotiToChooseItem item) { m_Item = item; }