private void frmHOLIDAY_Load(object sender, EventArgs e) { _context = new konekcija.MojaEntities(); cardholderBindingSource.DataSource = _context.Cardholders.ToList(); cmbCARDHOLDER.Text = ""; }
public frmSICKLEAVE() { InitializeComponent(); _context = new konekcija.MojaEntities(); sickLeaveBindingSource.DataSource = ListaSICKLEAVE; }
private void frmRELIGION_Load(object sender, EventArgs e) { _context = new konekcija.MojaEntities(); ListaRELIGION = _context.Religions.ToList(); ListaRELIGIONHOLIDAY = _context.ReligionHolidays.ToList(); cbxReligionName.DataSource = ListaRELIGION; cbxReligionName.Text = ""; txtTotalReligionDays.Text = ""; }
private void frmNONWORKINGDAYS_Load(object sender, EventArgs e) { _context = new konekcija.MojaEntities(); Lista = _context.Cardholders.ToList(); cardholderBindingSource.DataSource = Lista; cboxCARDHOLDER.Text = ""; }
private void frmEXCEPTION_Load(object sender, EventArgs e) { _context = new konekcija.MojaEntities(); cboxCARDHOLDER.DataSource = _context.Cardholders.ToList(); cboxCARDHOLDER.Text = ""; ListaLOGEXCEPTION = _context.LogExceptions.ToList(); Lista1 = _context.AccessLogs.ToList(); //dgLogDetails.DataSource = Lista1; }
public frmCARDHOLDERFIRM() { _context = new MojaEntities(); InitializeComponent(); ListaCARDHOLDER = _context.Cardholders.ToList(); foreach (var item in ListaCARDHOLDER) { checkComboBox1.Items.Add(new CheckComboBox.ComboboxData(item.Name, false)); } }
private void Form2_Load(object sender, EventArgs e) { _context = new konekcija.MojaEntities(); cboxCARDHOLDER.DataSource = _context.Cardholders.ToList(); cboxCARDHOLDER.Text = ""; // dgCHECKLIST.DataSource = _context.AccessLogs.ToList(); Lista2 = _context.Cards.ToList(); Lista1 = _context.AccessLogs.ToList(); Lista = _context.Cardholders.ToList(); //cardholderBindingSource.DataSource = Lista; }
private void Form2_Load(object sender, EventArgs e) { _context = new konekcija.MojaEntities(); cboxCARDHOLDER.DataSource = _context.Cardholders.OrderBy(o => o.Name).ToList(); cboxCARDHOLDER.Text = ""; // dgCHECKLIST.DataSource = _context.AccessLogs.ToList(); ListaCARD = _context.Cards.ToList(); ListaACCESSLOG = _context.AccessLogs.ToList(); ListaCARDHOLDER = _context.Cardholders.ToList(); ListaLOGEXCEPTION = _context.LogExceptions.ToList(); foreach (var item in ListaCARDHOLDER) { checkComboBox1.Items.Add(new CheckComboBox.ComboboxData(item.Name, false)); } }
public frmNONWORKINGDAYS() { _context = new konekcija.MojaEntities(); InitializeComponent(); }
public frmSHIFT() { InitializeComponent(); _context = new MojaEntities(); }
public frmLOGEXCEPTION() { _context = new konekcija.MojaEntities(); InitializeComponent(); }
public frmCARDHOLDER() { InitializeComponent(); _context = new konekcija.MojaEntities(); }
private void dgSICKLEAVE_CellClick(object sender, DataGridViewCellEventArgs e) { //SAVE BUTTON IN DATAGRIDVIEW if (e.ColumnIndex == 1) { DataGridViewRow row = this.dgSICKLEAVE.Rows[e.RowIndex]; if (!row.IsNewRow) { var date = row.Cells["Date"].Value; DateTime dateTime = Convert.ToDateTime(date); int SICKLEAVEID = Convert.ToInt16(row.Cells["SickLeaveIDCell"].Value); if (_context.SickLeaves.Where(w => w.SickLeaveID == SICKLEAVEID).Select(s => s.SickLeaveID).Count() == 0) { } else { if (_context.SickLeaves.Where(j => j.Date == dateTime && j.CardholderID == CARDHOLDERID).Select(s => s.SickLeaveID).Count() != 0) { MessageBox.Show("Save operation was not successful. Input date already exists.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); _context = new MojaEntities(); ListaSICKLEAVE = _context.SickLeaves.OrderBy(o => o.Date).ToList(); dgSICKLEAVE.DataSource = ListaSICKLEAVE.Where(j => j.CardholderID == CARDHOLDERID).ToList(); } else { //SICKLEAVEID = _context.SickLeaves.Where(w => w.CardholderID == CARDHOLDERID && w.Date == dateTime).Select(s => s.SickLeaveID).First(); var leaveQuery = _context.SickLeaves.Where(w => w.SickLeaveID == SICKLEAVEID).ToList(); var sickleavesave = leaveQuery[0]; sickleavesave.Date = Convert.ToDateTime(row.Cells["Date"].Value); _context.SaveChanges(); MessageBox.Show("Sick leave date has been successfully changed.", "Successful", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); } } } } //BRISANJE SELEKTOVANOG REDA if (e.ColumnIndex == 2) { try { DataGridViewRow row = this.dgSICKLEAVE.Rows[e.RowIndex]; if (!row.IsNewRow) { var date = row.Cells["Date"].Value; DateTime dateTime = Convert.ToDateTime(date); if (_context.SickLeaves.Where(w => w.Date == dateTime).Select(s => s.SickLeaveID).Count() == 0) { } else { if (MessageBox.Show("Do you really want to delete sick leave date?", "Delete", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes) { SICKLEAVEID = _context.SickLeaves.Where(w => w.Date == dateTime && w.CardholderID == CARDHOLDERID).Select(s => s.SickLeaveID).First(); System.Data.EntityKey sickleaveKey = new System.Data.EntityKey("MojaEntities.SickLeaves", "SickLeaveID", SICKLEAVEID); var SickLeaveDelete = _context.GetObjectByKey(sickleaveKey); _context.DeleteObject(SickLeaveDelete); _context.SaveChanges(); MessageBox.Show("Contract has been successfully deleted!", "Success", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); ListaSICKLEAVE = _context.SickLeaves.OrderBy(o => o.Date).ToList(); dgSICKLEAVE.DataSource = ListaSICKLEAVE.Where(j => j.CardholderID == CARDHOLDERID).ToList(); } } } } catch { MessageBox.Show("Delete operation was not successful. Please, contact your administrator.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } }
public void InsertAllTables() { _context = new konekcija.MojaEntities(); ListaLOGEXCEPTION = _context.LogExceptions.ToList(); ListaACCESSLOG = _context.AccessLogs.ToList(); ListaCARDHOLDER = _context.Cardholders.ToList(); foreach (var i in ListaCARDHOLDER) { CARDHOLDERID = i.CardholderID; ListaACCESSLOG = _context.AccessLogs.Where(w => w.CardholderID == CARDHOLDERID).ToList(); indikator = 1; var ListaACCESSLOGa = ListaACCESSLOG.GroupBy(u => u.LocalTime.Value.Date).Select(grp => grp.ToList()).ToList(); foreach (var j in ListaACCESSLOGa) { indikator = 1; CHECKError = 0; WORKTIMESUM = 0; int c = j.Count(); DATUM = j.First().LocalTime; foreach (var k in j) { if (c == 1) { CHECKError = 2; WORKTIMESUM = 0; } else { if (k.Direction == 2 && indikator == 1) { CHECKError = 2; continue; } else { if (c == 2) { CHECKError = 1; } else if (c % 2 != 0) { CHECKError = 2; } if (k.Direction == 1) { indikator = 0; DATUM1 = k.LocalTime.Value; } else { if (indikator == 1) { CHECKError = 2; } else { DATUM2 = k.LocalTime.Value; TimeSpan timeSpan = DATUM2 - DATUM1; WORKTIMESUM += Convert.ToInt32(timeSpan.TotalMinutes); indikator = 1; } } } } } if (!ListaLOGEXCEPTION.Any(w => w.CardholderID == CARDHOLDERID && w.LogExceptionDate == DATUM.Value.Date) && DATUM.Value.Date != System.DateTime.Now.Date) { var a = new LogException(); a.Worktime = WORKTIMESUM; var b = DATUM.Value.Date; a.LogExceptionDate = b; a.ExcIN_OUT = CHECKError; a.CardholderID = CARDHOLDERID; _context.LogExceptions.AddObject(a); _context.SaveChanges(); } } } }