public async Task <IActionResult> Upsert(Models.Territory territory)
{
if (ModelState.IsValid)
{
territory.Title = territory.Title.ToUpper();
territory.FirstName = territory.FirstName.ToUpper();
territory.LastName = territory.LastName.ToUpper();
territory.Street = territory.Street.ToUpper();
territory.Apartment = territory.Apartment.ToUpper();
territory.City = territory.City.ToUpper();
territory.State = territory.State.ToUpper();
if (territory.Id == 0)
{
await _unitOfWork.Territory.AddAsync(territory);
}
else
{
_unitOfWork.Territory.Update(territory);
}
_unitOfWork.Save();
return(RedirectToAction(nameof(Index)));
}
else
{
if (territory.Id != 0)
{
territory = await _unitOfWork.Territory.GetAsync(territory.Id);
}
}
return(View(territory));
}
public async Task <IActionResult> Upsert(int?id)
{
Models.Territory territory = new Models.Territory();
if (id == null)
{
//this is for create
return(View(territory));
}
//this is for edit request
territory = await _unitOfWork.Territory.GetAsync(id.GetValueOrDefault());
if (territory == null)
{
return(NotFound());
}
return(View(territory));
}
private List <Models.Territory> GetTerritoryList(string fileName)
{
List <Models.Territory> territoryList = new List <Models.Territory>();
var fName = $"{Directory.GetCurrentDirectory()}{@"\wwwroot\files"}" + "//" + fileName;
System.Text.Encoding.RegisterProvider(System.Text.CodePagesEncodingProvider.Instance);
using (var stream = System.IO.File.Open(fName, FileMode.Open, FileAccess.Read))
{
using (var reader = ExcelReaderFactory.CreateReader(stream))
{
while (reader.Read())
{
var territory = new Models.Territory();
if (reader.GetValue(0) != null)
{
territory.Title = reader.GetValue(0).ToString();
}
if (reader.GetValue(1) != null)
{
territory.FirstName = reader.GetValue(1).ToString();
}
if (reader.GetValue(2) != null)
{
territory.LastName = reader.GetValue(2).ToString();
}
if (reader.GetValue(3) != null)
{
territory.Street = reader.GetValue(3).ToString();
}
if (reader.GetValue(4) != null)
{
territory.Apartment = reader.GetValue(4).ToString();
}
if (reader.GetValue(5) != null)
{
territory.City = reader.GetValue(5).ToString();
}
if (reader.GetValue(6) != null)
{
territory.State = reader.GetValue(6).ToString();
}
if (reader.GetValue(7) != null)
{
territory.Zipcode = reader.GetValue(7).ToString();
}
if (reader.GetValue(8) != null)
{
territory.PhoneNumber = reader.GetValue(8).ToString();
}
territoryList.Add(territory);
// territoryList.Add(new Models.Territory()
// {
// Title = (string)reader.GetValue(0),
// FirstName = reader.GetValue(1).ToString(),
// LastName = reader.GetValue(2).ToString(),
// Street = reader.GetValue(3).ToString(),
// Apartment = (string)reader.GetValue(4),
// City = reader.GetValue(5).ToString(),
// State = reader.GetValue(6).ToString(),
// Zipcode = reader.GetValue(7).ToString(),
// PhoneNumber = (string)reader.GetValue(8)
// });
}
}
}
return(territoryList);
}
