public ActionResult Index()
{
var mgr = new SmartsheetManager(Db);
List <string> data = mgr.GetSheetNames();
return(View(data));
}
public ActionResult Import(string sheetName)
{
var mgr = new SmartsheetManager(Db);
int count = 0;
try
{
mgr.LoadSheetMaps();
var campaigns = mgr.Read(sheetName);
foreach (var campaign in campaigns)
{
try
{
Db.Campaigns.Add(campaign);
Db.SaveChanges();
// Create Testing Record
// Create Segment A Record
// Process and Upload Data Files
// Update Data File URL to Smartsheet
bool isUpdated = mgr.Update(sheetName, campaign.Price, campaign.OrderNumber);
if (isUpdated)
{
count++;
}
}
catch (Exception ex)
{
// Pi Ja
}
}
return(Json(new JsonResponse()
{
IsSucess = true, Result = $"Smartsheet ({sheetName}) - {count} orders has been imported to NXS sucessfully."
}, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(new JsonResponse()
{
IsSucess = false, ErrorMessage = ex.Message
}, JsonRequestBehavior.AllowGet));
}
}
