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);
}
