//delete Record, easy use
public static bool DeleteRecord(string table, Dictionary <string, string> parms)
{
List <MutliQuery> conditions = new List <MutliQuery>();
if (parms != null && !string.IsNullOrEmpty(parms.FirstOrDefault().Key))
{
foreach (var p in parms)
{
MutliQuery model = new MutliQuery(p.Key, null, p.Value);
conditions.Add(model);
}
}
return(DeleteRecord(table, conditions));
}
} //e.g.GetDBSource(QE_USER, QueryBuilder(null, QE_USER, new Dictionary(admin, password), null));
//use for complicated query, easy use
public static string QueryBuilder(string parameter, string table, Dictionary <string, string> parameters, string[] orders)
{
List <MutliQuery> parm = new List <MutliQuery>();
if (parameters != null && !string.IsNullOrEmpty(parameters.FirstOrDefault().Key))
{
foreach (var p in parameters)
{
MutliQuery model = new MutliQuery(p.Key, null, p.Value);
parm.Add(model);
}
}
return(QueryBuilder(parameter, table, parm, orders));
}
//modify a record. quick use
public static bool UpdateRecord(string table, Dictionary <string, string> parms, int id)
{
List <MutliQuery> conditions = new List <MutliQuery>();
List <MutliQuery> keys = new List <MutliQuery>();
if (parms != null && !string.IsNullOrEmpty(parms.FirstOrDefault().Key))
{
foreach (var p in parms)
{
MutliQuery model = new MutliQuery(p.Key, null, p.Value);
conditions.Add(model);
}
}
MutliQuery key = new MutliQuery("ID", null, id.ToString());
keys.Add(key);
return(UpdateRecord(table, conditions, keys));
}
