public static Member GetUserById(int idUser) { openConnection(); string condition = "id_user = '******'"; MySqlCommand command = new MySqlCommand(db.SelectSQLQuery(new string[] { LOGIN_ATTR, PASSWORD_ATTR }, Const.USERS_TABLE, condition), connection); MySqlDataReader reader = command.ExecuteReader(); if (reader.Read() == false) { return null; } Member m = new Member(idUser, reader.GetString(LOGIN_ATTR), reader.GetString(PASSWORD_ATTR)); connection.Close(); return m; }
/// <summary> /// Send Reminder to user /// </summary> /// <param name="email">user email</param> public void SendReminder(string email) { Member sendUser = new Member(); SendMail s = new SendMail(); try { sendUser = Login_DB.GetUserById(Member_DB.GetMemberIdByEmail(email)); } catch { s.Send(email, "Приносим свои извинения, но вы не зарегистрированы в нашей системе. Подробности [email protected]."); return; } s.Send(email, imposeMailText(sendUser.Login, sendUser.Password)); }
public void ChangeMember(Member m) { member = m; number.Text = "№" + member.Number.ToString(); fullName.Text = member.FirstName + " " + member.LastName + " " + member.Family; birthDay.Text = ifThereIsNotDate(member.BDate); enterDate.Text = ifThereIsNotDate(member.EnterDate); email.Text = member.Email; local.Text = member.Local; city.Text = member.City; if (member.Area != "") { area.Text = member.Area; } godFather.Text = Program.Data.GetMICGodFather(member).Family + " " + Program.Data.GetMICGodFather(member).FirstName + " " + Program.Data.GetMICGodFather(member).LastName; }
/// <summary> /// Returns an instance of the class Member /// </summary> /// <param name="id">Id man from the base</param> /// <returns></returns> public Member GetMember(int id) { MySqlConnection con = new MySqlConnection(); try { con = new MySqlConnection(connectionString); } catch { Console.WriteLine("Error: couldn't connect to database"); Console.ReadKey(); return null; } MySqlCommand cmd = new MySqlCommand(getMemberQuery + id.ToString(), con); try { con.Open(); } catch { return null; } MySqlDataReader reader = cmd.ExecuteReader(); Member mmbr = new Member(); while (reader.Read()) { mmbr.Area = reader["area"].ToString(); mmbr.Local = reader["local"].ToString(); mmbr.Family = reader["family"].ToString(); mmbr.FirstName = reader["firstName"].ToString(); mmbr.City = reader["city"].ToString(); mmbr.LastName = reader["lastName"].ToString(); mmbr.BDate = getDateTime(reader["b_Year"], reader["b_month"], reader["b_Day"]); mmbr.Education = reader["education"].ToString(); mmbr.Job = reader["job"].ToString(); mmbr.EnterDate = getDateTime(reader["enter_year"], reader["enter_month"], reader["enter_day"]); mmbr.Number = Int32.Parse(reader["number"].ToString()); mmbr.IndexAdress = Int32.Parse(reader["index_adress"].ToString()); mmbr.Contacts = reader["contacts"].ToString(); mmbr.EnterMark = reader["enter_Mark"].ToString(); mmbr.ChangeDate = reader["change_date"].ToString(); mmbr.GodFather = Int32.Parse(reader["godFather"].ToString()); mmbr.Post = reader["post"].ToString(); mmbr.Email = reader["email"].ToString(); } con.Close(); return mmbr; }
public Member GetMICGodFather(Member member) { help = new DBHelper(); return help.GetMember(member.God_Father); }
private Member checkDataInMember(Member m) { m.Area = thereIsNotData(m.Area); m.City = thereIsNotData(m.City); m.Contacts = thereIsNotData(m.Education); m.Enter_Mark = thereIsNotData(m.Enter_Mark); m.Family = thereIsNotData(m.Family); m.FirstName = thereIsNotData(m.FirstName); m.Home_Adress = thereIsNotData(m.Home_Adress); m.Job = thereIsNotData(m.Job); m.LastName = thereIsNotData(m.LastName); m.Local = thereIsNotData(m.Local); m.Post = thereIsNotData(m.Post); m.State = thereIsNotData(m.State); m.Email = thereIsNotData(m.Email); return m; }
public void SetMainUser(int userIndex, string userLogin, string userPassword) { MainUser = new Member(userIndex, userLogin, userPassword); }
public void PutInGodFather(Member member) { help = new DBHelper(); Program.MainWindow.PutInMemberCardGodFather(GetMICGodFather(member)); }
public void PutMember(Member m) { member = m; number = new OpacityLabel(); number.Size = new System.Drawing.Size(100, 30); number.Text = "№"; number.Text += member.Number.ToString(); number.Location = new System.Drawing.Point(this.Width - number.Width); number.Font = new System.Drawing.Font("PF BeauSans Pro", 16F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(204))); number.BorderStyle = BorderStyle.Fixed3D; this.Controls.Add(number); fullName = new OpacityLabel(); fullName.Text = member.FirstName + " " + member.LastName + " " + member.Family; fullName.Size = new System.Drawing.Size(400, 30); fullName.Location = new System.Drawing.Point(0, 0); fullName.Font = new System.Drawing.Font("PF BeauSans Pro", 16F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(204))); this.Controls.Add(fullName); birthDayLabel = new OpacityLabel(); birthDayLabel.Text = "День рождения"; birthDayLabel.Location = new System.Drawing.Point(0, 40); birthDayLabel.Size = new System.Drawing.Size(180, 30); birthDayLabel.Font = new System.Drawing.Font("PF BeauSans Pro", 16F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(204))); this.Controls.Add(birthDayLabel); birthDay = new OpacityLinkLabel(); birthDay.Text = ifThereIsNotDate(member.BDate); birthDay.Size = new System.Drawing.Size(200, 30); birthDay.Click += new EventHandler(birthDay_Click); birthDay.Location = new System.Drawing.Point(200, 40); birthDay.Font = new System.Drawing.Font("PF BeauSans Pro", 16F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(204))); this.Controls.Add(birthDay); enterDateLabel = new OpacityLabel(); enterDateLabel.Size = new System.Drawing.Size(190, 30); enterDateLabel.Location = new System.Drawing.Point(0, 80); enterDateLabel.Text = "Дата вступления"; enterDateLabel.Font = new System.Drawing.Font("PF BeauSans Pro", 16F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(204))); this.Controls.Add(enterDateLabel); enterDate = new OpacityLinkLabel(); enterDate.Size = new System.Drawing.Size(200, 30); enterDate.Text = ifThereIsNotDate(member.EnterDate); enterDate.Click += new EventHandler(enterDate_Click); enterDate.Location = new System.Drawing.Point(200, 80); enterDate.Font = new System.Drawing.Font("PF BeauSans Pro", 16F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(204))); this.Controls.Add(enterDate); emailLabel = new OpacityLabel(); emailLabel.Size = new System.Drawing.Size(190, 30); emailLabel.Location = new System.Drawing.Point(0, 120); emailLabel.Text = "E-mail"; emailLabel.Font = new System.Drawing.Font("PF BeauSans Pro", 16F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(204))); this.Controls.Add(emailLabel); email = new OpacityLinkLabel(); email.Size = new System.Drawing.Size(200, 30); email.Text = member.Email; email.Location = new System.Drawing.Point(200, 120); email.Font = new System.Drawing.Font("PF BeauSans Pro", 16F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(204))); this.Controls.Add(email); local = new OpacityLabel(); local.Size = new System.Drawing.Size(300, 60); local.Text = member.Local; local.Location = new System.Drawing.Point(200, 160); local.Font = new System.Drawing.Font("PF BeauSans Pro", 16F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(204))); this.Controls.Add(local); localLabel = new OpacityLabel(); localLabel.Size = new System.Drawing.Size(200, 30); localLabel.Location = new System.Drawing.Point(0, 160); localLabel.Text = "Подразделение"; localLabel.Font = new System.Drawing.Font("PF BeauSans Pro", 16F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(204))); this.Controls.Add(localLabel); city = new OpacityLinkLabel(); city.Size = new System.Drawing.Size(350, 30); city.Click += new EventHandler(city_Click); city.Location = new System.Drawing.Point(200, 240); city.Font = new System.Drawing.Font("PF BeauSans Pro", 16F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(204))); city.Text = member.City; this.Controls.Add(city); cityLabel = new OpacityLabel(); cityLabel.Size = new System.Drawing.Size(200, 30); cityLabel.Location = new System.Drawing.Point(0, 240); cityLabel.Text = "Населённый пункт"; cityLabel.Font = new System.Drawing.Font("PF BeauSans Pro", 16F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(204))); this.Controls.Add(cityLabel); if (member.Area != "") { area = new OpacityLinkLabel(); area.Size = new System.Drawing.Size(350, 30); area.Location = new System.Drawing.Point(200, 280); area.Font = new System.Drawing.Font("PF BeauSans Pro", 16F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(204))); area.Text = member.Area; this.Controls.Add(area); areaLabel = new OpacityLabel(); areaLabel.Size = new System.Drawing.Size(200, 30); areaLabel.Location = new System.Drawing.Point(0, 280); areaLabel.Text = "Район"; areaLabel.Font = new System.Drawing.Font("PF BeauSans Pro", 16F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(204))); this.Controls.Add(areaLabel); } godFather = new OpacityLinkLabel(); godFather.Size = new System.Drawing.Size(300, 60); godFather.Location = new System.Drawing.Point(200, 320); godFather.Click += new EventHandler(godFather_Click); godFather.Font = new System.Drawing.Font("PF BeauSans Pro", 16F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(204))); godFather.Text = Program.Data.GetMICGodFather(member).Family + " " + Program.Data.GetMICGodFather(member).FirstName + " " + Program.Data.GetMICGodFather(member).LastName; this.Controls.Add(godFather); godFatherLabel = new OpacityLabel(); godFatherLabel.Size = new System.Drawing.Size(200, 30); godFatherLabel.Location = new System.Drawing.Point(0, 320); godFatherLabel.Text = "Крёстный в МИЦ"; godFatherLabel.Font = new System.Drawing.Font("PF BeauSans Pro", 16F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(204))); this.Controls.Add(godFatherLabel); }
private void GetMemberClick(object sender, EventArgs e) { this.workSpaceTableLayoutPanel.Controls.Remove(memberCard); memberCard = new MemberCard(); Member member = new Member(); member = Program.Data.GetMICMember(Int32.Parse(memberList[Const.MEMBERS].SelectedItem.ToString().Split(' ')[0])); memberCard.PutMember(member); this.workSpaceTableLayoutPanel.Controls.Add(memberCard, 2, 2); }
public void PutInMemberCardGodFather(Member godFather) { this.workSpaceTableLayoutPanel.Controls.Remove(memberCard); memberCard = new MemberCard(); memberCard.PutMember(godFather); this.workSpaceTableLayoutPanel.Controls.Add(memberCard, 2, 2); }
private void GetMemberClick(object sender, EventArgs e) { if ( memberList[Const.MEMBERS].SelectedItem != null ) { Member member = new Member(); member = Program.Data.GetMICMember(Int32.Parse(memberList[Const.MEMBERS].SelectedItem.ToString().Split(' ')[0])); int index = this.workSpaceTableLayoutPanel.Controls.IndexOf(memberCard); if ( index == -1 ) { memberCard = new MemberCard(); memberCard.PutMember(member); this.workSpaceTableLayoutPanel.Controls.Add(memberCard, 2, 2); } else { ( (MemberCard)this.workSpaceTableLayoutPanel.Controls[index] ).ChangeMember(member); } } }
public static Member GetMemberAttrWithOneQuery(int userId) { openConnection(); MySqlCommand command = new MySqlCommand(SELECT_MEMBER_ATTRS_QUERY + userId.ToString() + "'", connection); MySqlDataReader reader = command.ExecuteReader(); Member m = new Member(); m.BDate = new DateTime(); m.EnterDate = new DateTime(); while (reader.Read()) { string attrName = db.GetAttrNameById(reader.GetInt32(ID_ATTR_COLUMN)); if (attrName == "b_day") { m.BDate = new DateTime(m.BDate.Year, m.BDate.Month, reader.GetInt32(VALUE_COLUMN)); continue; } if (attrName == "b_month") { m.BDate = new DateTime(m.BDate.Year, reader.GetInt32(VALUE_COLUMN), m.BDate.Day); continue; } if (attrName == "b_year") { m.BDate = new DateTime(reader.GetInt32(VALUE_COLUMN), m.BDate.Month, m.BDate.Day); continue; } if (attrName == "enter_day") { m.EnterDate = new DateTime(m.EnterDate.Year, m.EnterDate.Month, reader.GetInt32(VALUE_COLUMN)); continue; } if (attrName == "enter_month") { m.EnterDate = new DateTime(m.EnterDate.Year, reader.GetInt32(VALUE_COLUMN), m.EnterDate.Day); continue; } if (attrName == "enter_year") { m.EnterDate = new DateTime(reader.GetInt32(VALUE_COLUMN), m.EnterDate.Month, m.EnterDate.Day); continue; } foreach (FieldInfo f in m.GetType().GetFields()) { if (String.Compare(f.Name, attrName, true) == 0) { if (f.FieldType == typeof(Int32)) { m.GetType().GetField(f.Name).SetValue(m, reader.GetInt32(VALUE_COLUMN)); continue; } if ((f.FieldType == typeof(DateTime)) && (f.Name != "BDate") && (f.Name != "EnterDate")) { m.GetType().GetField(f.Name).SetValue(m, DateTime.Parse(reader.GetString(VALUE_COLUMN))); continue; } m.GetType().GetField(f.Name).SetValue(m, reader.GetString(VALUE_COLUMN)); } } } return m; }