protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
if (Request.QueryString["holidayid"] != null)
{
string holidayid = Request.QueryString["holidayid"];
holiday new_h = PolaczenieSQL.find_holiday(holidayid);
if (new_h.menager != Context.User.Identity.Name && new_h.othermenager != Context.User.Identity.Name)
{
Response.Redirect("menager_holidays.aspx");
}
string user_name_string = PolaczenieSQL.find_user(new_h.userid).ToString();
switch (new_h.statusid)
{
case "1":
butt_delete.Visible = false;
butt_app_men.Visible = true;
butt_app_hr.Visible = false;
butt_rej_men.Visible = true;
butt_rej_hr.Visible = false;
label_status.BackColor = Color.LightYellow;
break;
case "2":
butt_delete.Visible = false;
butt_app_men.Visible = false;
butt_app_hr.Visible = false;
butt_rej_men.Visible = true;
butt_rej_hr.Visible = false;
label_status.BackColor = Color.LightYellow;
break;
case "3":
butt_delete.Visible = false;
butt_app_men.Visible = false;
butt_app_hr.Visible = false;
butt_rej_men.Visible = true;
butt_rej_hr.Visible = false;
label_status.BackColor = Color.LightGreen;
break;
case "4":
butt_delete.Visible = false;
butt_app_men.Visible = false;
butt_app_hr.Visible = false;
butt_rej_men.Visible = false;
butt_rej_hr.Visible = false;
label_status.BackColor = Color.LightPink;
break;
case "5":
butt_delete.Visible = false;
butt_app_men.Visible = false;
butt_app_hr.Visible = false;
butt_rej_men.Visible = false;
butt_rej_hr.Visible = false;
label_status.BackColor = Color.LightPink;
break;
case "6":
butt_delete.Visible = false;
butt_app_men.Visible = false;
butt_app_hr.Visible = false;
butt_rej_men.Visible = false;
butt_rej_hr.Visible = false;
label_status.BackColor = Color.DarkSeaGreen;
break;
case "7":
butt_delete.Visible = false;
butt_app_men.Visible = false;
butt_app_hr.Visible = false;
butt_rej_men.Visible = false;
butt_rej_hr.Visible = false;
label_status.BackColor = Color.LightSlateGray;
break;
}
l_id.Text = new_h.holidayid;
l_name.Text = user_name_string;
l_od.Text = new_h.date_od.ToShortDateString();
l_do.Text = new_h.date_do.ToShortDateString();
l_menager.Text = PolaczenieSQL.find_user(new_h.menager).ToString();
l_ilość_dni.Text = new_h.holiday_dyas_all.ToString();
l_losc_dni_all.Text = new_h.holiday_dyas_ciag.ToString();
string[] days_of_holidays = PolaczenieSQL.find_holiday_days_byuser(new_h.userid);
Labelpr.Text = days_of_holidays[0];
Labelor.Text = days_of_holidays[8];
Labelnr.Text = days_of_holidays[9];
Labeldd.Text = days_of_holidays[5];
Labelnz.Text = days_of_holidays[6];
Labelsum.Text = days_of_holidays[10];
Labelwyk.Text = days_of_holidays[3];
if (Convert.ToInt16(Labelsum.Text) > 0)
{
suncell.BackColor = Color.LightGreen;
}
if (Convert.ToInt16(Labelsum.Text) <= 0)
{
suncell.BackColor = Color.LightPink;
}
h_details.InnerHtml = "Szczegóły urlopu [id:" + holidayid + "]";
h_userdays.InnerHtml = "Dni urlopowe pracownika [" + user_name_string + "]";
PolaczenieSQL.fill_holidays_by_user(GridView1, new_h.userid, 10);
PolaczenieSQL.fill_holiday_history(GridView2, holidayid);
label_status.Text = "STATUS: " + new_h.status;
DateTime date1 = new DateTime(new_h.date_od.Year, new_h.date_od.Month, 1);
DateTime date0 = date1.AddMonths(-1);
DateTime date2 = date1.AddMonths(1);
PageMetods.month_calendar_by_holidayid(bigDiv, date0, date2, new_h.userid, true, new_h.holidayid);
Session.Contents.RemoveAll();
GC.SuppressFinalize(this);
foreach (System.Collections.DictionaryEntry entry in HttpContext.Current.Cache)
{
HttpContext.Current.Cache.Remove((string)entry.Key);
}
}
else
{
Response.Redirect("menager_holidays.aspx");
}
}
}
protected void Button1_Click(Object sender, EventArgs e)
{
Page.Validate();
string userName = Request.QueryString["user"];
if (string.IsNullOrEmpty(userName))
{
Response.Redirect("manageusers.aspx");
}
List <string> userlist = new List <string>();
userlist.Add(HiddenFielduserid.Value);
// Get information about this user
MembershipUser usr = Membership.GetUser(userName);
if (usr == null)
{
Response.Redirect("manageusers.aspx");
}
bool menager_yes = false;
if ((Roles.IsUserInRole(usr.UserName, "menager")) && PracownikMenager.Checked == false)
{
using (SqlConnection conn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["ApplicationServices"].ConnectionString))
{
conn.Open();
string sql = "Select Menager FROM Teams";
SqlCommand command = new SqlCommand(sql, conn);
SqlDataReader sdr2;
sdr2 = command.ExecuteReader();
if (sdr2.HasRows == true)
{
while (sdr2.Read())
{
if (sdr2[0].ToString() == usr.UserName)
{
menager_yes = true;
break;
}
}
}
sdr2.Close();
command.Cancel();
conn.Close();
}
if (menager_yes)
{
Response.Redirect("manageuser.aspx?user="******"&deleteMenager=" + usr.UserName);
return;
}
Roles.RemoveUserFromRole(usr.UserName, "menager");
PolaczenieSQL.addHRhistory(userlist, 0, "Employee loses function 'Menager'", Context.User.Identity.Name, "Function change");
}
else if (!(Roles.IsUserInRole(usr.UserName, "menager")) && PracownikMenager.Checked == true)
{
Roles.AddUserToRole(usr.UserName, "menager");
PolaczenieSQL.addHRhistory(userlist, 0, "Employee gain function 'Menager'", Context.User.Identity.Name, "Function change");
}
if ((Roles.IsUserInRole(usr.UserName, "emploee")) && Pracownik.Checked == false)
{
Roles.RemoveUserFromRole(usr.UserName, "emploee");
PolaczenieSQL.addHRhistory(userlist, 0, "Employee loses function 'Emploee'", Context.User.Identity.Name, "Function change");
}
else if (!(Roles.IsUserInRole(usr.UserName, "emploee")) && Pracownik.Checked == true)
{
Roles.AddUserToRole(usr.UserName, "emploee");
PolaczenieSQL.addHRhistory(userlist, 0, "Employee gain function 'Emploee'", Context.User.Identity.Name, "Function change");
}
if ((Roles.IsUserInRole(usr.UserName, "hr_emploee")) && PracownikHR.Checked == false)
{
Roles.RemoveUserFromRole(usr.UserName, "hr_emploee");
PolaczenieSQL.addHRhistory(userlist, 0, "Employee loses function 'HR emploee'", Context.User.Identity.Name, "Function change");
}
else if (!(Roles.IsUserInRole(usr.UserName, "hr_emploee")) && PracownikHR.Checked == true)
{
Roles.AddUserToRole(usr.UserName, "hr_emploee");
PolaczenieSQL.addHRhistory(userlist, 0, "Employee gain function 'HR emploee'", Context.User.Identity.Name, "Function change");
}
if ((Roles.IsUserInRole(usr.UserName, "Administrators")) && PracownikAdmin.Checked == false)
{
Roles.RemoveUserFromRole(usr.UserName, "Administrators");
PolaczenieSQL.addHRhistory(userlist, 0, "Employee loses function 'Administrator'", Context.User.Identity.Name, "Function change");
}
else if (!(Roles.IsUserInRole(usr.UserName, "Administrators")) && PracownikAdmin.Checked == true)
{
Roles.AddUserToRole(usr.UserName, "Administrators");
PolaczenieSQL.addHRhistory(userlist, 0, "Employee gain function 'Administrator'", Context.User.Identity.Name, "Function change");
}
using (SqlConnection conn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["ApplicationServices"].ConnectionString))
{
conn.Open();
string sql = "";
if (SaveUserButton.Text != "Dodaj nowego pracownika")
{
sql = "UPDATE aspnet_Users SET Imie = @imie, Nazwisko = @nazwisko, pesel = @pesel, data_urodz = @urodz, data_zatrudnienia = @zatrudnienia, team = @team, dniurlopowe = @dniurlopowe, kiedy26 = @kiedy26 Where UserName = @user";
}
else if (SaveUserButton.Text == "Dodaj nowego pracownika")
{
sql = "UPDATE aspnet_Users SET Imie = @imie, Nazwisko = @nazwisko, pesel = @pesel, data_urodz = @urodz, data_zatrudnienia = @zatrudnienia, team = @team, dniurlopowe = @dniurlopowe, kiedy26 = @kiedy26, dni_p_rok = @dni_p_rok, dni_o_rok = @dni_o_rok, dni_n_rok = @dni_n_rok, dni_nz = @dni_nz Where UserName = @user";
}
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.Add("@imie", SqlDbType.VarChar, 50).Value = ImieTextBox.Text;
cmd.Parameters.Add("@nazwisko", SqlDbType.VarChar, 50).Value = NazwiskoTextBox.Text;
cmd.Parameters.Add("@pesel", SqlDbType.Float, 11).Value = PeselTextBox.Text;
if (Dataurodzenia.Text != string.Empty)
{
string dateUr = Dataurodzenia.Text;
DateTime datetimeUr = DateTime.ParseExact(dateUr, "dd-MM-yyyy", CultureInfo.InvariantCulture);
cmd.Parameters.Add("@urodz", SqlDbType.Date, 50).Value = datetimeUr;
}
else
{
cmd.Parameters.Add("@urodz", SqlDbType.Date, 50).Value = DBNull.Value;
}
int dni_o_rok;
if (DataZatrudnienia.Text != string.Empty)
{
string dateZa = DataZatrudnienia.Text;
DateTime datetimeZa = DateTime.ParseExact(dateZa, "dd-MM-yyyy", CultureInfo.InvariantCulture);
cmd.Parameters.Add("@zatrudnienia", SqlDbType.Date, 50).Value = datetimeZa;
if (SaveUserButton.Text == "Dodaj nowego pracownika")
{
double ma26;
int ma26bis;
if (String.Equals(DropDownList2.Text, "2"))
{
ma26 = 2.16;
ma26bis = 26;
}
else
{
ma26 = 1.66;
ma26bis = 20;
}
dni_o_rok = PageMetods.licz_dni_pierwszego_roku(datetimeZa, ma26);
cmd.Parameters.Add("@dni_p_rok", SqlDbType.Int, 2).Value = 0;
cmd.Parameters.Add("@dni_o_rok", SqlDbType.Int, 2).Value = dni_o_rok;
cmd.Parameters.Add("@dni_n_rok", SqlDbType.Int, 2).Value = ma26bis;
if (dni_o_rok >= 4)
{
cmd.Parameters.Add("@dni_nz", SqlDbType.Int, 2).Value = 4;
}
else
{
cmd.Parameters.Add("@dni_nz", SqlDbType.Int, 2).Value = dni_o_rok;
}
}
}
else
{
cmd.Parameters.Add("@zatrudnienia", SqlDbType.Date, 50).Value = DBNull.Value;
}
//if (SaveUserButton.Text != "Dodaj nowego pracownika")
//{
// cmd.Parameters.Add("@dni_p_rok", SqlDbType.Int, 2).Value = Convert.ToInt16(Labelpr.Text);
// cmd.Parameters.Add("@dni_o_rok", SqlDbType.Int, 2).Value = Convert.ToInt16(Labelor.Text);
// cmd.Parameters.Add("@dni_n_rok", SqlDbType.Int, 2).Value = Convert.ToInt16(Labelnr.Text);
// cmd.Parameters.Add("@dni_nz", SqlDbType.Int, 2).Value = Convert.ToInt16(Labelnz.Text);
//}
cmd.Parameters.Add("@team", SqlDbType.Int, 3).Value = DropDownList1.SelectedValue;
cmd.Parameters.Add("@dniurlopowe", SqlDbType.Int, 2).Value = DropDownList2.Text;
if (uzyska26TextBox.Text != string.Empty)
{
string date26 = uzyska26TextBox.Text;
DateTime datetime26 = DateTime.ParseExact(date26, "dd-MM-yyyy", CultureInfo.InvariantCulture);
cmd.Parameters.Add("@kiedy26", SqlDbType.Date, 50).Value = datetime26;
}
else
{
cmd.Parameters.Add("@kiedy26", SqlDbType.Date, 50).Value = DBNull.Value;
}
cmd.Parameters.Add("@user", SqlDbType.VarChar, 50).Value = usr.UserName;
cmd.CommandType = CommandType.Text;
cmd.ExecuteNonQuery();
if (SaveUserButton.Text == "Dodaj nowego pracownika")
{
string newPassword;
MembershipUser u;
u = Membership.GetUser(userName, false);
try
{
newPassword = u.ResetPassword();
}
catch (Exception e2)
{
return;
}
if (newPassword != null)
{
mailSender.SendMailNewAccount(Server.HtmlEncode(newPassword), u.Email, u.ToString());
PolaczenieSQL.updatepasstemp("yes", u.UserName);
}
}
if (HiddenField20t26.Value != DropDownList2.SelectedValue)
{
PolaczenieSQL.update20to26(userlist, Context.User.Identity.Name, DropDownList2.SelectedValue);
if (DropDownList2.SelectedValue == "2")
{
PolaczenieSQL.addHRhistory(userlist, 0, "Employee reach proper expierience", Context.User.Identity.Name, "Go from 20 to 26 holidays days");
}
}
if (HiddenFieldTeam.Value != DropDownList1.SelectedValue)
{
if (String.IsNullOrEmpty(HiddenFieldTeam.Value))
{
PolaczenieSQL.addHRhistory(userlist, 0, "New user account has been created: " + userName, Context.User.Identity.Name, "New user");
}
else
{
PolaczenieSQL.addHRhistory(userlist, 0, "Employee change team from " + HiddenTeamName.Value + " to " + DropDownList1.SelectedItem.Text, Context.User.Identity.Name, "Team change");
}
}
usr.Email = TextBox_email.Text;
Membership.UpdateUser(usr);
}
Response.Redirect(Request.RawUrl);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
string text_url = Request.RawUrl;
//Session["LastHolidayList"] = text_url;
//if (Request.QueryString["teamid"] != null)
//{
string menager_id = Context.User.Identity.Name;
string teamid = Request.QueryString["teamid"];
//PolaczenieSQL.list_of_users_names(PersonDropDown);
//PolaczenieSQL.list_of_teams_names(TeamDropDown, teamid);
PolaczenieSQL.fill_holidays_by_menager_status(GridViewAppMen, 1, menager_id);
PolaczenieSQL.fill_holidays_by_menager_status(GridViewAppHR, 2, menager_id);
PolaczenieSQL.fill_holidays_by_menager_status(GridViewZat, 3, menager_id);
PolaczenieSQL.fill_holidays_by_menager_status(GridViewRejec, 4, menager_id);
PolaczenieSQL.fill_holidays_by_menager_status(GridViewOK, 6, menager_id);
PolaczenieSQL.fill_holidays_by_menager_status(GridViewDelete, 7, menager_id);
//}
//else if (Request.QueryString["userid"] != null)
//{
// string userid = Request.QueryString["userid"];
// PolaczenieSQL.list_of_users_names(PersonDropDown, userid);
// PolaczenieSQL.list_of_teams_names(TeamDropDown);
// PolaczenieSQL.fill_holidays_by_status(GridViewAppMen, 1, user_id: userid);
// PolaczenieSQL.fill_holidays_by_status(GridViewAppHR, 2, user_id: userid);
// PolaczenieSQL.fill_holidays_by_status(GridViewZat, 3, user_id: userid);
// PolaczenieSQL.fill_holidays_by_status(GridViewRejec, 4, user_id: userid);
// PolaczenieSQL.fill_holidays_by_status(GridViewOK, 6, user_id: userid);
// PolaczenieSQL.fill_holidays_by_status(GridViewDelete, 7, user_id: userid);
//}
//else
//{
// PolaczenieSQL.list_of_users_names(PersonDropDown);
// PolaczenieSQL.list_of_teams_names(TeamDropDown);
// PolaczenieSQL.fill_holidays_by_status(GridViewAppMen, 1);
// PolaczenieSQL.fill_holidays_by_status(GridViewAppHR, 2);
// PolaczenieSQL.fill_holidays_by_status(GridViewZat, 3);
// PolaczenieSQL.fill_holidays_by_status(GridViewRejec, 4);
// PolaczenieSQL.fill_holidays_by_status(GridViewOK, 6);
// PolaczenieSQL.fill_holidays_by_status(GridViewDelete, 7);
//}
h_AppMen.InnerHtml = "Do zatwierdzenia przez menagera (" + GridViewAppMen.Rows.Count + ")";
h_AppHR.InnerHtml = "Do zatwierdzenia przez dział HR (" + GridViewAppHR.Rows.Count + ")";
h_Zat.InnerHtml = "Urlopy zatwierdzone (" + GridViewZat.Rows.Count + ")";
h_OK.InnerHtml = "Urlopy wykorzystane (" + GridViewOK.Rows.Count + ")";
h_Rejec.InnerHtml = "Urlopy odrzucone (" + GridViewRejec.Rows.Count + ")";
h_Delete.InnerHtml = "Urlopy usunięte (" + GridViewDelete.Rows.Count + ")";
DateTime date0 = new DateTime(DateTime.Today.Year, 1, 1);
DateTime date2 = new DateTime(DateTime.Today.Year + 1, 3, 1);
PageMetods.month_calendar_by_holidayid(bigDiv, date0, date2, Context.User.Identity.Name, true, "0", true);
Session.Contents.RemoveAll();
GC.SuppressFinalize(this);
foreach (System.Collections.DictionaryEntry entry in HttpContext.Current.Cache)
{
HttpContext.Current.Cache.Remove((string)entry.Key);
}
}
else
{
//string team1 = Request.Form[TeamDropDown.UniqueID];
//TeamDropDown.Text = team1;
//string user1 = Request.Form[PersonDropDown.UniqueID];
//PersonDropDown.Text = user1;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
string[] days_of_holidays = holidays.PolaczenieSQL.find_holiday_days_byuser(Context.User.Identity.Name);
Labelpr.Text = days_of_holidays[0];
Labelor.Text = days_of_holidays[8];
Labelnr.Text = days_of_holidays[9];
Labeldd.Text = days_of_holidays[5];
Labelnz.Text = days_of_holidays[6];
Labelsum.Text = days_of_holidays[10];
Labelwyk.Text = days_of_holidays[3];
if (Convert.ToInt16(Labelsum.Text) > 0)
{
suncell.BackColor = Color.LightGreen;
}
if (Convert.ToInt16(Labelsum.Text) <= 0)
{
suncell.BackColor = Color.LightPink;
}
List <string> holiday_list = holidays.PolaczenieSQL.find_holiday_byuser(Context.User.Identity.Name);
DataTable td = new DataTable();
td.Columns.Add("From");
td.Columns.Add("To");
td.Columns.Add("Rodzaj");
td.Columns.Add("ManagerId");
td.Columns.Add("Status");
td.Columns.Add("Id");
td.Columns.Add("Ilosc_dni");
DataRow dr = null;
DateTime myTime;
if (holiday_list != null)
{
foreach (string holidayID in holiday_list)
{
holidays.holiday h = holidays.PolaczenieSQL.find_holiday(holidayID);
dr = td.NewRow();
if (h.date_od != null)
{
myTime = DateTime.Parse(h.date_od.ToString());
dr[0] = myTime.ToString("yyyy-MM-dd");
if (h.statusid == "3" && (myTime <= DateTime.Today))
{
h.wykorzystany();
h.status = "Wykonany";
}
}
if (h.date_od != null)
{
myTime = DateTime.Parse(h.date_do.ToString());
dr[1] = myTime.ToString("yyyy-MM-dd");
}
dr[2] = h.rodzaj.ToString();
holidays.user m = holidays.PolaczenieSQL.find_user(h.menager.ToString());
if (m != null)
{
dr[3] = m.ToString();
}
else
{
dr[3] = "User deleted";
}
dr[4] = h.status.ToString();
dr[5] = h.holidayid.ToString();
dr[6] = h.holiday_dyas_all.ToString();
td.Rows.Add(dr);
}
}
GridView1.DataSource = td;
GridView1.DataBind();
holidays.PageMetods.holiday_status_color(GridView1);
DropDownMenager.DataBind();
//if (Request.QueryString["teamadd"] != null)
//{
// string teamadd = Request.QueryString["teamadd"];
// info_label.Text = "Team <b> " + teamadd + "</b> został dodant z bazy danych";
// info_label.CssClass = "goodNotification";
// info_label.Visible = true;
//}
//else { info_label.Text = ""; }
//if (Request.QueryString["nodeleteteamid"] != null && Request.QueryString["nodeleteteamName"] != null && Request.QueryString["userscount"] == null)
//{
// string noteamdeletename = Request.QueryString["nodeleteteamName"];
// string noteamdeleteid = Request.QueryString["nodeleteteamid"];
// info_label.Text = "Nie można usunąc tamu <b>id: " + noteamdeleteid + "</b>. Taki team nie istnieje w bazie danych";
// info_label.CssClass = "failureNotification";
// info_label.Visible = true;
//}
//if (Request.QueryString["deleteteamid"] != null && Request.QueryString["deleteteamName"] != null)
//{
// string teamdeleteid = Request.QueryString["deleteteamid"];
// string teamdeletename = Request.QueryString["deleteteamName"];
// info_label.Text = "Team <b> " + teamdeletename + "</b> (id: " + teamdeleteid + ") został usunięty z bazy danych";
// info_label.CssClass = "failureNotification";
// info_label.Visible = true;
//}
//if (String.Equals(Request.QueryString["userscount"], "1"))
//{
// string teamdeleteid = Request.QueryString["nodeleteteamid"];
// string teamdeletename = Request.QueryString["nodeleteteamName"];
// info_label.Text = "Team <b> " + teamdeletename + "</b> (id: " + teamdeleteid + ") nie może zostac usunięty, gdyż są do niego wciąż podłączeni pracownicy<br />By usunąś team odłącz od niego wszystkich przcowników. <a href='/hr/manageteam.aspx?teamid=" + teamdeleteid + "'>Zarządzaj Teamem " + teamdeletename + "</a>";
// info_label.CssClass = "failureNotification";
// info_label.Visible = true;
//}
}
else
{
string menager1 = Request.Form[DropDownMenager.UniqueID];
DropDownMenager.Text = menager1;
string rodzaj1 = Request.Form[DropDownHoliday.UniqueID];
DropDownHoliday.Text = rodzaj1;
string date1 = Request.Form[OdTextBox.UniqueID];
OdTextBox.Text = date1;
string date3 = Request.Form[DoTextBox.UniqueID];
DoTextBox.Text = date3;
info_label.Text = "";
}
DateTime date0 = new DateTime(DateTime.Today.Year, 1, 1);
DateTime date2 = new DateTime(DateTime.Today.Year + 1, 3, 1);
PageMetods.month_calendar_by_holidayid(bigDiv, date0, date2, Context.User.Identity.Name);
Session.Contents.RemoveAll();
GC.SuppressFinalize(this);
foreach (System.Collections.DictionaryEntry entry in HttpContext.Current.Cache)
{
HttpContext.Current.Cache.Remove((string)entry.Key);
}
}