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);
}
