private void DeleteLeaveRequest(Int32 LeaveRequestID)
{
try
{
String result = DatabaseManager.Data.DBAccessManager.DeleteLeaveRequest(LeaveRequestID, Int32.Parse(keyField.Text.ToString()));
if (result != "")
{
Tab2_Message.Visible = true;
Tab2_Message.Text = result;
Tab2_Message.CssClass = "errorMessage";
}
}
catch (Exception exception)
{
Tab2_Message.Visible = true;
Tab2_Message.Text = ErrorLogging.LogError(exception, "Unknown Exception Occured.Please contact Support.");
Tab2_Message.CssClass = "errorMessage";
}
LGrid.CurrentPageIndex = 0;
LoadLeaveRequestList();
}
protected void Save_Click(object sender, EventArgs e)
{
try
{
if (Page.IsValid == true)
{
if (Tab1_KeyField.Text.ToString() == "")
{
Tab1_KeyField.Text = "0";
}
String Result = DatabaseManager.Data.DBAccessManager.AddUpdatePharmacyPurchase(Int32.Parse(Tab1_KeyField.Text), Int32.Parse(DrugId.SelectedValue), BillReference.Text, ConvertDMY_MDY(PurchaseDate), Int32.Parse(Quantity.Text), Double.Parse(UnitPrice.Text), ConvertDMY_MDY(ExpiryDate), Comments.Text, Int32.Parse(Page.User.Identity.Name.ToString()));
this.AlertDiv.Visible = true;
if (Result == "")
{
this.AlertDiv.Attributes["class"] = "alert alert-success alert-dismissible fade in";
this.message.Text = "Successfully saved.";
ResetFields();
}
else
{
this.AlertDiv.Attributes["class"] = "alert alert-danger alert-dismissible fade in";
this.message.Text = Result;
}
}
else
{
this.AlertDiv.Attributes["class"] = "alert alert-danger alert-dismissible fade in";
this.message.Text = "Error:Could not save the information. Please check the inputs";
}
}
catch (Exception exception)
{
this.AlertDiv.Visible = true;
this.AlertDiv.Attributes["class"] = "alert alert-danger alert-dismissible fade in";
this.message.Text = ErrorLogging.LogError(exception, "Unknown Exception Occured. Please contact support.");
}
LoadDataList(); // Refresh the Grid after Save.
}
private void LoadPayrollDataList()
{
try
{
DataSet _DataList = null;
_DataList = DatabaseManager.Data.DBAccessManager.RetrievePayrollDashBoardDataByEmpID(Int32.Parse(Page.User.Identity.Name.ToString()), Int32.Parse(businessUnitDDList.SelectedValue), Int32.Parse(DivisionLocationList.SelectedValue));
if (_DataList.Tables.Count > 0)
{
if (_DataList.Tables[2].Rows.Count > 0) // Current Month Payroll data/Status
{
DataTable _DataTable = _DataList.Tables[2];
Grid8.DataSource = _DataTable;
Grid8.DataBind();
}
else
{
Grid8.DataSource = null;
Grid8.DataBind();
}
if (_DataList.Tables[3].Rows.Count > 0) // Historical data for payroll
{
DataTable _DataTable = _DataList.Tables[3];
Grid9.DataSource = _DataTable;
Grid9.DataBind();
}
else
{
Grid9.DataSource = null;
Grid9.DataBind();
}
}
}
catch (Exception exception)
{
ErrorLogging.LogError(exception, "Unknown Exception Occured. Please contact support.");
}
}
protected void EmpTrain_Save_Click(object sender, EventArgs e)
{
try
{
if (Page.IsValid == true) // Change requestStatusType to be dynamic, currently 1=submitted.
{
if (Tab1_keyField.Text.ToString() == "")
{
Tab1_keyField.Text = "0";
}
if (Tab1_Duration.Text.ToString() == "")
{
Tab1_Duration.Text = "0";
}
String Result = DatabaseManager.Data.DBAccessManager.AddUpdateEmployeeTraining(Convert.ToInt32(Tab1_keyField.Text), EmpId, Tab1_TrainingName.Text.ToString(), Int32.Parse(Tab1_TrainingType.SelectedValue), Tab1_Description.Text.ToString(), ConvertDMY_MDY(Tab1_DateCompleted), Int32.Parse(Tab1_Duration.Text.ToString()));
this.Hmessage.Visible = true;
Hmessage.CssClass = "errorMessage";
if (Result == "")
{
ResetFields();
}
}
else
{
this.Hmessage.Text = "Error:Could not save the information. Please check the inputs";
this.Hmessage.CssClass = "errorMessage";
}
LoadEmployeeTrainingList();// Refresh the grid
}
catch (Exception exception)
{
this.Hmessage.Visible = true;
this.Hmessage.Text = ErrorLogging.LogError(exception, "Unknown Exception Occured.Please contact Support.");
this.Hmessage.CssClass = "errorMessage";
}
}
private void DeleteUserAccount(Int32 Emp_Id)
{
try
{
String result = DatabaseManager.Data.DBAccessManager.DeleteUserAccount(Emp_Id);
if (result != "")
{
this.Hmessage.Text = "Error:Could not delete the user account. Please check the data";
this.Hmessage.CssClass = "errorMessage";
}
}
catch (Exception exception)
{
this.Hmessage.Text = ErrorLogging.LogError(exception, "Unknown Exception Occured.Please contact Support.");
this.Hmessage.CssClass = "errorMessage";
}
UsersGrid.CurrentPageIndex = 0;
LoadPortalUserAccounts();
}
protected void Save_Preference_Click(object sender, EventArgs e)
{
try
{
if (Page.IsValid == true)
{
keyField.Text = EmpId.ToString(); // Hardcoded value
Int32 Alerting = 0;
if (Tab1_ApprCheckBox1.Checked)
{
Alerting = 1;
}
if (Tab1_PersistDays.Text.ToString() == "")
{
Tab1_PersistDays.Text = "0";
}
String Result = DatabaseManager.Data.DBAccessManager.SavePreferences(Int32.Parse(this.keyField.Text.ToString()), Alerting, Tab1_EmailAddress.Text.ToString(), Tab1_EmergencyPhone.Text.ToString(), Int32.Parse(Tab1_PersistDays.Text.ToString()));
this.message.Visible = true;
if (Result == "")
{
this.message.Text = "Successfully saved.";
this.message.CssClass = "errorMessage";
}
}
else
{
this.message.Text = "Error:Could not save the information. Please check the inputs";
this.message.CssClass = "errorMessage";
}
}
catch (Exception exception)
{
this.message.Visible = true;
this.message.Text = ErrorLogging.LogError(exception, "Unknown Exception Occured.Please contact Support.");
this.message.CssClass = "errorMessage";
}
}
private void LoadDependentsList()
{
DataTable _empDependentDataTable = null;
try
{
DataSet _DataList = null;
_DataList = DatabaseManager.Data.DBAccessManager.RetrieveEmployeeInfo(Int32.Parse(this.keyField.Text.ToString()));
if (_DataList.Tables[1].Rows.Count > 0) // Employee Dependent Information.
{
_empDependentDataTable = _DataList.Tables[1];
this.DPGrid.DataSource = _empDependentDataTable;
this.DPGrid.DataBind();
DPmessage.Text = "";
DPmessage.Visible = false;
emptyRow2.Text = "";
emptyRow2.Visible = false;
}
else
{
this.DPGrid.DataSource = null;
this.DPGrid.DataBind();
}
}
catch (Exception exception)
{
if (DPGrid.CurrentPageIndex >= DPGrid.PageCount)
{
DPGrid.CurrentPageIndex -= 1;
this.DPGrid.DataSource = _empDependentDataTable;
this.DPGrid.DataBind();
}
else
{
ErrorLogging.LogError(exception, " ");
}
}
}
/* Used for saving as PDF. This is not complete due to htmlparser error. */
protected void SavePDF_Click(object sender, EventArgs e)
{
try
{
string HRSystemLink = ConfigurationManager.AppSettings["HRSystemURL"].ToString();
Response.ContentType = "application/pdf";
Response.AddHeader("content-disposition", "attachment;filename=payslip.pdf");
Response.Cache.SetCacheability(HttpCacheability.NoCache);
StringWriter sw = new StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(sw);
LoadEmployeePayrollInfo(Int32.Parse(Page.User.Identity.Name.ToString()), Payroll_Date.Text);
PayStubViewPaycomponents.RenderControl(hw);
StringBuilder sb = new StringBuilder();
/* html to parse */
// sb.Append("<html><head><title>AON ME HR System-Payroll</title>");
// sb.Append("<link rel=stylesheet type=text/css href=\"http://localhost:56141/HRMSNet_Dev/CSS/CommonStyles.css \" />");
// sb.Append("<link rel=stylesheet type=text/css href=\""+HRSystemLink+"/CSS/CommonStyles.css media=all\" />");
sb.Append("<html><body><table>");
sb.Append(sw.ToString());
sb.Append("</table></body></html>");
StringReader sr = new StringReader(sb.ToString());
Document pdfDoc = new Document(PageSize.A4, 7f, 7f, 7f, 0f);
// pdfDoc.HtmlStyleClass = "mainheadtxt4";
HTMLWorker htmlparser = new HTMLWorker(pdfDoc);
PdfWriter.GetInstance(pdfDoc, Response.OutputStream);
pdfDoc.Open();
htmlparser.Parse(sr);
pdfDoc.Close();
Response.Write(pdfDoc);
Response.End();
}
catch (Exception exception)
{
this.message.Visible = true;
this.message.Text = ErrorLogging.LogError(exception, "Unknown Exception Occured. Please contact support.");
this.message.CssClass = "errorMessage";
}
}
protected void Save_Click(object sender, EventArgs e)
{
try
{
if (Page.IsValid == true)
{
Int32 Status = 0;
if (Radio1.Checked)
{
Status = 1;
}
if (Tab1_KeyField.Text.ToString() == "")
{
Tab1_KeyField.Text = "0";
}
String Result = DatabaseManager.Data.DBAccessManager.AddUpdateDepartment(Int32.Parse(Page.User.Identity.Name.ToString()), Int32.Parse(Tab1_KeyField.Text), DeptName.Text, DeptPrefix.Text, GLCode.Text, Status);
this.Tab1_Message.Visible = true;
this.Tab1_Message.CssClass = "errorMessage";
if (Result == "")
{
ResetFields();
}
}
else
{
this.Tab1_Message.Text = "Error:Could not save the information. Please check the inputs";
this.Tab1_Message.CssClass = "errorMessage";
}
}
catch (Exception exception)
{
this.Tab1_Message.Visible = true;
this.Tab1_Message.Text = ErrorLogging.LogError(exception, "Unknown Exception Occured. Please contact support.");
this.Tab1_Message.CssClass = "errorMessage";
}
LoadDataList(); // Refresh the Grid after Save.
}
protected void PreviewEmployeeMonthlyPayroll(String Pay_MonthYear, Int32 DivisionID, Int32 DivisionLocationID, Int32 RequestingEmpId)
{
try
{
DataSet _DataList = null;
_DataList = DatabaseManager.Data.DBAccessManager.RetrieveEmployeeMonthlyPayroll_Preview(Pay_MonthYear, DivisionID, DivisionLocationID, RequestingEmpId);
if (_DataList.Tables.Count > 0)
{
if (_DataList.Tables[0].Rows.Count > 0)
{
this.message.Visible = false;
this.message.Text = "";
DataTable _dataTable = _DataList.Tables[0];
ExportToExcel(_dataTable);
}
else
{
this.message.Visible = true;
this.message.Text = "No matching data found!.";
this.message.CssClass = "errorMessage";
}
}
else
{
this.message.Visible = true;
this.message.Text = "No Pending Payroll data exists to process";
this.message.CssClass = "errorMessage";
}
}
catch (Exception exception)
{
// ErrorLogging.LogError(exception, "");
this.message.Visible = true;
this.message.Text = ErrorLogging.LogError(exception, "Unknown Exception Occured.Please contact Support.");
this.message.CssClass = "errorMessage";
}
}
protected void Tab2_Save_Click(object sender, EventArgs e)
{
try
{
if (Page.IsValid == true)
{
if (Tab2_keyField.Text.ToString() == "")
{
Tab2_keyField.Text = "0";
}
String Result = DatabaseManager.Data.DBAccessManager.AddUpdateDailyFNTransactions(Int32.Parse(Tab2_EmployeeList.SelectedValue), Int32.Parse(Tab2_PayComponentList.SelectedValue), Decimal.Parse(NumericCheck_EmptyString(Tab2_Amount.Text)), Int32.Parse(Page.User.Identity.Name.ToString()));
this.Tab2_Message.Visible = true;
this.Tab2_Message.CssClass = "errorMessage";
if (Result == "")
{
this.Tab2_Message.Text = "Successfully saved.";
ClearTab2();
}
else
{
this.Tab2_Message.Text = Result;
}
}
else
{
this.Tab2_Message.Text = "Error:Could not save the information. Please check the inputs and submit again";
this.Tab2_Message.CssClass = "errorMessage";
}
}
catch (Exception exception)
{
this.Tab2_Message.Visible = true;
this.Tab2_Message.Text = ErrorLogging.LogError(exception, "Unknown Exception Occured. Please contact support.");
this.Tab2_Message.CssClass = "errorMessage";
}
LoadDailyFNTransactionsList();
}
protected void LGrid_EditCommand(object source, DataGridCommandEventArgs e)
{
Tab2_KeyField.Text = LGrid.DataKeys[e.Item.ItemIndex].ToString(); // LocationID
DivisionName.Text = EmptyString(e.Item.Cells[0].Text);
Int32 DivisionID = Int32.Parse(EmptyString(e.Item.Cells[1].Text));
LoadSupervisorsListLookupByDivisionID(SupervisorDDList, DivisionID);
if (EmptyString(e.Item.Cells[8].Text.Trim()) != "")
{
try
{
Tab2_CountryList.SelectedValue = Tab2_CountryList.Items.FindByValue(e.Item.Cells[8].Text.Trim()).Value;
}
catch (Exception exception)
{
Tab2_CountryList.SelectedValue = "-1";
ErrorLogging.LogError(exception, "");
}
}
if (EmptyString(e.Item.Cells[3].Text.Trim()) != "")
{
try
{
Tab2_SuperVisorList.SelectedValue = Tab2_SuperVisorList.Items.FindByText(e.Item.Cells[3].Text.Trim()).Value;
}
catch (Exception exception)
{
Tab2_SuperVisorList.SelectedValue = "-1";
ErrorLogging.LogError(exception, "");
}
}
Tab2_EmployerID.Text = EmptyString(e.Item.Cells[4].Text);
Tab2_EmployerRef.Text = EmptyString(e.Item.Cells[5].Text);
Tab2_EmployerRoutingCode.Text = EmptyString(e.Item.Cells[6].Text);
Tab2_GLCode.Text = EmptyString(e.Item.Cells[7].Text);
Tab2_CountryList.Enabled = false;
LGrid.EditItemIndex = -1;
}
private void LoadEContactList()
{
DataTable _empECDataTable = null;
try
{
DataSet _DataList = null;
_DataList = DatabaseManager.Data.DBAccessManager.RetrieveEmployeeInfo(Int32.Parse(this.keyField.Text.ToString()));
if (_DataList.Tables[2].Rows.Count > 0) // Employee Emergency Contacts Information.
{
_empECDataTable = _DataList.Tables[2];
this.ECGrid.DataSource = _empECDataTable;
this.ECGrid.DataBind();
ECmessage.Text = "";
ECmessage.Visible = false;
emptyRow1.Text = "";
emptyRow1.Visible = false;
}
else
{
this.ECGrid.DataSource = null;
this.ECGrid.DataBind();
}
}
catch (Exception exception)
{
if (ECGrid.CurrentPageIndex >= ECGrid.PageCount)
{
ECGrid.CurrentPageIndex -= 1;
this.ECGrid.DataSource = _empECDataTable;
this.ECGrid.DataBind();
}
else
{
ErrorLogging.LogError(exception, " ");
}
}
}
private void DeleteDivisionLocation(Int32 DivisionID, Int32 LocationID)
{
try
{
String result = DatabaseManager.Data.DBAccessManager.DeleteDivisionLocation(Int32.Parse(Page.User.Identity.Name.ToString()), DivisionID, LocationID);
if (result != "")
{
this.Tab2_Message.Text = result;
this.Tab2_Message.Visible = true;
this.Tab2_Message.CssClass = "errorMessage";
}
}
catch (Exception exception)
{
this.Tab2_Message.Visible = true;
this.Tab2_Message.Text = ErrorLogging.LogError(exception, "Unknown Exception Occured. Please contact support.");
this.Tab2_Message.CssClass = "errorMessage";
}
LGrid.CurrentPageIndex = 0;
LoadDivisionLocationList(DivisionID);
}
private void DeleteDependent(Int32 DependentID)
{
try
{
String result = DatabaseManager.Data.DBAccessManager.DeleteEmployeeDependent(Int32.Parse(keyField.Text.ToString()), DependentID);
if (result != "")
{
this.DPmessage.Text = "Error:Could not delete the dependent. Please check the data";
this.DPmessage.CssClass = "errorMessage";
}
}
catch (Exception exception)
{
this.DPmessage.Text = ErrorLogging.LogError(exception, "Unknown Exception Occured.Please contact Support.");
this.DPmessage.CssClass = "errorMessage";
}
DPGrid.CurrentPageIndex = 0;
LoadDependentsList();
}
private void LoadEmployeePositionList()
{
try
{
DataSet _DataList = null;
_DataList = DatabaseManager.Data.DBAccessManager.RetrieveEmployeeInfo(Int32.Parse(this.keyField.Text.ToString()));
if (_DataList.Tables[4].Rows.Count > 0) // Employee Emergency Contacts Information.
{
DataTable _DataTable = _DataList.Tables[4];
this.EPGrid.DataSource = _DataTable;
this.EPGrid.DataBind();
}
else
{
this.EPGrid.DataSource = null;
this.EPGrid.DataBind();
}
}
catch (Exception exception)
{
ErrorLogging.LogError(exception, " ");
}
}
private void LoadCurrentEntitlement()
{
try
{
DataSet _DataList = null;
_DataList = DatabaseManager.Data.DBAccessManager.RetrieveLeaveEntitlements(Int32.Parse(keyField.Text.ToString()));
if (_DataList.Tables[0].Rows.Count > 0)
{
this.EGrid.DataSource = _DataList;
this.EGrid.DataBind();
}
else
{
this.EGrid.DataSource = null;
this.EGrid.DataBind();
}
}
catch (Exception exception)
{
ErrorLogging.LogError(exception, " ");
}
}
private void LoadBenefitDeductionList()
{
try
{
DataSet _DataList = null;
_DataList = DatabaseManager.Data.DBAccessManager.RetrieveEmployeeBenefitInfo(Int32.Parse(keyField.Text.ToString()));
if (_DataList.Tables.Count > 0)
{
if (_DataList.Tables[0].Rows.Count > 0) // Benefit Information
{
DataTable _BenefitTable = _DataList.Tables[0];
this.BTGrid.DataSource = _BenefitTable;
this.BTGrid.DataBind();
}
else
{
this.BTGrid.DataSource = null;
this.BTGrid.DataBind();
}
if (_DataList.Tables[1].Rows.Count > 0) // Deductions Information
{
DataTable _DeductionTable = _DataList.Tables[1];
this.DedGrid.DataSource = _DeductionTable;
this.DedGrid.DataBind();
}
else
{
this.DedGrid.DataSource = null;
this.DedGrid.DataBind();
}
}
}
catch (Exception exception)
{
ErrorLogging.LogError(exception, "");
}
}
protected void Save_Click(object sender, EventArgs e)
{
try {
if (Page.IsValid == true)
{
if (Tab1_KeyField.Text.ToString() == "")
{
Tab1_KeyField.Text = "0";
}
String Result = DatabaseManager.Data.DBAccessManager.AddUpdateCattleRaceSampling(Int32.Parse(Tab1_KeyField.Text), Int32.Parse(AnimalID.Text), Int32.Parse(TrainerID.Text), Int32.Parse(RaceID.Text), Int32.Parse(LocationID.Text), Int32.Parse(TrialNumber.Text), ConvertDMY_MDY(SamplingStartTime), Duration.Text, Int32.Parse(PlaceTypeID.Text), 0, 0, Int32.Parse(Page.User.Identity.Name.ToString()));
this.AlertDiv.Visible = true;
if (Result == "")
{
this.AlertDiv.Attributes["class"] = "alert alert-success alert-dismissible fade in";
this.message.Text = "Successfully saved.";
ResetFields();
}
else
{
this.AlertDiv.Attributes["class"] = "alert alert-danger alert-dismissible fade in";
this.message.Text = Result;
}
}
else
{
this.AlertDiv.Attributes["class"] = "alert alert-danger alert-dismissible fade in";
this.message.Text = "Error:Could not save the information. Please check the inputs";
}
}
catch (Exception exception)
{
this.AlertDiv.Visible = true;
this.AlertDiv.Attributes["class"] = "alert alert-danger alert-dismissible fade in";
this.message.Text = ErrorLogging.LogError(exception, "Unknown Exception Occured. Please contact support.");
}
LoadDataList(); // Refresh the Grid after Save.
}
private void LoadHolidaysList()
{
try
{
DataSet _DataList = null;
_DataList = DatabaseManager.Data.DBAccessManager.RetrieveHolidayList(Int32.Parse(Page.User.Identity.Name.ToString()));
if (_DataList.Tables[0].Rows.Count > 0)
{
this.Grid.DataSource = _DataList;
this.Grid.DataBind();
}
else
{
emptyRow.Visible = true;
emptyRow.Text = "There are no records found.";
emptyRow.CssClass = "errorMessage";
}
}
catch (Exception exception)
{
ErrorLogging.LogError(exception, "");
}
}
private void LoadEmployeeLanguagesList()
{
try
{
DataSet _DataList = null;
_DataList = DatabaseManager.Data.DBAccessManager.RetrieveEmployeeLanguages(EmpId);
if (_DataList.Tables[0].Rows.Count > 0)
{
emptyRow.Visible = false;
this.Grid.DataSource = _DataList;
this.Grid.DataBind();
}
else
{
this.Grid.DataSource = null;
this.Grid.DataBind();
}
}
catch (Exception exception)
{
ErrorLogging.LogError(exception, "");
}
}
protected void Tab1_Save_Click(object sender, EventArgs e)
{
try
{
if (Page.IsValid == true)
{
if (Tab1_keyField.Text.ToString() == "")
{
Tab1_keyField.Text = "0";
}
String Result = DatabaseManager.Data.DBAccessManager.AddUpdateGenTransactions(Int32.Parse(Tab1_EmployeeList.SelectedValue), Int32.Parse(Tab1_ImportDataTypeList.SelectedValue), Tab1_InstrumentNo.Text, ConvertDMY_MDY(Tab1_VisaIssueDate), ConvertDMY_MDY(Tab1_VisaExpiryDate), Int32.Parse(Tab1_CountryList.SelectedValue), Int32.Parse(Tab1_VisaType.SelectedValue), Int32.Parse(Page.User.Identity.Name.ToString()));
this.Tab1_Message.Visible = true;
this.Tab1_Message.CssClass = "errorMessage";
if (Result == "")
{
this.Tab1_Message.Text = "Successfully saved.";
ClearTab2();
}
else
{
this.Tab1_Message.Text = Result;
}
}
else
{
this.Tab1_Message.Text = "Error:Could not save the information. Please check the inputs and submit again";
this.Tab1_Message.CssClass = "errorMessage";
}
}
catch (Exception exception)
{
this.Tab1_Message.Visible = true;
this.Tab1_Message.Text = ErrorLogging.LogError(exception, "Unknown Exception Occured. Please contact support.");
this.Tab1_Message.CssClass = "errorMessage";
}
}
protected void Payroll_StartOver_Click(object sender, EventArgs e)
{
try
{
String result = DatabaseManager.Data.DBAccessManager.DeleteEmployeeMonthlyPayrollInfo(Int32.Parse(this.keyField.Text), Payroll_Date.Text, Int32.Parse(Page.User.Identity.Name.ToString()));
this.message.Visible = true;
message.CssClass = "errorMessage";
if (result == "")
{
LoadEmployeeMonthlyPayrollInfo(Int32.Parse(this.keyField.Text), Payroll_Date.Text);
this.message.Text = "Successfully started over again.";
}
else
{
this.message.Text = result;
}
}
catch (Exception exception)
{
this.message.Visible = true;
this.message.Text = ErrorLogging.LogError(exception, "Unknown Exception Occured.Please contact support.");
this.message.CssClass = "errorMessage";
}
}
protected void Save_Employee_Click(object sender, EventArgs e)
{
Int32 AccountStatus; Int32 PhotoProfile; String PhotoPath; String FilePath;
try
{
if (Page.IsValid == true)
{
if (RadioButton1.Checked)
{
AccountStatus = 1;
}
else
{
AccountStatus = 0;
}
if (Tab1_ProfilePhoto.PostedFile != null && Tab1_ProfilePhoto.PostedFile.FileName != "") // Checked Photo is uploaded.
{
HttpPostedFile myFile = Tab1_ProfilePhoto.PostedFile;
String Ext = System.IO.Path.GetExtension(myFile.FileName);
FilePath = Server.MapPath(Page.ResolveUrl("~\\PhotoProfiles\\" + Tab1_FName.Text.ToString() + "_" + Tab1_LName.Text.ToString() + Ext));
myFile.SaveAs(FilePath);
PhotoPath = Tab1_FName.Text.ToString() + "_" + Tab1_LName.Text.ToString() + Ext;
PhotoProfile = 1;
}
else
{
PhotoPath = "";
PhotoProfile = 0;
}
if (Tab1_Probation.Text == "")
{
Tab1_Probation.Text = "0";
}
String Result = DatabaseManager.Data.DBAccessManager.AddNewEmployee(Int32.Parse(Tab1_SaluationType.SelectedValue), Tab1_FName.Text.ToString(), Tab1_MidName.Text.ToString(), Tab1_LName.Text.ToString(), ConvertDMY_MDY(Tab1_DOB), Int32.Parse(Tab1_GenderType.SelectedValue), Int32.Parse(Tab1_MaritalStatus.SelectedValue), ConvertDMY_MDY(Tab1_HireDate), Tab1_EmployeeID.Text.ToString(), Int32.Parse(Tab1_EmpCategory.SelectedValue), Int32.Parse(Tab1_EmpStatus.SelectedValue), Int32.Parse(Tab1_Designation.SelectedValue), Int32.Parse(Tab1_Department.SelectedValue), Int32.Parse(Tab1_Division.SelectedValue), Int32.Parse(Tab1_Education.SelectedValue), PhotoProfile, PhotoPath, Tab1_UserName.Text.ToString(), EncodePasswordToBase64(Tab1_password.Text.ToString()), Int32.Parse(Tab1_Location.SelectedValue), Int32.Parse(Tab1_Probation.Text.ToString()), Tab1_PSEmployeeID.Text.ToString(), Tab1_HAddress1.Text.ToString(), Tab1_HAddress2.Text.ToString(), Tab1_HCity.Text.ToString(), Tab1_HState.Text.ToString(), Int32.Parse(Tab1_CountryDDList.SelectedValue), Tab1_WAddress1.Text.ToString(), Tab1_WAddress2.Text.ToString(), Tab1_WCity.Text.ToString(), Tab1_WState.Text.ToString(), Int32.Parse(Tab1_WCountryDDList.SelectedValue), Tab1_HPhone.Text.ToString(), Tab1_Mobile.Text.ToString(), Tab1_WPhone.Text.ToString(), Tab1_WorkEmail.Text.ToString(), Int32.Parse(Tab1_Supervisor.SelectedValue), Int32.Parse(Tab1_AccessLevel.SelectedValue), Int32.Parse(Page.User.Identity.Name.ToString()), AccountStatus);
this.message.Visible = true;
this.message.CssClass = "errorMessage";
if (Result == "")
{
String Emp_FullName = Tab1_FName.Text.ToString() + ' ' + Tab1_MidName.Text.ToString() + ' ' + Tab1_LName.Text.ToString();
String EmpEmail = Tab1_WorkEmail.Text.ToString();
String UserName = Tab1_UserName.Text.ToString();
String Password = Tab1_password.Text.ToString();
if (CheckEmail(EmpEmail)) // Notify via Email if Email was used as a user Name
{
NotifyEmployee_PortaLoginViaEmail(Emp_FullName, EmpEmail, UserName, Password);
}
this.message.Text = "Successfully saved.";
ResetFields();
}
else
{
this.message.Text = Result;
// System.IO.File.Delete(FilePath);
}
}
else
{
this.message.Text = "Error:Could not save the information. Please check the inputs";
this.message.CssClass = "errorMessage";
}
}
catch (Exception exception)
{
this.message.Visible = true;
this.message.Text = ErrorLogging.LogError(exception, "Unknown Exception Occured. Please contact support.");
this.message.CssClass = "errorMessage";
}
}
protected void Import_Click(object sender, EventArgs e)
{
try
{
Tab1_Message.CssClass = "errorMessage";
Tab1_Message.Visible = true;
string extension = System.IO.Path.GetExtension(fileuploadExcel.PostedFile.FileName);
if (fileuploadExcel.FileName != "") //&& extension == ".xls")
{
string excelConnectionString;
SqlConnection connection = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings.Get("ConnectionInfo"));
string connStr = System.Configuration.ConfigurationSettings.AppSettings.Get("ConnectionInfo");
// string path = fileuploadExcel.PostedFile.FileName;
string path = Server.MapPath(Page.ResolveUrl("~\\App_Data\\") + fileuploadExcel.FileName);
fileuploadExcel.SaveAs(path);
// string a = fileuploadExcel.PostedFile.FileName;
string tableName = StringEnum.stringValueOf(Constants.ImportTableName.FinanceTransaction);
//Create connection string to Excel work book
if (extension == ".xls")
{
excelConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + path +
";Extended Properties=Excel 8.0";
}
else if (extension == ".csv")
{
excelConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + path +
";Extended Properties=text;FMT=Delimited()";
}
else
{
excelConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + path +
";Extended Properties=Excel 12.0";
}
//Create Connection to Excel work book
OleDbConnection excelConnection = new OleDbConnection(excelConnectionString);
//Create OleDbCommand to fetch data from Excel
connection.Open();
SqlCommand comm = new SqlCommand("delete from " + tableName, connection);
comm.ExecuteNonQuery();
SqlCommand identityChange = connection.CreateCommand();
identityChange.CommandText = "SET IDENTITY_INSERT " + tableName + " ON";
OleDbCommand cmd = new OleDbCommand("Select RowID,PSEmployeeID,ComponentCode,Amount from [Sheet1$] where RowID > 0", excelConnection);
excelConnection.Open();
OleDbDataReader dReader;
dReader = cmd.ExecuteReader();
identityChange.ExecuteNonQuery();
SqlBulkCopy sqlBulk = new SqlBulkCopy(connStr);
//Give your Destination table name
sqlBulk.DestinationTableName = tableName;
sqlBulk.WriteToServer(dReader);
excelConnection.Close();
connection.Close();
// Validate the data in the staging table and return all bad data.
DataSet _DataList = null;
_DataList = DatabaseManager.Data.DBAccessManager.ValidateImportedFinanceTransactions(Int32.Parse(Page.User.Identity.Name.ToString()));
if (_DataList.Tables.Count > 0)
{
if (_DataList.Tables[0].Rows.Count > 0) // Bad Data exists
{
DataTable _DeductionTable = _DataList.Tables[0];
this.Tab1Grid.DataSource = _DeductionTable;
this.Tab1Grid.DataBind();
Export1.Visible = true;
Tab1_Message.Text = "The following data was not imported due to validation error. Please fix them and re-import.";
}
else
{
this.Tab1Grid.DataSource = null;
this.Tab1Grid.DataBind();
Export1.Visible = false;
Tab1_Message.Text = "All data has been successfully imported into the system";
}
}
}
else
{
Tab1_Message.CssClass = "errorMessage";
Tab1_Message.Text = "Please select the excel(.xlsx) file to import.You should save the file as 'Excel Workbook' for the import process to work.";
}
}
catch (Exception exception)
{
this.Tab1_Message.Visible = true;
this.Tab1_Message.Text = ErrorLogging.LogError(exception, "Unknown Exception Occured. Please check the data in the import file.");
this.Tab1_Message.CssClass = "errorMessage";
}
}
private void LoadDataList()
{
try
{
DataSet _DataList = null;
_DataList = DatabaseManager.Data.DBAccessManager.RetrievePayrollDashBoardDataByEmpID(Int32.Parse(Page.User.Identity.Name.ToString()), Int32.Parse(businessUnitDDList.SelectedValue), Int32.Parse(DivisionLocationList.SelectedValue));
if (_DataList.Tables.Count > 0)
{
if (_DataList.Tables[0].Rows.Count > 0) // Employee Divisional PieChart
{
PieXML = "";
DataTable _DataTable = _DataList.Tables[0];
PieXML = CreatePieGraph1(_DataTable, "Employee Count Breakdown By Business Unit/Dept", "", "Count", "Division/Dept");
FCLiteral2.Text = FusionCharts.RenderChartHTML("../FusionCharts/FCF_Pie3D.swf", "", PieXML, "DivisionDeptChart", PieWidth, PieHeight, false);
}
else
{
FCLiteral2.Visible = false;
}
if (_DataList.Tables[1].Rows.Count > 0) // Employee Location PieChart
{
PieXML = "";
DataTable _DataTable = _DataList.Tables[1];
PieXML = CreatePieGraph1(_DataTable, "Employee Count Breakdown By Country", "", "Country", "Count");
FCLiteral3.Text = FusionCharts.RenderChartHTML("../FusionCharts/FCF_Pie3D.swf", "", PieXML, "CountryChart", PieWidth, PieHeight, false);
}
else
{
FCLiteral3.Visible = false;
}
if (_DataList.Tables[2].Rows.Count > 0) // Current Month Payroll data/Status
{
DataTable _DataTable = _DataList.Tables[2];
Grid1.DataSource = _DataTable;
Grid1.DataBind();
}
else
{
Grid1.DataSource = null;
Grid1.DataBind();
}
if (_DataList.Tables[3].Rows.Count > 0) // Historical data for payroll
{
DataTable _DataTable = _DataList.Tables[3];
Grid2.DataSource = _DataTable;
Grid2.DataBind();
}
else
{
Grid2.DataSource = null;
Grid2.DataBind();
}
}
}
catch (Exception exception)
{
ErrorLogging.LogError(exception, "Unknown Exception Occured. Please contact support.");
}
}
protected void DPGrid_EditCommand(object source, DataGridCommandEventArgs e)
{
keyField.Text = DPGrid.DataKeys[e.Item.ItemIndex].ToString();
DPGrid.EditItemIndex = -1;
try
{
DataSet _DataList = null;
_DataList = DatabaseManager.Data.DBAccessManager.RetrieveEmpDependentInfo(Int32.Parse(keyField.Text.ToString()));
if (_DataList.Tables.Count > 0)
{
if (_DataList.Tables[0].Rows.Count > 0) // Leave Request Information.
{
DataRow _DataRow = _DataList.Tables[0].Rows[0];
Tab3_Name.Text = _DataRow["FullName"].ToString();
Tab3_DOB.Text = _DataRow["DOB"].ToString();
Tab3_PassportExpiryDate.Text = _DataRow["PP_ExpiryDate"].ToString();
Tab3_PassportIssueDate.Text = _DataRow["PP_IssueDate"].ToString();
Tab3_PassportNo.Text = _DataRow["PassportNumber"].ToString();
Tab3_VisaExpiryDate.Text = _DataRow["Visa_ExpiryDate"].ToString();
Tab3_VisaIssueDate.Text = _DataRow["Visa_IssueDate"].ToString();
Tab3_VisaNumber.Text = _DataRow["Visa_Number"].ToString();
if (_DataRow["GenderTypeID"].ToString() != "")
{
Tab3_GenderType.SelectedValue = _DataRow["GenderTypeID"].ToString();
}
if (_DataRow["PP_IssueCountryID"].ToString() != "")
{
Tab3_PassportCountryDDList.SelectedValue = _DataRow["PP_IssueCountryID"].ToString();
}
if (_DataRow["RelationshipID"].ToString() != "")
{
Tab3_RelationshipDDList.SelectedValue = _DataRow["RelationshipID"].ToString();
}
if (_DataRow["Visa_TypeID"].ToString() != "")
{
Tab3_VisaType.SelectedValue = _DataRow["Visa_TypeID"].ToString();
}
if (_DataRow["Visa_IssueCountryID"].ToString() != "")
{
Tab3_VisaIssueCountryID.SelectedValue = _DataRow["Visa_IssueCountryID"].ToString();
}
}
}
}
catch (Exception exception)
{
ErrorLogging.LogError(exception, "");
}
}
protected void Tab3_Approve_Click(object sender, EventArgs e)
{
try
{
if (Page.IsValid == true)
{
Int32 Approval = 0; Int32 LeavePayType = 0;
if (Tab3_keyField.Text.ToString() == "")
{
Tab3_keyField.Text = "0";
}
if (Tab3_ApprRB1.Checked)
{
Approval = 1;
}
if (Tab3_ApprRB2.Checked)
{
Approval = 0;
}
if (Tab3_Rb1_PayType1.Checked)
{
LeavePayType = 1;
}
if (Tab3_Rb1_PayType2.Checked)
{
LeavePayType = 0;
}
DataSet _DataList = null;
_DataList = DatabaseManager.Data.DBAccessManager.Appprove_LeaveRequest(Convert.ToInt32(Tab3_keyField.Text), Convert.ToInt32(keyField.Text), Tab3_ApproverComments.Text.ToString(), LeavePayType, Approval, EmpId);
if (_DataList.Tables[0].Rows.Count > 0)
{
String Result, LineManagerName, LineManagerEmail, EmpName, EmpEmail, LeaveType, LeaveStartDate, LeaveEndDate, StatusName;
DataRow _DataRow = _DataList.Tables[0].Rows[0];
Result = _DataRow["Result"].ToString();
if (Result == "")
{
LineManagerName = _DataRow["ApproverName"].ToString();
LineManagerEmail = _DataRow["ApproverEmail"].ToString();
EmpName = _DataRow["EmpName"].ToString();
EmpEmail = _DataRow["EmpEmail"].ToString();
LeaveStartDate = _DataRow["LeaveDate"].ToString();
LeaveEndDate = _DataRow["LeaveEndDate"].ToString();
LeaveType = _DataRow["LeaveType"].ToString();
StatusName = _DataRow["StatusName"].ToString();
if ((LineManagerEmail != "") && (EmpEmail != "")) // Notify via Email if Email was used as a user Name
{
LeaveRequestApproval_Notification(EmpName, EmpEmail, LeaveStartDate, LeaveEndDate, LeaveType, StatusName, LineManagerName, LineManagerEmail);
}
ResetFields();
}
else
{
Tab3_Message.Visible = true;
Tab3_Message.Text = Result;
Tab3_Message.CssClass = "errorMessage";
}
}
}
else
{
Tab3_Message.Visible = true;
Tab3_Message.Text = "Error:Could not save the information. Please check the inputs";
Tab3_Message.CssClass = "errorMessage";
}
LoadPendingLeaveRequestList();// Refresh the grid
}
catch (Exception exception)
{
Tab3_Message.Visible = true;
Tab3_Message.Text = ErrorLogging.LogError(exception, "Unknown Exception Occured. Please contact support.");
Tab3_Message.CssClass = "errorMessage";
}
}
protected void Tab2_Cancel_Click(object sender, EventArgs e)
{
try
{
if (Page.IsValid == true)
{
if (Tab2_keyField.Text.ToString() == "0")
{
Tab2_Message2.Visible = true;
Tab2_Message2.Text = "Please select the leave request to cancel.";
Tab2_Message2.CssClass = "errorMessage";
return;
}
DataSet _DataList = null;
_DataList = DatabaseManager.Data.DBAccessManager.Cancel_ApprovedLeaveRequest(Convert.ToInt32(Tab2_keyField.Text), Convert.ToInt32(keyField.Text), Tab2_ApproverComments.Text.ToString(), EmpId);
if (_DataList.Tables[0].Rows.Count > 0)
{
String Result, LineManagerName, LineManagerEmail, EmpName, EmpEmail, LeaveType, LeaveStartDate, LeaveEndDate, StatusName;
DataRow _DataRow = _DataList.Tables[0].Rows[0];
Result = _DataRow["Result"].ToString();
if (Result == "")
{
EmpName = _DataRow["EmpName"].ToString();
EmpEmail = _DataRow["EmpEmail"].ToString();
LeaveStartDate = _DataRow["LeaveDate"].ToString();
LeaveEndDate = _DataRow["LeaveEndDate"].ToString();
LeaveType = _DataRow["LeaveType"].ToString();
StatusName = _DataRow["StatusName"].ToString();
if (StatusName != "")
{
if (EmpEmail != "") // Notify via Email if Email was used as a user Name
{
LeaveRequestCancel_Notification(EmpName, EmpEmail, LeaveStartDate, LeaveEndDate, LeaveType, StatusName);
}
Tab2_Message2.Visible = true;
Tab2_Message2.Text = "This request has been successfully cancelled and employee has been notified via email.";
Tab2_Message2.CssClass = "errorMessage";
ResetFields();
}
}
else
{
Tab2_Message2.Visible = true;
Tab2_Message2.Text = Result;
Tab2_Message2.CssClass = "errorMessage";
}
}
}
else
{
Tab2_Message2.Visible = true;
Tab2_Message2.Text = "Error:Could not save the information. Please check the inputs";
Tab2_Message2.CssClass = "errorMessage";
}
LoadPendingLeaveRequestList();// Refresh the grid
}
catch (Exception exception)
{
Tab2_Message.Visible = true;
Tab2_Message.Text = ErrorLogging.LogError(exception, "Unknown Exception Occured. Please contact support.");
Tab2_Message.CssClass = "errorMessage";
}
}
private void MemberLogin(object sender, System.EventArgs e)
{
try
{
if (Page.IsValid == true)
{
DataSet _DataList = null;
String userName = string.Empty;
String roleName = string.Empty;
String userEmail = string.Empty;
String MemberName = string.Empty;
String PasswordExpiry = string.Empty;
_DataList = DBAccessManager.ValidateLogin(this.EmailAddress.Text.ToString().Trim(), SchoolNetBase.EncodePasswordToBase64(this.Login_Password.Text.ToString().Trim()));
if (_DataList.Tables.Count > 0)
{
if (_DataList.Tables[0].Rows.Count > 0) // Member Login Information
{
DataRow _DataRow = _DataList.Tables[0].Rows[0];
userName = _DataRow["EmpId"].ToString();
roleName = _DataRow["RoleName"].ToString();
userEmail = _DataRow["Work_Email"].ToString();
MemberName = _DataRow["MemberName"].ToString();
PasswordExpiry = _DataRow["PasswordExpiry"].ToString();
}
// If the password has expired, redirect to change password screen
if (PasswordExpiry != "")
{
Tab1_keyField.Text = EmailAddress.Text.ToString().Trim();
Login_Pane.Visible = false;
ChangePassword.Visible = true;
errorMessage.Text = "";
}
else
{
DateTime expiryDate = DateTime.Now.AddMinutes(60);// Default
bool isPersistent = false;
if (login_RememberMe.Checked)
{
//clear any other tickets that are already in the response
Response.Cookies.Clear();
//set the new expiry date - to thirty days from now
expiryDate = DateTime.Now.AddDays(30);
//create a new forms auth ticket
isPersistent = true;
}
FormsAuthenticationTicket ticket = new FormsAuthenticationTicket(1, userName, DateTime.Now, expiryDate, isPersistent, roleName);
//encrypt the ticket
String encryptedTicket = FormsAuthentication.Encrypt(ticket);
//create a new authentication cookie - and set its expiration date
HttpCookie authenticationCookie = new HttpCookie(FormsAuthentication.FormsCookieName, encryptedTicket);
authenticationCookie.Expires = ticket.Expiration;
//add the cookie to the response.
Response.Cookies.Add(authenticationCookie);
Session["MemberName"] = MemberName;
Session["MemberEmail"] = userEmail;
String redirectUrl = "";
if (roleName == "HR Administrator")
{
redirectUrl = FormsAuthentication.GetRedirectUrl(userName, false);
}
if (roleName == "Payroll Administrator")
{
redirectUrl = Page.ResolveUrl("~/Payroll/PayrollDashboard.aspx");
}
if (roleName == "Supervisor" || roleName == "Employee")
{
redirectUrl = Page.ResolveUrl("~/Common/EmployeeProfile.aspx");
}
if (roleName == "Data Entry Clerk")
{
redirectUrl = Page.ResolveUrl("~/Clerical/EnterDailyFNTrans.aspx");
}
if (redirectUrl.Equals(String.Empty))
{
redirectUrl = Page.ResolveUrl("~/Common/EmployeeProfile.aspx");
}
Page.Response.Redirect(redirectUrl);
}
}
else
{
this.errorMessage.Visible = true;
this.EmailAddress.Text = "";
this.Login_Password.Text = "";
this.errorMessage.Text = "Invalid Email Id or Password. Please check your credentials.";
this.errorMessage.CssClass = "errorMessage";
}
}
}
catch (Exception exception)
{
this.errorMessage.Visible = true;
this.EmailAddress.Text = "";
this.Login_Password.Text = "";
this.errorMessage.Text = ErrorLogging.LogError(exception, "Unknown Exception Occured.Please contact Support.");
this.errorMessage.CssClass = "errorMessage";
}
}