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