public virtual BangoCommand GetGridFilterItemsCommand(DbConnect con, DynamicDictionary data_param, int page = -1, int pageSize = 20, string sort_by = null, bool count = false)
{
sort_by = sort_by == null ? string.Empty : sort_by;
ComboFieldsAttribute comboAttrib = _model.GetComoFields();
if (sort_by.Trim().Length == 0 && comboAttrib.OrderBy.Length > 0)
{
sort_by = DbServiceUtility.SetColumnAlias(TableDetail.Alias, comboAttrib.OrderBy);
}
BangoCommand cmd = GetGridFilterItemsCommandTemplate(comboAttrib.ToString(), count, TableDetail.Alias);
cmd = GetSearchCommand(SearchScenario.GridFilter, con, cmd, data_param, comboAttrib.ToString()
, sort_by, page, pageSize, count, TableDetail.Alias);
//adding the query clause
string or_query = string.Empty;
Dapper.DynamicParameters param = new Dapper.DynamicParameters();
if (data_param.ContainsKey("q") || data_param.ContainsKey("query"))
{
string query = data_param.GetValueAsString("q");
if (query.Trim().Length == 0)
{
query = data_param.GetValueAsString("query");
}
AppendQueryAsOr(cmd, query, new string[] { "code", "name_np", "name_en" });
}
return(cmd);
}
public override BangoCommand GetComboItemsCommand(DbConnect con, DynamicDictionary data_param, int page = -1, int pageSize = 20, string sort_by = null, bool count = false)
{
sort_by = sort_by == null ? string.Empty : sort_by;
ComboFieldsAttribute comboAttrib = _model.GetComoFields();
if (sort_by.Trim().Length == 0 && comboAttrib.OrderBy.Length > 0)
{
sort_by = DbServiceUtility.SetColumnAlias(TableDetail.Alias, comboAttrib.OrderBy);
}
BangoCommand cmd = GetCombotItemsCommandTemplate(comboAttrib.ToString(), count, TableDetail.Alias);
if (comboAttrib.Status != null || comboAttrib.Status.Length > 0)
{
data_param.Add(comboAttrib.Status, true); //for Combo Status=True mains Active Recors load in ComboBOx
}
cmd = GetSearchCommand(SearchScenario.Combo, con, cmd, data_param, comboAttrib.ToString()
, sort_by, page, pageSize, count, TableDetail.Alias);
//adding the query clause
string or_query = string.Empty;
Dapper.DynamicParameters param = new Dapper.DynamicParameters();
return(cmd);
}
public virtual ComboFieldsAttribute GetComoFields()
{
Type typ = this.GetType();
if (_comboFields != null)
{
return(_comboFields);
}
_comboFields = typ.GetCustomAttribute <ComboFieldsAttribute>();
if (_comboFields == null)
{
_comboFields = new ComboFieldsAttribute();
}
if (_comboFields.Id.Trim().Length == 0)
{
_comboFields.Id = GetKeyPropertyName();
}
if (_comboFields.Code.Trim().Length == 0)
{
if (typ.GetProperty("code") == null)
{
_comboFields.Code = _comboFields.Id;
}
else
{
_comboFields.Code = "code";
}
}
if (_comboFields.Name.Trim().Length == 0)
{
if (typ.GetProperty("name") == null)
{
_comboFields.Name = _comboFields.Id;
}
else
{
_comboFields.Name = "name" + SessionData.language;
}
}
if (_comboFields.Text.Trim().Length == 0)
{
_comboFields.Text = string.Format("concat_ws(' - ' , {0}, {1}) as text", _comboFields.Code, _comboFields.Name);
}
if (_comboFields.OrderBy.Trim().Length == 0)
{
_comboFields.OrderBy = _comboFields.Code;
}
return(_comboFields);
}
public virtual BangoCommand GetComboItemsCommand(DbConnect con, DynamicDictionary data_param, int page = -1, int pageSize = 20, string sort_by = null, bool count = false)
{
sort_by = sort_by == null ? string.Empty : sort_by;
ComboFieldsAttribute comboAttrib = _model.GetComoFields();
if (sort_by.Trim().Length == 0 && comboAttrib.OrderBy.Length > 0)
{
sort_by = DbServiceUtility.SetColumnAlias(TableDetail.Alias, comboAttrib.OrderBy);
}
BangoCommand cmd = GetCombotItemsCommandTemplate(comboAttrib.ToString(), count, TableDetail.Alias);
if (comboAttrib.Status != null || comboAttrib.Status.Length > 0)
{
data_param.Add(comboAttrib.Status, true); //for Combo Status=True mains Active Recors load in ComboBOx
}
cmd = GetSearchCommand(SearchScenario.Combo, con, cmd, data_param, comboAttrib.ToString()
, sort_by, page, pageSize, count, TableDetail.Alias);
//adding the query clause
string or_query = string.Empty;
Dapper.DynamicParameters param = new Dapper.DynamicParameters();
if (data_param.ContainsKey("query"))
{
string query = data_param.GetValueAsString("query");
if (query != null && query.Trim().Length > 0)
{
var q = query;
string[] arr = q.Split('-');
string searchParams = arr[0].ToString().Trim();
//string name = arr[1].ToString();
AppendQueryAsOr(cmd, searchParams, new string[] { "code", "name_np", "name_en" });
}
else
{
AppendQueryAsOr(cmd, query, new string[] { "code", "name_np", "name_en" });
}
//query = data_param.GetValueAsString("query");
}
return(cmd);
}
