/// <summary>
/// Insert data in Version table against multikey Master table
/// </summary>
/// <param name="baseTbl"></param>
/// <param name="keyCols"></param>
/// <param name="tblVer"></param>
/// <returns></returns>
private string InsertMKVersionData(MTable baseTbl, string[] keyCols, MTable tblVer)
{
string retMsg = "";
// Get data from Master table
DataSet dsRecs = DB.ExecuteDataset("SELECT * FROM " + baseTbl.GetTableName(), null, _trx);
// check if there are any records in master table
if (dsRecs != null && dsRecs.Tables[0].Rows.Count > 0)
{
// loop through all records and insert in Version table
for (int i = 0; i < dsRecs.Tables[0].Rows.Count; i++)
{
// get where Clause for Master table against multiple key columns
GetMKWhereClause(dsRecs.Tables[0].Rows[i], keyCols);
if (MKWhereClause.Length > 0)
{
int count = Util.GetValueOfInt(DB.ExecuteScalar("SELECT COUNT(" + tblVer.GetTableName() + "_ID) FROM " + tblVer.GetTableName() + " WHERE " + MKWhereClause.ToString(), null, _trx));
if (count > 0)
{
continue;
}
}
// create PO object of source table (Master table)
PO sPO = baseTbl.GetPO(GetCtx(), dsRecs.Tables[0].Rows[i], _trx);
// create PO object of destination table (Version table)
PO dPO = tblVer.GetPO(GetCtx(), 0, _trx);
sPO.CopyTo(dPO);
dPO.SetAD_Client_ID(sPO.GetAD_Client_ID());
dPO.SetAD_Org_ID(sPO.GetAD_Org_ID());
dPO.Set_Value("RecordVersion", "1");
dPO.Set_ValueNoCheck("VersionValidFrom", sPO.Get_Value("Created"));
dPO.Set_ValueNoCheck("IsVersionApproved", true);
dPO.Set_ValueNoCheck("Processed", true);
dPO.Set_ValueNoCheck("ProcessedVersion", true);
for (int j = 0; j < keyCols.Length; j++)
{
dPO.Set_ValueNoCheck(keyCols[j], sPO.Get_Value(keyCols[j]));
}
dPO.Set_Value("Export_ID", null);
if (!dPO.Save())
{
ValueNamePair vnp = VLogger.RetrieveError();
string error = "";
if (vnp != null)
{
error = vnp.GetName();
if (error == "" && vnp.GetValue() != null)
{
error = vnp.GetValue();
}
}
if (error == "")
{
error = "Error in saving data in Version table";
}
return(retMsg);
}
}
}
return(retMsg);
}