public static DataSet GetEvents(
int moduleId,
DateTime beginDate,
DateTime endDate)
{
StringBuilder sqlCommand = new StringBuilder();
SqliteParameter[] arParams = new SqliteParameter[3];
arParams[0] = new SqliteParameter(":ModuleID", DbType.Int32);
arParams[1] = new SqliteParameter(":BeginDate", DbType.DateTime);
arParams[2] = new SqliteParameter(":EndDate", DbType.DateTime);
arParams[0].Direction = ParameterDirection.Input;
arParams[0].Value = moduleId;
sqlCommand.Append("SELECT * ");
sqlCommand.Append("FROM mp_CalendarEvents ");
sqlCommand.Append("WHERE ");
sqlCommand.Append("ModuleID = :ModuleID ");
sqlCommand.Append("AND EventDate >= :BeginDate ");
arParams[1].Direction = ParameterDirection.Input;
arParams[1].Value = beginDate;
sqlCommand.Append("AND EventDate <= :EndDate ");
arParams[2].Direction = ParameterDirection.Input;
arParams[2].Value = endDate;
sqlCommand.Append(" ;");
return(SqliteHelper.ExecuteDataset(
GetConnectionString(),
sqlCommand.ToString(),
arParams));
}