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()); }