protected void ddlManagerRole_SelectedIndexChanged(object sender, EventArgs e) { lblerr.Text = ""; clsTbUser User = new clsTbUser(); User.sRole = ddlManagerRole.SelectedValue.ToString(); DataTable dt = User.GetDataByRoles(); DataTable dt1 = User.GetRoles4Employees(); if (dt.Rows.Count > 0) { ddlManager.DataSource = dt; ddlManager.DataTextField = "User_Name"; ddlManager.DataValueField = "ID"; ddlManager.DataBind(); } ddlManager.Items.Insert(0, "Select"); if (dt1.Rows.Count > 0) { ddlEmployeeRole.DataSource = dt1; ddlEmployeeRole.DataTextField = "Role"; ddlEmployeeRole.DataBind(); } ddlEmployeeRole.Items.Insert(0, "Select"); }
protected void btnLogin_Click(object sender, EventArgs e) { //txtPassword.Text = GetSHA1HashData(txtUserName.Text); clsTbUser User = new clsTbUser(); if (txtUserName.Text == "" || txtPassword.Text == "") { lblerr.Text = "User Name and Password is Mandatary"; } else { User.sUser_Name = txtUserName.Text.Trim(); User.sPassword = GetSHA1HashData(txtPassword.Text); if (User.IsUserExists_Login()) { if (txtUserName.Text == "SuperAdmin" || txtUserName.Text == "superadmin" || txtUserName.Text == "SUPERADMIN") { Session["UserName"] = txtUserName.Text.Trim(); Response.Redirect("Admin/Home.aspx"); lblerr.Text = ""; } } else { lblerr.Text = "UserName or Password is incorrect or Account is inactive. Contact Admin."; txtUserName.Text = ""; txtPassword.Text = ""; } } //Response.Redirect("Admin/Home.aspx"); }
public void LoadManagerRoles() { clsTbUser User = new clsTbUser(); DataTable dt = User.GetRoles(); if (dt.Rows.Count > 0) { ddlManagerRole.DataSource = dt; ddlManagerRole.DataTextField = "Role"; ddlManagerRole.DataBind(); } ddlManagerRole.Items.Insert(0, "Select"); }
protected void btnSubmit_Click(object sender, EventArgs e) { if (txtFirstName.Text == "" || txtLastName.Text == "" || txtUserName.Text == "" || txtPassword.Text == "") { lblerr.Text = "* Marked fields are Empty."; } else { clsTbContact Contact = new clsTbContact(); Contact.sFST_Name = txtFirstName.Text.Trim(); Contact.sLAST_Name = txtLastName.Text.Trim(); Contact.daDOB = Convert.ToDateTime(txtDOB.Text.Trim()); Contact.sSSN = txtSSN.Text.Trim(); if (rbtnMale.Checked == true) { Contact.sGender = "Male"; } else { Contact.sGender = "Female"; } Contact.sStatus = ddlStatus.SelectedValue.ToString(); Contact.sPrimary_Email = txtPrimaryEmail.Text.Trim(); Contact.sSecondary_Email = txtSecondaryEmail.Text.Trim(); Contact.sSkypeID = txtSkypeID.Text.Trim(); Contact.sType = ddlType.SelectedValue.ToString(); Contact.sCurrent_Location = txtCurrentLocation.Text.Trim(); Contact.sCurrent_Client = txtCurrentClient.Text.Trim(); Contact.sAvailable_For_Interview = ddlAvailableForInterview.SelectedValue.ToString(); Contact.sAvailability_To_Join = ddlAvailabilityToJoin.SelectedValue.ToString(); //Contact.iRecruiterID = ""; //Contact.iSub_Vendor_ID = ""; Contact.sType2 = ddlType2.SelectedValue.ToString(); Contact.sPrimary_Skill = txtPrimarySkill.Text.Trim(); Contact.sSecondary_Skill = txtSecondarySkill.Text.Trim(); Contact.sIMMI_Status = txtIMMIStatus.Text.Trim(); Contact.sDescription = txtDescription.Text.Trim(); if (txtDOB.Text == "") { txtDOB.Text = "01/01/1900"; } if (txtClientRate.Text == "") { txtClientRate.Text = "0.0"; } if (txtSynergyRate.Text == "") { txtSynergyRate.Text = "0.0"; } if (txtHealthInsurance.Text == "") { txtHealthInsurance.Text = "0.0"; } if (txtH1BExp.Text == "") { txtH1BExp.Text = "0.0"; } if (txtPTO.Text == "") { txtPTO.Text = "0"; } if (txtOtherIMMIExp.Text == "") { txtOtherIMMIExp.Text = "0.0"; } if (txtCOMM.Text == "") { txtCOMM.Text = "0.0"; } if (txtNumberOfYearsExperience.Text == "") { txtNumberOfYearsExperience.Text = "0"; } Contact.dcClient_Rate = Convert.ToDecimal(txtClientRate.Text.Trim()); Contact.dcSynergy_Rate = Convert.ToDecimal(txtSynergyRate.Text.Trim()); Contact.dcHealth_Insurance = Convert.ToDecimal(txtHealthInsurance.Text.Trim()); Contact.dcH1B_Exp = Convert.ToDecimal(txtH1BExp.Text.Trim()); Contact.iPTO = Convert.ToInt32(txtPTO.Text.Trim()); Contact.dcOther_IMMI_Exp = Convert.ToDecimal(txtOtherIMMIExp.Text.Trim()); Contact.dcCOMM = Convert.ToDecimal(txtCOMM.Text.Trim()); Contact.iNo_Of_Years_Exp = Convert.ToInt32(txtNumberOfYearsExperience.Text.Trim()); Contact.sSeniority = ddlSeniority.SelectedValue.ToString(); Contact.sComm_Skills = ddlCommSkills.SelectedValue.ToString(); Contact.sAddress_Line1 = txtAddressLine1.Text.Trim(); Contact.sAddress_Line2 = txtAddressLine2.Text.Trim(); Contact.sCity = txtCity.Text.Trim(); Contact.sState = txtState.Text.Trim(); Contact.sZip = txtZip.Text.Trim(); Contact.sCountry = txtCountry.Text.Trim(); clsTbUser User = new clsTbUser(); User.sStatus = ddlStatus.SelectedValue.ToString(); User.sRole = ddlRole.SelectedItem.Text; User.sRole_Level = ddlRole_Level.SelectedItem.Text; User.sUser_Name = txtUserName.Text.Trim(); User.sPassword = GetSHA1HashData(txtPassword.Text.Trim()); //txtPassword.Text.Trim(); //User.sSEC_Q1 = ""; //User.sSEC_A1 = ""; //User.sSEC_Q2 = ""; //User.sSEC_A2 = ""; if (string.IsNullOrEmpty(Request.QueryString["ID"])) { if (User.IsUserExists()) { lblerr.Text = "UserName Already Taken. Please Choose Another UserName"; txtUserName.Focus(); } else { Contact.daCDate = Convert.ToDateTime(DateTime.Now); Contact.sCPerson = Session["UserName"].ToString(); DataTable dti = Contact.Insert(); string CID = dti.Rows[0][0].ToString(); User.daCDate = Convert.ToDateTime(DateTime.Now); User.sCPerson = Session["UserName"].ToString(); DataTable dtiu = User.Insert(); string CUID = dtiu.Rows[0][0].ToString(); clsTbContact_User CU = new clsTbContact_User(); CU.iContact_ID = Convert.ToInt32(CID); CU.iUser_ID = Convert.ToInt32(CUID); CU.sStatus = ddlStatus.SelectedValue.ToString(); CU.Insert(); lblerr.Text = "Successfully Registered Contact ID: " + CID + "UserID: " + CUID; } } else { int i = Convert.ToInt32(Request.QueryString["id"].ToString()); Contact.iID = i; Contact.Update(); lblerr.Text = "Updated Successfully"; Bind(); } } }
protected void btnSubmit_Click(object sender, EventArgs e) { clsTbUser User = new clsTbUser(); clsTbClient_Team CTeam = new clsTbClient_Team(); CTeam.iClient_ID = Convert.ToInt32(ddlClientName.SelectedValue.ToString()); CTeam.sName = txtName.Text.Trim(); CTeam.sState = ddlStatus.SelectedItem.ToString(); CTeam.sRole = ddlClientRole.SelectedItem.ToString(); CTeam.sEmail = txtEmail.Text.Trim(); CTeam.sPrimary_Phone = txtPrimaryPhone.Text.Trim(); CTeam.sSecondary_Phone = txtSecondaryPhone.Text.Trim(); CTeam.sLocation = txtLocation.Text.Trim(); CTeam.sAddress_Line1 = txtAddress_Line1.Text.Trim(); CTeam.sAddress_Line2 = txtAddress_Line2.Text.Trim(); CTeam.sCity = txtCity.Text.Trim(); CTeam.sState = txtState.Text.Trim(); CTeam.sZip = txtZIP.Text.Trim(); CTeam.sCountry = txtCountry.Text.Trim(); CTeam.sStatus = ddlStatus.SelectedValue.ToString(); User.sStatus = ddlStatus.SelectedValue.ToString(); User.sRole = ddlUserRole.SelectedItem.Text; User.sRole_Level = ddlRole_Level.SelectedItem.Text; User.sUser_Name = txtUserName.Text.Trim(); User.sPassword = GetSHA1HashData(txtPassword.Text.Trim()); //txtPassword.Text.Trim(); //User.sSEC_Q1 = ""; //User.sSEC_A1 = ""; //User.sSEC_Q2 = ""; //User.sSEC_A2 = ""; if (string.IsNullOrEmpty(Request.QueryString["ID"])) { if (txtName.Text == "" || txtUserName.Text == "" || txtPassword.Text == "") { lblerr.Text = "* marked are compulsory"; } else { if (User.IsUserExists()) { lblerr.Text = "UserName Already Taken. Please Choose Another UserName"; txtUserName.Focus(); } else { CTeam.daCDate = Convert.ToDateTime(DateTime.Now); CTeam.sCPerson = Session["UserName"].ToString(); DataTable dti = CTeam.Insert(); string CID = dti.Rows[0][0].ToString(); User.daCDate = Convert.ToDateTime(DateTime.Now); User.sCPerson = Session["UserName"].ToString(); DataTable dtiu = User.Insert(); string CUID = dtiu.Rows[0][0].ToString(); clsTbClient_User CU = new clsTbClient_User(); CU.iClient_ID = Convert.ToInt32(CID); CU.iUser_ID = Convert.ToInt32(CUID); CU.sStatus = ddlStatus.SelectedValue.ToString(); CU.Insert(); lblerr.Text = "Successfully Registered ClientID: " + CID + "UserID: " + CUID; } } } else { if (txtName.Text == "") { lblerr.Text = "* marked are compulsory"; } else { int i = Convert.ToInt32(Request.QueryString["id"].ToString()); CTeam.iID = i; CTeam.Update(); lblerr.Text = "Updated Successfully"; } } txtName.Text = ""; txtEmail.Text = ""; txtPrimaryPhone.Text = ""; txtSecondaryPhone.Text = ""; txtLocation.Text = ""; txtAddress_Line1.Text = ""; txtAddress_Line2.Text = ""; txtCity.Text = ""; txtState.Text = ""; txtZIP.Text = ""; txtCountry.Text = ""; Bind(); }