public int getNextID() { int i = 0; try { SqlDbDataAccess da = new SqlDbDataAccess(); SqlCommand cmd = da.GetCommand("SELECT MAX(ID) FROM LOGIN_CREDENTIALS"); //List <LOGIN_CREDENTIALS> userLoginInfo = GetDataLogInCredentials(cmd); cmd.Connection.Open(); SqlDataReader reader = cmd.ExecuteReader(); LOGIN_CREDENTIALS obj = new LOGIN_CREDENTIALS(); using (reader) { while (reader.Read()) { obj.ID = reader.GetInt32(0); } } reader.Close(); cmd.Connection.Close(); i = obj.ID; i++; } catch (Exception ex) { } return(i); }
public bool insertLoginCredentials(LOGIN_CREDENTIALS obj) { int val = 0; try { SqlDbDataAccess da = new SqlDbDataAccess(); SqlCommand cmd = da.GetCommand("INSERT INTO [dbo].[LOGIN_CREDENTIALS] ([PASSWORD],[TYPE],[STATUS])" + "VALUES (@PASSWORD, @TYPE, @STATUS)"); //SqlParameter p = new SqlParameter("@ID", SqlDbType.Int); //p.Value = obj.ID; SqlParameter p1 = new SqlParameter("@PASSWORD", SqlDbType.VarChar, 50); p1.Value = obj.PASSWORD; SqlParameter p2 = new SqlParameter("@TYPE", SqlDbType.VarChar, 10); p2.Value = obj.TYPE; SqlParameter p3 = new SqlParameter("@STATUS", SqlDbType.VarChar, 10); p3.Value = obj.STATUS; //cmd.Parameters.Add(p); cmd.Parameters.Add(p1); cmd.Parameters.Add(p2); cmd.Parameters.Add(p3); cmd.Connection.Open(); val = cmd.ExecuteNonQuery(); cmd.Connection.Close(); } catch (Exception ex) { } return(val > 0); }
private void button1_Click(object sender, EventArgs e) { //insert into db as receiver name = textBox1.Text; password = passwordTB.Text.ToString(); password2 = textBox2.Text.ToString(); cellphone = textBox4.Text.ToString(); email = textBox3.Text.ToString(); if (!password.Equals(password2) || password.Equals(" ")) { MessageBox.Show("Passwords don't match", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } else if (password.Equals(password2) && !password.Equals(" ")) { if (name.Equals(" ") || gender.Equals(" ") || bloodGroup.Equals(" ") || address.Equals(" ") || cellphone.Equals(" ") || email.Equals(" ")) { MessageBox.Show("Fill Up All The Fields Properly", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { BloodBankData bbd = new BloodBankData(); LOGIN_CREDENTIALS lc = new LOGIN_CREDENTIALS(); lc.PASSWORD = passwordTB.Text; lc.TYPE = "RECEIVER"; lc.STATUS = "PENDING"; bbd.insertLoginCredentials(lc); USERS u = new USERS(); u.ID = id; u.NAME = textBox1.Text; u.IMAGE = convertImageToBinary(pictureBox2.BackgroundImage); u.DOB = dob; u.GENDER = gender; u.BLOOD_GROUP = bloodGroup; u.ADDRESS = address; u.CELLPHONE = cellphone; u.EMAIL = email; bbd.insertUsersReceiver(u); textBox1.Clear(); textBox2.Clear(); textBox3.Clear(); passwordTB.Clear(); monthCalendar1.ResetText(); this.Close(); thread = new Thread(openSignUpSuccessForm); thread.SetApartmentState(ApartmentState.STA); thread.Start(); } } }
List <LOGIN_CREDENTIALS> GetDataLogInCredentials(SqlCommand cmd) { cmd.Connection.Open(); SqlDataReader reader = cmd.ExecuteReader(); List <LOGIN_CREDENTIALS> list = new List <LOGIN_CREDENTIALS>(); using (reader) { while (reader.Read()) { LOGIN_CREDENTIALS obj = new LOGIN_CREDENTIALS(); obj.ID = reader.GetInt32(0); obj.PASSWORD = reader.GetString(1); obj.TYPE = reader.GetString(2); obj.STATUS = reader.GetString(3); list.Add(obj); } reader.Close(); } cmd.Connection.Close(); return(list); }
private void button1_Click(object sender, EventArgs e) { //insert into db as donor bool flagLG = false; bool flagUSR = false; name = textBox1.Text; password = passwordTB.Text.ToString(); password2 = textBox2.Text.ToString(); cellphone = textBox4.Text.ToString(); email = textBox3.Text.ToString(); if (!password.Equals(password2) || password.Equals(" ")) { MessageBox.Show("Passwords don't match", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } else if (password.Equals(password2) && !password.Equals(" ")) { if (name.Equals(" ") || gender.Equals(" ") || bloodGroup.Equals(" ") || address.Equals(" ") || cellphone.Equals(" ") || email.Equals(" ") || drugAddiction.Equals(" ") || HIV.Equals(" ")) { MessageBox.Show("Fill Up All The Fields Properly", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { BloodBankData bbd = new BloodBankData(); LOGIN_CREDENTIALS lc = new LOGIN_CREDENTIALS(); lc.PASSWORD = passwordTB.Text; lc.TYPE = "DONOR"; lc.STATUS = "PENDING"; flagLG = bbd.insertLoginCredentials(lc); USERS u = new USERS(); u.ID = id; u.NAME = textBox1.Text; u.IMAGE = convertImageToBinary(pictureBox2.BackgroundImage); u.DOB = dob; u.GENDER = gender; u.BLOOD_GROUP = bloodGroup; u.ADDRESS = address; u.CELLPHONE = textBox4.Text.ToString(); u.EMAIL = textBox3.Text.ToString(); u.DRUG_ADDICTION = drugAddiction; u.HIV_STATUS = HIV; u.LAST_DONATION_DATE = donationDate; flagUSR = bbd.insertUsersDonor(u); if (flagLG == true && flagUSR == true) { this.Close(); thread = new Thread(openNewSignUpSuccessForm); thread.SetApartmentState(ApartmentState.STA); thread.Start(); } else { MessageBox.Show("Failed to sign up. Please fill up the form correctly & try again", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } } }
public int logIn(int id, string password) { int loginFlag = 0; string status; string type; try { SqlDbDataAccess da = new SqlDbDataAccess(); SqlCommand cmd = da.GetCommand("SELECT * FROM LOGIN_CREDENTIALS WHERE ID = " + id + " AND PASSWORD = "******"ACTIVE") && type.Equals("MODERATOR")) { if (id == obj.ID && password.Equals(obj.PASSWORD)) { loginFlag = 1; } } else if (status.Equals("ACTIVE") && type.Equals("RECEIVER")) { if (id == obj.ID && password.Equals(obj.PASSWORD)) { loginFlag = 2; } } else if (status.Equals("ACTIVE") && type.Equals("DONOR")) { if (id == obj.ID && password.Equals(obj.PASSWORD)) { loginFlag = 3; } } else { loginFlag = 0; } } catch (Exception ex) { } return(loginFlag); }