protected void btnUpload_Click(object sender, EventArgs e)
{
var extension = Path.GetExtension(fuData.FileName);
//verify file
var verifyResult = VerifyFile(extension);
if (verifyResult)
{
//get table data
var dt = new DataTable();
using (Stream stream = fuData.PostedFile.InputStream)
dt = ImportExcel(stream, extension, "");
if (dt.Rows.Count == 0)
{
lbMsg.Text = "Data is empty";
}
else
{
using (TransactionScope txnScope = new TransactionScope())
{
_dBHelper.DeleteAllBankCardList();
_dBHelper.InsertFullBankCardList(dt);
txnScope.Complete();
}
lbMsg.Text = "Upload successfully";
BankCardHelper.BankCardList = GeneralUtility.ConvertDataTableToList <BankCard>(_dBHelper.GetBankCardList(0, 0, true));
}
}
}
