/// <summary>
/// Function to fill the values in curresponding controls for updation
/// </summary>
public void FillControls()
{
try
{
UserInfo infoUser = new UserInfo();
UserSp spUser = new UserSp();
infoUser = spUser.UserView(decUserId);
txtUserName.Text = infoUser.UserName;
txtPassword.Text = infoUser.Password;
cmbRole.SelectedValue = infoUser.RoleId;
txtNarration.Text = infoUser.Narration;
if (infoUser.Active)
{
cbxActive.Checked = true;
}
else
{
cbxActive.Checked = false;
}
txtRetype.Text = txtPassword.Text;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
/// <summary>
/// Function that validates user credentials
/// </summary>
public void _login()
{
UserInfo userinfo = new UserInfo();
UserSp validate_user = new UserSp();
userinfo.UserName = txtUserName.Text.Trim();
userinfo.Password = txtPassword.Text.Trim();
int dbresult = validate_user.accessdb(userinfo);
if (txtPassword.Text.Length > 0 && txtUserName.Text.Length > 0)
{
if (dbresult == 1)
{
frmMDI frm = new frmMDI();
frm.Show();
this.Hide();
}
else
{
MessageBox.Show("Wrong username or password", "Niambie School Management", MessageBoxButtons.OK, MessageBoxIcon.Error);
txtUserName.Focus();
}
}
else
{
MessageBox.Show("Please enter Username and Password values to continue", "Niambie School Management", MessageBoxButtons.OK, MessageBoxIcon.Warning);
txtUserName.Focus();
}
}
/// <summary>
/// User Creation GridFill
/// </summary>
public void GridFill()
{
try
{
UserSp spUser = new UserSp();
DataTable dtblUserCreation = new DataTable();
dtblUserCreation = spUser.UserCreationViewForGridFill();
dgvUserCreation.DataSource = dtblUserCreation;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
/// <summary>
/// Delete Function
/// </summary>
public void DeleteFunction()
{
bool isMessageDelete = true;
try
{
if (isMessageDelete)
{
if (Messages.DeleteMessage())
{
UserInfo infoUser = new UserInfo();
UserSp spUser = new UserSp();
if ((spUser.UserCreationReferenceDelete(decUserId) == -1))
{
Messages.ReferenceExistsMessage();
}
else
{
Messages.DeletedMessage();
btnSave.Text = "Save";
btnDelete.Enabled = false;
ClearFunction();
GridFill();
}
}
}
else
{
UserInfo infoUser = new UserInfo();
UserSp spUser = new UserSp();
if ((spUser.UserCreationReferenceDelete(decUserId) == -1))
{
Messages.ReferenceExistsMessage();
}
else
{
Messages.DeletedMessage();
btnSave.Text = "Save";
btnDelete.Enabled = false;
ClearFunction();
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
/// <summary>
/// Save Function
/// </summary>
private void SaveFunction()
{
try
{
UserInfo infoUser = new UserInfo();
UserSp spUser = new UserSp();
infoUser.UserName = txtUserName.Text.Trim();
infoUser.Password = txtPassword.Text.Trim();
if (cbxActive.Checked)
{
infoUser.Active = true;
}
else
{
infoUser.Active = false;
}
infoUser.RoleId = Convert.ToDecimal(cmbRole.SelectedValue);
infoUser.Narration = txtNarration.Text.Trim();
string strUserName = txtUserName.Text.Trim();
if (spUser.UserCreationCheckExistence(decUserId, strUserName) == false)
{
spUser.UserAdd(infoUser);
Messages.SavedMessage();
ClearFunction();
GridFill();
txtUserName.Focus();
}
else
{
MessageBox.Show("User name already exists");
txtUserName.Focus();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
