private void btnUpdate_Click(object sender, EventArgs e)
{
bool status = true;
if (txtFirstName.Text == string.Empty)
{
pnlError.Visible = true;
pnlError.BackColor = System.Drawing.ColorTranslator.FromHtml("#f5b7b7");
pnlError.Location = new Point((this.Width - pnlError.ClientSize.Width) / 2, 12);
lblError.Text = "First Name is required";
lblError.Location = new Point((pnlError.Width - lblError.ClientSize.Width) / 2, (pnlError.Height - lblError.ClientSize.Height) / 2);
status = false;
txtFirstName.Focus();
return;
}
if (txtLastName.Text == string.Empty)
{
pnlError.Visible = true;
pnlError.BackColor = System.Drawing.ColorTranslator.FromHtml("#f5b7b7");
pnlError.Location = new Point((this.Width - pnlError.ClientSize.Width) / 2, 12);
lblError.Text = "Last Name is required";
lblError.Location = new Point((pnlError.Width - lblError.ClientSize.Width) / 2, (pnlError.Height - lblError.ClientSize.Height) / 2);
status = false;
txtLastName.Focus();
return;
}
if (txtUserName.Text == string.Empty)
{
pnlError.Visible = true;
pnlError.BackColor = System.Drawing.ColorTranslator.FromHtml("#f5b7b7");
pnlError.Location = new Point((this.Width - pnlError.ClientSize.Width) / 2, 12);
lblError.Text = "User Name is required";
lblError.Location = new Point((pnlError.Width - lblError.ClientSize.Width) / 2, (pnlError.Height - lblError.ClientSize.Height) / 2);
status = false;
txtUserName.Focus();
return;
}
if (txtPassword.Text == string.Empty)
{
pnlError.Visible = true;
pnlError.BackColor = System.Drawing.ColorTranslator.FromHtml("#f5b7b7");
pnlError.Location = new Point((this.Width - pnlError.ClientSize.Width) / 2, 12);
lblError.Text = "Password is required";
lblError.Location = new Point((pnlError.Width - lblError.ClientSize.Width) / 2, (pnlError.Height - lblError.ClientSize.Height) / 2);
status = false;
txtPassword.Focus();
return;
}
if (txtConfirmPassword.Text == string.Empty)
{
pnlError.Visible = true;
pnlError.BackColor = System.Drawing.ColorTranslator.FromHtml("#f5b7b7");
pnlError.Location = new Point((this.Width - pnlError.ClientSize.Width) / 2, 12);
lblError.Text = "Please confirm Password";
lblError.Location = new Point((pnlError.Width - lblError.ClientSize.Width) / 2, (pnlError.Height - lblError.ClientSize.Height) / 2);
status = false;
txtConfirmPassword.Focus();
return;
}
if (cmbRoles.Text == "Choose Role" || cmbRoles.Text.Length == 0)
{
pnlError.Visible = true;
pnlError.Location = new Point((this.Width - pnlError.ClientSize.Width) / 2, 12);
pnlError.BackColor = System.Drawing.ColorTranslator.FromHtml("#f5b7b7");
lblError.Text = "Select a Role";
lblError.Location = new Point((pnlError.Width - lblError.ClientSize.Width) / 2, (pnlError.Height - lblError.ClientSize.Height) / 2);
status = false;
cmbRoles.Focus();
return;
}
if (cmbStatus.Text == "-Choose a Status-")
{
pnlError.Visible = true;
pnlError.Location = new Point((this.Width - pnlError.ClientSize.Width) / 2, 12);
pnlError.BackColor = System.Drawing.ColorTranslator.FromHtml("#f5b7b7");
lblError.Text = "Select a Status";
lblError.Location = new Point((pnlError.Width - lblError.ClientSize.Width) / 2, (pnlError.Height - lblError.ClientSize.Height) / 2);
status = false;
cmbStatus.Focus();
return;
}
if (txtPassword.Text != txtConfirmPassword.Text)
{
pnlError.Visible = true;
pnlError.BackColor = System.Drawing.ColorTranslator.FromHtml("#f5b7b7");
pnlError.Location = new Point((this.Width - pnlError.ClientSize.Width) / 2, 12);
lblError.Text = "Password and Confirm Password does not match, try again";
lblError.Location = new Point((pnlError.Width - lblError.ClientSize.Width) / 2, (pnlError.Height - lblError.ClientSize.Height) / 2);
status = false;
return;
}
if (!status)
{
MessageBox.Show("Please Enter Required Data");
}
else
{
try
{
//* Updating User details in Users table *//
Boolean Status = Convert.ToBoolean(0);
if (cmbStatus.Text == "Active")
{
Status = Convert.ToBoolean(1);
}
else if (cmbStatus.Text == "InActive")
{
Status = Convert.ToBoolean(0);
}
NewUserManager objNewUserManager = new NewUserManager();
NandanaResult insertUserValues = objNewUserManager.UpdateUserDetails(UserID, txtFirstName.Text.Trim(), txtLastName.Text.Trim(), txtMiddleName.Text.Trim(), txtAddress.Text.Trim(), txtCity.Text.Trim(), txtState.Text.Trim(), txtCountry.Text.Trim(), txtZip.Text.Trim(), txtMobile.Text.Trim(), txtHomePhone.Text.Trim(), txtUserName.Text.Trim(), this.Encrypt(txtPassword.Text.Trim()), cmbRoles.SelectedValue.ToString(), Status);
//* End *//
SaveSuccess objSaveSuccess = new SaveSuccess();
objSaveSuccess.FormName = "NewUser";
objSaveSuccess.ShowDialog();
EmptyControls();
GetUsersDetails();
txtUserName.ReadOnly = false;
btnUpdate.Visible = false;
btnSave.Visible = true;
}
catch (Exception x)
{
MessageBox.Show(x.Message, "Error while Inserting Data from InsertUserValues SP");
}
}
}
public void GetUsersDetails()
{
dgvUsers.Columns.Clear();
dgvUsers.AutoGenerateColumns = false;
dgvUsers.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
dgvUsers.ColumnHeadersDefaultCellStyle.ForeColor = System.Drawing.ColorTranslator.FromHtml("#444444");
this.dgvUsers.ColumnHeadersDefaultCellStyle.Font = new System.Drawing.Font("Segoe UI", 11.00F);
DataGridViewColumn clnDocumentID = new DataGridViewTextBoxColumn();
clnDocumentID.DataPropertyName = "User_ID";
clnDocumentID.Name = "User_ID";
dgvUsers.Columns.Add(clnDocumentID);
clnDocumentID.Visible = false;
DataGridViewLinkColumn clnDocumentName = new DataGridViewLinkColumn();
clnDocumentName.LinkBehavior = System.Windows.Forms.LinkBehavior.NeverUnderline;
clnDocumentName.LinkColor = Color.Blue;
clnDocumentName.DataPropertyName = "Name";
clnDocumentName.Name = "Name";
dgvUsers.Columns.Add(clnDocumentName);
dgvUsers.Columns[1].SortMode = DataGridViewColumnSortMode.NotSortable;
DataGridViewColumn clnDocumentPath = new DataGridViewTextBoxColumn();
clnDocumentPath.DataPropertyName = "Address";
clnDocumentPath.Name = "Address";
dgvUsers.Columns.Add(clnDocumentPath);
DataGridViewColumn clnKeyword = new DataGridViewTextBoxColumn();
clnKeyword.DataPropertyName = "State";
clnKeyword.Name = "State";
dgvUsers.Columns.Add(clnKeyword);
DataGridViewColumn clnKeywordID = new DataGridViewTextBoxColumn();
clnKeywordID.DataPropertyName = "Country";
clnKeywordID.Name = "Country";
dgvUsers.Columns.Add(clnKeywordID);
DataGridViewColumn clnProcesstype = new DataGridViewTextBoxColumn();
clnProcesstype.DataPropertyName = "MobileNo";
clnProcesstype.Name = "MobileNo";
dgvUsers.Columns.Add(clnProcesstype);
DataGridViewColumn clnUsername = new DataGridViewTextBoxColumn();
clnUsername.DataPropertyName = "User_Name";
clnUsername.Name = "UserName";
dgvUsers.Columns.Add(clnUsername);
dgvUsers.Columns[6].HeaderCell.SortGlyphDirection = SortOrder.None;
DataGridViewColumn clnRole = new DataGridViewTextBoxColumn();
clnRole.DataPropertyName = "Role_Name";
clnRole.Name = "Role";
dgvUsers.Columns.Add(clnRole);
DataGridViewImageColumn img = new DataGridViewImageColumn();
img.Image = global::DocSort_CPA.Properties.Resources.delete1;
dgvUsers.Columns.Add(img);
img.HeaderText = "";
img.Name = "img";
img.AutoSizeMode = DataGridViewAutoSizeColumnMode.None;
img.Width = 40;
Dttemp.Clear();
try
{
NewUserManager objShowDocumentsManager = new NewUserManager();
NandanaResult dsgetScannedDocumentResultsdetails = objShowDocumentsManager.GetUsers();
UserManager objUserManager = new UserManager();
NandanaResult dsUserData = objUserManager.GetRoles();
if (dsgetScannedDocumentResultsdetails.resultDS != null && dsgetScannedDocumentResultsdetails.resultDS.Tables[0].Rows.Count > 0)
{
foreach (DataRow dr in dsgetScannedDocumentResultsdetails.resultDS.Tables[0].Rows)
{
DataRow[] drResult = dsUserData.resultDS.Tables[0].Select("Role_ID =" + dr["Role_ID"].ToString() + "");
if (drResult.Count() != 0)
{
DataRow drtemp = Dttemp.NewRow();
drtemp["User_ID"] = dr["User_ID"].ToString();
drtemp["Name"] = dr["Name"].ToString();
drtemp["Address"] = dr["Address"].ToString();
drtemp["State"] = dr["State"].ToString();
drtemp["Country"] = dr["Country"].ToString();
drtemp["MobileNo"] = dr["MobileNo"].ToString();
drtemp["User_Name"] = dr["User_Name"].ToString();
drtemp["Role_Name"] = drResult[0].ItemArray[1].ToString();
Dttemp.Rows.Add(drtemp);
}
}
dgvUsers.DataSource = Dttemp;
}
else
{
dgvUsers.DataSource = null;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error While retriving data from GetUsers table");
}
}
private void dgvUsers_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
NewUserManager objNewUserManager = new NewUserManager();
if (dgvUsers.Rows.Count > 0)
{
if (e.ColumnIndex == 8)
{
int row;
row = e.RowIndex;
DeleteConfirmation objDeleteConfirmation = new DeleteConfirmation();
objDeleteConfirmation.UserName = dgvUsers.Rows[row].Cells[1].Value.ToString();
objDeleteConfirmation.ShowDialog();
if (objDeleteConfirmation.DeleteConfirmationRequest == "Yes")
{
if (row >= 0)
{
UserID = dgvUsers.Rows[row].Cells[0].Value.ToString();
try
{
NandanaResult result = new NandanaResult();
result = objNewUserManager.DeleteUserDetails(UserID);
}
catch (Exception x)
{
MessageBox.Show(x.Message, "Error while Deleting Data from DeletePayslip SP");
}
GetUsersDetails();
}
}
}
if (e.ColumnIndex == 1)
{
int row;
row = e.RowIndex;
if (row >= 0)
{
UserID = dgvUsers.Rows[row].Cells[0].Value.ToString();
}
if (UserID != null && UserID != string.Empty)
{
Boolean Status = false;
try
{
NandanaResult dsUserdetailValues = objNewUserManager.GetUserDetailsUsingUserID(UserID);
if (dsUserdetailValues.resultDS != null && dsUserdetailValues.resultDS.Tables[0].Rows.Count > 0)
{
DataRow dr = dsUserdetailValues.resultDS.Tables[0].Rows[0];
txtFirstName.Text = dr["FirstName"].ToString();
txtLastName.Text = dr["LastName"].ToString();
txtMiddleName.Text = dr["MiddleName"].ToString();
txtAddress.Text = dr["Address"].ToString();
txtCity.Text = dr["City"].ToString();
txtState.Text = dr["State"].ToString();
txtCountry.Text = dr["Country"].ToString();
txtZip.Text = dr["Zip"].ToString();
txtMobile.Text = dr["MobileNo"].ToString();
txtHomePhone.Text = dr["AlternateMobileNo"].ToString();
txtUserName.Text = dr["User_Name"].ToString();
txtPassword.Text = this.Decrypt(dr["Password"].ToString());
txtConfirmPassword.Text = this.Decrypt(dr["Password"].ToString());
cmbRoles.SelectedValue = dr["Role_ID"].ToString();
Status = Convert.ToBoolean(dr["Status"]);
}
txtUserName.ReadOnly = true;
if (Status == true)
{
cmbStatus.Text = "Active";
}
else
{
cmbStatus.Text = "InActive";
}
btnSave.Visible = false;
btnUpdate.Visible = true;
btnUpdate.Location = new Point(471, 301);
}
catch (Exception x)
{
MessageBox.Show(x.Message, "Error while Retreiving Data from GetUserDetailsUsingUserID SP");
}
txtFirstName.Focus();
}
}
}
}
public BaseController(GameManager gameManager, NewUserManager userManager)
{
GameManager = gameManager;
UserManager = userManager;
}