protected void LoadExecutiveDDLs() { ddlEndorsedBy1.Items.Clear(); //ddlEndorsedBy1.DataSource = clsEmployee.DSLEmployeeListManagerVPSupervisor(Request.Cookies["Speedo"]["UserName"]); ddlEndorsedBy1.DataSource = clsModuleApprover.GetDSLFinanceApprover(clsModule.RFPModule, "1"); ddlEndorsedBy1.DataValueField = "pvalue"; ddlEndorsedBy1.DataTextField = "ptext"; ddlEndorsedBy1.DataBind(); ddlEndorsedBy1.Items.Insert(0, new ListItem("-", String.Empty)); ddlEndorsedBy1.SelectedIndex = 0; ddlEndorsedBy2.Items.Clear(); //ddlEndorsedBy2.DataSource = clsEmployee.DSLEmployeeListManagerVPSupervisor(Request.Cookies["Speedo"]["UserName"]); ddlEndorsedBy1.DataSource = clsModuleApprover.GetDSLFinanceApprover(clsModule.RFPModule, "1"); ddlEndorsedBy2.DataValueField = "pValue"; ddlEndorsedBy2.DataTextField = "pText"; ddlEndorsedBy2.DataBind(); ddlEndorsedBy2.Items.Insert(0, new ListItem("-", String.Empty)); ddlEndorsedBy2.SelectedIndex = 0; ddlAuthorized.Items.Clear(); //ddlAuthorized.DataSource = clsEmployee.DSLEmployeeListManagerVPSupervisor(Request.Cookies["Speedo"]["UserName"]); ddlAuthorized.DataSource = clsModuleApprover.GetDSLFinanceApprover(clsModule.RFPModule, "2"); ddlAuthorized.DataValueField = "pValue"; ddlAuthorized.DataTextField = "pText"; ddlAuthorized.DataBind(); using (clsEmployee employee = new clsEmployee()) { employee.Username = ddlExecutive.SelectedValue; employee.Fill(); ddlAuthorized.SelectedValue = clsDivision.GetDivisionHead(employee.DivisionCode); } }
/////////////////////////////// ///////// Page Events ///////// /////////////////////////////// protected void Page_Load(object sender, EventArgs e) { clsSpeedo.Authenticate(); //btnSend.Attributes.Add("onclick", "if(Page_ClientValidate()){this.disabled=true;" + btnSend.Page.ClientScript.GetPostBackEventReference(btnSend, string.Empty).ToString() + ";return CheckIsRepeat();}"); btnSend.Attributes.Add("onclick", " this.disabled = true; " + ClientScript.GetPostBackEventReference(btnSend, null) + ";"); if (!Page.IsPostBack) { //string strProcessScript = "this.value='" + clsString.Submit + "';this.disabled=true;"; // btnSend.Attributes.Add("onclick", strProcessScript + ClientScript.GetPostBackEventReference(btnSend, "").ToString()); CreateDataTable(); ddlDivision.DataSource = clsModuleApprover.GetDSLDivisionHeadApprover(Request.Cookies["Speedo"]["UserName"], clsModule.ATWModule); ddlDivision.DataValueField = "pvalue"; ddlDivision.DataTextField = "ptext"; ddlDivision.DataBind(); using (clsEmployee employee = new clsEmployee()) { employee.Username = Request.Cookies["Speedo"]["UserName"]; employee.Fill(); lblRequestorName.Text = employee.FirstName + " " + employee.MiddleInitial + ". " + employee.LastName; } ddlApprover.DataSource = clsModuleApprover.DSLApproverEmployee(Request.Cookies["Speedo"]["UserName"], clsModule.ATWModule, "1"); ddlApprover.DataValueField = "pvalue"; ddlApprover.DataTextField = "ptext"; ddlApprover.DataBind(); divScheduleList.Visible = false; dtpDateStart.Date = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day, 22, 0, 0); dtpDateEnd.Date = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day, 23, 0, 0); } }
protected void Page_Load(object sender, EventArgs e) { clsSpeedo.Authenticate(); // btnSend.Attributes.Add("onclick", "if(Page_ClientValidate()){this.disabled=true;" + btnSend.Page.ClientScript.GetPostBackEventReference(btnSend, string.Empty).ToString() + ";return CheckIsRepeat();}"); btnSend.Attributes.Add("onclick", " this.disabled = true; " + ClientScript.GetPostBackEventReference(btnSend, null) + ";"); btnPrint.Attributes.Add("onclick", " this.disabled = true; " + ClientScript.GetPostBackEventReference(btnPrint, null) + ";"); if (!Page.IsPostBack) { trNoRequest.Visible = true; MakeCart(); LoadDDLs(); ValidateRequestForField(); using (clsEmployee employee = new clsEmployee()) { employee.Username = Request.Cookies["Speedo"]["UserName"]; employee.Fill(); if (employee.RcCode == "AUD") { ddlAuthorized.SelectedValue = "jun.sagcal"; } else { ddlAuthorized.SelectedValue = clsDivision.GetDivisionHead(employee.DivisionCode); } } txtRequestor.Text = clsEmployee.GetName(Request.Cookies["Speedo"]["UserName"], EmployeeNameFormat.FirstLast); ddlEndorsedBy1.SelectedValue = clsModuleApprover.ApproverEmployee(Request.Cookies["Speedo"]["UserName"], clsModule.ATWModule, "1"); //btnPrint.Attributes.Add("onclick", "this.disabled=true;" + GetPostBackEventReference(btnPrint).ToString()); //btnSend.Attributes.Add("onclick", "this.disabled=true;" + GetPostBackEventReference(btnSend).ToString()); } }
/////////////////////////////// ///////// Page Events ///////// /////////////////////////////// protected void Page_Load(object sender, EventArgs e) { clsSpeedo.Authenticate(); if (!Page.IsPostBack) { trNoRequest.Visible = true; this.MakeCart(); txtRequestorName.Text = clsEmployee.GetName(Request.Cookies["Speedo"]["UserName"], EmployeeNameFormat.LastFirst); hdnDepartmentCode.Value = clsEmployee.GetDepartmentCode(Request.Cookies["Speedo"]["UserName"]); using (clsEmployee objEmployee = new clsEmployee()) { objEmployee.Username = RFI.ProcurementHead; objEmployee.Fill(); txtProcurementName.Text = objEmployee.LastName + ", " + objEmployee.FirstName; } DataTable tblDepartmentApprover = clsDepartmentApprover.DSLApproverDepartment(hdnDepartmentCode.Value, EFormType.RFI); ddlApprover.DataSource = tblDepartmentApprover; ddlApprover.DataValueField = "pvalue"; ddlApprover.DataTextField = "ptext"; ddlApprover.DataBind(); if (ddlApprover.Items.Count == 0) { ddlApprover.Items.Add(new ListItem("No Approver Defined", "none")); } hdnProcurementCode.Value = RFI.ProcurementHead; dteDateNeeded.MinDate = clsDateTime.AddDaysWorking(5); dteDateNeeded.Date = clsDateTime.AddDaysWorking(5); } }
protected void ddlExecutive_SelectedIndexChanged(object sender, EventArgs e) { LoadExecutiveDDLs(); using (clsEmployee employee = new clsEmployee()) { employee.Username = ddlExecutive.SelectedValue; employee.Fill(); ddlAuthorized.SelectedValue = clsDivision.GetDivisionHead(employee.DivisionCode); } }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { clsGuestbooksLog.InsertRecord(Request.QueryString["username"], Request.Cookies["Speedo"]["UserName"]); //if (File.Exists(Server.MapPath("~/pictures/avatar/") + Request.QueryString["username"] + ".jpg")) // imgAvatar.ImageUrl = "~/pictures/avatar/" + Request.QueryString["username"] + ".jpg"; //else // imgAvatar.ImageUrl = "~/pictures/avatar/default.jpg"; if (File.Exists(Server.MapPath("~/pictures/realpicture/") + Request.QueryString["username"] + ".jpg")) { imgRealPic.ImageUrl = "~/pictures/realpicture/" + Request.QueryString["username"] + ".jpg"; } else { imgRealPic.ImageUrl = "~/pictures/realpicture/default.jpg"; } using (SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["speedo"].ToString())) { SqlCommand cmd = cn.CreateCommand(); cmd.CommandText = "SELECT firname + ' ' + lastname AS name,email FROM Users.Users WHERE username='******'"; cn.Open(); SqlDataReader dr = cmd.ExecuteReader(); if (dr.Read()) { lblName.Text = dr["name"].ToString(); lblEmail.Text = "<a href='mailto://" + dr["email"].ToString() + "'>" + dr["email"].ToString() + "</a>"; } dr.Close(); } using (clsEmployee employee = new clsEmployee()) { employee.Username = Request.QueryString["username"]; employee.Fill(); lblTitle.Text = employee.Position; lblLocal.Text = clsUsers.GetLocalNumber(employee.Username); lblBirthDate.Text = employee.BirthDate.ToString("MMMM dd, ") + "19??"; lblDivision.Text = clsDivision.GetDivisionName(employee.DivisionCode); //lblGroup.Text = clsGroup.GetGroupName(employee.GroupCode); lblDepartment.Text = clsDepartment.GetName(employee.DepartmentCode); lblHobbies.Text = employee.Hobbies; } } }
protected void ddlPayee_SelectedIndexChanged(object sender, EventArgs e) { if (ddlPayee.SelectedValue == "Self") { trPayeeExecutive.Visible = false; trPayeeOthers.Visible = false; trPayeeRequestor.Visible = true; LoadDDLs(); using (clsEmployee employee = new clsEmployee()) { employee.Username = Request.Cookies["Speedo"]["UserName"]; employee.Fill(); if (employee.Username != clsDivision.GetDivisionHead(employee.DivisionCode)) { ddlAuthorized.SelectedValue = clsDivision.GetDivisionHead(employee.DivisionCode); } } txtRequestor.Text = clsEmployee.GetName(Request.Cookies["Speedo"]["UserName"], EmployeeNameFormat.FirstLast); ddlEndorsedBy1.SelectedValue = clsModuleApprover.ApproverEmployee(Request.Cookies["Speedo"]["UserName"], clsModule.RFPModule, "1"); } if (ddlPayee.SelectedValue == "Executive") { trPayeeExecutive.Visible = true; trPayeeOthers.Visible = false; trPayeeRequestor.Visible = false; LoadExecutiveDDLs(); using (clsEmployee employee = new clsEmployee()) { employee.Username = ddlExecutive.SelectedValue; employee.Fill(); ddlAuthorized.SelectedValue = clsDivision.GetDivisionHead(employee.DivisionCode); } ddlEndorsedBy1.SelectedValue = clsModuleApprover.ApproverEmployee(ddlExecutive.SelectedValue, clsModule.RFPModule, "1"); } if (ddlPayee.SelectedValue == "Others") { trPayeeExecutive.Visible = false; trPayeeOthers.Visible = true; trPayeeRequestor.Visible = false; LoadDDLs(); } }
protected void LoadUsers() { string strWrite = ""; string strDivisionCode = ""; string strDepartmentCode = ""; string strKeyword = ""; string strKeywordQ = ""; int intCtr = 0; if (ddlDivision.SelectedValue.ToString() != "ALL") { strDivisionCode = ddlDivision.SelectedValue.ToString(); } else { strDivisionCode = "ALL"; } if (ddlDepartment.SelectedValue.ToString() != "ALL") { strDepartmentCode = ddlDepartment.SelectedValue.ToString(); } else { strDepartmentCode = "ALL"; } if (txtKeyWord.Text != string.Empty) { strKeyword = txtKeyWord.Text; } if (strDivisionCode != "ALL") { strDivisionCode = " AND divicode='" + strDivisionCode + "'"; } else { strDivisionCode = ""; } if (strDepartmentCode != "ALL") { strDepartmentCode = " AND deptcode='" + strDepartmentCode + "'"; } else { strDepartmentCode = ""; } if (strKeyword != string.Empty) { strKeywordQ = " AND (username LIKE '%" + strKeyword + "%' OR lastname LIKE '%" + strKeyword + "%' OR firname LIKE '%" + strKeyword + "%') "; } using (SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["Speedo"].ToString())) { SqlCommand cmd = cn.CreateCommand(); cmd.CommandText = "SELECT username,lastname + ', ' + firname AS name, (SELECT CASE WHEN lcalnmbr = '' THEN '--' ELSE lcalnmbr END) AS lcalnmbr FROM HR.Employees WHERE (pstatus = '1') " + strDivisionCode + strDepartmentCode + strKeywordQ + " ORDER BY lastname"; cn.Open(); SqlDataReader dr = cmd.ExecuteReader(); string strLocalNumber = ""; while (dr.Read()) { if (dr["lcalnmbr"].ToString() != "--") { strLocalNumber = dr["lcalnmbr"].ToString(); } else { strLocalNumber = "--"; } using (clsEmployee employee = new clsEmployee()) { employee.Username = dr["username"].ToString(); employee.Fill(); strWrite = strWrite + "<tr>" + "<td class='GridRows' style='text-align:center;'>" + "<img src='http://192.20.4.120/Pictures/realpicture/" + (File.Exists(Server.MapPath("~/pictures/realpicture/") + dr["username"].ToString() + ".jpg") ? dr["username"].ToString() + ".jpg" : "default.jpg") + "' width='100' height='100'>" + "</td>" + "<td class='GridRows' style='font-size:small;'><a href='../Userpage/Userpage.aspx?username="******"username"].ToString() + "'>" + dr["name"] + "</a>" + "<font style='font-size:x-small;'><br />Nickname: " + employee.NickName + "<br />Position: " + employee.Position + "<br />Email: " + "<a href='mailto://" + employee.EmailOfficial + "'>" + employee.EmailOfficial + "</a></font>" + "</td>" + "<td class='GridRows' style='font-size:small;text-align:left; vertical-align:middle'>" + strLocalNumber + "</td>" + "</tr>"; intCtr++; } } dr.Close(); } Response.Write(strWrite); if (intCtr == 0) Response.Write("<tr><td colspan='3' class='BrowseAll'>No record found</td></tr>"); else Response.Write("<tr><td colspan='3' class='BrowseAll'>[ " + intCtr + " Employees found ]</td></tr>"); }
private void LoadDetails() { using (clsEmployee employee = new clsEmployee(Request.Cookies["Speedo"]["UserName"].ToString())) { employee.Fill(); txtUsername.Text = employee.Username; txtEmployeeNumber.Text = employee.EmployeeNumber; txtNameFirst.Text = employee.FirstName; txtNameMiddle.Text = employee.MiddleName; txtNameLast.Text = employee.LastName; txtEmployeeType.Text = clsEmployeeType.GetEmployeeTypeName(employee.EmploymentTypeCode); if (employee.Title.Trim() != "") { ddlTitle.SelectedValue = employee.Title; } if (employee.Suffix.Trim() != "") { ddlSuffix.SelectedValue = employee.Suffix; } txtCompany.Text = employee.CompanyCode; ///////// txtPosition.Text = employee.Position; txtUpdateBy.Text = employee.UpdatedBy; txtUpdateOn.Text = employee.UpdatedOn.ToString("MMMM dd, yyyy"); txtNickName.Text = employee.NickName; txtGender.Text = employee.Gender; txtCivilStatus.Text = (employee.CivilStatus == "S" ? "Single" : "Married"); txtDateOfBirth.Text = employee.BirthDate.ToString("MM-dd-yyyy"); txtAge.Text = clsEmployee.ComputeAge(employee.BirthDate).ToString(); txtPlaceOfBirth.Text = employee.BirthPlace; txtCitizenship.Text = employee.Citizenship; txtHobby.Text = employee.Hobbies; txtHeight.Text = employee.Height; txtWeight.Text = employee.Weight; txtBloodType.Text = employee.BloodType; txtLanguage.Text = employee.Language; txtSSS.Text = employee.SssID; txtPhilhealth.Text = employee.PhilHealthID; txtTIN.Text = employee.TaxID; txtHDMF.Text = employee.HdmfID; txtHMO.Text = employee.HmoID; txtBankAccount.Text = employee.BankAccount; txtFatherName.Text = employee.FatherName; dtpFatherBirthdate.Date = employee.FatherBirthDate; txtFatherAge.Text = clsEmployee.ComputeAge(employee.FatherBirthDate).ToString(); txtMotherName.Text = employee.MotherName; dtpMotherBirthdate.Date = employee.MotherBirthDate; txtMotherAge.Text = clsEmployee.ComputeAge(employee.MotherBirthDate).ToString(); txtSpouseName.Text = employee.SpouseName; dtpSpouseBDate.Date = employee.SpouseBirthDate; txtSpouseAge.Text = clsEmployee.ComputeAge(employee.SpouseBirthDate).ToString(); txtAddress1.Text = employee.PermanentAddress; txtCity1.Text = employee.PermanentCity; txtPhone1.Text = employee.PermanentPhoneNumber; txtAddress2.Text = employee.CurrentAddress; txtCity2.Text = employee.CurrentCity; txtPhone2.Text = employee.CurrentPhoneNumber; txtMobile1.Text = employee.PrimaryMobileNumber; txtMobile2.Text = employee.AlternativeMobileNumber; txtDirectLine.Text = employee.DirectNumber; txtLocal.Text = employee.LocalNumber; txtFax.Text = employee.FaxNumber; txtEmailOfficial.Text = employee.EmailOfficial; txtEmailPersonal.Text = employee.EmailPersonal; txtEmergencyName.Text = employee.EmergencyPerson; txtEmergencyRelation.Text = employee.EmergencyRelation; txtEmergencyPhoneNumber.Text = employee.EmergencyPhone; txtEmergencyCellNumber.Text = employee.EmergencyCell; txtEmergencyAddress.Text = employee.EmergencyAddress; txtEmploymentStatus.Text = clsEmploymentStatus.GetEmploymentStatusName(employee.EmploymentStatusCode); txtDivision.Text = clsDivision.GetDivisionName(employee.DivisionCode); txtGroup.Text = clsGroup.GetGroupName(employee.GroupCode); txtDepartment.Text = clsDepartment.GetName(employee.DepartmentCode); txtRC.Text = clsRC.GetRCName(employee.RcCode); txtJGCode.Text = employee.JGCode; txtAssignment.Text = employee.Assignment; txtDateHired.Text = employee.DateStart.ToString("MMMM dd, yyyy"); txtDateRegular.Text = (employee.DateRegular == clsDateTime.SystemMinDate ? "" : employee.DateRegular.ToString("MMMM dd, yyyy")); txtSkillPrimary.Text = employee.SkillPrimary; txtSkillSecondary.Text = employee.SkillSecondary; if (employee.CivilStatus == "S" || employee.CivilStatus == "s") { trFatherName.Visible = true; trFatherBirthDate.Visible = true; trMotherName.Visible = true; trMotherBirthDate.Visible = true; trDependents.Visible = true; trSpouseName.Visible = false; trSpouseBirthDate.Visible = false; trChildren.Visible = false; } else { trFatherName.Visible = false; trFatherBirthDate.Visible = false; trMotherName.Visible = false; trMotherBirthDate.Visible = false; trDependents.Visible = false; trSpouseName.Visible = true; trSpouseBirthDate.Visible = true; trChildren.Visible = true; } } }
protected void Page_Load(object sender, EventArgs e) { //btnSaveandApprove.Attributes.Add("onclick", "if(Page_ClientValidate()){this.disabled=true;" + btnSaveandApprove.Page.ClientScript.GetPostBackEventReference(btnSaveandApprove, string.Empty).ToString() + ";return CheckIsRepeat();}"); btnSave.Attributes.Add("onclick", " this.disabled = true; " + ClientScript.GetPostBackEventReference(btnSave, null) + ";"); btnSaveandApprove.Attributes.Add("onclick", " this.disabled = true; " + ClientScript.GetPostBackEventReference(btnSaveandApprove, null) + ";"); if (!Page.IsPostBack) { chkbExecutive.Checked = true; using (clsEmployee employee = new clsEmployee()) { hdnUsername.Value = Request.Cookies["Speedo"]["UserName"]; employee.Username = Request.Cookies["Speedo"]["UserName"]; employee.Fill(); //txtRequestor.Text = employee.FirstName + " " + employee.MiddleInitial + ". " + employee.LastName; txtRequestorName.Text = employee.FirstName + " " + employee.MiddleInitial + ". " + employee.LastName; ddlDivisionHead.DataSource = clsModuleApprover.GetDSLFinanceApprover(clsModule.CATAModule, "2"); ddlDivisionHead.DataValueField = "pvalue"; ddlDivisionHead.DataTextField = "ptext"; ddlDivisionHead.DataBind(); if (employee.RcCode == "AUD") { //hdnAuthorizedby1.Value = "jun.sagcal"; //txtAuthorizeBy1.Text = "Engracio Sagcal Jr."; ddlDivisionHead.SelectedValue = "jun.sagcal"; } else { ddlDivisionHead.SelectedValue = clsDivision.GetDivisionHead(employee.DivisionCode); //hdnAuthorizedby1.Value = clsDivision.GetDivisionHead(employee.DivisionCode); //txtAuthorizeBy1.Text = clsEmployee.GetName(hdnAuthorizedby1.Value, EmployeeNameFormat.FirstLast); } } string _strJobGradeClass = clsJobGrade.GetJobGradeClass(clsEmployee.GetJobGrade(hdnUsername.Value)); if (_strJobGradeClass == "1") { ddlExecutive.SelectedValue = hdnUsername.Value; } dtDateDeparture.SelectedValue = DateTime.Now; dtDateArrival.SelectedValue = DateTime.Now; DDLLoad(); LoadAccomodation(); MakeCart(); trNoIncedental.Visible = true; trNoRepresentation.Visible = true; CalculateDate(); //Travel Allowance TravelAllowance(); LoadHiddenValue(); //accommodation if 2 days and up if (int.Parse(txtDays.Text) > 1) { divAccomodation.Visible = true; } else { divAccomodation.Visible = false; } RepresentationAllowance(); LoadTerminalFee(); divTransportation.Visible = true; divTravelAllowance.Visible = true; divIncedental.Visible = true; divApprovers.Visible = true; CATASum(); ddlExecutive.Visible = true; } }