private string CreateExport(DataTable ooo_data, int access_level)
{
DateTime now = DateTime.Now;
string
user_id = HttpContext.Current.Session["employee_id"].ToString(),
file_name = "OutOfOffice-" + user_id + "-" + now.ToString("yyyyMMdd_HHmmss") + ".xlsx";
if (access_level == 1)
{
// Initializing the column names for the export.
string[] column_names =
new string[] { "Employee ID", "Employee Name", "OutOfOffice Type", "From DateTime", "To DateTime", "Hours", "TotalHours Availed", "Reason", "Manager Status" };
ExcelExport.ExportDataToExcel(file_name, "OUT OF OFFICE", ooo_data, Context, column_names);
}
if (access_level == 3)
{
// Initializing the column names for the export.
string[] column_names =
new string[] { "EmployeeID", "EmployeeName", "OutOfOffice Type", "FromDateTime", "ToDateTime", "Hours", "TotalHours Availed", "Reason", "Manager Name", "Manager Remark", "Manager Status", "HR Status" };
ExcelExport.ExportDataToExcel(file_name, "OUT OF OFFICE", ooo_data, Context, column_names);
}
return(file_name);
}
private string CreateExport(DataTable filtered_data, string company_name)
{
DateTime now = DateTime.Now;
// Initializing the column names for the export.
string[] column_names =
new string[] { "Employee ID", "Employee Name", "Branch", "Department", "Category", "LeaveType", "MaxLeave", "Consumed", "Balance" };
string
user_id = HttpContext.Current.Session["employee_id"].ToString(),
file_name = "EmploeeLeaveCardReport-" + user_id + "-" + now.ToString("yyyyMMdd_HHmmss") + ".xlsx";
ExcelExport.ExportDataToExcel(file_name, "EMPLOYEE LEAVE CARD", filtered_data, Context, column_names, company_name);
return(file_name);
}
private string CreateExport(DataTable company_data)
{
DateTime now = DateTime.Now;
// Initializing the column names for the export.
string[] column_names =
new string[] { "Department Code", "Department Name", "Company Name", "CompanyCode" };
string
user_id = HttpContext.Current.Session["employee_id"].ToString(),
file_name = "DepartmentMaster-" + user_id + "-" + now.ToString("yyyyMMdd_HHmmss") + ".xlsx";
ExcelExport.ExportDataToExcel(file_name, "DEPARTMENT MASTER", company_data, Context, column_names);
return(file_name);
}
private string CreateExport(DataTable company_data)
{
DateTime now = DateTime.Now;
// Initializing the column names for the export.
string[] column_names =
new string[] { "Branch Code", "Branch Name", "Company Code", "Company Name", "Branch Address", "Phone No", "Fax No", "Email" };
string
user_id = HttpContext.Current.Session["employee_id"].ToString(),
file_name = "BranchMaster-" + user_id + "-" + now.ToString("yyyyMMdd_HHmmss") + ".xlsx";
ExcelExport.ExportDataToExcel(file_name, "BRANCH MASTER", company_data, Context, column_names);
return(file_name);
}
private string CreateExport(DataTable company_data)
{
DateTime now = DateTime.Now;
// Initializing the column names for the export.
string[] column_names =
new string[] { "Employee Code", "Employee Name", "Leave Name", "Max Leaves", "Leaves Applied", "Balance Leave" };
string
user_id = HttpContext.Current.Session["employee_id"].ToString(),
file_name = "LeaveAvailable-" + user_id + "-" + now.ToString("yyyyMMdd_HHmmss") + ".xlsx";
ExcelExport.ExportDataToExcel(file_name, "LEAVES AVAILABLE", company_data, Context, column_names);
return(file_name);
}
private string CreateExport(DataTable company_data)
{
DateTime now = DateTime.Now;
// Initializing the column names for the export.
string[] column_names =
new string[] { "Employee Category Code", "Employee Category Name", "Company Code", "Company Name", "Total Hours", "Process" };
string
user_id = HttpContext.Current.Session["employee_id"].ToString(),
file_name = "EmployeeCategoryMaster-" + user_id + "-" + now.ToString("yyyyMMdd_HHmmss") + ".xlsx";
ExcelExport.ExportDataToExcel(file_name, "EMPLOYEE CATEGORY MASTER", company_data, Context, column_names);
return(file_name);
}
private string CreateExport(DataTable company_data)
{
DateTime now = DateTime.Now;
// Initializing the column names for the export.
string[] column_names =
new string[] { "Shift Code", "Shift Name", "In Time", "Out Time", "Weekly Off 1", "Weekly Off 2" };
string
user_id = HttpContext.Current.Session["username"].ToString(),
file_name = "ShiftDetails-" + user_id + "-" + now.ToString("yyyyMMdd_HHmmss") + ".xlsx";
ExcelExport.ExportDataToExcel(file_name, "SHIFT DETAILS", company_data, Context, column_names);
return(file_name);
}
private string CreateExportTransaction(DataTable employee_transaction_data)
{
DateTime now = DateTime.Now;
// Initializing the column names for the export.
//string[] column_names =
// new string[] { "Employee Code", "Employee Card Number", "Employee Name", "Company", "Branch", "Department", "Designation", "Shift", "Date of Joining", "Date of Birth", "Gender", "Address", "Phone Number", "Email Address" };
string[] column_names =
new string[] { "Employee Code", "Transaction Name", "From Date", "To Date", "Transaction Value", "Status" };
string
user_id = HttpContext.Current.Session["employee_id"].ToString(),
file_name = "EmployeeDataTrnsaction-" + user_id + "-" + now.ToString("yyyyMMdd_HHmmss") + ".xlsx";
ExcelExport.ExportDataToExcel(file_name, "EMPLOYEE DATA TRANSACTION", employee_transaction_data, Context, column_names);
return(file_name);
}
private string CreateExport(DataTable company_data)
{
DateTime now = DateTime.Now;
// Initializing the column names for the export.
//string[] column_names =
// new string[] { "Employee Code", "Employee Card Number", "Employee Name", "Company", "Branch", "Department", "Designation", "Shift", "Date of Joining", "Date of Birth", "Gender", "Address", "Phone Number", "Email Address" };
string[] column_names =
new string[] { "Employee Code", "Employee Name", "Dob", "Gender", "Address", "Phone", "Email", "Date Of Join", "Date of Leave", "Company", "Branch", "Department", "Designation", "Employee Category", "Card No", "Shift", "Status", "OT_Eligibility", "Passport_No", "Passport_Exp_Date", "Emirates_No", "Nationality", "Emergency_Contact_No", "Visa_Exp_Date", "IsManager", "ManagerId", "otflag", "isreinstate", "IsHR", "AbscondingDate", "isAutoShiftEligible", "Employee Relegion" };
string
user_id = HttpContext.Current.Session["employee_id"].ToString(),
file_name = "EmployeeMaster-" + user_id + "-" + now.ToString("yyyyMMdd_HHmmss") + ".xlsx";
ExcelExport.ExportDataToExcel(file_name, "EMPLOYEE MASTER", company_data, Context, column_names);
return(file_name);
}
