public RMS.Common.ObjectModel.CShiftOrderInfo GetAllShiftOrderInfoID(long ShiftOrderID)
{
CShiftOrderInfo shiftSchedule = new CShiftOrderInfo();
string sSql = String.Format(SqlQueries.GetQuery(Query.GetAllShiftOrderInfoID), ShiftOrderID);
try
{
this.OpenConnection();
IDataReader oReader = this.ExecuteReader(sSql);
while (oReader.Read())
{
shiftSchedule = ReaderToShiftOrder(oReader);
}
}
catch (Exception ex)
{
Logger.Write("Exception : " + ex + " in GetAllShiftManageByShiftID()", LogLevel.Error, "Database");
if (ex.GetType().Equals(typeof(SqlException)))
{
SqlException oSQLEx = ex as SqlException;
if (oSQLEx.Number != 7619)
throw new Exception("Exception occured at GetAllShiftManageByShiftID()", ex);
}
else
{
throw new Exception("Exception occure at GetAllShiftManageByShiftID()", ex);
}
}
finally
{
this.CloseConnection();
}
return shiftSchedule;
}
private CShiftOrderInfo ReaderToShiftOrder(IDataReader inReader)
{
CShiftOrderInfo tempShiftSOrder = new CShiftOrderInfo();
if (inReader["ShiftOrderID"] != null)
tempShiftSOrder.ShiftOrderID = Int64.Parse(inReader["ShiftOrderID"].ToString());
if (inReader["shiftID"] != null)
tempShiftSOrder.ShiftID = Int64.Parse(inReader["shiftID"].ToString());
if (inReader["orderID"] != null)
tempShiftSOrder.OrderID = Int64.Parse(inReader["orderID"].ToString());
if (inReader["creationDate"] != null)
tempShiftSOrder.CreationDate = DateTime.Parse(inReader["creationDate"].ToString());
if (inReader["shiftNo"] != null)
tempShiftSOrder.ShiftNo = Int32.Parse(inReader["shiftNo"].ToString());
if (inReader["paymentcreationDate"] != null)
tempShiftSOrder.PaymentCreationDate = DateTime.Parse(inReader["paymentcreationDate"].ToString());
return tempShiftSOrder;
}
public List<CShiftOrderInfo> GetAllShiftOrderInfoByPaymentcreationDate(DateTime paymentcreationDate)
{
List<CShiftOrderInfo> shiftorderList = new List<CShiftOrderInfo>();
DateTime toDate = new DateTime(paymentcreationDate.Year, paymentcreationDate.Month, paymentcreationDate.Day, 23, 59, 59);
string sSql = String.Format(SqlQueries.GetQuery(Query.GetAllShiftOrderInfoByPaymentcreationDate), paymentcreationDate, toDate);
try
{
this.OpenConnection();
IDataReader oReader = this.ExecuteReader(sSql);
while (oReader.Read())
{
CShiftOrderInfo shiftSchedule = new CShiftOrderInfo();
shiftSchedule = ReaderToShiftOrder(oReader);
shiftorderList.Add(shiftSchedule);
}
}
catch (Exception ex)
{
Logger.Write("Exception : " + ex + " in GetAllShiftManage()", LogLevel.Error, "Database");
if (ex.GetType().Equals(typeof(SqlException)))
{
SqlException oSQLEx = ex as SqlException;
if (oSQLEx.Number != 7619)
throw new Exception("Exception occured at GetAllShiftManage()", ex);
}
else
{
throw new Exception("Exception occure at GetAllShiftManage()", ex);
}
}
finally
{
this.CloseConnection();
}
return shiftorderList;
}
