public string UPDATEQuery(Hashtable pHT)
{
StringBuilder vUpdateQuery = new StringBuilder();
vUpdateQuery = CRUDHelper.BuildUPDATEQuery(pHT, null);
return(vUpdateQuery.ToString());
}
public string UPDATEQuery(object pModel, ArrayList pExcludeList)
{
//Taking the model object in hashtable
Hashtable vHT = CRUDHelper.GetColumnValueCol(pModel);
StringBuilder vUpdateQuery = new StringBuilder();
vUpdateQuery = CRUDHelper.BuildUPDATEQuery(vHT, pExcludeList);
return(vUpdateQuery.ToString());
}
public string UPDATEQuery(Hashtable pHT, Hashtable pFilteredColumns)
{
StringBuilder vUpdateQuery = new StringBuilder();
vUpdateQuery = CRUDHelper.BuildUPDATEQuery(pHT, null);
//Adding additional filter
foreach (DictionaryEntry de in pFilteredColumns)
{
vUpdateQuery.Append(" AND ");
vUpdateQuery.Append(de.Key.ToString());
vUpdateQuery.Append(" = ");
vUpdateQuery.Append(CRUDHelper.GetFormatedColumnValue(de.Value));
}
return(vUpdateQuery.ToString());
}
public string UPDATEQuery(object pModel, Hashtable pFilteredColumns, ArrayList pExcludeList)
{
//Taking the model object in hashtable
Hashtable vHT = CRUDHelper.GetColumnValueCol(pModel);
StringBuilder vUpdateQuery = new StringBuilder();
vUpdateQuery = CRUDHelper.BuildUPDATEQuery(vHT, pExcludeList);
//Adding additional filter
foreach (DictionaryEntry de in pFilteredColumns)
{
vUpdateQuery.Append(" AND ");
vUpdateQuery.Append(de.Key.ToString());
vUpdateQuery.Append(" = ");
vUpdateQuery.Append(CRUDHelper.GetFormatedColumnValue(de.Value));
}
return(vUpdateQuery.ToString());
}
