public DespesasController(UsuariosDAO userDAO, TiposDeDespesasDAO tpDAO, DespesasDAO depDAO, UploadDAO arq)
{
this.usuarioDAO = userDAO;
this.tiposDAO = tpDAO;
this.despesasDAO = depDAO;
this.uploadDAO = arq;
//Carrega os Menus desse controller
BuildMenu();
}
public static async Task Main(string[] args)
{
var mapDAO = new MapDAO(Constants.MapSQLConnection);
var logDAO = new LogDAO(Constants.NOSQLConnection);
var userDAO = new UserDAO(Constants.SQLConnection);
var uploadDAO = new UploadDAO(Constants.SQLConnection);
var snapshotDAO = new SnapshotDAO(Constants.NOSQLConnection);
var maskService = new MaskingService(mapDAO);
var ffLoggingService = new FlatFileLoggingService(maskService);
var dsLoggingService = new DataStoreLoggingService(logDAO, maskService);
var snapshotService = new SnapshotService(logDAO, userDAO, uploadDAO, snapshotDAO);
var loggingManager = new LoggingManager(ffLoggingService, dsLoggingService);
var createSnapManager = new CreateSnapshotManager(loggingManager, snapshotService);
// Script called at the beginning of every month.
// Get the year and month according the Utc time.
var year = DateTime.UtcNow.Year;
var month = DateTime.UtcNow.Month;
// We want to create a snapshot of the previous month so we have to subtract 1 to the month if it is not 1 (January).
// If it is 1, then change month to 12, and subtract 1 from year instead.
if (month == 1)
{
year = year - 1;
month = 12;
}
else
{
month = month - 1;
}
var tries = 0;
var createSnapshotSuccess = false;
// If the createsnapshot was a failure, there are 3 extra tries. It can stop if it was successful though.
while (!createSnapshotSuccess && tries < 4)
{
createSnapshotSuccess = await createSnapManager.CreateSnapshotAsync(tries, year, month).ConfigureAwait(false);
if (!createSnapshotSuccess)
{
tries++;
}
}
}
public async Task<IActionResult> SearchIngredientAtStoreAsync(string ingredientName, int storeID, int pagination, string username, string ipAddress)
{
// New up DAL
UploadDAO uploadDAO = new UploadDAO(Constants.SQLConnection);
var mapDao = new MapDAO(Constants.MapSQLConnection);
var logDao = new LogDAO(Constants.SQLConnection);
// New up Service
var uploadService = new UploadService(uploadDAO);
var maskingService = new MaskingService(mapDao);
var ffLoggingService = new FlatFileLoggingService(maskingService);
var dsLoggingService = new DataStoreLoggingService(logDao, maskingService);
// New up Managers
var loggingManager = new LoggingManager(ffLoggingService, dsLoggingService);
var ingredientManager = new IngredientManager( uploadService, loggingManager);
return Ok(await ingredientManager.GetUploadsByIngredientNameandStoreId(ingredientName, storeID, pagination, Constants.InitialFailureCount, username, ipAddress).ConfigureAwait(false));
}
public async Task <bool> DownvoteIngredient(int uploadId, string username, string ipAddress)
{
// New up DAL
UploadDAO uploadDAO = new UploadDAO(Constants.SQLConnection);
var mapDao = new MapDAO(Constants.MapSQLConnection);
var logDao = new LogDAO(Constants.SQLConnection);
var userDao = new UserDAO(Constants.SQLConnection);
var anonymousUserDao = new AnonymousUserDAO(Constants.SQLConnection);
// New up Service
var uploadService = new UploadService(uploadDAO);
var maskingService = new MaskingService(mapDao);
var ffLoggingService = new FlatFileLoggingService(maskingService);
var dsLoggingService = new DataStoreLoggingService(logDao, maskingService);
var userManagementService = new UserManagementService(userDao, anonymousUserDao, dsLoggingService, ffLoggingService, maskingService);
// New up Managers
var loggingManager = new LoggingManager(ffLoggingService, dsLoggingService);
var ingredientManager = new IngredientManager(uploadService, loggingManager, userManagementService);
return(await ingredientManager.EditDownvotesonUpload(Constants.PositiveVote, uploadId, Constants.InitialFailureCount, username, ipAddress));
}
public async Task <IActionResult> GetIngredientViewPaginationSize(string ingredientName, int storeId, string username, string ipAddress)
{
// New up DAL
UploadDAO uploadDAO = new UploadDAO(Constants.SQLConnection);
var mapDao = new MapDAO(Constants.MapSQLConnection);
var logDao = new LogDAO(Constants.SQLConnection);
var userDao = new UserDAO(Constants.SQLConnection);
var anonymousUserDao = new AnonymousUserDAO(Constants.SQLConnection);
// New up Service
var uploadService = new UploadService(uploadDAO);
var maskingService = new MaskingService(mapDao);
var ffLoggingService = new FlatFileLoggingService(maskingService);
var dsLoggingService = new DataStoreLoggingService(logDao, maskingService);
var userManagementService = new UserManagementService(userDao, anonymousUserDao, dsLoggingService, ffLoggingService, maskingService);
// New up Managers
var loggingManager = new LoggingManager(ffLoggingService, dsLoggingService);
var ingredientManager = new IngredientManager(uploadService, loggingManager, userManagementService);
try
{
// Return status code of 200 as well as the content.
return(Ok(await ingredientManager.GetIngredientViewPaginationSize(ingredientName, storeId, Constants.InitialFailureCount, username, ipAddress).ConfigureAwait(false)));
}
catch (ArgumentException ae)
{
// Return an 404 error when the resource does not exists.
return(NotFound(ae.Message));
}
catch
{
// Return generic server error for all other exceptions.
return(StatusCode(StatusCodes.Status500InternalServerError));
}
}
public UploadController(UploadDAO u)
{
this.uploadDAO = u;
}
public UploadService(UploadDAO uploadDAO)
{
_uploadDAO = uploadDAO;
}
public WorkplaceController()
{
_dao = new UploadDAO();
_daoActionPlan = new ActionPlanDAO();
}
public ActionResult Submit(FormCollection formCollection)
{
HttpPostedFileBase file = Request.Files["UploadedFile"];
var datasList = new List <UploadDataVM>();
//var datasList2 = new List<UploadDataVM2>();
if ((file != null) && (file.ContentLength > 0) && !string.IsNullOrEmpty(file.FileName))
{
string fileName = file.FileName;
string fileContentType = file.ContentType;
byte[] fileBytes = new byte[file.ContentLength];
var data = file.InputStream.Read(fileBytes, 0, Convert.ToInt32(file.ContentLength));
using (var package = new ExcelPackage(file.InputStream))
{
var currentSheet = package.Workbook.Worksheets;
var workSheet = currentSheet.First();
var noOfCol = workSheet.Dimension.End.Column;
var noOfRow = workSheet.Dimension.End.Row;
for (int rowIterator = 2; rowIterator <= noOfRow; rowIterator++)
{
var item = new UploadDataVM();
item.KPILevelCode = workSheet.Cells[rowIterator, 1].Value.ToSafetyString().ToUpper();
//item.KPIName = workSheet.Cells[rowIterator, 2].Value.ToSafetyString().ToUpper();
item.Value = workSheet.Cells[rowIterator, 3].Value.ToSafetyString();
item.TargetValue = workSheet.Cells[rowIterator, 4].Value.ToDouble();
item.PeriodValue = workSheet.Cells[rowIterator, 5].Value.ToInt();
//item.Year = workSheet.Cells[rowIterator, 6].Value.ToInt();
//item.Area = workSheet.Cells[rowIterator, 7].Value.ToSafetyString();
//item.UpdateTime = workSheet.Cells[rowIterator, 8].Value.ToSafetyString().Trim();
//item.Remark = workSheet.Cells[rowIterator, 8].Value.ToSafetyString();
item.CreateTime = DateTime.Now;
datasList.Add(item);
}
}
var model = new UploadDAO().UploadData(datasList);
if (model.ListUploadKPIVMs.Count > 0)
{
string content = System.IO.File.ReadAllText(Server.MapPath("~/Templates/newEmail.html"));
var html = string.Empty;
foreach (var item in model.ListUploadKPIVMs)
{
html += @"<tr>
<td valign='top' style='padding:5px; font-family: Arial,sans-serif; font-size: 16px; line-height:20px;'>{{area}}</td>
<td valign='top' style='padding:5px; font-family: Arial,sans-serif; font-size: 16px; line-height:20px;'>{{kpiname}}</td>
<td valign='top' style='padding:5px; font-family: Arial,sans-serif; font-size: 16px; line-height:20px;'>{{week}}</td>
<td valign='top' style='padding:5px; font-family: Arial,sans-serif; font-size: 16px; line-height:20px;'>{{month}}</td>
<td valign='top' style='padding:5px; font-family: Arial,sans-serif; font-size: 16px; line-height:20px;'>{{quarter}}</td>
<td valign='top' style='padding:5px; font-family: Arial,sans-serif; font-size: 16px; line-height:20px;'>{{year}}</td>
</tr>"
.Replace("{{area}}", item.Area)
.Replace("{{kpiname}}", item.KPIName)
.Replace("{{week}}", item.Week.ToSafetyString())
.Replace("{{month}}", item.Month.ToSafetyString())
.Replace("{{quarter}}", item.Quarter.ToSafetyString())
.Replace("{{year}}", item.Year.ToSafetyString());
}
content = content.Replace("{{{html-template}}}", html);
var sessionUser = Session["UserProfile"] as UserProfileVM;
string from = ConfigurationManager.AppSettings["FromEmailAddress"].ToSafetyString();
string password = ConfigurationManager.AppSettings["FromEmailPassword"].ToSafetyString();
string to = sessionUser.User.Email;
if (sessionUser.User.Email.IsEmailFormat())
{
to = sessionUser.User.Email.ToSafetyString();
}
string subject = ConfigurationManager.AppSettings["FromEmailDisplayName"].ToSafetyString();
MailMessage mail = new MailMessage();
mail.To.Add(to.ToString());
mail.From = new MailAddress(from, "KPI.App");
mail.Subject = subject;
mail.Body = content;
mail.IsBodyHtml = true;
mail.BodyEncoding = System.Text.Encoding.UTF8;
mail.Priority = MailPriority.High;
try
{
using (var smtp = new SmtpClient())
{
smtp.Send(mail);
}
}
catch (Exception ex)
{
Console.WriteLine(ex);
}
return(Json(model.Status, JsonRequestBehavior.AllowGet));
}
return(Json(model.Status, JsonRequestBehavior.AllowGet));
}
return(Json(false, JsonRequestBehavior.AllowGet));
}
public ActionResult ExcelExport(int userid)
{
var model = new UploadDAO().DataExport(userid);
var currentYear = DateTime.Now.Year;
var currentWeek = DateTime.Now.GetIso8601WeekOfYear();
var currentMonth = DateTime.Now.Month;
var currentQuarter = DateTime.Now.GetQuarter();
var now = DateTime.Now;
var end = now.GetEndOfQuarter();
var tt = end.Subtract(now).Days;
//var targetValue = "";
DataTable Dt = new DataTable();
Dt.Columns.Add("KPILevel Code", typeof(string));
Dt.Columns.Add("KPI Name", typeof(string));
Dt.Columns.Add("Actual Value", typeof(string));
Dt.Columns.Add("Target Value", typeof(object));
Dt.Columns.Add("Period Value", typeof(string));
Dt.Columns.Add("Year", typeof(int));
Dt.Columns.Add("Area", typeof(string));
Dt.Columns.Add("Update Time", typeof(object));
Dt.Columns.Add("Start Date", typeof(string));
Dt.Columns.Add("End Date", typeof(string));
foreach (var item in model)
{
///Logic export tuần
//if (item.StateW == true)
//{
// for (int i = 1; i <= currentWeek; i++)
// {
// var startDayOfWeek = CodeUtility.ToGetMondayOfWeek(currentYear, i).ToString("MM/dd/yyyy");
// var endDayOfWeek = CodeUtility.ToGetSaturdayOfWeek(currentYear, i).ToString("MM/dd/yyyy");
// var updateTimeW = item.UploadTimeW.ConvertNumberDayOfWeekToString() + ", Week " + i;
// var value = new UploadDAO().GetValueData(item.KPILevelCode, "W", i);
// Dt.Rows.Add(item.KPILevelCode + "W", item.KPIName, value, item.TargetValueW, i, currentYear, item.Area, updateTimeW, startDayOfWeek, endDayOfWeek);
// }
//}
/////Logic export tháng
//if (item.StateM == true)
//{
// var updateTimeM = item.UploadTimeM.ToStringDateTime("MM/dd/yyyy");
// for (int i = 1; i <= currentMonth; i++)
// {
// var startDayOfMonth = CodeUtility.ToGetStartDateOfMonth(currentYear, i).ToString("MM/dd/yyyy");
// var endDayOfMonth = CodeUtility.ToGetEndDateOfMonth(currentYear, i).ToString("MM/dd/yyyy");
// var value = new UploadDAO().GetValueData(item.KPILevelCode, "M", i);
// Dt.Rows.Add(item.KPILevelCode + "M", item.KPIName, value, item.TargetValueW, i, currentYear, item.Area, updateTimeM, startDayOfMonth, endDayOfMonth);
// }
//}
/////Logic export quý
//if (item.StateQ == true)
//{
// var updateTimeQ = item.UploadTimeQ.ToStringDateTime("MM/dd/yyyy");
// for (int i = 1; i <= currentQuarter; i++)
// {
// var seq = CodeUtility.ToGetStartAndEndDateOfQuarter(currentYear, i);
// var value = new UploadDAO().GetValueData(item.KPILevelCode, "Q", i);
// Dt.Rows.Add(item.KPILevelCode + "Q", item.KPIName, value, item.TargetValueW, i, currentYear, item.Area, updateTimeQ, seq.start.ToString("MM/dd/yyyy"), seq.end.ToString("MM/dd/yyyy"));
// }
//}
///Logic export năm
if (item.StateY == true)
{
var updateTimeY = item.UploadTimeY.ToStringDateTime("MM/dd/yyyy");
var sey = CodeUtility.ToGetStartAndEndDateOfYear(currentYear);
for (int i = currentYear - 9; i <= currentYear; i++)
{
var value = new UploadDAO().GetValueData(item.KPILevelCode, "Y", currentYear);
Dt.Rows.Add(item.KPILevelCode + "Y", item.KPIName, value, item.TargetValueW, i, currentYear, item.Area, updateTimeY, sey.start.ToString("MM/dd/yyyy"), sey.end.ToString("MM/dd/yyyy"));
}
}
}
var memoryStream = new MemoryStream();
using (var excelPackage = new ExcelPackage(memoryStream))
{
var worksheet = excelPackage.Workbook.Worksheets.Add("Sheet1");
worksheet.Cells["A1"].LoadFromDataTable(Dt, true, TableStyles.None);
worksheet.Cells["A1:AN1"].Style.Font.Bold = true;
worksheet.DefaultRowHeight = 18;
worksheet.Column(2).Style.HorizontalAlignment = ExcelHorizontalAlignment.Left;
worksheet.Column(6).Style.HorizontalAlignment = ExcelHorizontalAlignment.Center;
worksheet.Column(7).Style.HorizontalAlignment = ExcelHorizontalAlignment.Center;
worksheet.DefaultColWidth = 20;
worksheet.Column(2).AutoFit();
Session["DownloadExcel_FileManager"] = excelPackage.GetAsByteArray();
return(Json("", JsonRequestBehavior.AllowGet));
}
}
public ActionResult ExcelExport1(int userid)
{
var model = new UploadDAO().DataExport(userid);
var currentYear = DateTime.Now.Year;
var currentWeek = DateTime.Now.GetIso8601WeekOfYear();
var currentMonth = DateTime.Now.Month;
var currentQuarter = DateTime.Now.GetQuarter();
var now = DateTime.Now;
var end = now.GetEndOfQuarter();
var tt = end.Subtract(now).Days;
//var targetValue = "";
DataTable Dt = new DataTable();
Dt.Columns.Add("KPILevel Code", typeof(string));
Dt.Columns.Add("KPI Name", typeof(string));
Dt.Columns.Add("Actual Value", typeof(string));
Dt.Columns.Add("Target Value", typeof(object));
Dt.Columns.Add("Period Value", typeof(string));
Dt.Columns.Add("Year", typeof(int));
Dt.Columns.Add("Area", typeof(string));
Dt.Columns.Add("Update Time", typeof(object));
Dt.Columns.Add("Start Date", typeof(string));
Dt.Columns.Add("End Date", typeof(string));
foreach (var item in model)
{
///Logic export tuần
//Nếu tuần MAX trong bảng DATA mà bằng 0 thì export từ tuần đầu cho đến tuần hiện tại
if (item.PeriodValueW == 0 && item.StateW == true)
{
for (int i = 1; i <= currentWeek; i++)
{
var startDayOfWeek = CodeUtility.ToGetMondayOfWeek(currentYear, i).ToString("MM/dd/yyyy");
var endDayOfWeek = CodeUtility.ToGetSaturdayOfWeek(currentYear, i).ToString("MM/dd/yyyy");
var updateTimeW = item.UploadTimeW.ConvertNumberDayOfWeekToString() + ", Week " + i;
Dt.Rows.Add(item.KPILevelCode + "W", item.KPIName, item.Value, item.TargetValueW, i, currentYear, item.Area, updateTimeW, startDayOfWeek, endDayOfWeek);
}
}
// nếu tuần hiện tại trừ tuần MAX >= 1 thì export từ tuần kế tiếp tuần MAX cho đến tuần hiện tại
else if (item.PeriodValueW > 0 && item.StateW == true)
{
if (currentWeek - item.PeriodValueW >= 1)
{
for (int i = item.PeriodValueW + 1; i <= currentWeek; i++)
{
var startDayOfWeek = CodeUtility.ToGetMondayOfWeek(currentYear, i).ToString("MM/dd/yyyy");
var endDayOfWeek = CodeUtility.ToGetSaturdayOfWeek(currentYear, i).ToString("MM/dd/yyyy");
var updateTimeW = item.UploadTimeW.ConvertNumberDayOfWeekToString() + ", Week " + i;
Dt.Rows.Add(item.KPILevelCode + "W", item.KPIName, item.Value, item.TargetValueW, i, currentYear, item.Area, updateTimeW, startDayOfWeek, endDayOfWeek);
}
}
else
{
for (int i = 1; i <= currentWeek; i++)
{
var startDayOfWeek = CodeUtility.ToGetMondayOfWeek(currentYear, i).ToString("MM/dd/yyyy");
var endDayOfWeek = CodeUtility.ToGetSaturdayOfWeek(currentYear, i).ToString("MM/dd/yyyy");
var updateTimeW = item.UploadTimeW.ConvertNumberDayOfWeekToString() + ", Week " + i;
var value = new UploadDAO().GetValueData(item.KPILevelCode, "W", i);
Dt.Rows.Add(item.KPILevelCode + "W", item.KPIName, value, item.TargetValueW, i, currentYear, item.Area, updateTimeW, startDayOfWeek, endDayOfWeek);
}
}
}
///Logic export tháng
//Nếu tháng MAX trong bảng DATA mà bằng 0 thì export từ tháng đầu cho đến tháng hiện tại
if (item.PeriodValueM == 0 && item.StateM == true)
{
for (int i = 1; i <= currentMonth; i++)
{
Dt.Rows.Add(item.KPILevelCode + "M", item.KPIName, item.Value, item.TargetValueW, i, currentYear, item.Area, item.UploadTimeM.ToSafetyString().Split(' ')[0].ToSafetyString());
}
}
// nếu tháng hiện tại trừ tháng MAX >= 1 thì export từ tháng kế tiếp tháng MAX cho đến tháng hiện tại
if (item.PeriodValueM > 0 && item.StateM == true)
{
if (currentMonth - item.PeriodValueM > 1)
{
for (int i = item.PeriodValueM + 1; i <= currentMonth; i++)
{
Dt.Rows.Add(item.KPILevelCode + "M", item.KPIName, item.Value, item.TargetValueW, i, currentYear, item.Area, item.UploadTimeM.ToSafetyString().Split(' ')[0].ToSafetyString());
}
}
else
{
for (int i = 1; i <= currentMonth; i++)
{
var value = new UploadDAO().GetValueData(item.KPILevelCode, "M", i);
Dt.Rows.Add(item.KPILevelCode + "M", item.KPIName, value, item.TargetValueW, i, currentYear, item.Area, item.UploadTimeM.ToSafetyString().Split(' ')[0].ToSafetyString());
}
}
}
///Logic export quý
//Nếu quý MAX trong bảng DATA mà bằng 0 thì export từ tháng đầu cho đến quý hiện tại
if (item.PeriodValueQ == 0 && item.StateQ == true)
{
for (int i = 1; i < currentQuarter; i++)
{
Dt.Rows.Add(item.KPILevelCode + "Q", item.KPIName, item.Value, item.TargetValueW, i, currentYear, item.Area, item.UploadTimeQ.ToSafetyString().Split(' ')[0].ToSafetyString());
}
if (tt <= 30)
{
Dt.Rows.Add(item.KPILevelCode + "Q", item.KPIName, item.Value, item.TargetValueW, currentQuarter, currentYear, item.Area, item.UploadTimeQ.ToSafetyString().Split(' ')[0].ToSafetyString());
}
}
if (item.PeriodValueQ > 0 && item.StateQ == true)
{
//, Nếu quý hiện tại trừ quý MAX trong bảng DATA lớn hơn 1 thì
//export từ quý 1 cho đến quý hiện tại
if (currentQuarter - item.PeriodValueQ >= 1)
{
for (int i = item.PeriodValueQ; i <= currentQuarter; i++)
{
Dt.Rows.Add(item.KPILevelCode + "Q", item.KPIName, item.Value, item.TargetValueW, i, currentYear, item.Area, item.UploadTimeQ.ToSafetyString().Split(' ')[0].ToSafetyString());
}
}
else
{
for (int i = 1; i <= currentQuarter; i++)
{
var value = new UploadDAO().GetValueData(item.KPILevelCode, "Q", i);
Dt.Rows.Add(item.KPILevelCode + "Q", item.KPIName, value, item.TargetValueW, i, currentYear, item.Area, item.UploadTimeQ.ToSafetyString().Split(' ')[0].ToSafetyString());
}
}
}
///Logic export năm
//Nếu năm MAX trong bảng DATA == 0 thì export năm hiện tại
if (item.PeriodValueY == 0 && item.StateY == true)
{
for (int i = currentYear - 10; i <= currentYear; i++)
{
Dt.Rows.Add(item.KPILevelCode + "Y", item.KPIName, item.Value, item.TargetValueW, i, currentYear, item.Area, item.UploadTimeY.ToSafetyString().Split(' ')[0].ToSafetyString());
}
}
if (item.PeriodValueY > 0 && item.StateY == true)
{
// nếu năm hiện tại - năm max trong bảng DATA > 1 thì export năm kế tiếp đến năm hiện tại
if (currentYear - item.PeriodValueY >= 1)
{
for (int i = item.PeriodValueY + 1; i <= currentYear; i++)
{
Dt.Rows.Add(item.KPILevelCode + "Y", item.KPIName, item.Value, item.TargetValueW, i, currentYear, item.Area, item.UploadTimeY.ToSafetyString().Split(' ')[0].ToSafetyString());
}
}
else
{
for (int i = currentYear - 10; i <= currentYear; i++)
{
var value = new UploadDAO().GetValueData(item.KPILevelCode, "Y", i);
Dt.Rows.Add(item.KPILevelCode + "Y", item.KPIName, value, item.TargetValueW, i, currentYear, item.Area, item.UploadTimeY.ToSafetyString().Split(' ')[0].ToSafetyString());
}
}
}
}
var memoryStream = new MemoryStream();
using (var excelPackage = new ExcelPackage(memoryStream))
{
var worksheet = excelPackage.Workbook.Worksheets.Add("Sheet1");
worksheet.Cells["A1"].LoadFromDataTable(Dt, true, TableStyles.None);
worksheet.Cells["A1:AN1"].Style.Font.Bold = true;
worksheet.DefaultRowHeight = 18;
worksheet.Column(2).Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Left;
worksheet.Column(6).Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Center;
worksheet.Column(7).Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Center;
worksheet.DefaultColWidth = 20;
worksheet.Column(2).AutoFit();
Session["DownloadExcel_FileManager"] = excelPackage.GetAsByteArray();
return(Json("", JsonRequestBehavior.AllowGet));
}
}
public SearchService(StoreDAO storeDAO, UploadDAO uploadDAO)
{
_storeDAO = storeDAO;
_uploadDAO = uploadDAO;
}
