private void button7_Click(object sender, EventArgs e)
{
label8.Visible = false;
label9.Visible = false;
string fName = textBox1.Text;
string lName = textBox2.Text;
string pNo = textBox3.Text;
string userName = comboBox1.SelectedItem.ToString();
string password = textBox5.Text;
if (fName.Length < 1 || lName.Length < 1 || pNo.Length < 1 || userName.Length < 1 || password.Length < 1)
{
label9.Text = "Please Fill All The Fields";
label9.Visible = true;
return;
}
if (!password.Equals(textBox6.Text))
{
label8.Visible = true;
return;
}
DataSets.Users userInfo = new DataSets.Users();
userInfo.fName = fName;
userInfo.lName = lName;
userInfo.pNo = pNo;
userInfo.userName = userName;
userInfo.password = password;
DataBaseManager dbm = new DataBaseManager();
dbm.updateUser(userInfo);
MessageBox.Show("The User Has Been Updated Successfully.");
this.Dispose();
}
public void deleteUser(DataSets.Users userInfo)
{
string sql = "DELETE FROM USERS WHERE UserName='******'";
m_dbConnection.Open();
SQLiteCommand command = new SQLiteCommand(sql, m_dbConnection);
command.ExecuteNonQuery();
m_dbConnection.Close();
}
public void updateUser(DataSets.Users userInfo)
{
m_dbConnection.Open();
string sql = "UPDATE USERS SET Password='******'," +
"Fname='" + userInfo.fName + "',Lname='" + userInfo.lName +
"', Pno='" + userInfo.pNo + "' WHERE UserName='******'";
SQLiteCommand command = new SQLiteCommand(sql, m_dbConnection);
command.ExecuteNonQuery();
m_dbConnection.Close();
}
private void button1_Click(object sender, EventArgs e)
{
string userName = comboBox1.SelectedItem.ToString();
if (userName.Equals("admin"))
{
MessageBox.Show("Admin Cannot Be Deleted.");
return;
}
DataSets.Users userInfo = new DataSets.Users();
userInfo.userName = userName;
dbm.deleteUser(userInfo);
MessageBox.Show("The User Has Been Deleted Successfully.");
this.Dispose();
}
public List <DataSets.Users> getUsers()
{
List <DataSets.Users> retVal = new List <DataSets.Users>();
m_dbConnection.Open();
string sql = "SELECT * FROM USERS";
SQLiteCommand command = new SQLiteCommand(sql, m_dbConnection);
SQLiteDataReader reader = command.ExecuteReader();
while (reader.Read())
{
DataSets.Users temp = new DataSets.Users();
temp.userName = reader.GetString(0);
temp.password = reader.GetString(1);
temp.fName = reader.GetString(2);
temp.lName = reader.GetString(3);
temp.pNo = reader.GetString(4);
retVal.Add(temp);
}
reader.Close();
m_dbConnection.Close();
return(retVal);
}
public bool addUser(DataSets.Users userInfo)
{
bool retVal = false;
m_dbConnection.Open();
string sql = "SELECT * FROM USERS WHERE UserName='******'";
SQLiteCommand command = new SQLiteCommand(sql, m_dbConnection);
SQLiteDataReader reader = command.ExecuteReader();
if (!reader.Read())
{
reader.Close();
retVal = true;
sql = "insert into USERS (UserName, Password,Fname,Lname,Pno,UT) values ('" + userInfo.userName +
"', '" + userInfo.password + "','" + userInfo.fName + "','" + userInfo.lName + "','" + userInfo.pNo + "','C')";
command = new SQLiteCommand(sql, m_dbConnection);
command.ExecuteNonQuery();
m_dbConnection.Close();
return(retVal);
}
reader.Close();
m_dbConnection.Close();
return(retVal);
}