public string DELETEQuery(object pModel, bool pMarkDEL, Hashtable pMarkDELColNameValues)
{
Hashtable vHT = CRUDHelper.GetColumnValueCol(pModel);
StringBuilder vDeleteQuery = new StringBuilder();
vDeleteQuery = CRUDHelper.BuildDELETEQuery(vHT, pMarkDEL, pMarkDELColNameValues);
return(vDeleteQuery.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 READQuery(object pModel, bool pAll)
{
//Start to create the query
StringBuilder vReadQuery = new StringBuilder("SELECT ");
Hashtable vHT = CRUDHelper.GetColumnValueCol(pModel);
vReadQuery = CRUDHelper.BuildREADQuery(vHT, vReadQuery, pAll);
return(vReadQuery.ToString());
}
public string READQuery(object pModel, Hashtable pFilteredColumns)
{
//Start to create the query
StringBuilder vReadQuery = new StringBuilder("SELECT ");
Hashtable vHT = CRUDHelper.GetColumnValueCol(pModel);
//Build the READ query with PK
vReadQuery = CRUDHelper.BuildREADQuery(vHT, vReadQuery, false);
//Adding additional filter
foreach (DictionaryEntry de in pFilteredColumns)
{
vReadQuery.Append(" AND ");
vReadQuery.Append(de.Key.ToString());
vReadQuery.Append(" = ");
vReadQuery.Append(CRUDHelper.GetFormatedColumnValue(de.Value));
}
return(vReadQuery.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());
}
public string READQuery(object pModel, bool pAll, bool pOrderBy, string[] pOrderColumns, bool pASC)
{
//Start to create the query
StringBuilder vReadQuery = new StringBuilder("SELECT ");
Hashtable vHT = CRUDHelper.GetColumnValueCol(pModel);
vReadQuery = CRUDHelper.BuildREADQuery(vHT, vReadQuery, pAll);
if (pOrderBy)//Adding Order By
{
vReadQuery.Append(CRUDHelper.CreateOrderBy(pOrderColumns));
if (pASC)
{
vReadQuery.Append(" ASC ");
}
else
{
vReadQuery.Append(" DESC ");
}
}
return(vReadQuery.ToString());
}
public string CREATEQuery(object pModel)
{
Hashtable vHT = CRUDHelper.GetColumnValueCol(pModel);
return(CRUDHelper.BuildCREATEQuery(vHT, null).ToString());
}
public string CREATEQuery(object pModel, ArrayList pExcludeList)
{
Hashtable vHT = CRUDHelper.GetColumnValueCol(pModel);
return(CRUDHelper.BuildCREATEQuery(vHT, pExcludeList).ToString());
}
