public MainWindow()
{
InitializeComponent();
GettingSettings.SettingValuesFromConfig();
if (GettingSettings._sServer != null && GettingSettings._sServer != "")
{
try
{
string sqlConn = DatabaseProcedure.BuildingConnectionString();
if (sqlConn != "")
{
DatabaseProcedure.BuildingDatabase(sqlConn);
DatabaseProcedure.BuildingTable(sqlConn);
DatabaseProcedure.BuildingColumns(sqlConn);
}
}
catch (Exception ex)
{ MessageBox.Show(ex.Message.ToString()); }
}
dgComponent.CanUserAddRows = false;
dataGrid.CanUserAddRows = false;
dtShipDate.Text = DateTime.Now.ToString();
AddingItemsToDropDownList();
AddingComponentsToGrid();
FillingMainDataGrid(false);
//StartingTimertoRefresh();
}
private void bttnAddComponent_Click(object sender, RoutedEventArgs e)
{
Window2 AddDevice = new Window2();
AddDevice.ShowDialog();
DatabaseProcedure.BuildingColumns(DatabaseProcedure.BuildingConnectionString());
AddingComponentsToGrid();
FillingMainDataGrid(true);
}
private void bttnDelete_Click(object sender, RoutedEventArgs e)
{
if (MessageBox.Show(string.Format("This will delete LogID: {0} for Company: {1}?", iLogID, sCompany), "Delete Shipment Log", MessageBoxButton.YesNo, MessageBoxImage.Warning) == MessageBoxResult.Yes)
{
DatabaseProcedure.DeletingFromLog(iLogID);
FillingMainDataGrid(true);
}
else
{
//No Stuff
}
}
private void bttnSave_Click(object sender, RoutedEventArgs e)
{
dtShipDate.Text = DateTime.Now.ToString();
DatabaseProcedure.InsertingIntoDB(InsertQuery());
MyCollection = null;
txtCompany.Text = "";
cbShippingCompany.Text = "";
chckbRepair.IsChecked = false;
txtCost.Text = "0";
AddingComponentsToGrid();
FillingMainDataGrid(true);
}
private void InsertingDevice()
{
if (txtDevice.Text.ToString() != "" && txtDevice.Text.ToString() != null)
{
DatabaseProcedure.InsertingIntoComponents(txtDevice.Text.ToString().Replace(" ", "_"));
this.Close();
}
else
{
this.Close();
}
}
private void FillingMainDataGrid(bool pRefresh)
{
try
{
DataTable dtInfo = new DataTable();
string sQuery = DatabaseProcedure.OrderingColumns();
dtInfo = DatabaseProcedure.GettingInfoFromDatabase(sQuery);
dataGrid.ItemsSource = dtInfo.DefaultView;
}
catch (Exception ex)
{
// MessageBox.Show(ex.Message.ToString());
}
}
private static void FillingOutList()
{
List <ComponentsList> items = new List <ComponentsList>();
try
{
DataTable dtComponents = DatabaseProcedure.GettingInfoFromDatabase("SELECT Components FROM Components ORDER BY Components;");
foreach (DataRow row in dtComponents.Rows)
{
items.Add(new ComponentsList()
{
sComponent = row["Components"].ToString().Replace("_", " "), iQuantity = 0
});
}
MyCollectionList = items;
}
catch { }
}
public void AddingComponentsToGrid()
{
MyCollection = null;
List <ComponentsList> items = new List <ComponentsList>();
try
{
DataTable dtComponents = DatabaseProcedure.GettingInfoFromDatabase("SELECT Components FROM Components ORDER BY Components;");
foreach (DataRow row in dtComponents.Rows)
{
items.Add(new ComponentsList()
{
sComponent = row["Components"].ToString().Replace("_", " "), iQuantity = 0
});
}
MyCollectionList = items;
}
catch (Exception ex) { MessageBox.Show(ex.Message.ToString()); }
MyCollection = new ObservableCollection <ComponentsList>(MyCollectionList);
dgComponent.ItemsSource = MyCollection;
}
