public DataTable GetUserNamebyReceipt(int ReceiptID)
 {
     ReceiveDocConfirmation rdc = new ReceiveDocConfirmation();
     var query = HCMIS.Repository.Queries.ReceiveDocConfirmation.SelectGetUserNamebyReceipt(ReceiptID);
     rdc.LoadFromRawSql(query);
     return rdc.DataTable;
 }
        public DataTable GetUserNamebyReceipt(int ReceiptID)
        {
            ReceiveDocConfirmation rdc = new ReceiveDocConfirmation();
            var query = HCMIS.Repository.Queries.ReceiveDocConfirmation.SelectGetUserNamebyReceipt(ReceiptID);

            rdc.LoadFromRawSql(query);
            return(rdc.DataTable);
        }
        public void ChangeStatusByAccountReceiveDocs(string receiveDocs,int StatusID,int? PreviousStatusID = null)
        {
            if (receiveDocs!= "")
            {
                ReceiveDocConfirmation receiveDocConfirmation = new ReceiveDocConfirmation();

                var query = HCMIS.Repository.Queries.ReceiveDocConfirmation.UpdateChangeStatusByAccountReceiveDocs(receiveDocs, StatusID, PreviousStatusID);

                     receiveDocConfirmation.LoadFromRawSql(query);
                    }
        }
        public void ChangeStatusByAccountReceiveDocs(string receiveDocs, int StatusID, int?PreviousStatusID = null)
        {
            if (receiveDocs != "")
            {
                ReceiveDocConfirmation receiveDocConfirmation = new ReceiveDocConfirmation();

                var query = HCMIS.Repository.Queries.ReceiveDocConfirmation.UpdateChangeStatusByAccountReceiveDocs(receiveDocs, StatusID, PreviousStatusID);


                receiveDocConfirmation.LoadFromRawSql(query);
            }
        }