bool checkIfRepeat(DataReg newDataFromExcel) //to check if there is new data in rows
{
int a = 1;
string dateWorkForCheck = newDataFromExcel.dateWork;
string typeWorkForCheck = newDataFromExcel.typeWork;
var dbContext = new DemoContext();
var listBd = from p in dbContext.DataWorks select p;
foreach (var p in listBd)
{
if ((p.dateWork == dateWorkForCheck) && (p.typeWork == typeWorkForCheck))
{
a = 1;
return(true);
}
else
{
a = 0;
return(false);
}
}
if (a == 1)
{
return(true);
}
else
{
return(false);
}
}
private void buttonSaveKey_Click(object sender, RoutedEventArgs e)
{
if ((textBoxSiteKey.Text.Length != 0) && (textBoxSiteKey.Text != "Site Key") && (textBoxSiteKey.Text.Length != 0) && (textBoxSiteKey.Text != "Write your own Key"))
{
var dbContext = new DemoContext2();
var info = new DataReg()
{
TargetKey = textBoxSiteKey.Text, key = labelKeyGenerated.Content.ToString()
};
dbContext.DataKeys.Add(info);
dbContext.SaveChanges();
MessageBox.Show("Key User Save");
}
else
{
MessageBox.Show("Site Key or Key into null");
}
}
public MatrixMultiplication(int N, int K, int M)
{
// Make the processes
matrix_A = new TrueDualPortMemory <int>(N * K);
matrix_B = new TrueDualPortMemory <int>(K * M);
matrix_C = new TrueDualPortMemory <int>(N * M);
var access = new AccessGenerator();
var data_reg_a = new DataReg();
var data_reg_b = new DataReg();
var multiplier = new Multiplier();
var ctrl_reg_0 = new CtrlReg();
var ctrl_reg_1 = new CtrlReg();
var ctrl_reg_2 = new CtrlReg();
var accumulator = new Accumulator();
var meta_reg_0 = new MetaReg();
var meta_reg_1 = new MetaReg();
var meta_reg_2 = new MetaReg();
var meta_reg_3 = new MetaReg();
// Connect the processes
access.matrix_ctrl_A = matrix_A.ControlB;
access.matrix_ctrl_B = matrix_B.ControlB;
access.matrix_ctrl_C = ctrl_reg_0.input;
data_reg_a.input = matrix_A.ReadResultB;
data_reg_b.input = matrix_B.ReadResultB;
ctrl_reg_0.output = ctrl_reg_1.input;
multiplier.input_a = data_reg_a.output;
multiplier.input_b = data_reg_b.output;
ctrl_reg_1.output = ctrl_reg_2.input;
accumulator.input = multiplier.output;
//ctrl_reg_1.output = accumulator.addr;
ctrl_reg_2.output = accumulator.addr;
//accumulator.addr = ctrl_reg_1.output;
accumulator.output = matrix_C.ControlB;
meta_reg_0.input = access.matrix_meta_C;
meta_reg_1.input = meta_reg_0.output;
meta_reg_2.input = meta_reg_1.output;
meta_reg_3.input = meta_reg_2.output;
// Connect the top-level busses
matrix_A_meta = access.matrix_meta_A;
matrix_B_meta = access.matrix_meta_B;
matrix_C_meta = meta_reg_3.output;
}
private void addToDBButton_Click(object sender, EventArgs e)
{
if (siteTextBox.Text != "")
{
var dbContext = new DemoContext();
var info = new DataReg()
{
typeWork = typeWork.Text, siteWork = siteTextBox.Text, zipCode = zipCodeTextBox.Text, detailsWork = detailsTextBox.Text, dateWork = monthCalendar1.SelectionRange.Start.ToShortDateString(), timeStartWork = (comboBoxHourStart.Text.ToString() + ":" + comboBoxMinuteStart.Text.ToString()), timeFinishWork = (comboBoxHourFinish.Text.ToString() + ":" + comboBoxMinuteFinish.Text.ToString()), timeWorked = timeWorked.ToString(@"hh\:mm"), earned = earned, paid = false
};
dbContext.DataWorks.Add(info);
dbContext.SaveChanges();
MessageBox.Show("Work Saved");
newMainWindow.showDataGridView();
}
else
{
MessageBox.Show("Site Work not valid");
}
}
private void importButton_Click(object sender, EventArgs e)
{
//improve: 1-select excel file
Excel.Application xlApp;
Excel.Workbook xlWorkBook;
Excel.Worksheet xlWorkSheet;
Excel.Range range;
string str;
int rCnt = 0;
int cCnt = 0;
int contAdd = 0;
xlApp = new Excel.Application();
xlWorkBook = xlApp.Workbooks.Open("ControlWorkSupermums.xlsx", 0, true, 5, "", "", true, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "\t", false, false, 0, true, 1, 0);
xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1);
range = xlWorkSheet.UsedRange;
var dbContext = new DemoContext();
for (rCnt = 2; rCnt <= range.Rows.Count; rCnt++) //start on sencond row
{
var newDataFromExcel = new DataReg();
for (cCnt = 1; cCnt <= range.Columns.Count; cCnt++)
{
if ((range.Cells[rCnt, cCnt] as Excel.Range).Value2 == null) //when there is null cells on excel
{
str = "";
}
else
{
str = (range.Cells[rCnt, cCnt] as Excel.Range).Value2.ToString();
}
if (newDataFromExcel.typeWork != "") //execute only if exists a data in the first column
{
switch (cCnt)
{
case 1:
newDataFromExcel.typeWork = str;
break;
case 2:
double oleDateTime = double.Parse(str);
DateTime dt = DateTime.FromOADate(oleDateTime);
dt = DateTime.FromOADate(oleDateTime);
string date = dt.ToString("dd/MM/yyyy");
newDataFromExcel.dateWork = date;
break;
case 3:
double oleDateTime2 = double.Parse(str);
DateTime dt2 = DateTime.FromOADate(oleDateTime2);
string time = dt2.ToString("HH:mm");
newDataFromExcel.timeStartWork = time;
break;
case 4:
double oleDateTime3 = double.Parse(str);
DateTime dt3 = DateTime.FromOADate(oleDateTime3);
string time2 = dt3.ToString("HH:mm");
newDataFromExcel.timeFinishWork = time2;
break;
case 5:
double oleDateTime4 = double.Parse(str);
DateTime dt4 = DateTime.FromOADate(oleDateTime4);
string time3 = dt4.ToString("HH:mm");
newDataFromExcel.timeWorked = time3;
break;
case 6:
newDataFromExcel.siteWork = str;
break;
case 7:
newDataFromExcel.zipCode = str;
break;
case 8:
newDataFromExcel.detailsWork = str;
break;
case 9:
// nothing, it´s coef hours
break;
case 10:
// nothing, it´s earn per hour
break;
case 11:
newDataFromExcel.earned = decimal.Parse(str);
break;
case 14:
newDataFromExcel.paid = false;
break;
default:
break;
}
}
else
{
MessageBox.Show("First Column empty"); //to stop at final of Excel File
}
}
if (checkIfRepeat(newDataFromExcel) == false) //clean last rows excel file
{
dbContext.DataWorks.Add(newDataFromExcel);
dbContext.SaveChanges();
contAdd++;
}
else
{
MessageBox.Show("Any new Data in Excel");
}
}
if (contAdd != 0)
{
MessageBox.Show(contAdd + " Data Imported");
}
xlWorkBook.Close(true, null, null);
xlApp.Quit();
releaseObject(xlWorkSheet);
releaseObject(xlWorkBook);
releaseObject(xlApp);
showDataGridView();
}
