public static void InsertImportPriceList(ImportPriceList newValue) { CanonDataContext db = Cdb.Instance; db.ImportPriceLists.InsertOnSubmit(newValue); db.SubmitChanges(); }
public bool ExportToDb() { ErrorMessages.Clear(); try { bool IsSucceeded = false; List <T> list = this.ImportFile(ref IsSucceeded); if (IsSucceeded == false) { return(false); } CanonDataContext db = Cdb.Instance; // Create ImportPriceList ImportPriceList priceList = new ImportPriceList(); priceList.IDUser = WebVariables.LoggedUserId; priceList.FileName = _OriginalFilename; priceList.DateImported = DateTime.Now; priceList.ErrorMessage = string.Empty; priceList.Succeeded = true; CanonImportPriceList.InsertImportPriceList(priceList); // import products foreach (T productPrice in list) { try { productPrice.ImportPriceList = priceList; productPrice.InsertImportPriceListRecord(db); } catch (Exception ex) { //add message about error ErrorMessages.Add(new ImportErrorMessage("GeneralRecordImportError", new string[] { "Produkt", productPrice.ProductName })); //into log WebVariables.Logger.Error(string.Format("File {0}, general import error", _filename), ex); } } } catch (Exception ex) { ErrorMessages.Add(new ImportErrorMessage("GeneralFileImportError")); //into log WebVariables.Logger.Error(string.Format("File {0} ", _filename), ex); return(false); } return(true); }
public static void InsertImportPriceList(ImportPriceList newValue) { CanonDataContext db = Cdb.Instance; db.ImportPriceLists.InsertOnSubmit(newValue); db.SubmitChanges(); }