public void ImportInfoPosisInfo()
{
string tableName = "POSISINFO";
using (DataTable impTable = GetData("DemoData." + tableName))
{
foreach (DataRow row in impTable.Select())
{
SqlInsert sqlInsert = new SqlInsert(tableName);
if (row["ID"] != DBNull.Value)
{
sqlInsert.Add("ID", Convert.ToString(row["ID"]));
}
if (row["TEXT"] != DBNull.Value)
{
sqlInsert.Add("TEXT", Convert.ToString(row["TEXT"]));
}
dbUtil.Execute(sqlInsert);
}
}
RaiseTableImported(tableName);
}
private void ImportIntoPosisErrors()
{
string tableName = "RETAILERRORS";
using (DataTable impTable = GetData("DemoData." + tableName))
{
foreach (DataRow row in impTable.Select())
{
SqlInsert sqlInsert = new SqlInsert(tableName);
if (row["ERRORID"] != DBNull.Value)
{
sqlInsert.Add("ERRORID", Convert.ToInt32(row["ERRORID"]));
}
if (row["ERRORMESSAGEID"] != DBNull.Value)
{
sqlInsert.Add("ERRORMESSAGEID", Convert.ToInt32(row["ERRORMESSAGEID"]));
}
if (row["DESCRIPTION"] != DBNull.Value)
{
sqlInsert.Add("DESCRIPTION", Convert.ToString(row["DESCRIPTION"]));
}
if (row["CODEUNIT"] != DBNull.Value)
{
sqlInsert.Add("CODEUNIT", Convert.ToString(row["CODEUNIT"]));
}
if (row["ACTIVE"] != DBNull.Value)
{
sqlInsert.Add("ACTIVE", Convert.ToInt32(row["ACTIVE"]));
}
if (row["FIRSTINVERSION"] != DBNull.Value)
{
sqlInsert.Add("FIRSTINVERSION", Convert.ToString(row["FIRSTINVERSION"]));
}
if (row["DATECREATED"] != DBNull.Value)
{
sqlInsert.Add("DATECREATED", Convert.ToDateTime(row["DATECREATED"]));
}
dbUtil.Execute(sqlInsert);
}
}
RaiseTableImported(tableName);
}
