private void metroButtonRegAddU_Click(object sender, EventArgs e)
{
if (metroTextBoxUnames.Text == "" || metroTextBoxPws.Text == "")
{
MessageBox.Show("Fields cannot be empty");
}
else
{
CommonDBTransaction c = new CommonDBTransaction();
string sql = "SELECT * FROM Registar WHERE Username = '******'";
DataTable d = c.searchData(sql);
metroGridRegs.DataSource = d;
if (d.Rows.Count > 0)
{
MetroMessageBox.Show(this, "This Data already exist");
}
else
{
Registar obj = new Registar(metroTextBoxUnames.Text, metroTextBoxPws.Text);
RegistarTransactions tr = new RegistarTransactions();
tr.addRegistar(obj);
MetroMessageBox.Show(this, "Data Saved Sucessfully !");
clearReg();
}
}
}
void DataGridViewReg()
{
RegistarTransactions c = new RegistarTransactions();
string sql = "SELECT * FROM Registar";
DataTable dt = c.searchData(sql);
metroGridRegs.DataSource = dt;
}