private DataSourceTable CheckDSTableDesign(DataTable dtTable)
{
string tablename = dtTable.TableName;
DataSourceTable sTableDetail = new DataSourceTable();
sTableDetail.Name = tablename;
int iCount = 0;
int iIdCount = 0;
int iUpdateCount = 0;
foreach (DataColumn column in dtTable.Columns)
{
if (column.ToString() == "GINGER_KEY_NAME" || column.ToString() == "GINGER_KEY_VALUE")
{
iCount++;
}
else if (column.ToString() == "GINGER_ID")
{
iIdCount++;
}
else if (column.ToString() == "GINGER_LAST_UPDATE_DATETIME" || column.ToString() == "GINGER_LAST_UPDATED_BY")
{
iUpdateCount++;
}
}
if (iCount == 2 && dtTable.Columns.Count == 2 + iIdCount + iUpdateCount)
{
sTableDetail.DSTableType = DataSourceTable.eDSTableType.GingerKeyValue;
}
else
{
sTableDetail.DSTableType = DataSourceTable.eDSTableType.Customized;
}
OleDbCommand myCommand = new OleDbCommand();
if (iIdCount == 0)
{
myAccessConn.Close();
Init(mFilePath, "Write");
myCommand.CommandText = "ALTER TABLE " + tablename + " ADD COLUMN [GINGER_ID] AUTOINCREMENT";
myCommand.Connection = myAccessConn;
myCommand.ExecuteNonQuery();
myAccessConn.Close();
Init(mFilePath);
}
sTableDetail.DSC = this;
return(sTableDetail);
}
public override void AddRow(List <string> mColumnNames, DataSourceTable mDSTableDetails)
{
DataRow dr = mDSTableDetails.DataTable.NewRow();
mColumnNames = mDSTableDetails.DSC.GetColumnList(mDSTableDetails.Name);
foreach (string sColName in mColumnNames)
{
if (sColName != "GINGER_ID" && sColName != "GINGER_LAST_UPDATED_BY" && sColName != "GINGER_LAST_UPDATE_DATETIME")
{
dr[sColName] = "";
}
else if (sColName == "GINGER_ID")
{
dr[sColName] = System.DBNull.Value;
}
}
mDSTableDetails.DataTable.Rows.Add(dr);
}
public override void DuplicateRow(List <string> mColumnNames, List <object> SelectedItemsList, DataSourceTable mDSTableDetails)
{
mColumnNames = mDSTableDetails.DSC.GetColumnList(mDSTableDetails.Name);
foreach (object o in SelectedItemsList)
{
DataRow row = (((DataRowView)o).Row);
DataRow dr = mDSTableDetails.DataTable.NewRow();
foreach (string sColName in mColumnNames)
{
if (sColName != "GINGER_ID" && sColName != "GINGER_LAST_UPDATED_BY" && sColName != "GINGER_LAST_UPDATE_DATETIME")
{
dr[sColName] = row[sColName];
}
else
{
dr[sColName] = System.DBNull.Value;
}
}
mDSTableDetails.DataTable.Rows.Add(dr);
}
}
public abstract void DuplicateRow(List <string> mColumnNames, List <object> SelectedItemsList, DataSourceTable mDSTableDetails);
public abstract void AddRow(List <string> mColumnNames, DataSourceTable mDSTableDetails);
