public static DataTable GetAllReceiptTypesForReceive()
 {
     var receiptType = new ReceiptType();
     var query = HCMIS.Repository.Queries.ReceiptType.SelectGetAllReceiptTypes();
     receiptType.LoadFromRawSql(query);
     var dt = receiptType.DataTable;
     if (BLL.Settings.IsCenter)
         dt =
             dt.AsEnumerable()
                 .Where(
                     dr =>
                         dr.Field<string>("ReceiptTypeCode") != "DN" && dr.Field<string>("ReceiptTypeCode") != "MDN")
                 .CopyToDataTable();
     return dt;
 }
        public static DataTable GetAllReceiptTypesForReceive()
        {
            var receiptType = new ReceiptType();
            var query       = HCMIS.Repository.Queries.ReceiptType.SelectGetAllReceiptTypes();

            receiptType.LoadFromRawSql(query);
            var dt = receiptType.DataTable;

            if (BLL.Settings.IsCenter)
            {
                dt =
                    dt.AsEnumerable()
                    .Where(
                        dr =>
                        dr.Field <string>("ReceiptTypeCode") != "DN" && dr.Field <string>("ReceiptTypeCode") != "MDN")
                    .CopyToDataTable();
            }
            return(dt);
        }