public void changemypassword(Credential_DB cDB)
{
string query = String.Format("UPDATE [credential] SET [password] = '{0}' where [username] = '{1}' and [usertype] = '{2}'", cDB.Password, cDB.UserName, cDB.UserType);
Business_Logic BL = new Business_Logic();
BL.NonQuery(query);
}
public void deleteuser(Credential_DB cDB)
{
string query = String.Format("delete from credential where username = '******'", cDB.UserName);
Business_Logic BL = new Business_Logic();
BL.NonQuery(query);
}
public void createnewuser(Credential_DB cDB)
{
string query = String.Format("Insert into Credential Values('{0}','{1}','{2}','{3}','{4}')", cDB.UserName, cDB.Password, cDB.UserType, cDB.name, cDB.city);
Business_Logic BL = new Business_Logic();
BL.NonQuery(query);
}