private void btnRemoveReligion_Click(object sender, EventArgs e)
{
try
{
if (_context.Religions.Where(j => j.Name == cbxReligionName.Text).Select(s => s.ReligionID).Count() != 0)
{
if (MessageBox.Show("Do you really want to delete religion?", "Delete",
MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes)
{
RELIGIONID = _context.Religions.Where(j => j.Name == cbxReligionName.Text).Select(s => s.ReligionID).First();
System.Data.EntityKey religionKey = new System.Data.EntityKey("MojaEntities.Religions", "ReligionID", RELIGIONID);
var religionDelete = _context.GetObjectByKey(religionKey);
_context.DeleteObject(religionDelete);
_context.SaveChanges();
MessageBox.Show("You have successfully deleted religion from database.", "Successful",
MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
cbxReligionName.Text = "";
cbxReligionName.DataSource = _context.Religions.OrderBy(o => o.Name).ToList();
}
}
}
catch
{
MessageBox.Show("Delete operation was not successful. Please, contact your administrator.", "Error",
MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btnREMOVE_Click(object sender, EventArgs e)
{
try
{
if (_context.Firms.Where(j => j.Name == cboxFIRM.Text).Select(s => s.FirmID).Count() != 0)
{
if (MessageBox.Show("Do you really want to delete shift?", "Delete",
MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes)
{
FIRMID = _context.Firms.Where(j => j.Name == cboxFIRM.Text).Select(s => s.FirmID).First();
System.Data.EntityKey firmKey = new System.Data.EntityKey("MojaEntities.Firms", "FirmID", FIRMID);
var firmDelete = _context.GetObjectByKey(firmKey);
_context.DeleteObject(firmDelete);
_context.SaveChanges();
MessageBox.Show("You have successfully deleted firm from database.", "Successful",
MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
cboxFIRM.Text = "";
cboxFIRM.DataSource = _context.Firms.OrderBy(o => o.Name).ToList();
}
}
}
catch
{
MessageBox.Show("Delete operation was not successful. Please, contact your administrator.", "Error",
MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btnDELETE_Click(object sender, EventArgs e)
{
if (CARDHOLDERID == 0)
{
errorProvider1.SetError(cboxCARDHOLDER, "Please, choose the worker.");
cboxCARDHOLDER.Focus();
cboxCARDHOLDER.TextChanged += (s, ex) => { errorProvider1.SetError(cboxCARDHOLDER, ""); };
return;
}
if (_context.Contracts.Where(j => j.CardholderID == CARDHOLDERID && j.ActiveState == true).Select(s => s.ContractID).Count() == 0)
{
}
else
{
try
{
if (MessageBox.Show("Do you really want to delete contract?", "Delete",
MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes)
{
CONTRACTID = _context.Contracts.Where(j => j.CardholderID == CARDHOLDERID && j.ActiveState == true).Select(s => s.ContractID).First();
double?b = _context.Contracts.Where(j => j.CardholderID == CARDHOLDERID && j.ActiveState == true).Select(s => s.FreeDays).First();
var k = new NonWorkingDay();
k.CardholderID = CARDHOLDERID;
k.TotalNWD = a;
k.Description = "Contract -" + b;
_context.NonWorkingDays.AddObject(k);
_context.SaveChanges();
var queryCARDHOLDER = _context.Cardholders.Where(j => j.CardholderID == CARDHOLDERID).ToList();
var CardholderVar = queryCARDHOLDER[0];
CardholderVar.SumNWD = CardholderVar.SumNWD - b;
_context.SaveChanges();
txtTOTAL.Text = CardholderVar.SumNWD.ToString();
if (_context.Cardholders.Where(w => w.CardholderID == CARDHOLDERID).Select(s => s.SumNWD).First() is null)
{
txtTOTAL.Text = "";
}
else
{
txtTOTAL.Text = queryCARDHOLDER.First().SumNWD.ToString();
}
gbCONTRACT.BackColor = Color.FromArgb(255, 0, 0);
System.Data.EntityKey contractKey = new System.Data.EntityKey("MojaEntities.Contracts", "ContractID", CONTRACTID);
var ContractDelete = _context.GetObjectByKey(contractKey);
_context.DeleteObject(ContractDelete);
_context.SaveChanges();
MessageBox.Show("Contract has been successfully deleted!", "Success",
MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
cboxCARDHOLDER.Text = "";
gbCONTRACT.BackColor = System.Drawing.SystemColors.ControlLightLight;
}
}
catch
{
MessageBox.Show("Delete operation was not successful. Please, contact your administrator.", "Error",
MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
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);
}
}
}