public void Process(string file)
{
const string conStr = @"server=localhost;user id=tns;persistsecurityinfo=True;database=adsurvey2;password=ad2016;";
//const string conStr = @"server=localhost;user id=root;persistsecurityinfo=True;database=adsurvey2;password=morningM00n;";
using (var con = new MySqlConnection(conStr))
{
con.Open();
var tr = con.BeginTransaction();
var reader = new ExcelReader(new DbCommander(con), ExcelConfiguration.GetConfiguration());
try
{
reader.Read(file);
tr.Commit();
}
catch (Exception ex)
{
tr.Rollback();
_log.Write(ex.ToString());
}
}
}
public ExcelReader(DbCommander cmd, ExcelConfiguration config)
{
_cmd = cmd;
_config = config;
_step = 6;
}
