private void btnToevoegen_Click(object sender, EventArgs e)
{
Omission om = new Omission();
User u = new User(email);
Logic.UserLogic ul = new Logic.UserLogic();
ul.GetSingleUser(u);
int id = u.RetrieveUserID();
DateTime beginDate = dtpBegin.Value;
DateTime endDate = dtpEnd.Value;
string type = Convert.ToString(cmbxType.SelectedItem.ToString());
string description = tbxDescription.Text;
om.Id = id;
om.BeginDate = beginDate;
om.EndDate = endDate;
om.Type = type;
om.Description = description;
om.Code = 0;
Logic.OmissionLogic ol = new Logic.OmissionLogic();
ol.AddOmission(om);
}
public void AddOmission(Omission om)
{
try
{
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["Datacon"].ConnectionString))
{
string query = "INSERT INTO Proftaak.Omission(UserID, StartDate, EndDate, Type, Description, Code) " +
"Values(@UserID, @StartDate, @EndDate, @Type, @Description, @Code)";
using (SqlCommand cmd = new SqlCommand(query, conn))
{
conn.Open();
cmd.Parameters.AddWithValue("@UserID", om.Id);
cmd.Parameters.AddWithValue("@StartDate", om.BeginDate);
cmd.Parameters.AddWithValue("@EndDate", om.EndDate);
cmd.Parameters.AddWithValue("@Type", om.Type);
cmd.Parameters.AddWithValue("@Description", om.Description);
cmd.Parameters.AddWithValue("@Code", om.Code);
cmd.ExecuteNonQuery();
MessageBox.Show("Verlof aanvragen gelukt!");
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public bool isOmissionAllowed(Omission o, int code)
{
bool isAllowed = false;
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["Datacon"].ConnectionString))
{
string query = "UPDATE Proftaak.Omission SET Code = @Code WHERE Id = @Id";
SqlCommand cmd = new SqlCommand(query, conn);
cmd.Parameters.AddWithValue("@Code", code);
cmd.Parameters.AddWithValue("@Id", o.Id);
try
{
conn.Open();
cmd.ExecuteNonQuery();
isAllowed = true;
}
catch (Exception e)
{
Console.WriteLine(e.Message);
isAllowed = false;
}
}
return(isAllowed);
}
private void btnRefuse_Click(object sender, EventArgs e)
{
OmissionLogic logic = new OmissionLogic();
if (lbxOmission.SelectedItem != null)
{
string omission = lbxOmission.SelectedItem.ToString();
int omissionType = omission.IndexOf(",");
string selectedOmission = omission.Substring(omissionType + 2);
int omissionTypeID = omission.IndexOf(",");
string selectedId = omission.Substring(0, omissionTypeID);
int id = Convert.ToInt32(selectedId);
int codeID = omission.IndexOf("Verlopen");
if (codeID == -1)
{
Omission om = new Omission(selectedOmission);
om.Id = id;
logic.IsOmissionAllowed(om, 2);
}
else
{
MessageBox.Show("Het geselecteerde verzuim is verlopen en kan niet meer worden geweigerd.");
}
}
else
{
MessageBox.Show("Je moet een verzuim item selecteren.");
}
List <Omission> omissions = logic.GetAllOmissions();
string allowed = "";
lbxOmission.Items.Clear();
foreach (Omission o in omissions)
{
if (o.Code == 0)
{
allowed = "Niet toegekend";
}
else if (o.Code == 1)
{
allowed = "Toegestaan";
}
else if (o.Code == 2)
{
allowed = "Geweigerd";
}
else if (o.Code == 3)
{
allowed = "Verlopen";
}
lbxOmission.Items.Add(o.Id + "," + logic.GetUsername(o.UserID) + "-" + o.BeginDate.ToShortDateString() + "-" + o.EndDate.ToShortDateString() + "," + o.Type + "-" + allowed);
}
}
/// <summary>
/// bij de int isAllowed = 0 niet bekeken, 1 geaccepteerd, 2 afgewezen, 3 verlopen
/// </summary>
public bool IsOmissionAllowed(Omission o, int code)
{
bool hasBeenAllowed = false;
hasBeenAllowed = omRepo.IsOmissionAllowed(o, code);
return(hasBeenAllowed);
}
public OmissionTestContext()
{
Omission o = new Omission();
{ o.BeginDate = Convert.ToDateTime("21-3-2018"); o.EndDate = Convert.ToDateTime("25-3-2018"); o.Description = "Ik ben op vakantie."; o.Code = 0; o.UserID = 2; o.Type = "Vakantie"; }
omissions.Add(o);
Omission om = new Omission();
{ o.BeginDate = Convert.ToDateTime("22-3-2018"); o.EndDate = Convert.ToDateTime("1-04-2018"); o.Description = "Ik ben vader geworden."; o.Code = 1; o.UserID = 4; o.Type = "Verlof"; }
omissions.Add(om);
}
public void AddOmission(Omission o)
{
if (!string.IsNullOrEmpty(o.Type))
{
if (o.Code == 0 || o.Code == 1 || o.Code == 2 || o.Code == 3 || o.UserID != -1)
{
if (o.BeginDate != null)
{
if (o.EndDate != null)
{
omissions.Add(o);
}
}
}
}
}
public List <Omission> GetAllOmissions()
{
List <Omission> om = new List <Omission>();
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["Datacon"].ConnectionString))
{
string query = "SELECT * FROM Proftaak.Omission";
SqlCommand cmd = new SqlCommand(query, conn);
try
{
conn.Open();
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
string type = reader["Type"].ToString();
Omission o = new Omission(type);
o.Id = (int)reader["Id"];
o.BeginDate = (DateTime)reader["StartDate"];
o.EndDate = (DateTime)reader["EndDate"];
o.Description = reader["Description"].ToString();
o.UserID = (int)reader["UserID"];
o.Code = (int)reader["Code"];
if ((DateTime.Now.Day - o.EndDate.Day) < 3)
{
if ((DateTime.Now.Day - o.EndDate.Day) > 0)
{
o.Code = 3;
}
om.Add(o);
}
}
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
}
return(om);
}
public void AddOmission(Omission om)
{
var OmissiondateB = om.BeginDate;
var OmissiondateE = om.EndDate;
var TodayDate = DateTime.Now;
if ((OmissiondateB - TodayDate).TotalDays < 6)
{
MessageBox.Show("Verzuim moet minimaal 7 dagen van te voren aangevraagd worden.");
}
else if ((OmissiondateE - om.BeginDate).TotalDays < 1)
{
MessageBox.Show("Verzuim moet minimaal 1 dag lang zijn");
}
else
{
omRepo.AddOmission(om);
}
}
public ChordCategoryInfo(
CD chordDegree,
ChordMode mode,
NumberOfNotes nofn,
Omission omission,
AlterationType alteration,
AddedToneType addedTone,
ChordConstructionType construction,
FunctionType function)
{
this.chordDegree = chordDegree;
this.mode = mode;
this.nofn = nofn;
this.omission = omission;
this.alteration = alteration;
this.addedTone = addedTone;
this.construction = construction;
this.function = function;
}
public List <Omission> GetSingleUserOmission(Omission om)
{
try
{
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["Datacon"].ConnectionString))
{
List <Omission> OmissionListUser = new List <Omission>();
string query = "Select* " +
"From Proftaak.Omission " +
"Where UserID = @UserID";
conn.Open();
using (SqlCommand cmd = new SqlCommand(query, conn))
{
cmd.Parameters.AddWithValue("@UserID", om.UserID);
cmd.ExecuteNonQuery();
using (SqlDataReader dtr = cmd.ExecuteReader())
{
while (dtr.Read())
{
int Id = (int)dtr["Id"];
DateTime StartDate = (DateTime)dtr["StartDate"];
DateTime EndDate = (DateTime)dtr["EndDate"];
string Type = (string)dtr["Type"];
string Description = (string)dtr["Description"];
int Code = (int)dtr["Code"];
OmissionListUser.Add(new Omission(Id, StartDate, EndDate, Type, Description, Code));
}
return(OmissionListUser);
}
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
return(null);
}
public List <Omission> GetSingleUserOmission(Omission om)
{
return(omission.GetSingleUserOmission(om));
}
public void AddOmission(Omission om)
{
omission.AddOmission(om);
}
public bool IsOmissionAllowed(Omission o, int code)
{
return(omission.isOmissionAllowed(o, code));
}
public List <Omission> GetSingleUserOmission(Omission om)
{
throw new NotImplementedException();
}
private void Verzuim_Load(object sender, EventArgs e)
{
OmissionLogic logic = new OmissionLogic();
List <Omission> omissions = logic.GetAllOmissions();
User u = new User(email);
UserLogic uLogic = new UserLogic();
User SingleUser = uLogic.GetSingleUser(u);
int RoleId = SingleUser.RetrieveRoleID();
int Id = SingleUser.RetrieveUserID();
PermissionRepository pRepo = new PermissionRepository((new PermissionContext()));
int OmissionPermission = 29;
bool haOmissionPermission = pRepo.CheckPermissionsFromRole(u.RetrieveRoleID(), OmissionPermission);
if (haOmissionPermission == true)
{
string allowed = "";
lbxOmission.Items.Clear();
foreach (Omission o in omissions)
{
if (o.Code == 0)
{
allowed = "Niet toegekend";
}
else if (o.Code == 1)
{
allowed = "Toegestaan";
}
else if (o.Code == 2)
{
allowed = "Geweigerd";
}
else if (o.Code == 3)
{
allowed = "Verlopen";
}
lbxOmission.Items.Add(o.Id + "," + logic.GetUsername(o.UserID) + "-" + o.BeginDate.ToShortDateString() + "-" + o.EndDate.ToShortDateString() + "," + o.Type + "-" + allowed);
}
}
else
{
string allowed = "";
Omission om = new Omission(Id);
OmissionLogic oLogic = new OmissionLogic();
List <Omission> SingleUserOmissionList = oLogic.GetSingleUserOmission(om);
foreach (Omission o in SingleUserOmissionList)
{
if (o.Code == 0)
{
allowed = "Niet toegekend";
}
else if (o.Code == 1)
{
allowed = "Toegestaan";
}
else if (o.Code == 2)
{
allowed = "Geweigerd";
}
else if (o.Code == 3)
{
allowed = "Verlopen";
}
lbxOmission.Items.Add(o.Id + "," + logic.GetUsername(o.UserID) + "-" + o.BeginDate.ToShortDateString() + "-" + o.EndDate.ToShortDateString() + "," + o.Type + "-" + allowed);
}
}
PermissionRepository PermissionRepo = new PermissionRepository((new PermissionContext()));
UserLogic userLogic = new UserLogic();
User user;
user = new User(email);
userLogic.GetSingleUser(user);
int pagePermission = 20;
bool hasPagePermission = PermissionRepo.CheckPermissionsFromRole(user.RetrieveRoleID(), pagePermission);
if (hasPagePermission == true)
{
btnAllow.Visible = true;
btnRefuse.Visible = true;
}
else
{
btnAllow.Visible = false;
btnRefuse.Visible = false;
}
}
public bool isOmissionAllowed(Omission o, int code)
{
throw new NotImplementedException();
}
