private void btnDeleteUser_Click(object sender, EventArgs e)
{
if (txtUserId.Text.Length == 0)
{
Mymessage mymessage = new Mymessage("UserID is required!");
mymessage.Show();
return;
}
u1.id = Convert.ToInt32(txtUserId.Text);
bool success = dal.Delete(u1);//= dal.Delete(u1);
if (success == true)
{
Mymessage mymessage = new Mymessage("Data Succussfully Deleted!");
mymessage.Show();
clearUser();
}
else
{
Mymessage myMessageBox = new Mymessage("There is Error while Deleting data in the DataBase");
myMessageBox.Show();
}
DataTable dt = dal.select();//dal.select();
GDVusers.DataSource = dt;
GDVusers.Refresh();
}
private void txtSearch_OnValueChanged(object sender, EventArgs e)
{
string keywords = txtSearch.Text;
if (keywords != null)
{
DataTable dt = dal.Search(keywords);//=dal.Search(keywords);
GDVusers.DataSource = dt;
GDVusers.Refresh();
}
else
{
DataTable dt = dal.select();//=dal.Select();
GDVusers.DataSource = dt;
GDVusers.Refresh();
}
}
private void btnUpdateUser_Click(object sender, EventArgs e)
{
if (txtUserId.Text.Length == 0)
{
Mymessage mymessage = new Mymessage("UserID is required!");
mymessage.Show();
return;
}
if (txtFName.Text.Length == 0)
{
Mymessage mymessage = new Mymessage("User First Name is required!");
mymessage.Show();
return;
}
if (txtLName.Text.Length == 0)
{
Mymessage mymessage = new Mymessage("User Last Name is required!");
mymessage.Show();
return;
}
if (txtEMail.Text.Length == 0)
{
Mymessage mymessage = new Mymessage("User E-Mail is required, If don't have Enter '*****@*****.**'!");
mymessage.Show();
return;
}
if (txtUserName.Text.Length == 0)
{
Mymessage mymessage = new Mymessage("UserName is required!");
mymessage.Show();
return;
}
if (txtPassword.Text.Length == 0)
{
Mymessage mymessage = new Mymessage("Password is required!");
mymessage.Show();
return;
}
if (txtContact.Text.Length == 0)
{
Mymessage mymessage = new Mymessage("User Contact Number is required!");
mymessage.Show();
return;
}
if (txtAddress.Text.Length == 0)
{
Mymessage mymessage = new Mymessage("User Address is required!");
mymessage.Show();
return;
}
if (cmbGender.Text.Length == 0)
{
Mymessage mymessage = new Mymessage("User Gender is required!,Please select one of them!");
mymessage.Show();
return;
}
if (cmbUserType.Text.Length == 0)
{
Mymessage mymessage = new Mymessage("UserType is required!, pLease Select a user type!");
mymessage.Show();
return;
}
u1.id = Convert.ToInt32(txtUserId.Text.ToString());
u1.First_Name = txtFName.Text;
u1.Last_Name = txtLName.Text;
u1.EMail = txtEMail.Text;
u1.UserName = txtUserName.Text;
u1.Password = txtPassword.Text;
u1.Contact = txtContact.Text;
u1.Address = txtAddress.Text;
u1.Gender = cmbGender.Text;
u1.UserType = cmbUserType.Text;
u1.Added_Date = DateTime.Now;
u1.Added_By = 1;
bool success = dal.Update(u1);//= dal.Update(u1);
if (success == true)
{
Mymessage mymessage = new Mymessage("Data Succussfully Updated!");
mymessage.Show();
}
else
{
Mymessage myMessageBox = new Mymessage("There is Error while Updating data in the DataBase");
myMessageBox.Show();
}
DataTable dt = dal.select();//dal.select();
GDVusers.DataSource = dt;
GDVusers.Refresh();
}
