/// <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("UC:8" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Start a login /// </summary> public void Login() { try { UserSP spUser = new UserSP(); CompanySP spCompany = new CompanySP(); CompanyInfo infoCompany = new CompanyInfo(); string strUserName = txtUserName.Text.Trim(); string strPassword = spUser.LoginCheck(strUserName); if (strPassword == txtPassword.Text.Trim() && strPassword != string.Empty) { int inUserId = spUser.GetUserIdAfterLogin(strUserName, strPassword); PublicVariables._decCurrentUserId = inUserId; infoCompany = spCompany.CompanyView(1); PublicVariables._decCurrencyId = infoCompany.CurrencyId; formMDI.MDIObj.CallFromLogin(); SettingsCheck(); //for Quock Launch menu formMDI.MDIObj.ShowQuickLaunchMenu(); formMDI.MDIObj.CurrentSettings(); //Display ChangeCurrentDate form// frmChangeCurrentDate frmCurrentDateChangeObj = new frmChangeCurrentDate(); frmCurrentDateChangeObj.MdiParent = formMDI.MDIObj; frmCurrentDateChangeObj.CallFromLogin(this); formMDI.MDIObj.Text = "OpenMiracle " + infoCompany.CompanyName + " [ " + PublicVariables._dtFromDate.ToString("dd-MMM-yyyy") + " To " + PublicVariables._dtToDate.ToString("dd-MMM-yyyy") + " ]"; // For showing the OpenMiracle message from the website formMDI.MDIObj.logoutToolStripMenuItem.Enabled = true; if (PublicVariables.MessageToShow != string.Empty) { frmMessage frmMsg = new frmMessage(); frmMsg.lblHeading.Text = PublicVariables.MessageHeadear; frmMsg.lblMessage.Text = PublicVariables.MessageToShow; frmMsg.MdiParent = formMDI.MDIObj; frmMsg.Show(); frmMsg.Location = new Point(0, formMDI.MDIObj.Height - 270); foreach (Form form in Application.OpenForms) { if (form.GetType() == typeof(frmChangeCurrentDate)) { form.Focus(); } } } } else { Messages.InformationMessage("Invalid username or password"); Clear(); } } catch (Exception ex) { MessageBox.Show("LOGIN02:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Function to Update values in account group Table /// </summary> /// <param name="userinfo"></param> public void UserEdit(UserInfo infoUser) { UserSP spUser = new UserSP(); try { spUser.UserEdit(infoUser); } catch (Exception ex) { MessageBox.Show("UBLL1:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Function to delete particular details based on the parameter /// </summary> /// <param name="UserId"></param> public void UserDelete(decimal UserId) { UserSP spUser = new UserSP(); try { spUser.UserDelete(UserId); } catch (Exception ex) { MessageBox.Show("UBLL1:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Function to Get UserId After Login based on parameter /// </summary> /// <param name="strUserName"></param> /// <param name="strPassword"></param> /// <returns></returns> public int GetUserIdAfterLogin(string strUserName, string strPassword) { UserSP spUser = new UserSP(); int inUserId = 0; try { inUserId = spUser.GetUserIdAfterLogin(strUserName, strPassword); } catch (Exception ex) { MessageBox.Show("UBLL1:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } return(inUserId); }
/// <summary> /// Function to view all details from user Table based on parameter /// </summary> /// <param name="strUserName"></param> /// <param name="strRole"></param> /// <returns></returns> public List <DataTable> UserCreationViewForGridFill(string strUserName, string strRole) { UserSP spUser = new UserSP(); List <DataTable> ListObj = new List <DataTable>(); try { ListObj = spUser.UserCreationViewForGridFill(strUserName, strRole); } catch (Exception ex) { MessageBox.Show("UBLL1:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } return(ListObj); }
/// <summary> /// Add user of group /// </summary> /// <param name="web"></param> /// <param name="groupName">SharePoint group name </param> /// <param name="user"></param> /// <returns></returns> public static bool AddUserGroup(this SPWeb web, string groupName, UserSP user) { try { var groups = web.SiteGroups; var groupSP = groups[groupName]; groupSP.AddUser(web.EnsureUser(user.Value)); return true; } catch (Exception exception) { Logger.Error(string.Concat("Error AddUserGroup ", exception.Message)); return false; } }
/// <summary> /// Form load make the form controls based on settings /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void frmChangePassword_Load(object sender, EventArgs e) { try { UserInfo infoUser = new UserInfo(); UserSP spUser = new UserSP(); infoUser = spUser.UserView(PublicVariables._decCurrentUserId); txtUserName.Text = infoUser.UserName; txtUserName.ReadOnly = true; } catch (Exception ex) { MessageBox.Show("CHGPWD:3" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Function to get particular values from account group table based on the parameter /// </summary> /// <param name="userId"></param> /// <returns></returns> public UserInfo UserView(decimal userId) { UserInfo infoUser = new UserInfo(); UserSP spUser = new UserSP(); try { infoUser = spUser.UserView(userId); } catch (Exception ex) { MessageBox.Show("UBLL1:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } return(infoUser); }
/// <summary> /// Function to get all the values from account group Table /// </summary> /// <returns></returns> public List <DataTable> UserViewAll() { UserSP spUser = new UserSP(); List <DataTable> ListObj = new List <DataTable>(); try { ListObj = spUser.UserViewAll(); } catch (Exception ex) { MessageBox.Show("UBLL1:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } return(ListObj); }
/// <summary> /// User Creation GridFill /// </summary> public void GridFill() { try { UserSP spUser = new UserSP(); DataTable dtblUserCreation = new DataTable(); string strSearchUserName = txtSearchUserName.Text.Trim(); string strSearchRole = cmbSearchRole.Text; dtblUserCreation = spUser.UserCreationViewForGridFill(strSearchUserName, strSearchRole); dgvUserCreation.DataSource = dtblUserCreation; } catch (Exception ex) { MessageBox.Show("UC:7" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Function for check refernce and delete based on parameter /// </summary> /// <param name="userId"></param> /// <returns></returns> public decimal UserCreationReferenceDelete(decimal userId) { UserSP spUser = new UserSP(); decimal decUser = 0; try { decUser = spUser.UserCreationReferenceDelete(userId); } catch (Exception ex) { MessageBox.Show("UBLL1:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } return(decUser); }
/// <summary> /// Function to check existence of User based on parameter /// </summary> /// <param name="decUserId"></param> /// <param name="strUserName"></param> /// <returns></returns> public bool UserCreationCheckExistence(decimal decUserId, string strUserName) { UserSP spUser = new UserSP(); bool isEdit = false; try { isEdit = spUser.UserCreationCheckExistence(decUserId, strUserName); } catch (Exception ex) { MessageBox.Show("UBLL1:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } return(isEdit); }
/// <summary> /// Function to get the next id for AdditionalCost table /// </summary> /// <returns></returns> public int UserGetMax() { UserSP spUser = new UserSP(); int inMax = 0; try { inMax = spUser.UserGetMax(); } catch (Exception ex) { MessageBox.Show("UBLL1:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } return(inMax); }
/// <summary> /// Function to check Password on Login /// </summary> /// <param name="strUserName"></param> /// <returns></returns> public string LoginCheck(string strUserName) { UserSP spUser = new UserSP(); string strPsw = string.Empty; try { strPsw = spUser.LoginCheck(strUserName); } catch (Exception ex) { MessageBox.Show("UBLL1:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } return(strPsw); }
/// <summary> /// Delete Function /// </summary> public void DeleteFunction() { try { if (PublicVariables.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("UC:9" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Update Function /// </summary> public void EditFunction() { try { UserInfo infoUser = new UserInfo(); UserSP spUser = new UserSP(); infoUser.UserId = Convert.ToDecimal(dgvUserCreation.CurrentRow.Cells["dgvtxtUserId"].Value); 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(); infoUser.Extra1 = string.Empty; infoUser.Extra2 = string.Empty; string strUserName = txtUserName.Text.Trim(); if (spUser.UserCreationCheckExistence(decUserId, strUserName) == false) { spUser.UserEdit(infoUser); Messages.UpdatedMessage(); ClearFunction(); GridFill(); txtUserName.Focus(); } else { Messages.InformationMessage("User name already exists"); txtUserName.Focus(); } } catch (Exception ex) { MessageBox.Show("UC:4" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Save function, Checking the Invalid entries /// </summary> public void SaveFunction() { try { UserInfo infoUser = new UserInfo(); UserSP spUser = new UserSP(); string strUserName = txtUserName.Text.Trim(); string strPassword = spUser.LoginCheck(strUserName); if (txtOldPassword.Text.Trim() == string.Empty) { Messages.InformationMessage("Enter password"); txtOldPassword.Focus(); } else if (txtNewPassword.Text.Trim() == string.Empty) { Messages.InformationMessage("Enter new password"); txtNewPassword.Focus(); } else if (txtRetype.Text.Trim() == string.Empty) { Messages.InformationMessage("Enter confirmation password"); txtRetype.Focus(); } else if (txtNewPassword.Text != txtRetype.Text) { Messages.InformationMessage("Password and confirm password should match"); txtRetype.Focus(); txtRetype.SelectAll(); } else if (strPassword == txtOldPassword.Text.Trim()) { if (PublicVariables.isMessageAdd) { if (Messages.SaveMessage()) { infoUser.UserId = PublicVariables._decCurrentUserId; infoUser.UserName = txtUserName.Text.Trim(); infoUser.Password = txtNewPassword.Text.Trim(); spUser.ChangePasswordEdit(infoUser); Clear(); Messages.SavedMessage(); this.Close(); } } else { infoUser.UserId = PublicVariables._decCurrentUserId; infoUser.UserName = txtUserName.Text.Trim(); infoUser.Password = txtNewPassword.Text.Trim(); spUser.ChangePasswordEdit(infoUser); } } else { Messages.InformationMessage("Invalid password"); txtOldPassword.Focus(); txtOldPassword.SelectAll(); } } catch (Exception ex) { MessageBox.Show("CHGPWD:2" + ex.Message, "Open Miracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }