public ActionResult ImportPriceList(FormCollection formCollection)
{
if (Request != null)
{
DataTable dt = new DataTable();
HttpPostedFileBase file = Request.Files["UploadedFile"];
if ((file != null) && (file.ContentLength > 0) && !string.IsNullOrEmpty(file.FileName))
{
string fileName = file.FileName;
string path = Server.MapPath(System.Configuration.ConfigurationManager.AppSettings["XlsFilePath"] + fileName);
file.SaveAs(path);
if (!System.IO.Directory.Exists(Server.MapPath(System.Configuration.ConfigurationManager.AppSettings["XlsFilePath"])))
{
System.IO.Directory.CreateDirectory(Server.MapPath(System.Configuration.ConfigurationManager.AppSettings["XlsFilePath"]));
}
var excelData = new ViewModel.MicrosoftPriceList.ImportPriceList(path);
var sData = excelData.getData("USD");
List <ExcelPriceList> list = new List <ExcelPriceList>();
dt = sData.CopyToDataTable();
ViewModel.MicrosoftPriceList.PriceList priceList = new ViewModel.MicrosoftPriceList.PriceList();
list = excelData.ImportPrice(dt);
ViewBag.MicrosoftPriceList = list;
TempData["MicrosoftPriceList"] = list;
}
}
return(View("ImportPriceList"));
}
public ActionResult SaveMicrosoftPrice()
{
List <ExcelPriceList> _m = TempData["MicrosoftPriceList"] as List <ExcelPriceList>;
ViewModel.MicrosoftPriceList.PriceList pl = new ViewModel.MicrosoftPriceList.PriceList();
pl.SavePriceList(_m);
return(View("MicrosoftPriceList", _m));
}
public JsonResult GetMicrosoftOffersPrice(string Id)
{
ViewModel.MicrosoftPriceList.PriceList _mopl = new ViewModel.MicrosoftPriceList.PriceList();
return(Json(_mopl.GetPriceById(Id), JsonRequestBehavior.AllowGet));
}
