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;
}
}