public void DisplayData()
{
MISManager mISManager = new MISManager();
dataGridViewDisplay.DataSource = mISManager.ReadData();
this.ClearTextBox();
}
private void buttonAdd_Click(object sender, EventArgs e)
{
if (ValidateEmptyTextBox(1))
{
MISManager mISManager = new MISManager();
mISManager.FirstName = textBoxFirstName.Text;
mISManager.LastName = textBoxLastName.Text;
mISManager.UserName = textBoxUserName.Text;
mISManager.Password = textBoxPassword.Text;
mISManager.RoleId = Convert.ToInt32(textBoxRoleID.Text);
if (mISManager.SaveRecord(mISManager)) //! TRUE
{
MessageBox.Show("Recored Inserted..");
this.DisplayData();
}
else
{
MessageBox.Show("Recored Is Not Inserted.. \n" +
" OR \n Username is Exist -> " + mISManager.UserName,
"Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
this.ClearTextBox();
}
else
{
MessageBox.Show("Please Enter Values. ", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void buttonDelete_Click(object sender, EventArgs e)
{
if (ValidateEmptyTextBox(1) && !String.IsNullOrEmpty(textBoxUserID.Text))
{
if (MessageBox.Show("Do You Want to Delete this Record", "Delete", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
MISManager mISManager = new MISManager();
mISManager.UserId = Convert.ToInt32(textBoxUserID.Text);
if (mISManager.DelRecord(mISManager))
{
MessageBox.Show("Deletion Completed.");
}
else
{
MessageBox.Show("Deletion Is Not Completed.");
}
this.DisplayData();
this.ClearTextBox();
}
}
else
{
MessageBox.Show("Please Select a Row For Delete Operation.");
}
}
private void buttonUpdate_Click(object sender, EventArgs e)
{
if (ValidateEmptyTextBox(1) && !String.IsNullOrEmpty(textBoxUserID.Text))
{
if (MessageBox.Show("Do You Want to Update this Record", "Update", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
MISManager mISManager = new MISManager();
mISManager.UserId = Convert.ToInt32(textBoxUserID.Text);
mISManager.FirstName = textBoxFirstName.Text;
mISManager.LastName = textBoxLastName.Text;
mISManager.UserName = textBoxUserName.Text;
mISManager.Password = textBoxPassword.Text;
mISManager.RoleId = Convert.ToInt32(textBoxRoleID.Text);
if (mISManager.UpdateRecord(mISManager))
{
MessageBox.Show("Record Updated.");
this.DisplayData();
}
else
{
MessageBox.Show("Record Is Not Updated.(Check Data or UserName Must be Unique)");
}
}
this.ClearTextBox();
}
else
{
MessageBox.Show("Please Select a Row For Update Operation.");
}
}
public static DataTable SearchRecordDB(MISManager manager)
{
//string queryText = string.Format("Select * from users where UserID = {0} or FirstName LIKE '%{1}%' " +
// "or LastName LIKE '%{2}%' or UserName LIKE '%{3}%' or RoleID = {4} ",
// manager.UserId, manager.FirstName, manager.LastName, manager.UserName, manager.RoleId);
string query = " Select * from users where ";
if (manager.UserId != 0)
{
query += string.Format(" UserID = {0} ", manager.UserId);
}
else if (!string.IsNullOrEmpty(manager.FirstName))
{
query += string.Format(" FirstName LIKE '%{0}%' ", manager.FirstName);
}
else if (!string.IsNullOrEmpty(manager.LastName))
{
query += string.Format(" LastName LIKE '%{0}%' ", manager.LastName);
}
else if (!string.IsNullOrEmpty(manager.UserName))
{
query += string.Format(" UserName LIKE '%{0}%' ", manager.UserName);
}
else if (manager.RoleId != 0)
{
query += string.Format(" RoleID = '{0}' ", manager.RoleId);
}
return(MISManagerDB.ExecuteReaderQuery(query));
}
public static bool SaveRecordDB(MISManager manager)
{
string queryText = String.Format("Insert into users values ('{0}','{1}','{2}','{3}',{4})",
manager.FirstName, manager.LastName, manager.UserName, manager.Password, manager.RoleId);
return(MISManagerDB.SqlNonQuery(queryText));
}
public static bool UpdateRecordDB(MISManager manager)
{
string queryText = String.Format("Update users set FirstName = '{0}', LastName = '{1}', " +
" UserName = '******', Password='******', RoleID = {4} where UserID = {5} ",
manager.FirstName, manager.LastName, manager.UserName, manager.Password, manager.RoleId, manager.UserId);
return(MISManagerDB.SqlNonQuery(queryText));
}
private void buttonSearch_Click(object sender, EventArgs e)
{
if (ValidateEmptyTextBox(2))
{
MISManager mISManager = new MISManager();
if (comboBoxSearch.Text == Convert.ToString(comboBoxSearch.Items[0])) //UserID
{
mISManager.UserId = Convert.ToInt32(textBoxSearch.Text);
}
else if (comboBoxSearch.Text == Convert.ToString(comboBoxSearch.Items[1])) //FirstName
{
mISManager.FirstName = textBoxSearch.Text;
}
else if (comboBoxSearch.Text == Convert.ToString(comboBoxSearch.Items[2])) // LastName
{
mISManager.LastName = textBoxSearch.Text;
}
else if (comboBoxSearch.Text == Convert.ToString(comboBoxSearch.Items[3])) // UserName
{
mISManager.UserName = textBoxSearch.Text;
}
else if (comboBoxSearch.Text == Convert.ToString(comboBoxSearch.Items[4])) // RoleID
{
mISManager.RoleId = Convert.ToInt32(textBoxSearch.Text);
}
DataTable dataTable = mISManager.SearchRecord(mISManager);
if (dataTable.Rows.Count != 0)
{
dataGridViewDisplay.DataSource = dataTable;
}
else
{
dataGridViewDisplay.DataSource = null;
MessageBox.Show("Record not Found.", "Try Again", MessageBoxButtons.OK, MessageBoxIcon.None);
}
this.ClearTextBox();
}
else
{
MessageBox.Show("Please Enter the Data in Search Box.");
}
}
public static bool DelRecoredDB(MISManager manager)
{
string queryText = String.Format("Delete From users where UserID = {0} ", manager.UserId);
return(MISManagerDB.SqlNonQuery(queryText));
}
