public void AddRange(ExpensesCollection value)
{
for (int i = 0; (i < value.Count); i++)
{
this.Add(value.List[i] as ExpensesInfo);
}
}
public static ExpensesCollection GetExpensesList(List<QueryElement> list)
{
ExpensesCollection coll = new ExpensesCollection();
StringBuilder sb = new StringBuilder();
sb.AppendFormat(" {0} ", "select * from expenses where 1=1");
if (list.Count > 0)
{
MySqlParameter[] pars = new MySqlParameter[list.Count];
for (int i = 0; i < list.Count; i++)
{
QueryElement query = list[i];
if (query.QueryElementType == MySqlDbType.DateTime)
{
sb.AppendFormat("{0} {1} {2} @{3} ", query.QueryLogic, query.Queryname, query.QueryOperation, query.Queryname + i);
pars[i] = new MySqlParameter("@" + query.Queryname + i, query.QueryElementType);
}
else
{
sb.AppendFormat("{0} {1} {2} @{3} ", query.QueryLogic, query.Queryname, query.QueryOperation, query.Queryname);
pars[i] = new MySqlParameter("@" + query.Queryname, query.QueryElementType);
}
if (query.QueryOperation.Equals("like"))
{
pars[i].Value = "%" + query.Queryvalue + "%";
}
else
{
pars[i].Value = query.Queryvalue;
}
}
using (MySqlDataReader reader = MySqlDBHelper.GetReader(sb.ToString(), pars))
{
while (reader.Read())
{
coll.Add(new ExpensesInfo(reader));
}
}
}
else
{
using (MySqlDataReader reader = MySqlDBHelper.GetReader(sb.ToString()))
{
while (reader.Read())
{
coll.Add(new ExpensesInfo(reader));
}
}
}
return coll;
}
public ExpensesCollection Pagination(int pageIndex, int pageSize)
{
if (InnerList.Count == 0)
{
return(null);
}
int start = pageSize * (pageIndex - 1);
int end = start + pageSize - 1;
if (end > InnerList.Count - 1)
{
end = InnerList.Count - 1;
}
ExpensesCollection pages = new ExpensesCollection();
for (int i = start; i <= end; i++)
{
pages.Add(InnerList[i] as ExpensesInfo);
}
return(pages);
}
public ExpensesCollectionEnumerator(ExpensesCollection mappings)
{
enumerator = ((IEnumerable)mappings).GetEnumerator();
}
public ExpensesCollection Pagination(int pageIndex, int pageSize)
{
if (InnerList.Count == 0)
return null;
int start = pageSize * (pageIndex - 1);
int end = start + pageSize - 1;
if (end > InnerList.Count - 1)
end = InnerList.Count - 1;
ExpensesCollection pages = new ExpensesCollection();
for (int i = start; i <= end; i++)
{
pages.Add(InnerList[i] as ExpensesInfo);
}
return pages;
}
public void AddRange(ExpensesCollection value)
{
for (int i = 0; (i < value.Count); i++)
{
this.Add(value.List[i] as ExpensesInfo);
}
}
public ExpensesCollectionEnumerator(ExpensesCollection mappings)
{
enumerator = ((IEnumerable)mappings).GetEnumerator();
}
