public JsonResult ImportPartData(string makeID)
{
string Message = "";
bool successFlag = false;
try
{
_uploadHelper = new ExcelUploadHelper();
if (_uploadHelper.InsertPartsExcelRecords(makeID))
{
successFlag = true;
}
else
{
successFlag = false;
}
}
catch (Exception ex)
{
WrapLogException(ex);
ViewBag.ImportPartsStatus = "false";
throw ex;
}
return(new JsonResult {
Data = new { Message = Message, Status = successFlag }
});
}
public ActionResult UploadControlCallbackAction()
{
string[] extension = { ".xls", ".xlsx", ".csv", };
ExcelUploadHelper.setPath(TemplateDirectory + "Target/", UploadDirectory + "Target/");
ExcelUploadHelper.setValidationSettings(extension, 20971520);
UploadControlExtension.GetUploadedFiles("uc", ExcelUploadHelper.ValidationSettings, ExcelUploadHelper.FileUploadComplete);
//UploadControlExtension.GetUploadedFiles("uc", UploadControlHelper.ValidationSettings, UploadControlHelper.FileUploadComplete);
return(null);
}
public ActionResult UploadControlCallbackAction(string configType, int scenarioId)
{
string[] extension = { ".xls", ".xlsx", ".csv", };
var sourcePath = string.Format("{0}{1}/", TemplateDirectory, configType);
var targetPath = string.Format("{0}{1}/", UploadDirectory, configType);
ExcelUploadHelper.setPath(sourcePath, targetPath);
ExcelUploadHelper.setValidationSettings(extension, 20971520);
UploadControlExtension.GetUploadedFiles("uc", ExcelUploadHelper.ValidationSettings, ExcelUploadHelper.FileUploadComplete);
return(null);
}
public ActionResult UploadControlCallbackAction(string configType)
{
string[] extension = { ".xls", ".xlsx", ".csv", };
var sourcePath = string.Format("{0}{1}/", TemplateDirectory, configType);
var targetPath = string.Format("{0}{1}/", UploadDirectory, configType);
ExcelUploadHelper.setPath(sourcePath, targetPath);
ExcelUploadHelper.setValidationSettings(extension, 30000000);
UploadControlExtension.GetUploadedFiles("uc", ExcelUploadHelper.ValidationSettings, ExcelUploadHelper.FileUploadComplete);
return(null);
//switch (configType)
//{
// case "KpiAchievement":
// return PartialView("UploadControlPartial", configType);
// break;
// default:
// break;
//}
}
public JsonResult ImportPartPriceData()
{
int updateCount = 0;
try
{
_uploadHelper = new ExcelUploadHelper();
updateCount = _uploadHelper.UpdatePartsPriceExcelRecords();
}
catch (Exception ex)
{
WrapLogException(ex);
ViewBag.ImportPartPriceStatus = "false";
throw ex;
}
return(new JsonResult {
Data = new { UpdateCount = updateCount }
});
}
