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