public static void InsertImportReseller(ImportReseller newValue)
{
CanonDataContext db = Cdb.Instance;
db.ImportResellers.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 ImportReseller
ImportReseller importReseller = new ImportReseller();
importReseller.IDUser = WebVariables.LoggedUserId;
importReseller.FileName = _OriginalFilename;
importReseller.DateImported = DateTime.Now;
importReseller.Succeeded = true;
CanonImportReseller.InsertImportReseller(importReseller);
// import resellers
foreach (T record in list)
{
try
{
record.ImportReseller = importReseller;
record.InsertImportResellerRecord();
}
catch (Exception ex)
{
//add message about error
ErrorMessages.Add(new ImportErrorMessage("GeneralRecordImportError",
new string[] { "Reseler", record.FileAs }));
//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 InsertImportReseller(ImportReseller newValue)
{
CanonDataContext db = Cdb.Instance;
db.ImportResellers.InsertOnSubmit(newValue);
db.SubmitChanges();
}
