public List <VBrigadeEndedTasks> SelectIn(List <int> task_ids)
{
var list = new List <VBrigadeEndedTasks>();
string values = "";
if (task_ids.Count > 0)
{
values = "where task_id in (" + String.Join(",", task_ids.ToArray()) + ")";
}
else
{
return(list);
}
using (OracleConnection connection = new OracleConnection(OracleWcfService.CONNECTION_STRING))
{
connection.Open();
OracleCommand oraCommand = new OracleCommand("SELECT * FROM BRIGADE_ENDED_TASKS " + values, connection);
OracleDataReader oraReader = oraCommand.ExecuteReader();
if (oraReader.HasRows)
{
while (oraReader.Read())
{
var temp = new VBrigadeEndedTasks();
temp.task_id = oraReader.GetInt32(0);
temp.request_name = oraReader.GetString(1);
temp.request_description = oraReader.GetString(2);
temp.task_note = oraReader.GetString(3);
temp.change_date = oraReader.GetDateTime(4);
temp.brigade_id = oraReader.GetInt32(5);
list.Add(temp);
}
}
}
return(list);
}
public List <VBrigadeEndedTasks> SelectAll()
{
var list = new List <VBrigadeEndedTasks>();
using (OracleConnection connection = new OracleConnection(OracleWcfService.CONNECTION_STRING))
{
connection.Open();
OracleCommand oraCommand = new OracleCommand("SELECT * FROM BRIGADE_ENDED_TASKS WHERE change_date between add_months(trunc(sysdate,'mm'),-1) and last_day(add_months(trunc(sysdate,'mm'),0))", connection);
OracleDataReader oraReader = oraCommand.ExecuteReader();
if (oraReader.HasRows)
{
while (oraReader.Read())
{
var temp = new VBrigadeEndedTasks();
temp.task_id = oraReader.GetInt32(0);
temp.request_name = oraReader.GetString(1);
temp.request_description = oraReader.GetString(2);
temp.task_note = oraReader.GetString(3);
temp.change_date = oraReader.GetDateTime(4);
temp.brigade_id = oraReader.GetInt32(5);
temp.total_time = oraReader.GetInt32(6);
list.Add(temp);
}
}
}
return(list);
}
