private Hashtable GetParameters()
{
Hashtable hash = new Hashtable();
string paramPrefix = GetParameterPrefix();
List <string> colList = _baseBO.GetColumnChangeList();
string idCol = _baseBO.GetIdColumn();
switch (_queryType)
{
/*-- Select And SelectWithFilter Parts --*/
case QueryTypes.Select:
case QueryTypes.SelectWithFilter:
case QueryTypes.SelectChangingColumns:
return(null);
/*-- SelectWithFilter Part --*/
case QueryTypes.InsertAndGetId:
case QueryTypes.Insert:
if (colList.IndexOf(idCol) > -1)
{
colList.Remove(idCol);
}
foreach (string col in colList)
{
PropertyInfo propInfo4 = _baseBO.GetType().GetProperty(col);
hash.Add(string.Format("{0}{1}", paramPrefix, col),
propInfo4.GetValue(_baseBO, null));
}
return(hash);
/*-- Update Part --*/
case QueryTypes.Update:
if (colList.IndexOf(idCol) == -1)
{
colList.Add(idCol);
}
foreach (string col in colList)
{
PropertyInfo propInfo1 = _baseBO.GetType().GetProperty(col);
hash.Add(string.Format("{0}{1}", paramPrefix, col),
propInfo1.GetValue(_baseBO, null));
}
return(hash);
/*-- Delete And SelectWhere Parts --*/
case QueryTypes.Delete:
case QueryTypes.SelectWhere:
PropertyInfo propInfo3 = _baseBO.GetType().GetProperty(idCol);
hash.Add(string.Format("{0}{1}", paramPrefix, idCol),
propInfo3.GetValue(_baseBO, null));
return(hash);
default:
throw new InvalidOperationException("Invalid Query Type");
}
}
internal static string GetColumns(IBaseBO bo, IQueryAdds adds, QueryTypes query_type, ConnectionTypes conn_type)
{
string cols = string.Empty;
try
{
List <string> colList = bo.GetColumnChangeList();
if (query_type == QueryTypes.Insert ||
query_type == QueryTypes.InsertAndGetId ||
query_type == QueryTypes.Update)
{
string id_col = bo.GetIdColumn();
colList.Remove(id_col);
}
if (query_type == QueryTypes.Insert || query_type == QueryTypes.InsertAndGetId ||
query_type == QueryTypes.InsertAnyChange || query_type == QueryTypes.SelectChangeColumns)
{
foreach (var col in colList)
{
cols = string.Concat(cols, ", ", col);
}
cols = cols.TrimStart(',').TrimStart();
// RETURN
return(cols);
}
if (query_type == QueryTypes.Update)
{
if (conn_type == ConnectionTypes.Odbc)
// || conn_type == ConnectionTypes.External)
{
foreach (var col in colList)
{
cols = string.Concat(cols, ", ", col, "=", adds.ParameterPrefix);
}
}
else
{
foreach (var col in colList)
{
cols = string.Concat(cols, ", ", col, "=", adds.ParameterPrefix, col);
}
}
cols = cols.TrimStart(',').TrimStart();
// RETURN
return(cols);
}
}
catch (Exception e)
{
throw;
}
return(cols);
}
/// <summary>
/// Create a QueryBuilder with given object and querytype and connetiontypes.
/// </summary>
/// <param name="ConnType">Connetion Types of Query Builder.</param>
/// <param name="queryType">Query Types of Query Builder.</param>
/// <param name="queryObject">An object inherits IBaseBO interface.</param>
public QueryBuilder(ConnectionTypes ConnType, QueryTypes queryType,
IBaseBO queryObject)
{
_baseBO = queryObject;
_queryType = queryType;
_ConnType = ConnType;
isNotEmptyChangeList = _baseBO.GetColumnChangeList().Count > 0;
_queryString = GetQueryString();
_parameters = GetParameters();
}
internal List <DbParameter> GetParameters(IBaseBO bo, IQueryAdds adds, QueryTypes query_type)
{
List <DbParameter> parameters = null;
DbParameter prm;
try
{
if (query_type != QueryTypes.Select ||
query_type != QueryTypes.SelectChangeColumns)
{
List <string> colList = bo.GetColumnChangeList();
string id_col;
PropertyInfo propInfo;
Type t = bo.GetType();
id_col = bo.GetIdColumn();
object val;
// IF BLOCK 1
if (query_type == QueryTypes.Delete || query_type == QueryTypes.SelectWhereId)
{
if (string.IsNullOrWhiteSpace(id_col))
{
throw new Exception("Id Column can not be empty or whit space.");
}
propInfo = t.GetProperty(id_col);
if (propInfo == null)
{
throw new Exception("Id Column Property has been specified as wrong. Please define right.");
}
val = propInfo.GetValue(bo, null);
if (val == null)
{
throw new Exception(string.Format("Id Column({0}) Value must be specified.", id_col));
}
parameters = new List <DbParameter>();
prm = this.CreateParameter();
prm.ParameterName = string.Format("{0}{1}", adds.ParameterPrefix, id_col);
prm.Value = val;
parameters.Add(prm);
return(parameters);
}
// IF BLOCK 2
if (query_type == QueryTypes.Insert || query_type == QueryTypes.InsertAndGetId)
{
colList.Remove(id_col);
}
parameters = new List <DbParameter>();
foreach (var col in colList)
{
propInfo = null;
propInfo = t.GetProperty(col);
if (propInfo == null)
{
throw new Exception(
string.Format("{0} Column Property has been specified as wrong. Please define right.", col));
}
val = propInfo.GetValue(bo, null);
prm = this.CreateParameter();
prm.ParameterName = string.Format("{0}{1}", adds.ParameterPrefix, col);
prm.Value = val;
parameters.Add(prm);
}
//RETURN
return(parameters);
}
}
catch (Exception e)
{
throw;
}
//RETURN
return(parameters);
}
internal string GetVals(IBaseBO bo, IQueryAdds adds, QueryTypes query_type, ConnectionTypes conn_type)
{
string vals = string.Empty;
try
{
List <string> colList = bo.GetColumnChangeList();
string id_col = string.Empty;
//IF BLOCK 1
if (query_type == QueryTypes.Insert || query_type == QueryTypes.InsertAndGetId ||
query_type == QueryTypes.InsertAnyChange)
{
if (query_type != QueryTypes.InsertAnyChange)
{
id_col = bo.GetIdColumn();
colList.Remove(id_col);
}
if (conn_type == ConnectionTypes.Odbc)
// || conn_type == ConnectionTypes.External)
{
foreach (var col in colList)
{
vals = string.Concat(vals, ", ", adds.ParameterPrefix);
}
}
else
{
foreach (var col in colList)
{
vals = string.Concat(vals, ", ", adds.ParameterPrefix, col);
}
}
vals = vals.TrimStart(',').TrimStart();
//RETURN
return(vals);
}
//IF BLOCK 2
if (query_type == QueryTypes.Delete || query_type == QueryTypes.SelectWhereId ||
query_type == QueryTypes.Update)
{
id_col = bo.GetIdColumn();
if (conn_type == ConnectionTypes.Odbc)
// || conn_type == ConnectionTypes.External)
{
vals = string.Format("{0}={1}", id_col, adds.ParameterPrefix);
}
else
{
vals = string.Format("{0}={1}{0}", id_col, adds.ParameterPrefix);
}
//RETURN
return(vals);
}
//IF BLOCK 3
if (query_type == QueryTypes.SelectWhereChangeColumns)
{
if (conn_type == ConnectionTypes.Odbc)
// || conn_type == ConnectionTypes.External)
{
foreach (var col in colList)
{
vals = string.Concat(vals, "AND ", col, "=", adds.ParameterPrefix);
}
}
else
{
foreach (var col in colList)
{
vals = string.Concat(vals, "AND ", col, "=", adds.ParameterPrefix, col);
}
}
if (vals.Length > 4)
{
vals = vals.Substring(4, vals.Length - 4);
}
//RETURN
return(vals);
}
}
catch (Exception e)
{
throw;
}
//RETURN
return(vals);
}
internal static Hashmap GetParameters(IBaseBO bo, IQueryAdds adds, QueryTypes query_type)
{
Hashmap h = null;
try
{
if (query_type != QueryTypes.Select || query_type != QueryTypes.SelectChangeColumns)
{
h = new Hashmap();
List <string> colList = bo.GetColumnChangeList();
string id_col;
PropertyInfo propInfo;
Type t = bo.GetType();
id_col = bo.GetIdColumn();
object val;
// IF BLOCK 1
if (query_type == QueryTypes.Delete || query_type == QueryTypes.SelectWhereId)
{
if (string.IsNullOrWhiteSpace(id_col))
{
throw new Exception("Id Column can not be empty or whit space.");
}
propInfo = t.GetProperty(id_col);
if (propInfo == null)
{
throw new Exception("Id Column Property has been specified as wrong. Please define right.");
}
val = propInfo.GetValue(bo, null);
if (val == null)
{
throw new Exception(string.Format("Id Column({0}) Value must be specified.", id_col));
}
h.Set(string.Format("{0}{1}", adds.ParameterPrefix, id_col), val);
//RETURN
return(h);
}
// IF BLOCK 2
if (query_type == QueryTypes.Insert || query_type == QueryTypes.InsertAndGetId)
{
colList.Remove(id_col);
}
foreach (var col in colList)
{
propInfo = null;
propInfo = t.GetProperty(col);
if (propInfo == null)
{
throw new Exception(string.Format("{0} Column Property has been specified as wrong. Please define right.", col));
}
val = propInfo.GetValue(bo, null);
h.Set(string.Format("{0}{1}", adds.ParameterPrefix, col), val);
}
//RETURN
return(h);
}
}
catch (Exception)
{
throw;
}
//RETURN
return(h);
}