protected void btnUpload_Click(object sender, EventArgs e)
{
if (fileUpload.HasFile)
{
if (Path.GetExtension(fileUpload.FileName) == ".xlsx")
{
ExcelPackage package = new ExcelPackage(fileUpload.FileContent);
DataTable dt = package.ToDataTable();
List <shift> toInsert = new List <shift>();
foreach (DataRow row in dt.Rows)
{
shift toAdd = new shift();
toAdd.ShiftName = row["ShiftName"].ToString();
toAdd.From = Convert.ToDateTime(row["Start_time"]);
toAdd.To = Convert.ToDateTime(row["End_time"]);
toAdd.DayName = row["DayOfWeek"].ToString();
toAdd.UserName = row["username"].ToString();
toInsert.Add(toAdd);
}
ShiftController.InsertShifts(toInsert);
bindGrid();
}
}
}