public ActionResult Upload(HttpPostedFileBase file)
{
using (var package = new ExcelPackage(file.InputStream))
{
var workSheet = package.Workbook.Worksheets.First();
var noOfCol = workSheet.Dimension.End.Column;
var noOfRow = workSheet.Dimension.End.Row;
if (noOfCol != 4)
{
ModelState.AddModelError(nameof(file), "Invalid file");
return(View());
}
for (int rowIterator = 2; rowIterator <= noOfRow; rowIterator++)
{
var ecnumber = workSheet.Cells[rowIterator, 1].Text;
var fname = workSheet.Cells[rowIterator, 2].Text;
var lastmane = workSheet.Cells[rowIterator, 3].Text;
var nationalid = workSheet.Cells[rowIterator, 4].Text;
var officer = new ExtensionOfficer
{
ECNumber = ecnumber,
Firstname = fname,
Surname = lastmane,
CreationDate = DateTime.UtcNow,
NationalID = nationalid,
ID = Guid.NewGuid(),
};
DB.ExtensionOfficers.Add(officer);
}
}
DB.SaveChanges();
return(RedirectToAction(nameof(Index)));
}
public ActionResult Add(ExtensionOfficer officer)
{
officer.CreationDate = DateTime.UtcNow;
officer.ID = Guid.NewGuid();
DB.ExtensionOfficers.Add(officer);
DB.SaveChanges();
return(RedirectToAction(nameof(Details), new { officer.ID }));
}
protected override void OnResume()
{
base.OnResume();
var oficer = ExtensionOfficer.DB.Rows.FirstOrDefault();
if (oficer != null)
{
CurMember = oficer;
LoadMember();
ExtensionOfficer.DB.Truncate();
}
}
async void LoadMember()
{
CurMember = await ExtensionOfficer.DB.RowsAsync.FirstOrDefaultAsync();
TextECnumber.Text = CurMember.ECNumber;
TextNationalID.Text = CurMember.NationalID;
TextFirstName.Text = CurMember.Firstname;
TextLastName.Text = CurMember.Surname;
TextMobile.Text = CurMember.Mobile;
TextEmail.Text = CurMember.Email;
TextProvince.Text = CurMember.Province;
TextDistrict.Text = CurMember.District;
TextDateOfBirth.Text = CurMember.DateOfBirth?.ToString("dd-MMM-yyy");
SpinnerGender.SetSelection(CurMember.GenderID ?? 1);
DOB = CurMember.DateOfBirth;
}