private void BT_FileImport_Click(object sender, RoutedEventArgs e)
{
Microsoft.Win32.OpenFileDialog dlg = new Microsoft.Win32.OpenFileDialog();
dlg.DefaultExt = ".xlsx";
dlg.Filter = "Excel documents|*.xls;*.xlsx";
Nullable<bool> result = dlg.ShowDialog();
if (result == true)
{
ExcelData exceldata = new ExcelData(dlg.FileName, CurrentProject.mf);
DG_Items.DataContext = null;;
DG_Items.ItemsSource = null;
db.ClearTable("Current_Data");
db.DoFillData("Current_Data", exceldata, CurrentProject.mf);
load_Items();
if (CurrentProject.InputItems.Count() > 0)
BT_FileImport_Checks.IsEnabled = true;
System.IO.File.Copy(dlg.FileName, System.IO.Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location) + "/CURRENT_EXCEL/current.xls", true);
}
}
public void DoFillData(String t, ExcelData ed, MapFieldList m)
{
table = t;
edata = ed;
mf = m;
ProgressDialog dlg2 = new ProgressDialog();
dlg2.Owner = null;
for (int index = 0; index < App.Current.Windows.Count; index++)
{
if (App.Current.Windows[index].Title == "ΕΥΕ Sampling")
{
dlg2.Owner = App.Current.Windows[index];
break;
}
}
dlg2.DialogText = "Καταγραφή δεδομένων στη Βάση.";
int startValue = 0;
dlg2.RunWorkerThread(startValue, FillData);
}
private void BT_FileImport_Checks_Click(object sender, RoutedEventArgs e)
{
if (CurrentProject.title == "")
{
MessageBox.Show("Παρακαλώ ορίστε τον τίτλο του Project!");
return;
} if (CurrentProject.mis == "")
{
MessageBox.Show("Παρακαλώ ορίστε τον κωδικό MIS του Project!");
return;
}
Microsoft.Win32.OpenFileDialog dlg = new Microsoft.Win32.OpenFileDialog();
dlg.DefaultExt = ".xlsx";
dlg.Filter = "Excel documents|*.xls;*.xlsx";
Nullable<bool> result = dlg.ShowDialog();
if (result == true)
{
db.ExecuteNonQuery("Update Current_Data set plithos_elegxon=0, synolo_poinon=0");
ExcelData exceldata_Check = new ExcelData(dlg.FileName, CurrentProject.mf_check, true);
string poin = "";
foreach (DataRow r in exceldata_Check.Data.Table.Rows)
{
if (r["ergo"].ToString() != CurrentProject.title && r["mis"].ToString() != CurrentProject.mis) continue;
poin = "";
if (r["poines"].ToString()!="")
poin=", synolo_poinon=synolo_poinon + "+r["poines"].ToString();
db.ExecuteNonQuery("Update Current_Data set plithos_elegxon=plithos_elegxon+1"+poin+" where ekepis=" + r["ekepis"].ToString() + " and praxi=" + r["praxi"].ToString());
}
DG_Items.DataContext = null; ;
DG_Items.ItemsSource = null;
load_Items();
}
}
/// <summary>
/// Allows the user to easily clear all data from a specific table.
/// </summary>
/// <param name="table">The name of the table to clear.</param>
/// <returns>A boolean true or false to signify success or failure.</returns>
public bool FillData(String table, ExcelData edata, MapFieldList mf)
{
try
{
foreach(DataRow r in edata.Data.Table.Rows)
{
Dictionary<string, string> dict = new Dictionary<string, string>(){};
int i = 0;
foreach(Mapfield m in mf)
{
dict.Add(m.Name,r[i++].ToString());
}
this.Insert(table, dict);
}
return true;
}
catch
{
return false;
}
}
