public ActionResult <CapacityProvider> Create(CapacityProvider item)
{
_context.CapacityProviders.Add(item);
_context.SaveChanges();
return(CreatedAtRoute("GetCapacityProvider", new { id = item.id }, item));
}
public IActionResult Update(int id, CapacityProvider item)
{
if (item == null || item.id != id)
{
return(BadRequest());
}
var CapacityProvider = _context.CapacityProviders.Find(id);
if (CapacityProvider == null)
{
return(NotFound());
}
CapacityProvider.name = item.name;
CapacityProvider.city = item.city;
_context.CapacityProviders.Update(CapacityProvider);
_context.SaveChanges();
return(NoContent());
}
public bool ParseData()
{
var assembly = Assembly.GetExecutingAssembly();
string resourceName = assembly.GetManifestResourceNames().Single(str => str.EndsWith("CS-03450-2019.xlsx"));
using (Stream stream = assembly.GetManifestResourceStream(resourceName))
{
using (var package = new ExcelPackage(stream))
{
var worksheet = package.Workbook.Worksheets[1];
try
{
// Parse names
for (int row = 3; row <= 7; row++)
{
int id = Convert.ToInt32(worksheet.Cells[$"K{row}"].Value.ToString());
string name = worksheet.Cells[$"L{row}"].Value?.ToString();
string city = worksheet.Cells[$"M{row}"].Value?.ToString();
string phone = worksheet.Cells[$"N{row}"].Value?.ToString();
string email = worksheet.Cells[$"O{row}"].Value?.ToString();
string contract_number = worksheet.Cells[$"P{row}"].Value?.ToString();
var cap = new CapacityProvider()
{
id = id,
name = name,
city = city,
phone = phone,
email = email,
contract_number = contract_number
};
_context.CapacityProviders.Add(cap);
_context.SaveChanges();
}
// Parse bookings
for (int row = 3; row <= 15; row++)
{
int id = Convert.ToInt32(worksheet.Cells[$"A{row}"].Value.ToString());
string object_name = worksheet.Cells[$"B{row}"].Value?.ToString();
int CapacityProviderId = Convert.ToInt32(worksheet.Cells[$"C{row}"].Value?.ToString());
DateTime date_from = Convert.ToDateTime(worksheet.Cells[$"D{row}"].Value?.ToString());
DateTime date_to = Convert.ToDateTime(worksheet.Cells[$"E{row}"].Value?.ToString());
bool is_active = Convert.ToBoolean(worksheet.Cells[$"F{row}"].Value?.ToString());
float amount = float.Parse(worksheet.Cells[$"G{row}"].Value?.ToString(), CultureInfo.InvariantCulture);
string currency = worksheet.Cells[$"H{row}"].Value?.ToString();
string comment = worksheet.Cells[$"I{row}"].Value?.ToString();
var booking = new Booking()
{
id = id,
object_name = object_name,
CapacityProviderId = CapacityProviderId,
date_from = date_from,
date_to = date_to,
is_active = is_active,
amount = amount,
currency = currency,
comment = comment
};
_context.Bookings.Add(booking);
_context.SaveChanges();
}
}
catch (Exception ex)
{
return(false);
}
}
}
return(true);
}
