public override object BuildNew()
{
YellowstonePathology.Business.Task.Model.TaskOrder taskOrder = new Task.Model.TaskOrder();
this.Build(taskOrder);
return(taskOrder);
}
public override object BuildNew()
{
YellowstonePathology.Business.Task.Model.TaskOrder taskOrder = new Task.Model.TaskOrder();
this.Build(taskOrder);
return taskOrder;
}
public static YellowstonePathology.Business.Task.Model.TaskOrderCollection GetDailyTaskOrderCollection()
{
YellowstonePathology.Business.Task.Model.TaskOrderCollection result = new YellowstonePathology.Business.Task.Model.TaskOrderCollection();
string sql = "Select * from tblTaskOrder where AcknowledgementType = 'Daily' " +
"and Acknowledged = 0 " +
"and TaskDate <= GetDate() order by TaskDate desc";
SqlCommand cmd = new SqlCommand(sql);
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add("@AcknowledgementType", SqlDbType.VarChar).Value = Task.Model.TaskAcknowledgementType.Daily;
using (SqlConnection cn = new SqlConnection(Properties.Settings.Default.ProductionConnectionString))
{
cn.Open();
cmd.Connection = cn;
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read() == true)
{
YellowstonePathology.Business.Task.Model.TaskOrder taskOrder = new Task.Model.TaskOrder();
YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(taskOrder, dr);
sqlDataReaderPropertyWriter.WriteProperties();
result.Add(taskOrder);
}
}
}
return result;
}
public static YellowstonePathology.Business.Task.Model.TaskOrderCollection GetDailyTaskOrderHistoryCollection(int daysBack)
{
YellowstonePathology.Business.Task.Model.TaskOrderCollection result = new YellowstonePathology.Business.Task.Model.TaskOrderCollection();
XElement collectionElement = new XElement("Document");
string sql = "Select * from tblTaskOrder where AcknowledgementType = 'Daily' " +
"and TaskDate between @StartDate and @EndDate order by TaskDate desc";
SqlCommand cmd = new SqlCommand(sql);
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add("@StartDate", SqlDbType.DateTime).Value = DateTime.Today.AddDays(-daysBack);
cmd.Parameters.Add("@EndDate", SqlDbType.DateTime).Value = DateTime.Today;
using (SqlConnection cn = new SqlConnection(Properties.Settings.Default.ProductionConnectionString))
{
cn.Open();
cmd.Connection = cn;
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read() == true)
{
YellowstonePathology.Business.Task.Model.TaskOrder taskOrder = new Task.Model.TaskOrder();
YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(taskOrder, dr);
sqlDataReaderPropertyWriter.WriteProperties();
result.Add(taskOrder);
}
}
}
return result;
}
/*public static YellowstonePathology.Business.Task.Model.TaskOrder BuildTaskOrder(XElement taskOrderElement)
{
YellowstonePathology.Business.Task.Model.TaskOrder taskOrder = new YellowstonePathology.Business.Task.Model.TaskOrder();
YellowstonePathology.Business.Persistence.XmlPropertyWriter xmlPropertyWriter = new YellowstonePathology.Business.Persistence.XmlPropertyWriter(taskOrderElement, taskOrder);
xmlPropertyWriter.Write();
List<XElement> taskOrderDetailElements = (from item in taskOrderElement.Elements("TaskOrderDetailCollection") select item).ToList<XElement>();
foreach (XElement taskOrderDetailElement in taskOrderDetailElements.Elements("TaskOrderDetail"))
{
YellowstonePathology.Business.Task.Model.TaskOrderDetail taskOrderDetail = BuildTaskOrderDetail(taskOrderDetailElement);
taskOrder.TaskOrderDetailCollection.Add(taskOrderDetail);
}
return taskOrder;
}
public static YellowstonePathology.Business.Task.Model.TaskOrderDetail BuildTaskOrderDetail(XElement taskOrderDetailElement)
{
YellowstonePathology.Business.Task.Model.TaskOrderDetail taskOrderDetail = new YellowstonePathology.Business.Task.Model.TaskOrderDetail();
YellowstonePathology.Business.Persistence.XmlPropertyWriter xmlPropertyWriter = new YellowstonePathology.Business.Persistence.XmlPropertyWriter(taskOrderDetailElement, taskOrderDetail);
xmlPropertyWriter.Write();
return taskOrderDetail;
}*/
private static Task.Model.TaskOrderCollection BuildTaskOrderCollection(SqlCommand cmd)
{
YellowstonePathology.Business.Task.Model.TaskOrderCollection result = new YellowstonePathology.Business.Task.Model.TaskOrderCollection();
using (SqlConnection cn = new SqlConnection(Properties.Settings.Default.ProductionConnectionString))
{
cn.Open();
cmd.Connection = cn;
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
Task.Model.TaskOrder taskOrder = new Task.Model.TaskOrder();
Business.Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(taskOrder, dr);
sqlDataReaderPropertyWriter.WriteProperties();
result.Add(taskOrder);
}
dr.NextResult();
while (dr.Read())
{
Task.Model.TaskOrderDetail taskOrderDetail = new Task.Model.TaskOrderDetail();
Business.Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(taskOrderDetail, dr);
sqlDataReaderPropertyWriter.WriteProperties();
foreach (Task.Model.TaskOrder taskOrder in result)
{
if (taskOrderDetail.TaskOrderId == taskOrder.TaskOrderId)
{
taskOrder.TaskOrderDetailCollection.Add(taskOrderDetail);
break;
}
}
}
}
}
return result;
}
