private void outletItemBindingSource_ListChanged(object sender, ListChangedEventArgs e)
{
// Exit if no project list
if (m_List == null)
{
return;
}
// Get the item affected
int index = e.NewIndex;
outletItem changedOutlet = null;
if ((index > -1) && (index < m_List.Count))
{
changedOutlet = m_List[index];
}
// Get the type of change that occured
ListChangedType changeType = e.ListChangedType;
// Dispatch a change handler
switch (changeType)
{
case ListChangedType.ItemChanged:
CommandCRUOutlet updateOutlet = new CommandCRUOutlet(changedOutlet, true);
m_AppController.ExecuteCommand(updateOutlet);
break;
case ListChangedType.ItemMoved:
// Not supported in this app
break;
}
}
/// <summary>
/// To get list per salesman
/// </summary>
/// <param name="list"></param>
/// <param name="slsmCode"></param>
internal void ShowList(outletList list, string slsmCode)
{
//Build a query string
string sql = string.Format("SELECT [OUTLCODE],[OUTLNAME],[OUTLADDRESS],[OUTLSLSM],[OUTLROUTE],[OUTLSTAT] FROM [OTF_Invoice].[dbo].[OUTLET] WHERE [OUTLSLSM] = '" + slsmCode + "'");
//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
outletItem nextItem = null;
foreach (DataRow parent in rotiTable.Rows)
{
nextItem = new outletItem();
nextItem.OutletCode = parent["OUTLCODE"].ToString();
nextItem.OutletName = parent["OUTLNAME"].ToString();
nextItem.OutletAddress = parent["OUTLADDRESS"].ToString();
nextItem.OutletRoute = parent["OUTLROUTE"].ToString();
nextItem.SlsmCode = parent["OUTLSLSM"].ToString();
nextItem.OutletStatus = Convert.ToBoolean(parent["OUTLSTAT"]);
//Add the data item to the data list
if (nextItem.OutletCode == "")
{
nextItem.DeleteDatabaseRecord();
}
list.Add(nextItem);
}
//Dispose of the dataset
dataSet.Dispose();
}
protected void AddOrUpdateDatabaseRecord(string sql, outletItem 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.OutletCode);
command.Parameters.AddWithValue("@name", itemMaster.OutletName);
command.Parameters.AddWithValue("@address", itemMaster.OutletAddress);
command.Parameters.AddWithValue("@route", itemMaster.OutletRoute);
command.Parameters.AddWithValue("@slsmCode", itemMaster.SlsmCode);
command.Parameters.AddWithValue("@stat", itemMaster.OutletStatus);
//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(outletItem newItem)
{
string sql = "INSERT INTO OUTLET (outlcode, outlname, outladdress, outlroute, outlslsm, outlstat) " +
"VALUES(@code, @name, @address, @route, @slsmCode, @stat)";
AddOrUpdateDatabaseRecord(sql, newItem);
}
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[0].Value != null)
{
outletItem myItem = new outletItem();
myItem.OutletCode = row.Cells[2].Value.ToString();
myItem.OutletName = row.Cells[3].Value.ToString();
myItem.SlsmCode = row.Cells[0].Value.ToString();
myItem.OutletAddress = row.Cells[4].Value.ToString();
myItem.OutletRoute = row.Cells[5].Value.ToString();
myItem.OutletStatus = true;
CommandCRUOutlet importData = new CommandCRUOutlet();
m_AppController.ExecuteCommand(importData);
}
}
}
private void saveToolStripButton_Click(object sender, EventArgs e)
{
if (m_List == null)
{
return;
}
outletItem currentItem = (outletItem)outletItemBindingSource.Current;
CommandCRUOutlet newOutlet = new CommandCRUOutlet(currentItem, false);
m_AppController.ExecuteCommand(newOutlet);
}
internal void UpdateDatabaseRecord(outletItem updateItem)
{
string sql = "UPDATE OUTLET SET " +
"outlName = @name, " +
"outlAddress = @address, " +
"outlroute = @route, " +
"outlslsm = @slsmCode, " +
"outlStat = @stat " +
"WHERE outlCode = @code";
AddOrUpdateDatabaseRecord(sql, updateItem);
}
private void deletesToolStripMenuItem_Click(object sender, EventArgs e)
{
// Confirm Delete
var pesan = MessageBox.Show("Apakah Anda Yakin Ingin Menghapus ? ", "Penghapusan", MessageBoxButtons.YesNo, MessageBoxIcon.Exclamation);
if (pesan == DialogResult.Yes)
{
foreach (DataGridViewRow row in outletItemDataGridView.SelectedRows)
{
outletItem item = row.DataBoundItem as outletItem;
if (item != null)
{
CommandDeleteOutlet deleteItem = new CommandDeleteOutlet(m_List, item);
m_AppController.ExecuteCommand(deleteItem);
}
}
}
}
public CommandCRUOutlet(outletItem item, bool isUpdate)
{
m_Item = item;
this.isUpdate = isUpdate;
}
public CommandDeleteOutlet(outletList list, outletItem item)
{
m_List = list;
m_Item = item;
}
