public async Task <JsonResult> AddItem(ItemModel item) { IItemServices itemServices = new ItemServices(); item.ItemName = Regex.Replace(item.ItemName, "[^a-zA-Z0-9]", "", RegexOptions.Compiled); try { if (itemServices.DoesTableExists(item.ItemName)) { await itemServices.DropExistingTable(item.ItemName); } var tableName = await itemServices.CreateItemTable(item); IExcelServices excelServices = new ExcelServices(new MemoryStream(item.ItemContent)); var list = await excelServices.ParseExcelFile(); var ret = await itemServices.WriteLine(list, item.ItemName); return(new JsonResult { Data = ret, JsonRequestBehavior = JsonRequestBehavior.AllowGet }); } catch (Exception ex) { throw ex; } }