Ejemplo n.º 1
0
        public IActionResult AddOrUpdateDataSheet(DataSheetViewModel model)
        {
            if (UserIdentityInfo.Roles.Contains(Roles.Customer))
            {
                var user = _userService.GetById(Convert.ToInt32(UserIdentityInfo.Id));
                if (user.CustomerId != model.DataSheet.CustomerId)
                {
                    model.DataSheet.CustomerId = (int)user.CustomerId;
                }
            }

            if (model.DataSheet.Id == 0)
            {
                model.DataSheet.CreateDate = DateTime.Now;
                model.DataSheet.CreateUser = Convert.ToInt32(UserIdentityInfo.Id);
                _dataSheetService.Add(model.DataSheet);
            }
            else
            {
                model.DataSheet.UpdateDate = DateTime.Now;
                model.DataSheet.UpdateUser = Convert.ToInt32(UserIdentityInfo.Id);
                _dataSheetService.Update(model.DataSheet);
            }
            return(RedirectToAction("DataSheet", "DataSheet", new { model.DataSheet.Id }));
        }
Ejemplo n.º 2
0
        public IActionResult DataSheet(int Id = 0)
        {
            DataSheetViewModel model = new DataSheetViewModel();

            if (Id > 0)
            {
                model.DataSheet = _dataSheetService.GetById(Id);
                if (model.DataSheet == null)
                {
                    return(RedirectToAction("DataSheetList", "DataSheet"));
                }
                if (UserIdentityInfo.Roles.Contains(Roles.Customer))
                {
                    model.CustomerUser = true;
                    model.CustomerName = _customerService.GetCustomerNameById(model.DataSheet.CustomerId);
                }
                model.Customers = _customerService.GetAllCustomers(k => k.Id != model.DataSheet.CustomerId);
                model.Customers.Add(_customerService.GetById(model.DataSheet.CustomerId));
                model.Files = _fileService.GetFilesByDataSheetCustomer(Id);
            }
            else
            {
                var user = _userService.GetById(Convert.ToInt32(UserIdentityInfo.Id));
                if (user.CustomerId == null)
                {
                    model.Customers = _customerService.GetAllCustomers();
                    model.DataSheet = new DataSheet
                    {
                        Id      = 0,
                        Contact = "",
                        Status  = 0
                    };
                }
                else
                {
                    return(RedirectToAction("DataSheetList", "DataSheet"));
                    //model.CustomerUser = true;
                    //var customer = _customerService.GetById((int)user.CustomerId);
                    //model.DataSheet = new DataSheet
                    //{
                    //    Id = 0,
                    //    CustomerId = customer.Id,
                    //    Contact = user.FirstName + " " + user.LastName,
                    //    EmailAddress = customer.EmailAddress,
                    //    TelephoneNumber = customer.TelephoneNumber,
                    //    FaxNumber = customer.FaxNumber,
                    //    Status = 0
                    //};
                    //model.CustomerName = customer.DisplayName;
                }
            }
            return(View(model));
        }
Ejemplo n.º 3
0
        public ActionResult DataSheet(int month, int year, HttpPostedFileBase file)
        {
            var viewModel = new DataSheetViewModel
            {
                Year    = year,
                Month   = month,
                Years   = MonthYearHelper.GetYearList(),
                Months  = MonthYearHelper.GetMonthList(),
                HasTags = true
            };

            if (file != null && file.ContentLength > 0)
            {
                if (file.FileName.EndsWith(".csv"))
                {
                    using (var stream = file.InputStream)
                    {
                        using (var csvTable = new DataTable())
                        {
                            using (var reader = new CsvReader(new StreamReader(stream), true))
                            {
                                csvTable.Load(reader);

                                if (!csvTable.IsHeaderValid(Common.Constants.Constants.DATASHEET_HEADERS))
                                {
                                    ModelState.AddModelError("", String.Format("Uploaded file does not contain all the required headers: {0}", String.Join(",", Common.Constants.Constants.DATASHEET_HEADERS)));
                                    return(View(viewModel));
                                }

                                try
                                {
                                    _dataSheetService.UploadDataSheet(month, year, csvTable);
                                }
                                catch (Exception ex)
                                {
                                    ModelState.AddModelError("", ex.Message);
                                }
                            }
                        }
                    }
                }
                else
                {
                    ModelState.AddModelError("", "Invalid file format. Please select only .csv file");
                }
            }

            //TempData["Message"] = "Datasheet has been successfully uploaded";
            return(View(viewModel));
        }
Ejemplo n.º 4
0
        public ActionResult DataSheet(int?month = null, int?year = null)
        {
            var now     = DateTime.Now;
            var y       = year ?? now.Year;
            var m       = month ?? now.Month;
            var hasTags = _tagService.HasTags(y, m);

            var viewModel = new DataSheetViewModel
            {
                Year    = y,
                Month   = m,
                HasTags = hasTags,
                Years   = MonthYearHelper.GetYearList(),
                Months  = MonthYearHelper.GetMonthList()
            };

            return(View(viewModel));
        }