public Boolean UpdateTCMapping(List <tcmapping> TCMList, tcmapping tc)
{
Boolean status = true;
string utString = "";
try
{
string updateSQL = "Delete from TCMapping where DocumentID = '" + tc.DocumentID + "'";
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("delete", "TCMapping", "", updateSQL) +
Main.QueryDelimiter;
foreach (tcmapping tcm in TCMList)
{
updateSQL = "insert into TCMapping " +
"(DocumentID,ReferenceTC) " +
"values ('" + tcm.DocumentID + "'," + "" + tcm.ReferenceTC + ")";
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("insert", "TCMapping", "", updateSQL) +
Main.QueryDelimiter;
}
if (!UpdateTable.UT(utString))
{
status = false;
}
}
catch (Exception ex)
{
status = false;
}
return(status);
}
public List <tcmapping> getTCMappingList(string docID)
{
tcmapping tcmapping;
List <tcmapping> TCMList = new List <tcmapping>();
try
{
string query = "select RowID, DocumentID, ReferenceTC " +
" from TCMapping where DocumentID = '" + docID + "'";
SqlConnection conn = new SqlConnection(Login.connString);
SqlCommand cmd = new SqlCommand(query, conn);
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
tcmapping = new tcmapping();
tcmapping.RowID = reader.GetInt32(0);
tcmapping.DocumentID = reader.GetString(1);
tcmapping.ReferenceTC = reader.GetInt32(2);
TCMList.Add(tcmapping);
}
conn.Close();
}
catch (Exception ex)
{
MessageBox.Show("Error querying Terms and Conditions Mapping Details");
}
return(TCMList);
}
