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(); }