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();
}
/// <summary>
/// Add or update the Item record
/// </summary>
/// <param name="sql">
/// The query string which will br run against, Make sure the parameter name is correct,
/// Param = @code,@name, @sort, @price, @satuan
/// </param>
/// <param name="ItemMaster">The itemMaster object that will be passed</param>
internal void AddorUpdateRecord(string sql, itemMaster ItemMaster)
{
try
{
//Create and open a connection
SqlConnection connection = new SqlConnection(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.Code);
command.Parameters.AddWithValue("@name", ItemMaster.Name);
command.Parameters.AddWithValue("@sort", ItemMaster.Sort);
command.Parameters.AddWithValue("@price", ItemMaster.Price);
command.Parameters.AddWithValue("@satuan", ItemMaster.Satuan);
//execute the command
command.ExecuteNonQuery();
//Close and dispose
command.Dispose();
connection.Close();
connection.Dispose();
}
catch (SqlException ex)
{
MessageBox.Show(ex.Message.ToString());
}
}
internal void CreateDatabaseRecord(itemMaster newItem)
{
string sql = "INSERT INTO ITEM " +
"(ITEMCODE, ITEMNAME, ITEMSORT, ITEMPRICE, ITEMSATUAN) "
+ "OUTPUT INSERTED.ITEMCODE "
+ "VALUES (@code, @name, @sort, @price, @satuan)";
AddorUpdateRecord(sql, newItem);
}
private void deleteBtn_Click(object sender, EventArgs e)
{
if (m_ItemList == null)
{
return;
}
itemMaster m_item = (itemMaster)itemMasterBindingSource.Current;
CommandDeleteItem deleteitem = new CommandDeleteItem(m_ItemList, m_item);
itemMaster itemDelete = (itemMaster)m_AppController.ExecuteCommand(deleteitem);
}
internal void UpdateDatabaseRecord(itemMaster changedItem)
{
// if (string.IsNullOrEmpty(changedItem.Code))
// {
// MessageBox.Show("TRUE");
// }
// else
// {
// MessageBox.Show("FALSE");
// }
string sql = "UPDATE ITEM SET " +
"itemName = @name, " +
"itemSort = @sort, " +
"itemPrice = @price, " +
"itemSatuan = @satuan " +
"WHERE itemCode = @code ";
AddorUpdateRecord(sql, changedItem);
}
private void itemMasterBindingSource_ListChanged(object sender, ListChangedEventArgs e)
{
/* This event will be called several times during form initialization.
* We don't want to do anything with it until the runtime authors
* list has been passed in. */
// Exit if no project list
if (m_ItemList == null)
{
return;
}
// Get the item affected
int index = e.NewIndex;
itemMaster changedItem = null;
if ((index > -1) && (index < m_ItemList.Count))
{
changedItem = m_ItemList[index];
}
// Get the type of change that occured
ListChangedType changeType = e.ListChangedType;
/* We only need to respond to two types of changes here; updates
* and moves. Adds are handled by bindingSourceProjects_AddingNew(),
* and deletes are handled by menuItemAuthorsDelete_Click(). */
// Dispatch a change handler
switch (changeType)
{
case ListChangedType.ItemChanged:
CommandUpdateItem updateAuthor = new CommandUpdateItem(changedItem);
m_AppController.ExecuteCommand(updateAuthor);
break;
case ListChangedType.ItemMoved:
// Not supported in this app
break;
}
}
private void saveBtn_Click(object sender, EventArgs e)
{
if (m_ItemList == null)
{
return;
}
itemMaster m_item = (itemMaster)itemMasterBindingSource.Current;
if (isNewRecord)
{
CommandCreateItem createItem = new CommandCreateItem(m_item);
itemMaster newItem = (itemMaster)m_AppController.ExecuteCommand(createItem);
}
else if (!isNewRecord)
{
CommandUpdateItem updateItem = new CommandUpdateItem(m_item);
itemMaster changeItem = (itemMaster)m_AppController.ExecuteCommand(updateItem);
}
isNewRecord = false;
}
public CommandCreateItem(itemMaster newItem)
{
m_Item = newItem;
}
public CommandDeleteItem(itemMasterList list, itemMaster deleteItem)
{
m_List = list;
m_Item = deleteItem;
}
public CommandUpdateItem(itemMaster changeItem)
{
m_Item = changeItem;
}