public string ExportExMonthTMS(int UserID, string MonthID, string FilterBy, string FilterValue)
{
External_TimesCollection collection = T_LMS_Trans_LeaveStoryManager.GetExMonthlyReport(UserID, MonthID, FilterBy, FilterValue);
DataSet ds = new DataSet();
DataTable dt = collection.ToDataTable <External_Times>();
string fileName = UserID + "_Monthly_TimeSheet_" + SystemConfig.CurrentDate.ToString("MM-dd-yyyy");
string[] sheetName = { "Daily_TMS" };
string[] RemoveColumn = { "CompanyID", "TargetDisplayID", "ReturnDisplay", "TotalRecord", "CreatedUser", "CreatedDate", "ErrorMesssage" };
for (int i = 0; i < RemoveColumn.Length; i++)
{
if (dt.Columns.Contains(RemoveColumn[i]))
{
dt.Columns.Remove(RemoveColumn[i]);
}
}
ds.Tables.Add(dt);
//set Column Date Format
//int[] DateColumn = { 5, 6 };
//ExcelPara mypara = new ExcelPara()
//{
// ds = ds,
// sheetName = sheetName,
// fileName = fileName,
// DateColumns = DateColumn,
// DateFormat = "h:mm:ss tt"
//};
//FileInputHelper.ExportMultiSheetExcelExtend(mypara);
FileInputHelper.ExportExcel(dt, fileName, "Monthly_TimeSheet", false);
return(fileName);
}
public static External_TimesCollection GetAllItemByMonth(DateTime FromDate, DateTime ToDate, int UserID, string FilterBy, string FilterValue)
{
var pars = new SqlParameter[]
{
new SqlParameter("@FromDate", FromDate),
new SqlParameter("@ToDate", ToDate),
new SqlParameter("@FilterBy", FilterBy),
new SqlParameter("@FilterValue", FilterValue),
new SqlParameter("@ManagerID", UserID),
new SqlParameter("@OrderBy", "AssociateNo"),
new SqlParameter("@OrderDirection", 1),
};
External_TimesCollection collection = new External_TimesCollection();
using (var reader = SqlHelper.ExecuteReaderService(ModuleConfig.MyConnection, "USP_TMS_External_AssociatesTimeSheet_Get_MonthlyScantime_V1", pars))
{
//return CommonHelper.DataReaderToList<External_TimesCollection>(reader);
External_Times obj = new External_Times();
while (reader.Read())
{
obj = GetMonthly(reader);
collection.Add(obj);
}
}
return(collection);
}
public static External_TimesCollection GetExMonthlyReport(int userid, string monthid, string FilterBy, string FilterValue)
{
External_TimesCollection items = new External_TimesCollection();
using (var client = WebApiHelper.myclient(HouseEndpoint, SystemConst.APIJosonReturnValue))
{
HttpResponseMessage response = client.GetAsync(string.Format("ExScanTime?userid={0}&monthid={1}&FilterBy={2}&FilterValue={3}", userid, monthid, FilterBy, FilterValue)).GetAwaiter().GetResult();
if (response.IsSuccessStatusCode)
{
items = response.Content.ReadAsAsync <External_TimesCollection>().GetAwaiter().GetResult();
}
}
return(items);
}
