public DataView GetLogHistory(int requisitionID)
 {
     var logRequisitionStatus = new LogRequisitionStatus();
     var query = HCMIS.Repository.Queries.LogRequisitionStatus.SelectGetLogRequisitionHistoty(requisitionID);
     logRequisitionStatus.LoadFromRawSql(query);
     return logRequisitionStatus.DefaultView;
 }
        public DataView GetLogHistory(int requisitionID)
        {
            var logRequisitionStatus = new LogRequisitionStatus();
            var query = HCMIS.Repository.Queries.LogRequisitionStatus.SelectGetLogRequisitionHistoty(requisitionID);

            logRequisitionStatus.LoadFromRawSql(query);
            return(logRequisitionStatus.DefaultView);
        }
 public void LogRequisitionStatus(int requisitionID, int? fromStatusID, int toStatusID, int userID)
 {
     LogRequisitionStatus logRequisitionStatus = new LogRequisitionStatus();
     logRequisitionStatus.AddNew();
     logRequisitionStatus.StatusChangedDate = DateTimeHelper.ServerDateTime;
     logRequisitionStatus.RequisitionID = requisitionID;
     if (fromStatusID.HasValue)
     {
         logRequisitionStatus.FromStatusID = (int) fromStatusID;
     }
     logRequisitionStatus.ToStatusID = toStatusID;
     logRequisitionStatus.UserID = userID;
     logRequisitionStatus.Save();
 }