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