Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- using System;
- using System.Collections.Generic;
- using System.ComponentModel;
- using System.Data;
- using System.Drawing;
- using System.Linq;
- using System.Text;
- using System.Threading.Tasks;
- using System.Windows.Forms;
- using Npgsql;
- namespace WindowsFormsApp2
- {
- public partial class Reg : Form
- {
- NpgsqlConnection con = new NpgsqlConnection("Server=127.0.0.1;Port=5432;User Id=postgres;Password=12436Dark;Database=usersroles;");
- public Reg()
- {
- con.Open();
- InitializeComponent();
- txbPass.UseSystemPasswordChar = true;
- NpgsqlCommand r = new NpgsqlCommand("select * from roles order by roleid", con);
- NpgsqlDataReader rdr = r.ExecuteReader();
- var datrole = new List<l>();
- while (rdr.Read())
- {
- var dr = new l
- {
- Code = rdr[0].ToString().Trim(),
- Name = rdr[1].ToString().Trim()
- };
- datrole.Add(dr);
- }
- cbrole.DataSource = datrole;
- cbrole.DisplayMember = "Name";
- cbrole.ValueMember = "Code";
- con.Close();
- }
- private void listBox1_SelectedIndexChanged(object sender, EventArgs e)
- {
- }
- private void listBox1_SelectedIndexChanged_1(object sender, EventArgs e)
- {
- }
- private void btReg_Click(object sender, EventArgs e)
- {
- this.Close();
- Form1 f1 = new Form1();
- f1.Show();
- }
- private void btInsert_Click(object sender, EventArgs e)
- {
- string nowDate = DateTime.Now.ToShortDateString();
- string nowTime = DateTime.Now.ToShortTimeString();
- string username = txbLogin.Text;
- con.Open();
- NpgsqlCommand chck = new NpgsqlCommand("select count(*) from users where username = @user", con);
- chck.Parameters.Add("user", NpgsqlTypes.NpgsqlDbType.Char, 30).Value = username;
- int usrcnt = Convert.ToInt32(chck.ExecuteScalar());
- if (usrcnt == 0) {
- int role;
- NpgsqlCommand cnt = new NpgsqlCommand("select count(*) from users", con);
- int number = Convert.ToInt32(cnt.ExecuteScalar());
- number++;
- string password = txbPass.Text;
- role = Convert.ToInt32(cbrole.SelectedValue);
- NpgsqlCommand com = new NpgsqlCommand("INSERT INTO users (userid, username, password, role) VALUES (@num, @user, @pass, @role)", con);
- com.Parameters.Add("num", NpgsqlTypes.NpgsqlDbType.Bigint).Value = number;
- com.Parameters.Add("user", NpgsqlTypes.NpgsqlDbType.Char, 30).Value = username;
- com.Parameters.Add("pass", NpgsqlTypes.NpgsqlDbType.Char, 30).Value = password;
- com.Parameters.Add("role", NpgsqlTypes.NpgsqlDbType.Bigint).Value = role;
- try
- {
- com.ExecuteNonQuery();
- MessageBox.Show("Пользователь был добавлен успешно!", "Внимание!");
- int n = number;
- Prog pr = new Prog(n);
- this.Close();
- pr.Show();
- NpgsqlCommand cmd = new NpgsqlCommand("INSERT INTO \"journal\" (\"date\", \"time\", \"user\", \"action\") VALUES (@date, @time, @user, @act)", con);
- cmd.Parameters.Add("date", NpgsqlTypes.NpgsqlDbType.Date).Value = DateTime.Parse(nowDate);
- cmd.Parameters.Add("time", NpgsqlTypes.NpgsqlDbType.Time).Value = DateTime.Parse(nowTime);
- cmd.Parameters.Add("user", NpgsqlTypes.NpgsqlDbType.Bigint).Value = n;
- cmd.Parameters.Add("act", NpgsqlTypes.NpgsqlDbType.Bigint).Value = 1;
- cmd.ExecuteNonQuery();
- }
- catch { MessageBox.Show("Пользователь не был добавлен!", "Ошибка!"); }
- }
- else
- {
- MessageBox.Show("Пользователь с таким именем уже существует!", "Ошибка!",MessageBoxButtons.OK, MessageBoxIcon.Information);
- }
- con.Close();
- }
- private void btLook_Click(object sender, EventArgs e)
- {
- if (txbPass.UseSystemPasswordChar == true)
- {
- txbPass.UseSystemPasswordChar = false;
- }
- else
- {
- txbPass.UseSystemPasswordChar = true;
- }
- }
- private void button1_Click(object sender, EventArgs e)
- {
- this.Close();
- Roleaddcs ra = new Roleaddcs();
- ra.Show();
- }
- private void Reg_Load(object sender, EventArgs e)
- {
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement