public void Page_Load(object sender, EventArgs args) { if (!Membership.EnablePasswordReset) { FormsAuthentication.RedirectToLoginPage(); } Msg.Text = ""; if (!IsPostBack) { Msg.ForeColor = Color.Maroon; Msg.Text = "Please supply a username."; if (Request.QueryString["userid"] != null) { string userid = Request.QueryString["userid"]; PolaczenieSQL.list_of_usersid(PersonDropDown, userid); VerifyUsername(); } else { PolaczenieSQL.list_of_usersid(PersonDropDown); } } else { VerifyUsername(); } }
protected void addextraday_Click(object sender, EventArgs e) { List <string> user_name_list = new List <string>(); foreach (GridViewRow row in GridView1.Rows) { if (row.RowType == DataControlRowType.DataRow) { CheckBox chkRow = (row.Cells[2].FindControl("chkRow") as CheckBox); if (chkRow.Checked) { user_name_list.Add(row.Cells[3].Text); chkRow.Checked = false; } } } int addnumber = Convert.ToInt16(TextBoxAdddays.Text); string reasonText = TextBoxReason.Text; if (user_name_list.Count > 0 && addnumber != 0 && reasonText.Length > 0) { PolaczenieSQL.addextraday(user_name_list, addnumber); PolaczenieSQL.addHRhistory(user_name_list, addnumber, reasonText, Context.User.Identity.Name, "Addtional days"); Response.Redirect("manageusers.aspx"); } }
protected void ZapiszButton_Click(object sender, EventArgs e) { Page.Validate(); if (Page.IsValid) { using (SqlConnection conn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["ApplicationServices"].ConnectionString)) { conn.Open(); string sql = "INSERT INTO Teams (Name, Menager) VALUES (@name, @menager)"; SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.Add("@name", SqlDbType.VarChar, 50).Value = addTeamNameTextBox.Text; cmd.Parameters.Add("@menager", SqlDbType.VarChar, 50).Value = DropDownMenager.SelectedValue; cmd.CommandType = CommandType.Text; cmd.ExecuteNonQuery(); conn.Close(); cmd.Cancel(); } List <string> userlist = new List <string>(); userlist.Add(addTeamNameTextBox.Text); PolaczenieSQL.addHRhistory(userlist, 0, "Team '" + addTeamNameTextBox.Text + "' was created", Context.User.Identity.Name, "Teams actions"); user u = PolaczenieSQL.find_user(DropDownMenager.SelectedValue); PolaczenieSQL.addHRhistory(userlist, 0, "Team '" + addTeamNameTextBox.Text + "' has new meanger " + u.ToString(), Context.User.Identity.Name, "Teams actions"); string team_name = addTeamNameTextBox.Text; string url_text = "menageteams.aspx?teamadd=" + team_name; Response.Redirect(url_text); } }
protected void hrhistory_Click(object sender, CommandEventArgs e) { //Page.Validate(); if (Page.IsValid) { string from = OdTextBox.Text; string to = DoTextBox.Text; DataTable dt2 = PolaczenieSQL.find_HistoryHR(from, to, e.CommandArgument.ToString()); GridViewHistoryHR.DataSource = dt2; GridViewHistoryHR.DataBind(); if (e.CommandArgument.ToString() == "team" || e.CommandArgument.ToString() == "newyear") { GridViewHistoryHR.Columns[0].Visible = true; GridViewHistoryHR.Columns[1].Visible = true; GridViewHistoryHR.Columns[2].Visible = true; GridViewHistoryHR.Columns[3].Visible = true; GridViewHistoryHR.Columns[4].Visible = true; GridViewHistoryHR.Columns[5].Visible = true; GridViewHistoryHR.Columns[6].Visible = true; GridViewHistoryHR.Columns[7].Visible = false; } else { GridViewHistoryHR.Columns[0].Visible = true; GridViewHistoryHR.Columns[1].Visible = true; GridViewHistoryHR.Columns[2].Visible = true; GridViewHistoryHR.Columns[3].Visible = true; GridViewHistoryHR.Columns[4].Visible = true; GridViewHistoryHR.Columns[5].Visible = true; GridViewHistoryHR.Columns[6].Visible = true; GridViewHistoryHR.Columns[7].Visible = true; } foreach (GridViewRow row in GridViewHistoryHR.Rows) { row.Height = 40; } switch (e.CommandArgument.ToString()) { case "team": LabelOperation.Text = "TEAMS OPERATIONS"; break; case "functions": LabelOperation.Text = "PERSON FUNCTION OPERATIONS"; break; case "newyear": LabelOperation.Text = "NEW YEAR OPERATIONS"; break; default: LabelOperation.Text = "PERSONAL OPERATIONS"; break; } } }
protected void delete_Click(object sender, EventArgs e) { holiday h = PolaczenieSQL.find_holiday(this.l_id.Text); h.deleted(Context.User.Identity.Name); string url_text = "menager_holiday.aspx?holidayid=" + this.l_id.Text; Response.Redirect(url_text); }
protected void DodajButton_Click(object sender, EventArgs e) { Page.Validate(); if (Page.IsValid) { PolaczenieSQL.insertswieto(DateTextBox.Text, NameTextBox.Text); string url_text = "hrsettings.aspx"; Response.Redirect(url_text); } }
protected void ZapiszButton_Click(object sender, EventArgs e) { //Page.Validate(); if (Page.IsValid) { holiday h = new holiday(OdTextBox.Text, DoTextBox.Text, DropDownMenager.SelectedValue, "1", "1", DropDownHoliday.SelectedValue, Context.User.Identity.Name); user u = PolaczenieSQL.find_user(Context.User.Identity.Name, false, true); PolaczenieSQL.insertholiday(h, u); string url_text = "myholidays.aspx"; Response.Redirect(url_text); } }
public void GridViewSwieta_RowCommand(Object sender, GridViewCommandEventArgs e) { if (e.CommandName == "usun") { int index = Convert.ToInt32(e.CommandArgument); GridViewRow row = GridViewSwieta.Rows[index]; string idvalue = row.Cells[3].Text as string; string name_sw = row.Cells[1].Text as string; PolaczenieSQL.usunswieto(idvalue); string url_text = "hrsettings.aspx?holidaydeleted=" + name_sw; Response.Redirect(url_text); } }
protected void NowyRokButton_Click(object sender, EventArgs e) { PolaczenieSQL.updateNewyear(); List <string> userlist = new List <string>(); userlist.Add("All employee"); PolaczenieSQL.addHRhistory(userlist, 0, "New Year calculations", Context.User.Identity.Name, "New Year calculations"); string url_text = "hrsettings.aspx"; Response.Redirect(url_text); }
void Page_Load(object sender, EventArgs e) { if (Request.QueryString["pathid"] != null) { // Create new PDF document PdfDocument document = new PdfDocument(); document.Info.Title = "PDFsharp Clock Demo"; document.Info.Author = "Stefan Lange"; document.Info.Subject = "Server time: "; // Create new page PdfPage page = document.AddPage(); XGraphics gfx = XGraphics.FromPdfPage(page); XFont font = new XFont("Verdana", 12, XFontStyle.Regular); double x = 100, y = 100; double ls = font.GetHeight(gfx); string[] strinData = PolaczenieSQL.print_history_pdf(Request.QueryString["pathid"]); // Draw the text gfx.DrawString("Action: " + strinData[6], font, XBrushes.Black, x, y); y += ls; gfx.DrawString("Action Id: " + strinData[0], font, XBrushes.Black, x, y); y += ls; gfx.DrawString("Employe: " + strinData[1], font, XBrushes.Black, x, y); y += ls; gfx.DrawString("HR employee: " + strinData[2], font, XBrushes.Black, x, y); y += ls; gfx.DrawString("Days count: " + strinData[3], font, XBrushes.Black, x, y); y += ls; gfx.DrawString("Reason: " + strinData[4], font, XBrushes.Black, x, y); y += ls; gfx.DrawString("Date: " + strinData[5], font, XBrushes.Black, x, y); // Send PDF to browser MemoryStream stream = new MemoryStream(); document.Save(stream, false); Response.Clear(); Response.ContentType = "application/pdf"; Response.AddHeader("content-length", stream.Length.ToString()); Response.BinaryWrite(stream.ToArray()); Response.Flush(); stream.Close(); Response.End(); } }
protected void RepeaterYears_ItemCommand(object source, RepeaterCommandEventArgs e) { int year = Convert.ToInt16(e.CommandArgument); LabelYear.Text = "Holidays " + year.ToString(); DataTable dt = PolaczenieSQL.find_swieta(year); GridViewSwieta.Columns[0].Visible = true; GridViewSwieta.Columns[1].Visible = true; GridViewSwieta.Columns[2].Visible = true; GridViewSwieta.Columns[3].Visible = true; GridViewSwieta.DataSource = dt; GridViewSwieta.DataBind(); GridViewSwieta.Columns[3].Visible = false; }
protected void ZapiszButton_Click(object sender, EventArgs e) { Page.Validate(); if (Page.IsValid) { string teamID = Request.QueryString["teamid"]; if (string.IsNullOrEmpty(teamID)) { Response.Redirect("menageteams.aspx"); } string teame_name = addTeamNameTextBox.Text; string selected_menager = DropDownMenager.SelectedValue; using (SqlConnection conn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["ApplicationServices"].ConnectionString)) { conn.Open(); string sql = "UPDATE Teams SET Name = @name, Menager = @menager Where Id = @id"; SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.Add("@id", SqlDbType.VarChar, 50).Value = teamID; cmd.Parameters.Add("@name", SqlDbType.VarChar, 50).Value = teame_name; cmd.Parameters.Add("@menager", SqlDbType.VarChar, 50).Value = selected_menager; cmd.ExecuteNonQuery(); cmd.Cancel(); conn.Close(); } if (addTeamNameTextBox.Text != HiddenFieldTeamName.Value) { List <string> userlist = new List <string>(); userlist.Add(HiddenFieldTeamName.Value); PolaczenieSQL.addHRhistory(userlist, 0, "Team '" + HiddenFieldTeamName.Value + "' change name to '" + addTeamNameTextBox.Text + "'", Context.User.Identity.Name, "Teams actions"); } if (DropDownMenager.SelectedItem.Text != HiddenFieldMenager.Value) { List <string> menagerlist = new List <string>(); menagerlist.Add(addTeamNameTextBox.Text); PolaczenieSQL.addHRhistory(menagerlist, 0, "Team '" + HiddenFieldTeamName.Value + "' change menager to " + DropDownMenager.SelectedItem.Text, Context.User.Identity.Name, "Teams actions"); } } Response.Redirect(Request.RawUrl); }
public void ResetPassword_OnClick(object sender, EventArgs args) { string newPassword; u = Membership.GetUser(PersonDropDown.Text, false); if (u == null) { Msg.ForeColor = Color.Maroon; Msg.Text = "Username " + Server.HtmlEncode(PersonDropDown.Text) + " not found. Please check the value and re-enter."; return; } try { newPassword = u.ResetPassword(); } catch (MembershipPasswordException e) { Msg.ForeColor = Color.Maroon; Msg.Text = "Invalid password answer. Please re-enter and try again."; return; } catch (Exception e) { Msg.Text = e.Message; return; } if (newPassword != null) { Msg.ForeColor = Color.DarkGreen; Msg.Text = "Password reset. Your new password is: "; Msg2.Text = Server.HtmlEncode(newPassword); mailSender.SendMailPassRestart(Server.HtmlEncode(newPassword), u.Email, u.ToString()); PolaczenieSQL.updatepasstemp("yes", u.UserName); } else { Msg.Text = "Password reset failed. Please re-enter your values and try again."; } }
protected void from20t026_Click(object sender, EventArgs e) { List <string> user_name_list = new List <string>(); foreach (GridViewRow row in GridView1.Rows) { if (row.RowType == DataControlRowType.DataRow) { CheckBox chkRow = (row.Cells[2].FindControl("chkRow") as CheckBox); if (chkRow.Checked) { user_name_list.Add(row.Cells[3].Text); chkRow.Checked = false; } } } if (user_name_list.Count > 0) { PolaczenieSQL.update20to26(user_name_list, Context.User.Identity.Name, "2"); PolaczenieSQL.addHRhistory(user_name_list, 0, "Employee reach proper expierience", Context.User.Identity.Name, "Go from 20 to 26 holidays days"); Response.Redirect("manageusers.aspx"); } }
protected void delete_btn_Click(object sender, EventArgs e) { string teamID = Request.QueryString["deleteteamid"]; if (string.IsNullOrEmpty(teamID)) { Response.Redirect("menageteams.aspx"); } string teamName = Request.QueryString["deleteteamName"]; if (string.IsNullOrEmpty(teamName)) { Response.Redirect("menageteams.aspx"); } using (SqlConnection conn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["ApplicationServices"].ConnectionString)) { conn.Open(); string sql = "DELETE FROM Teams Where Id = @id"; SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.Add("@id", SqlDbType.VarChar, 50).Value = teamID; cmd.ExecuteNonQuery(); conn.Close(); cmd.Cancel(); } List <string> userlist = new List <string>(); userlist.Add(teamName); PolaczenieSQL.addHRhistory(userlist, 0, "Team '" + teamName + "' was removed", Context.User.Identity.Name, "Teams actions"); string url_text = "menageteams.aspx?deleteteamid=" + teamID + "&deleteteamName=" + teamName; Response.Redirect(url_text); }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { // If querystring value is missing, send the user to ManageUsers.aspx string userName = Context.User.Identity.Name; //if (string.IsNullOrEmpty(userName)) // Response.Redirect("manageusers.aspx"); holidays.user u = PolaczenieSQL.find_user(userName, false, true); // Get information about this user MembershipUser usr = Membership.GetUser(userName); //if (usr == null) // Response.Redirect("manageusers.aspx"); user_name_label.InnerText = "User Account: " + usr.UserName; TextBox_email.Text = usr.Email; //HiddenFielduserid.Value = usr.UserName; if (Roles.IsUserInRole(usr.UserName, "emploee")) { Pracownik.Checked = true; } if (Roles.IsUserInRole(usr.UserName, "hr_emploee")) { PracownikHR.Checked = true; } if (Roles.IsUserInRole(usr.UserName, "Administrators")) { PracownikAdmin.Checked = true; } if (Roles.IsUserInRole(usr.UserName, "menager")) { PracownikMenager.Checked = true; } ImieTextBox.Text = u.imie.ToString(); NazwiskoTextBox.Text = u.nazwisko.ToString(); PeselTextBox.Text = u.pesel.ToString(); string data_urodz = u.data_urodzenia.ToString(); string data_zatrudnienia = u.data_zatrudnienia.ToString(); string kiedy26 = u.kiedy26.ToString(); TeamTextBox.Text = u.team.ToString(); string[] days_of_holidays = holidays.PolaczenieSQL.find_holiday_days_byuser(usr.UserName); 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; } DateTime myTime; if (data_urodz != string.Empty) { myTime = DateTime.Parse(data_urodz); Dataurodzenia.Text = myTime.ToString("dd-MM-yyyy"); } if (data_zatrudnienia != string.Empty) { myTime = DateTime.Parse(data_zatrudnienia); DataZatrudnienia.Text = myTime.ToString("dd-MM-yyyy"); } switch (u.dniurlopowe.ToString()) { case "1": DropDownList2TextBox.Text = "20"; break; case "2": DropDownList2TextBox.Text = "26"; break; default: DropDownList2TextBox.Text = "26"; break; } if (u.dniurlopowe.ToString() == "1") { uzyska26label.Visible = true; uzyska26TextBox.Visible = true; if (kiedy26 != string.Empty) { myTime = DateTime.Parse(kiedy26); uzyska26TextBox.Text = myTime.ToString("dd-MM-yyyy"); } } if (u.passtemp.ToString() == "True") { info_label.Visible = true; info_label.Text = "Your password is setup as tempolary. Please change your password now!"; } else { info_label.Visible = false; } } }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { int todayy = DateTime.Today.Year; LabelYear.Text = "Holidays " + todayy.ToString(); List <int> years = new List <int>(new int[] { todayy - 1, todayy, todayy + 1 }); RepeaterYears.DataSource = years; RepeaterYears.DataBind(); DataTable dt = PolaczenieSQL.find_swieta(todayy); GridViewSwieta.Columns[0].Visible = true; GridViewSwieta.Columns[1].Visible = true; GridViewSwieta.Columns[2].Visible = true; GridViewSwieta.Columns[3].Visible = true; GridViewSwieta.DataSource = dt; GridViewSwieta.DataBind(); GridViewSwieta.Columns[3].Visible = false; LabelOperation.Text = "PERSONAL OPERATIONS"; string to = DateTime.Today.ToShortDateString(); string from = DateTime.Today.AddDays(-30).ToShortDateString(); OdTextBox.Text = from; DoTextBox.Text = to; DataTable dt2 = PolaczenieSQL.find_HistoryHR(from, to, "personal"); GridViewHistoryHR.DataSource = dt2; GridViewHistoryHR.DataBind(); foreach (GridViewRow row in GridViewHistoryHR.Rows) { row.Height = 40; } GridViewHistoryHR.Columns[0].Visible = true; GridViewHistoryHR.Columns[1].Visible = true; GridViewHistoryHR.Columns[2].Visible = true; GridViewHistoryHR.Columns[3].Visible = true; GridViewHistoryHR.Columns[4].Visible = true; GridViewHistoryHR.Columns[5].Visible = true; GridViewHistoryHR.Columns[6].Visible = true; GridViewHistoryHR.Columns[7].Visible = true; string calculation_date = PolaczenieSQL.calculationdate(); DateTime myTime1 = DateTime.Today; DateTime myTime2 = DateTime.Today.AddDays(-1); if (calculation_date != string.Empty) { myTime2 = DateTime.Parse(calculation_date); //this.date_od = DateTime.ParseExact(odtext, "yyyy-MM-dd", CultureInfo.InvariantCulture); } TimeSpan span = myTime1 - myTime2; int totalnumber = Convert.ToInt16(span.TotalDays); string calculation_string = ""; if (totalnumber < 0) { calculation_string = "No action occure in past"; LabelLastCalculation.Text = calculation_string; LabelLastCalculation.ForeColor = Color.Gray; } else if (totalnumber >= 0 && totalnumber < 365) { calculation_string = "Last action: " + myTime2.ToShortDateString() + "; " + totalnumber + " days ago"; LabelLastCalculation.Text = calculation_string; LabelLastCalculation.ForeColor = Color.DarkGreen; } else { calculation_string = "Last action: " + myTime2.ToShortDateString() + "; " + totalnumber + " days ago"; LabelLastCalculation.Text = calculation_string; LabelLastCalculation.ForeColor = Color.Crimson; } } else { string menager1 = Request.Form[DateTextBox.UniqueID]; DateTextBox.Text = menager1; string date1 = Request.Form[NameTextBox.UniqueID]; NameTextBox.Text = date1; string dateod = Request.Form[OdTextBox.UniqueID]; OdTextBox.Text = dateod; string datedo = Request.Form[DoTextBox.UniqueID]; DoTextBox.Text = datedo; } if (Request.QueryString["holidaydeleted"] != null) { string usersdelete = Request.QueryString["holidaydeleted"]; info_label.Text = "Święto z dnia " + usersdelete + " zostało usunięte z listy"; info_label.Visible = true; } }
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 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; } }
/// <summary> /// Funkcja zwraca po³¹czenie SQL (istniej¹ce lub tworzy nowe) /// </summary> /// <returns></returns> private static PolaczenieSQL getPolaczenieSql() { lock (connectionList) { PolaczenieSQL polaczenieSQL; PolaczenieSQL polaczenieSQLdostepne = null; for (int i=connectionList.Count-1; i >= 0; i--) { polaczenieSQL = (PolaczenieSQL)connectionList[i]; if (polaczenieSQL.Aktualnie_wykorzystywane) continue; if (polaczenieSQLdostepne == null) { polaczenieSQL.Czas_ostatniego_uzycia = DateTime.Now; polaczenieSQL.Aktualnie_wykorzystywane = true; polaczenieSQLdostepne = polaczenieSQL; } //usuwamy nieu¿ywane if (polaczenieSQL.Czas_ostatniego_uzycia.AddSeconds(Dopuszczalny_czas_bezczynnosci).CompareTo(DateTime.Now) < 0) { connectionList.RemoveAt(i); } } //jesli nie ma istniej¹cego, dostêpnego po³¹czenia to tworzymy nowe if (polaczenieSQLdostepne == null) { if (Dopuszczalna_liczba_polaczen > 0 && connectionList.Count >= Dopuszczalna_liczba_polaczen) throw new Exception("Przekroczona liczba po³¹czeñ SQL"); SqlConnection connection = new SqlConnection(); connection.ConnectionString = connectionString; try { connection.Open(); } catch (SqlException e) { throw new Exception(e.Message); } if (connection.State != ConnectionState.Open) throw new Exception("Brak po³¹czenia"); polaczenieSQLdostepne = new PolaczenieSQL(); polaczenieSQLdostepne.SqlConn = connection; polaczenieSQLdostepne.Czas_ostatniego_uzycia = DateTime.Now; polaczenieSQLdostepne.Aktualnie_wykorzystywane = true; connectionList.Add(polaczenieSQLdostepne); } return polaczenieSQLdostepne; } }
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 teamid = Request.QueryString["teamid"]; PolaczenieSQL.list_of_users_names(PersonDropDown); PolaczenieSQL.list_of_teams_names(TeamDropDown, teamid); PolaczenieSQL.fill_holidays_by_status(GridViewAppMen, 1, team_id: teamid); PolaczenieSQL.fill_holidays_by_status(GridViewAppHR, 2, team_id: teamid); PolaczenieSQL.fill_holidays_by_status(GridViewZat, 3, team_id: teamid); PolaczenieSQL.fill_holidays_by_status(GridViewRejec, 4, team_id: teamid); PolaczenieSQL.fill_holidays_by_status(GridViewOK, 6, team_id: teamid); PolaczenieSQL.fill_holidays_by_status(GridViewDelete, 7, team_id: teamid); } 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 + ")"; 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) { PolaczenieSQL.updatepasstemp("no", Context.User.Identity.Name); }