private void Employee_Box_SelectedIndexChanged(object sender, EventArgs e)
{
var BoxToString = Employee_Box.SelectedItem.ToString();
FirstName = BoxToString.Split(' ').First();
FamilyName = BoxToString.Split(' ').Last();
MiddleName = BoxToString.Replace(FirstName, "");
MiddleName = MiddleName.Replace(FamilyName, "");
Load_Hours.PerformClick();
}
private void ClearBoxes()
{
Hour_Box_Ma.ResetText();
Hour_Box_Ma.BackColor = Color.White;
Acti_Box_Ma.SelectedItem = null;
Comment_Box_Ma.ResetText();
Sick_Check_Ma.Checked = false;
Home_Check_Ma.Checked = false;
Hour_Box_Di.ResetText();
Hour_Box_Di.BackColor = Color.White;
Acti_Box_Di.SelectedItem = null;
Comment_Box_Di.ResetText();
Sick_Check_Di.Checked = false;
Home_Check_Di.Checked = false;
Hour_Box_Wo.ResetText();
Hour_Box_Wo.BackColor = Color.White;
Acti_Box_Wo.SelectedItem = null;
Comment_Box_Wo.ResetText();
Sick_Check_Wo.Checked = false;
Home_Check_Wo.Checked = false;
Hour_Box_Do.ResetText();
Hour_Box_Do.BackColor = Color.White;
Acti_Box_Do.SelectedItem = null;
Comment_Box_Do.ResetText();
Sick_Check_Do.Checked = false;
Home_Check_Do.Checked = false;
Hour_Box_Vr.ResetText();
Hour_Box_Vr.BackColor = Color.White;
Acti_Box_Vr.SelectedItem = null;
Comment_Box_Vr.ResetText();
Sick_Check_Vr.Checked = false;
Home_Check_Vr.Checked = false;
Load_Hours.PerformClick();
}
private void Send_Hour_Button_Click(object sender, EventArgs e)
{
SelectedWeek = Convert.ToInt32(Week_ComboBox.SelectedItem);
if (SelfSelected)
{
CheckEmpty();
CheckMaxHours();
}
else
{
MonApproved = Convert.ToInt32(GoedMon.Checked);
TueApproved = Convert.ToInt32(GoedDi.Checked);
WedApproved = Convert.ToInt32(GoedWo.Checked);
ThuApproved = Convert.ToInt32(GoedDo.Checked);
FriApproved = Convert.ToInt32(GoedVr.Checked);
using (SqlConnection conn = new SqlConnection(DAL.connectionString))
{
conn.Open();
using (SqlCommand cmd = new SqlCommand("Edit_Hours", conn))
{
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.Add("@in_Username", System.Data.SqlDbType.VarChar).Value = DAL.OldUsername;
cmd.Parameters.Add("@in_SelectedFirstName", System.Data.SqlDbType.VarChar).Value = FirstName;
cmd.Parameters.Add("@in_SelectedMiddleName", System.Data.SqlDbType.VarChar).Value = MiddleName;
cmd.Parameters.Add("@in_SelectedFamilyName", System.Data.SqlDbType.VarChar).Value = FamilyName;
cmd.Parameters.Add("@in_SelectedWeek", System.Data.SqlDbType.Int).Value = SelectedWeek;
cmd.Parameters.Add("@in_CommentsMon", System.Data.SqlDbType.VarChar).Value = Comment_Box_Ma.Text;
cmd.Parameters.Add("@in_CommentsTue", System.Data.SqlDbType.VarChar).Value = Comment_Box_Di.Text;
cmd.Parameters.Add("@in_CommentsWed", System.Data.SqlDbType.VarChar).Value = Comment_Box_Wo.Text;
cmd.Parameters.Add("@in_CommentsThu", System.Data.SqlDbType.VarChar).Value = Comment_Box_Do.Text;
cmd.Parameters.Add("@in_CommentsFri", System.Data.SqlDbType.VarChar).Value = Comment_Box_Vr.Text;
cmd.Parameters.Add("@in_IP", System.Data.SqlDbType.VarChar).Value = Program.UserIP;
if (MonApproved == 1)
{
cmd.Parameters.Add("@in_MonApproved", System.Data.SqlDbType.Int).Value = 1;
}
else
{
cmd.Parameters.Add("@in_MonApproved", System.Data.SqlDbType.Int).Value = 2;
}
if (TueApproved == 1)
{
cmd.Parameters.Add("@in_TueApproved", System.Data.SqlDbType.Int).Value = 1;
}
else
{
cmd.Parameters.Add("@in_TueApproved", System.Data.SqlDbType.Int).Value = 2;
}
if (WedApproved == 1)
{
cmd.Parameters.Add("@in_WedApproved", System.Data.SqlDbType.Int).Value = 1;
}
else
{
cmd.Parameters.Add("@in_WedApproved", System.Data.SqlDbType.Int).Value = 2;
}
if (ThuApproved == 1)
{
cmd.Parameters.Add("@in_ThuApproved", System.Data.SqlDbType.Int).Value = 1;
}
else
{
cmd.Parameters.Add("@in_ThuApproved", System.Data.SqlDbType.Int).Value = 2;
}
if (FriApproved == 1)
{
cmd.Parameters.Add("@in_FriApproved", System.Data.SqlDbType.Int).Value = 1;
}
else
{
cmd.Parameters.Add("@in_FriApproved", System.Data.SqlDbType.Int).Value = 2;
}
cmd.ExecuteNonQuery();
}
}
}
Load_Hours.PerformClick();
}
private void Week_ComboBox_SelectedIndexChanged(object sender, EventArgs e)
{
Load_Hours.PerformClick();
}
