private void gridAktivita_CellMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e) { ZamestnanecFactory zamestnanecFactory = new ZamestnanecFactory(); ZamestnanecGateway <Zamestnanec> zg = (ZamestnanecGateway <Zamestnanec>)zamestnanecFactory.GetZamestnanec(); zamestananec = zg.Select(); Active t = GetSelectedData(); foreach (var i in zamestananec) { if (t.Name.Equals(i.Name, StringComparison.Ordinal) && t.Surname.Equals(i.LastName, StringComparison.Ordinal)) { info.Text = "Meno: " + i.Name + "\n" + "Prievisko: " + i.LastName + "\n" + "Rodne cislo: " + i.PerIdNum + "\n" + "Bydlisko: " + i.Adress + "\n" + "Pohlavie: " + i.Sex; } } }
protected void Page_Load(object sender, EventArgs e) { ZamestnanecFactory zamestnanecFactory = new ZamestnanecFactory(); ZamestnanecGateway <Zamestnanec> zg = (ZamestnanecGateway <Zamestnanec>)zamestnanecFactory.GetZamestnanec(); Zamestnanec zamestnanec = zg.Select_id(int.Parse((Session["ID"].ToString()))); NepritomnostFactory nepritomnostFactory = new NepritomnostFactory(); NepritomnostGateway <Nepritomnost> ng = (NepritomnostGateway <Nepritomnost>)nepritomnostFactory.GetNepritomnost(); Collection <Nepritomnost> nepritomnost = ng.Select_id_zam(zamestnanec.RecordId); Collection <DateTime> datesick1 = new Collection <DateTime>(); Collection <Active> datasick = new Collection <Active>(); NeschopenkaFactory neschopenkaFactory = new NeschopenkaFactory(); NeschopenkaGateway <Neschopenka> ne = (NeschopenkaGateway <Neschopenka>)neschopenkaFactory.GetNeschopenka(); Collection <Neschopenka> za = ne.Select(); foreach (var i in nepritomnost) { foreach (var a in za) { if (a.Nepritomnost == i.RecordId) { datasick.Add(new Active(i.Datum, "Send")); } else { datasick.Add(new Active(i.Datum, "Nothing")); datesick1.Add(i.Datum); } } } if (!IsPostBack) { GridView1.DataSource = datasick; GridView1.DataBind(); DropDownList1.DataSource = datesick1; DropDownList1.DataBind(); } }
protected void uploadButton_Click1(object sender, EventArgs e) { ZamestnanecFactory zamestnanecFactory = new ZamestnanecFactory(); ZamestnanecGateway <Zamestnanec> zg = (ZamestnanecGateway <Zamestnanec>)zamestnanecFactory.GetZamestnanec(); Zamestnanec zamestnanec = zg.Select_id(int.Parse((Session["ID"].ToString()))); NepritomnostFactory nepritomnostFactory = new NepritomnostFactory(); NepritomnostGateway <Nepritomnost> ng = (NepritomnostGateway <Nepritomnost>)nepritomnostFactory.GetNepritomnost(); Collection <Nepritomnost> nepritomnost = ng.Select_id_zam(zamestnanec.RecordId); foreach (Nepritomnost h in nepritomnost) { if (h.Datum.ToString() == DropDownList1.SelectedItem.ToString()) { nesch.Nepritomnost = h.RecordId; } } NeschopenkaFactory neschopenkaFactory = new NeschopenkaFactory(); NeschopenkaGateway <Neschopenka> ne = (NeschopenkaGateway <Neschopenka>)neschopenkaFactory.GetNeschopenka(); Collection <Neschopenka> za = ne.Select(); int id = 0; foreach (var nep in za) { if (nep.RecordId > id) { id = nep.RecordId; } } id++; nesch.Text = TextBox1.Text.ToString(); nesch.Datum = DateTime.Now; ne.Insert(nesch); }
public void OpenRecord(object primaryKey) { if (primaryKey != null) { int idZamestnanca = (int)primaryKey; ZamestnanecFactory zamestnanecFactory = new ZamestnanecFactory(); ZamestnanecGateway <Zamestnanec> zg = (ZamestnanecGateway <Zamestnanec>)zamestnanecFactory.GetZamestnanec(); zamestnanec = zg.Select_id(idZamestnanca); } else { zamestnanec = new Zamestnanec(); } }
protected void SaveRecord() { foreach (var i in p) { if (i.Name.Equals(projektCombo.Text, StringComparison.Ordinal)) { zamestnanec.IdProject = i.RecordId; ZamestnanecFactory zamestnanecFactory = new ZamestnanecFactory(); ZamestnanecGateway <Zamestnanec> zg = (ZamestnanecGateway <Zamestnanec>)zamestnanecFactory.GetZamestnanec(); zg.Update(zamestnanec); } } }
private void button1_Click_2(object sender, EventArgs e) { string a; Collection <Active> active = new Collection <Active>(); foreach (var i in pracovisko) { if (i.Name.Equals(pracoviskoCombo.Text, StringComparison.Ordinal)) { ZamestnanecFactory zamestnanecFactory = new ZamestnanecFactory(); ZamestnanecGateway <Zamestnanec> zg = (ZamestnanecGateway <Zamestnanec>)zamestnanecFactory.GetZamestnanec(); a = zg.AktualnePritomny(i.RecordId, null); string[] words = a.Split(';'); foreach (var word in words) { string[] words2 = word.Split(','); int counter = 0; bool b = false; Active t = new Active(); foreach (var word1 in words2) { if (counter == 0) { t.Name = word1; } if (counter == 1) { t.Surname = word1; } if (counter == 2) { t.State = word1; if (t.State == "Nepritomny") { NepritomnostFactory nepritomnostFactory = new NepritomnostFactory(); NepritomnostGateway <Nepritomnost> ng = (NepritomnostGateway <Nepritomnost>)nepritomnostFactory.GetNepritomnost(); Zamestnanec z = zg.Select_name(t.Name, t.Surname); Collection <Nepritomnost> za = ng.Select(); int id = 0; foreach (var nep in za) { if (nep.RecordId > id) { id = nep.RecordId; } } id++; Nepritomnost n = new Nepritomnost(id, z.RecordId, DateTime.Now); ng.Insert(n); } b = true; } counter++; } if (b) { active.Add(t); } } } } }
protected void Page_Load(object sender, EventArgs e) { ZamestnanecFactory zamestnanecFactory = new ZamestnanecFactory(); ZamestnanecGateway <Zamestnanec> zg = (ZamestnanecGateway <Zamestnanec>)zamestnanecFactory.GetZamestnanec(); if (Session["ID"] == null) { Response.Redirect("~/Login.aspx"); } zamestnanec = zg.Select_id(int.Parse((Session["ID"].ToString()))); newZamestnanec = zamestnanec; nameElement.Attributes.Add("placeholder", zamestnanec.Name); surnameElement.Attributes.Add("placeholder", zamestnanec.LastName); perIdNumElement.Attributes.Add("placeholder", zamestnanec.PerIdNum.ToString()); adressElement.Attributes.Add("placeholder", zamestnanec.Adress); sexElement.Attributes.Add("placeholder", zamestnanec.Sex); workGroupElement.Attributes.Add("placeholder", zamestnanec.WorkGroup.ToString()); projectElement.Attributes.Add("placeholder", zamestnanec.IdProject.ToString()); positionElemnt.Attributes.Add("placeholder", zamestnanec.Group.ToString()); mailElement.Attributes.Add("placeholder", zamestnanec.Mail); password1.Attributes.Add("placeholder", "********"); password2.Attributes.Add("placeholder", "********"); oldPasswordElement.Attributes.Add("placeholder", "********"); }
public bool OpenRecord(object primaryKey) { if (primaryKey != null) { int idZamestnanca = (int)primaryKey; ZamestnanecFactory zamestnanecFactory = new ZamestnanecFactory(); ZamestnanecGateway <Zamestnanec> zg = (ZamestnanecGateway <Zamestnanec>)zamestnanecFactory.GetZamestnanec(); zamestnanec = zg.Select_id(idZamestnanca); newRecord = false; } else { zamestnanec = new Zamestnanec(); newRecord = true; } BindData(); return(true); }
protected bool SaveRecord() { if (GetData()) { if (newRecord) { ZamestnanecFactory zamestnanecFactory = new ZamestnanecFactory(); ZamestnanecGateway <Zamestnanec> zg = (ZamestnanecGateway <Zamestnanec>)zamestnanecFactory.GetZamestnanec(); zg.Insert(zamestnanec); } else { ZamestnanecFactory zamestnanecFactory = new ZamestnanecFactory(); ZamestnanecGateway <Zamestnanec> zg = (ZamestnanecGateway <Zamestnanec>)zamestnanecFactory.GetZamestnanec(); zg.Update(zamestnanec); } return(true); } else { return(false); } }
private void button1_Click(object sender, EventArgs e) { foreach (var i in w) { if (i.Name.Equals(comboWork.Text, StringComparison.Ordinal)) { z.WorkGroup = i.RecordId; } } foreach (var i in p) { if (i.Name.Equals(comboProject.Text, StringComparison.Ordinal)) { z.IdProject = i.RecordId; } } foreach (var i in s) { if (i.Name.Equals(comboGroup.Text, StringComparison.Ordinal)) { z.Group = i.RecordId; } } z.Sex = comboSex.Text; z.Mail = textBox1.Text; z.Heslo = textBox2.Text; z.Vypis = Convert.ToInt32(textBox3.Text); bool vall = true; string a = ""; if (z.Name.Equals(a)) { meno.Text = "Prosim zadajte meno"; vall = false; } else { meno.Text = ""; } if (z.LastName.Equals(a)) { prie.Text = "Prosim zadajte priezvisko"; vall = false; } else { prie.Text = ""; } if (z.Adress.Equals(a)) { adre.Text = "Prosim zadajte adresu"; vall = false; } else { adre.Text = ""; } if (z.PerIdNum == 0) { rodn.Text = "Prosim zadajte rodne cislo"; vall = false; } else { rodn.Text = ""; } if (a.Equals(comboWork.Text)) { work.Text = "Prosim vyberte pracovisko"; vall = false; } else { work.Text = ""; } if (a.Equals(comboGroup.Text)) { gru.Text = "Prosim vyberte skupinu"; vall = false; } else { gru.Text = ""; } if (a.Equals(comboProject.Text)) { ptoj.Text = "Prosim vyberte projekt"; vall = false; } else { ptoj.Text = ""; } if (a.Equals(comboSex.Text)) { pohl.Text = "Prosim vyberte pohlavie"; vall = false; } else { pohl.Text = ""; } if (z.Mail.Equals(a)) { lmail.Text = "Prosim zadajte Mail"; vall = false; } else { lmail.Text = ""; } if (z.Heslo.Equals(a)) { lheslo.Text = "Prosim zadajte heslo"; vall = false; } else { lheslo.Text = ""; } if (z.Vypis == 0) { lvypis.Text = "Prosim zadajte priezvisko"; vall = false; } else { lvypis.Text = ""; } if (vall) { ZamestnanecFactory zamestnanecFactory = new ZamestnanecFactory(); ZamestnanecGateway <Zamestnanec> zg = (ZamestnanecGateway <Zamestnanec>)zamestnanecFactory.GetZamestnanec(); zg.Insert(z); Close(); } }
private void acceptButton_Click(object sender, EventArgs e) { Zamestnanec zamestnanec = new Zamestnanec(0, mailInput.Text, passwordInput.Text); ZamestnanecFactory zamestnanecFactory = new ZamestnanecFactory(); ZamestnanecGateway <Zamestnanec> zg = (ZamestnanecGateway <Zamestnanec>)zamestnanecFactory.GetZamestnanec(); Zamestnanec zam; if (Functions.IsValidEmail(mailInput.Text)) { if (passwordInput.Text.Length > 5) { zam = zg.CheckPassword(zamestnanec); if (zg.CheckPassword(zamestnanec) != null) { if (zam.Group == 12) { this.Dispose(); } else { MessageBox.Show("You have not permission!", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } else { MessageBox.Show("You enetered wrong credentials, try again!", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } else { MessageBox.Show("Password is too short!", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } else { MessageBox.Show("You entered invalid mail address!", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning); } }
private void button1_Click(object sender, EventArgs e) { step = new Collection <Step>(); string a = comboZam.Text; string result = "1"; string[] word = a.Split(' '); foreach (var i in z) { if (word[0].Equals(i.Name, StringComparison.Ordinal) && word[1].Equals(i.LastName, StringComparison.Ordinal)) { ZamestnanecFactory zamestnanecFactory = new ZamestnanecFactory(); ZamestnanecGateway <Zamestnanec> zg = (ZamestnanecGateway <Zamestnanec>)zamestnanecFactory.GetZamestnanec(); if (s < k || i != null) { result = zg.CheckEmp(i.RecordId, s, k, null); } else { MessageBox.Show("Choose dates!", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } } string[] word1 = result.Split(';'); foreach (var j in word1) { string[] word2 = j.Split(','); int counter = 0; Step steps = new Step(); foreach (var k in word2) { if (counter == 0) { steps.Date = k; } if (counter == 1) { steps.Status = k; } counter++; } step.Add(steps); } BindingList <Step> Bactive = new BindingList <Step>(step); gridStep.AutoGenerateColumns = false; gridStep.DataSource = Bactive; }
public FormAttendance() { ZamestnanecFactory zamestnanecFactory = new ZamestnanecFactory(); ZamestnanecGateway <Zamestnanec> zg = (ZamestnanecGateway <Zamestnanec>)zamestnanecFactory.GetZamestnanec(); z = zg.Select(); PracoviskoFactory pracoviskoFactory = new PracoviskoFactory(); PracoviskoGateway <Pracovisko> pg = (PracoviskoGateway <Pracovisko>)pracoviskoFactory.GetPracovisko(); p = pg.Select(); InitializeComponent(); loadWork(); }
protected void profileConfirmButton_Click1(object sender, EventArgs e) { ZamestnanecFactory zamestnanecFactory = new ZamestnanecFactory(); ZamestnanecGateway <Zamestnanec> zg = (ZamestnanecGateway <Zamestnanec>)zamestnanecFactory.GetZamestnanec(); bool toInsert = true; string errorMessage = ""; if (!string.IsNullOrWhiteSpace(nameElement.Text)) { newZamestnanec.Name = nameElement.Text; } if (!string.IsNullOrWhiteSpace(surnameElement.Text)) { newZamestnanec.LastName = surnameElement.Text; } if (!string.IsNullOrWhiteSpace(mailElement.Text)) { if (Functions.IsValidEmail(mailElement.Text)) { newZamestnanec.Mail = mailElement.Text; } else { toInsert = false; errorMessage = "Entered Mail is invalid."; } } if (!string.IsNullOrWhiteSpace(password1.Text) && !string.IsNullOrWhiteSpace(password2.Text)) { if (password1.Text == password2.Text && password1.Text.Length > 5 && oldPasswordElement.Text == zamestnanec.Heslo) { newZamestnanec.Heslo = password1.Text; } else { errorMessage = "An error occured, password is too short or does not match."; toInsert = false; } } if (toInsert) { zg.Update(newZamestnanec); Response.Redirect("~/Profile.aspx"); } else { ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", "alert('" + errorMessage + "');window.location ='ChangeProfile.aspx';", true); } }
public FormAktualny_stav() { ZamestnanecFactory zamestnanecFactory = new ZamestnanecFactory(); ZamestnanecGateway <Zamestnanec> zg = (ZamestnanecGateway <Zamestnanec>)zamestnanecFactory.GetZamestnanec(); zamestananec = zg.Select(); InitializeComponent(); pracoviskoCombo_Load(); }
protected void Button1_Click(object sender, EventArgs e) { ZamestnanecFactory zamestnanecFactory = new ZamestnanecFactory(); ZamestnanecGateway <Zamestnanec> zg = (ZamestnanecGateway <Zamestnanec>)zamestnanecFactory.GetZamestnanec(); string login = String.Format("{0}", Request.Form["loginInput"]); string password = String.Format("{0}", Request.Form["passwordInput"]); Zamestnanec zamestnanec = new Zamestnanec(); zamestnanec.Heslo = password; zamestnanec.Mail = login; if (string.IsNullOrWhiteSpace(login)) { ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", "alert('No mail was entered');window.location ='ChangeProfile.aspx';", true); } else if (!Functions.IsValidEmail(login)) { ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", "alert('You entered non-valid email address');window.location ='ChangeProfile.aspx';", true); } else if (string.IsNullOrWhiteSpace(password)) { ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", "alert('You entered non-valid password');window.location ='ChangeProfile.aspx';", true); } else { Zamestnanec za = zg.CheckPassword(zamestnanec); if (za != null) { Session["ID"] = za.RecordId; Session["login"] = za.Mail; Response.Redirect("~/Home.aspx"); } else { ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", "alert('Wrong credentials!');window.location ='ChangeProfile.aspx';", true); } } }
private void gridAktivita_CellContentClick(object sender, DataGridViewCellEventArgs e) { if (gridAktivita.Columns[e.ColumnIndex].Name == "Pritomny") { ZamestnanecFactory zamestnanecFactory = new ZamestnanecFactory(); ZamestnanecGateway <Zamestnanec> zg = (ZamestnanecGateway <Zamestnanec>)zamestnanecFactory.GetZamestnanec(); zamestananec = zg.Select(); Active t = GetSelectedData(); DateTime date1 = DateTime.Now; foreach (var i in zamestananec) { if (t.Name.Equals(i.Name, StringComparison.Ordinal) && t.Surname.Equals(i.LastName, StringComparison.Ordinal)) { Historia_pristupuFactory historia_pristupuFactory = new Historia_pristupuFactory(); Historia_pristupuGateway <Historia_pristupu> hg = (Historia_pristupuGateway <Historia_pristupu>)historia_pristupuFactory.GetHistoria_pristupu(); Historia_pristupu h = new Historia_pristupu(date1, i.RecordId, 37); hg.Insert(h); show(); } } } }
public FormEmpList() { ZamestnanecFactory zamestnanecFactory = new ZamestnanecFactory(); ZamestnanecGateway <Zamestnanec> zg = (ZamestnanecGateway <Zamestnanec>)zamestnanecFactory.GetZamestnanec(); z = zg.Select(); InitializeComponent(); loadList(); }
public void show() { string a; Collection <Active> active = new Collection <Active>(); foreach (var i in pracovisko) { if (i.Name.Equals(pracoviskoCombo.Text, StringComparison.Ordinal)) { ZamestnanecFactory zamestnanecFactory = new ZamestnanecFactory(); ZamestnanecGateway <Zamestnanec> zg = (ZamestnanecGateway <Zamestnanec>)zamestnanecFactory.GetZamestnanec(); a = zg.AktualnePritomny(i.RecordId, null); string[] words = a.Split(';'); foreach (var word in words) { string[] words2 = word.Split(','); int counter = 0; bool b = false; Active t = new Active(); foreach (var word1 in words2) { if (counter == 0) { t.Name = word1; } if (counter == 1) { t.Surname = word1; } if (counter == 2) { t.State = word1; b = true; } counter++; } if (b) { active.Add(t); } } } } BindingList <Active> Bactive = new BindingList <Active>(active); gridAktivita.AutoGenerateColumns = false; gridAktivita.DataSource = Bactive; }
public FormCreateProject() { ZamestnanecFactory zamestnanecFactory = new ZamestnanecFactory(); ZamestnanecGateway <Zamestnanec> zg = (ZamestnanecGateway <Zamestnanec>)zamestnanecFactory.GetZamestnanec(); z = zg.Select(); InitializeComponent(); empLoad(); }