public bool CheckPassword(int UserId, string password)
{
DataBaseUser db = new DataBaseUser();
string login = db.TakeALogin(UserId);
return(db.Login(password, login)[1] != 0);
}
public Boolean UserUpdate()
{
DataBaseUser dataBaseUser = new DataBaseUser();
MemoryStream picture = new MemoryStream();
picturebox.Image.Save(picture, picturebox.Image.RawFormat);
MySqlCommand command = new MySqlCommand("UPDATE `users` SET `firstname`= @fname,`surname`= @sname,`email`= @email,`password`= @pass,`picture`= @pic WHERE `user_id`=@id", dataBaseUser.GetConnection());
MySqlCommand my = new MySqlCommand("SET GLOBAL max_allowed_packet=1024*1024*1024", dataBaseUser.GetConnection());
command.Parameters.Add("@fname", MySqlDbType.VarChar).Value = name.Text;
command.Parameters.Add("@sname", MySqlDbType.VarChar).Value = surname.Text;
command.Parameters.Add("@email", MySqlDbType.VarChar).Value = email.Text;
command.Parameters.Add("@pass", MySqlDbType.VarChar).Value = pass.Text;
command.Parameters.Add("@pic", MySqlDbType.LongBlob).Value = picture.ToArray();
command.Parameters.Add("@id", MySqlDbType.Int64).Value = Globals.Global_userid;
dataBaseUser.openConnection();
my.ExecuteNonQuery();
if (command.ExecuteNonQuery() == 1)
{
dataBaseUser.closeConnection();
return(true);
}
else
{
dataBaseUser.closeConnection();
return(false);
}
}
static void Main()
{
Application.EnableVisualStyles();
Application.SetCompatibleTextRenderingDefault(false);
// Base de Dados Geral do Utulizador
DataBaseUser dataBase = new DataBaseUser();
// liga à base de dados
DataBase.Connect conn;
DataBase.QueryUser queryUser;
DataBase.QueryMissao querySoftware;
conn = new DataBase.Connect();
conn.openMyConnection();
queryUser = new DataBase.QueryUser(conn._myConnection);
querySoftware = new DataBase.QueryMissao(conn._myConnection);
// Apresenta o Login
Init abertura = new Init(dataBase, conn, queryUser);
Application.Run(abertura);
//MessageBox.Show("#### TODA A INFORMAÇÂO DA BASE DE DADOS ####\n"+dataBase.toString());
// Apresenta a nova janela
EscolheMissao cp = new EscolheMissao(dataBase, queryUser);
Application.Run(cp);
}
private void PanalEdit_Profies_Load(object sender, EventArgs e)
{
DataTable table = Register.GetUserEdit(Globals.Global_userid);
temp = table.Rows[0][1].ToString();
name.Text = table.Rows[0][2].ToString();
surname.Text = table.Rows[0][3].ToString();
email.Text = table.Rows[0][4].ToString();
pass.Text = table.Rows[0][5].ToString();
byte[] pic = (byte[])table.Rows[0]["picture"];
MemoryStream picture = new MemoryStream(pic);
picturebox.Image = Image.FromStream(picture);
DataBaseUser dataBaseUser = new DataBaseUser();
MySqlDataAdapter adapter = new MySqlDataAdapter("SELECT * FROM database_userwater WHERE CONCAT(water_id) LIKE '%" + temp + "%'", dataBaseUser.GetConnection());
DataTable dataTable = new DataTable();
adapter.Fill(dataTable);
textboxwaterid.Text = dataTable.Rows[0][0].ToString();
textboxname.Text = dataTable.Rows[0][1].ToString();
textboxsurname.Text = dataTable.Rows[0][2].ToString();
textboxadress.Text = dataTable.Rows[0][3].ToString();
textboxphone.Text = dataTable.Rows[0][4].ToString();
textboxplace.Text = dataTable.Rows[0][5].ToString();
}
private void signin_Click(object sender, EventArgs e)
{
String water_id = textboxwater_id.Text;
String password = textboxpassword.Text;
DataBaseUser dataBaseUser = new DataBaseUser();
DataTable table = new DataTable();
MySqlDataAdapter adapter = new MySqlDataAdapter();
MySqlCommand command = new MySqlCommand("SELECT * FROM `users` WHERE `water_id` = @wid AND `password` = @pass", dataBaseUser.GetConnection());
command.Parameters.Add("@wid", MySqlDbType.VarChar).Value = water_id;
command.Parameters.Add("@pass", MySqlDbType.VarChar).Value = password;
adapter.SelectCommand = command;
adapter.Fill(table);
if (table.Rows.Count > 0)
{
MySqlCommand my = new MySqlCommand("INSERT INTO `login_history`(`water_id`, `logintime`) VALUES (@water, @date)", dataBaseUser.GetConnection());
my.Parameters.Add("@water", MySqlDbType.VarChar).Value = water_id;
my.Parameters.Add("@date", MySqlDbType.VarChar).Value = DateTime.Now.ToShortTimeString() + " | " + DateTime.Now.ToLongDateString();
dataBaseUser.openConnection();
my.ExecuteNonQuery();
dataBaseUser.closeConnection();
int userid = Convert.ToInt32(table.Rows[0][0].ToString());
Globals.SetGlobal_userid(userid);
this.Hide();
Wellcome wellcome = new Wellcome();
wellcome.ShowDialog();
MainProgram mainProgram = new MainProgram();
mainProgram.Show();
}
else
{
if (textboxwater_id.Text.Equals("เลขที่ผู้ใช้น้ำ") && !textboxpassword.Text.Equals("รหัสผ่าน"))
{
warning.Visible = true;
textwarning.Text = "ชื่อผู้ใช้ไม่ถูกต้อง";
}
else if (textboxpassword.Text.Equals("รหัสผ่าน") && !textboxwater_id.Text.Equals("เลขที่ผู้ใช้น้ำ"))
{
warning.Visible = true;
textwarning.Text = "รหัสผ่านไม่ถูกต้อง";
}
else if (textboxwater_id.Text.Equals("เลขที่ผู้ใช้น้ำ") && textboxpassword.Text.Equals("รหัสผ่าน"))
{
warning.Visible = true;
textwarning.Text = "กรุณากรอกเลขที่ผู้ใช้น้ำ และรหัสผ่าน";
}
else
{
warning.Visible = true;
textwarning.Text = "เลขที่ผู้ใช้น้ำ หรือรหัสผ่านไม่ถูกต้อง";
}
}
}
public void AccessRegistration(string login, string email, string hash_password, int typeId)
{
DataBaseUser dataBaseUser = new DataBaseUser();
dataBaseUser.Insert(new User(login, email, hash_password, typeId));
RegistrationData registrationData = new RegistrationData();
registrationData.Delete(login);
}
public void Auth()
{
bool fl = true;
bool IsDone = true;
ErrorMes = "";
flag = true;
login += " ";
int x1 = login.Length - 1;
login = login.Substring(0, x1);
if (login == null || password == null || login == String.Empty)
{
ErrorMes = Properties.Resources.emptyfield;
}
else
{
if (fl && canreg)
{
DataBaseUser spam = new DataBaseUser();
string Pass = DB.DB.Hash(password).ToString();
IsDone = spam.GiveUserByLoginAndPassword(login, Pass);
if (IsDone)
{
Properties.Settings.Default.User = login;
Properties.Settings.Default.IdUser = spam.GetIdUserByLogin(login);
Properties.Settings.Default.Save();
bool isAdmin;
isAdmin = spam.GetIsAdminUser(Properties.Settings.Default.IdUser);
if (isAdmin)
{
AdminWindow sp = new AdminWindow();
sp.WindowStartupLocation = WindowStartupLocation.CenterScreen;
sp.Show();
Close();
}
else
{
MainWindow sp = new MainWindow();
sp.WindowStartupLocation = WindowStartupLocation.CenterScreen;
sp.Show();
Close();
}
}
}
if (!IsDone)
{
ErrorMes = Properties.Resources.nosuchuser;
}
flag = false;
canreg = true;
}
}
public DataTable GetUserEdit(Int64 id)
{
DataBaseUser dataBaseUser = new DataBaseUser();
DataTable table = new DataTable();
MySqlDataAdapter adapter = new MySqlDataAdapter();
MySqlCommand command = new MySqlCommand("SELECT * FROM `users` WHERE `user_id` = @id", dataBaseUser.GetConnection());
command.Parameters.Add("@id", MySqlDbType.Int64).Value = id;
adapter.SelectCommand = command;
adapter.Fill(table);
return(table);
}
public void RegisterCommand()
{
try
{
ErrorMes = "";
flag = true;
login += " ";
int x1 = login.Length - 1;
login = login.Substring(0, x1);
bool fl = true;
if (password.Length < 8)
{
ErrorMes = Properties.Resources.charac;
}
if (password == String.Empty || password == null || lastname == String.Empty || lastname == null || gender == null || gender == String.Empty ||
purpose_of_use == String.Empty || purpose_of_use == null || age == null || age == String.Empty || height == null || height == String.Empty ||
activity == String.Empty || activity == null || firstname == null || firstname == String.Empty)
{
fl = false;
ErrorMes = Properties.Resources.emptyfield;
}
bool IsDone = true;
if (fl && canreg)
{
DataBaseUser spam = new DataBaseUser();
string Pass = DB.DB.Hash(password).ToString();
IsDone = spam.AddUser(login, Pass, firstname, lastname, purpose_of_use, gender, age, height, weight, activity, daily_calories);
if (IsDone)
{
AuthView t = new AuthView();
t.Show();
Close();
}
}
if (!IsDone)
{
ErrorMes = Properties.Resources.existserr;
login = "";
}
canreg = true;
flag = false;
}
catch (SystemException)
{
ErrorMes = Properties.Resources.errordata;
}
}
private void PanalHisUse_Load(object sender, EventArgs e)
{
DataBaseUser dataBaseUser = new DataBaseUser();
DataTable table = new DataTable();
MySqlDataAdapter adapter = new MySqlDataAdapter();
MySqlCommand command = new MySqlCommand("SELECT * FROM `users` WHERE `user_id` = @id", dataBaseUser.GetConnection());
command.Parameters.Add("@id", MySqlDbType.VarChar).Value = Globals.Global_userid;
adapter.SelectCommand = command;
adapter.Fill(table);
if (table.Rows.Count > 0)
{
thename = "" + table.Rows[0]["water_id"] + "";
}
searchData(thename);
}
public void getIm_userid()
{
DataBaseUser dataBaseUser = new DataBaseUser();
DataTable table = new DataTable();
MySqlDataAdapter adapter = new MySqlDataAdapter();
MySqlCommand command = new MySqlCommand("SELECT * FROM `users` WHERE `user_id` = @id", dataBaseUser.GetConnection());
command.Parameters.Add("@id", MySqlDbType.VarChar).Value = Globals.Global_userid;
adapter.SelectCommand = command;
adapter.Fill(table);
if (table.Rows.Count > 0)
{
byte[] pic = (byte[])table.Rows[0]["picture"];
MemoryStream picture = new MemoryStream(pic);
picturebox.Image = Image.FromStream(picture);
textboxuser.Text = table.Rows[0]["firstname"].ToString() + " " + table.Rows[0]["surname"].ToString();
}
}
public List <DataBaseUser> GetUserModels()
{
DataBaseUserList = new List <DataBaseUser>();
SqlConnection conn = new SqlConnection();
try
{
DatabaseControl dbc = new DatabaseControl();
SqlDataReader rd = dbc.GetDataFromDB("select * from dbo.UserProfile", out conn);
if (rd != null)
{
while (rd.Read())
{
DataBaseUser du = new DataBaseUser();
du.Id = int.Parse(rd["UserId"].ToString());
du.UserName = rd["UserName"].ToString();
string admin = rd["isAdmin"].ToString();
if (!String.IsNullOrEmpty(admin))
{
du.IsAdmin = int.Parse(rd["isAdmin"].ToString());
}
else
{
du.IsAdmin = 0;
}
du.FirstName = rd["FirstName"].ToString();
du.LastName = rd["LastName"].ToString();
du.Patronymic = rd["Patronymic"].ToString();
du.RegisterDate = DateTime.Parse(rd["register_date"].ToString());
du.LastConnection = DateTime.Parse(rd["last_connect_date"].ToString());
DataBaseUserList.Add(du);
}
}
}
catch (Exception ex)
{
Singleton <Logger> .Instance.WriteMainLine("AdminModel:GetUserModels: " + ex.Message + ";" + ex.StackTrace);
}
finally
{
conn.Close();
}
return(DataBaseUserList);
}
public Boolean checkwater_id()
{
DataBaseUser dataBaseUser = new DataBaseUser();
DataTable table = new DataTable();
MySqlDataAdapter adapter = new MySqlDataAdapter();
MySqlCommand command = new MySqlCommand("SELECT * FROM `users` WHERE `water_id` = @wid", dataBaseUser.GetConnection());
command.Parameters.Add("@wid", MySqlDbType.VarChar).Value = number.Text;
adapter.SelectCommand = command;
adapter.Fill(table);
if (table.Rows.Count > 0)
{
return(true);
}
else
{
return(false);
}
}
public Boolean DatabaseUserUpdate()
{
DataBaseUser dataBaseUser = new DataBaseUser();
MySqlCommand command = new MySqlCommand("UPDATE `database_userwater` SET `firstname`= @fname,`surname`= @sname,`address`= @add,`phone`= @phone,`location`= @loc WHERE `water_id`=@id", dataBaseUser.GetConnection());
command.Parameters.Add("@fname", MySqlDbType.VarChar).Value = textboxname.Text;
command.Parameters.Add("@sname", MySqlDbType.VarChar).Value = textboxsurname.Text;
command.Parameters.Add("@add", MySqlDbType.VarChar).Value = textboxadress.Text;
command.Parameters.Add("@phone", MySqlDbType.VarChar).Value = textboxphone.Text;
command.Parameters.Add("@loc", MySqlDbType.VarChar).Value = textboxplace.Text;
command.Parameters.Add("@id", MySqlDbType.VarChar).Value = textboxwaterid.Text;
dataBaseUser.openConnection();
if (command.ExecuteNonQuery() == 1)
{
dataBaseUser.closeConnection();
return(true);
}
else
{
dataBaseUser.closeConnection();
return(false);
}
}
public List <int> Login()
{
DataBaseUser login = new DataBaseUser();
return(login.Login(this.login, this.password));
}
private void backtologin_Click(object sender, EventArgs e)
{
pictureBoxuser.Image = Image.FromFile(@"C:\Users\HP\Desktop\c#\FinalReferent\profile.png");
MemoryStream picture = new MemoryStream();
pictureBoxuser.Image.Save(picture, pictureBoxuser.Image.RawFormat);
DataBaseUser dataBaseUser = new DataBaseUser();
MySqlCommand command = new MySqlCommand("INSERT INTO `users`(`water_id`, `firstname`, `surname`, `email`, `password`, `picture`) VALUES (@wid, @fname, @sname, @email, @pass, @pic)", dataBaseUser.GetConnection());
command.Parameters.Add("@wid", MySqlDbType.VarChar).Value = number.Text;
command.Parameters.Add("@fname", MySqlDbType.VarChar).Value = name.Text;
command.Parameters.Add("@sname", MySqlDbType.VarChar).Value = surname.Text;
command.Parameters.Add("@email", MySqlDbType.VarChar).Value = email.Text;
command.Parameters.Add("@pass", MySqlDbType.VarChar).Value = pass.Text;
command.Parameters.Add("@pic", MySqlDbType.Blob).Value = picture.ToArray();
dataBaseUser.openConnection();
if (!checktextboxvalues())
{
if (pass.Text.Equals(conpass.Text))
{
if (checkwater_id())
{
if (checkwater_id())
{
warning.Visible = true;
textwarning.ForeColor = Color.FromArgb(235, 73, 93);
textwarning.Text = "รหัสผู้ใช้น้ำมีอยู่แล้ว โปรดลองใหม่";
}
}
else
{
if (command.ExecuteNonQuery() == 1)
{
warning.Visible = false;
warning0.Visible = true;
textwarning.ForeColor = Color.FromArgb(0, 154, 159);
textwarning.Text = "สร้างบัญชีผู้ใช้สำเร็จ";
}
}
}
else
{
warning.Visible = true;
textwarning.Text = "รหัสผ่านไม่ถูกต้อง";
}
}
else
{
if (name.Text.Equals("ชื่อ"))
{
name.Text = " ชื่อ";
warning1.Visible = true;
name.ForeColor = Color.FromArgb(235, 73, 93);
lineShape1.BorderColor = Color.FromArgb(235, 73, 93);
}
if (surname.Text.Equals("นามสกุล"))
{
surname.Text = " นามสกุล";
warning2.Visible = true;
surname.ForeColor = Color.FromArgb(235, 73, 93);
lineShape6.BorderColor = Color.FromArgb(235, 73, 93);
}
if (email.Text.Equals("อีเมล์"))
{
email.Text = " อีเมล์";
warning3.Visible = true;
email.ForeColor = Color.FromArgb(235, 73, 93);
lineShape2.BorderColor = Color.FromArgb(235, 73, 93);
}
if (number.Text.Equals("เลขที่ผู้ใช้น้ำ 11 หลัก") || number.Text.Length < 11)
{
number.Text = " เลขที่ผู้ใช้น้ำ 11 หลัก";
warning4.Visible = true;
number.ForeColor = Color.FromArgb(235, 73, 93);
lineShape3.BorderColor = Color.FromArgb(235, 73, 93);
}
if (pass.Text.Equals("รหัสผ่าน"))
{
pass.Text = " รหัสผ่าน";
warning5.Visible = true;
pass.ForeColor = Color.FromArgb(235, 73, 93);
lineShape4.BorderColor = Color.FromArgb(235, 73, 93);
}
if (conpass.Text.Equals("ยืนยันรหัสผ่าน"))
{
conpass.Text = " ยืนยันรหัสผ่าน";
warning6.Visible = true;
conpass.ForeColor = Color.FromArgb(235, 73, 93);
lineShape5.BorderColor = Color.FromArgb(235, 73, 93);
}
}
dataBaseUser.closeConnection();
}
public bool Check()
{
DataBaseUser checking = new DataBaseUser();
return(checking.IsItFree(login, email));
}
public void Register()
{
DataBaseUser reg = new DataBaseUser();
reg.Insert(login, email, password);
}
