Example #1
0
 private static string GetFormatedText(EF6.EPOSBatchTender target, string[] textField, string textFormatString)
 {
     for (int i = 0; i < textField.Length; i++)
     {
         PropertyInfo pi = target.GetType().GetProperty(textField[i]);
         textFormatString = textFormatString.Replace("{" + i.ToString() + "}", pi != null ? pi.GetValue(target, null).ToString() : string.Empty);
     }
     return(textFormatString);
 }
Example #2
0
        /// <summary>
        /// Get a EF6.EPOSBatchTender object from the database using the given TenderId
        /// </summary>
        /// <param name="tenderId">The primary key value</param>
        /// <returns>A EF6.EPOSBatchTender object</returns>
        public static EF6.EPOSBatchTender Get(Guid tenderId)
        {
            EF6.EPOSBatchTender result = null;

            using (var ctx = new EF6.RT2020Entities())
            {
                result = ctx.EPOSBatchTender.Where(x => x.TenderId == tenderId).AsNoTracking().FirstOrDefault();
            }

            return(result);
        }
Example #3
0
        /// <summary>
        /// Get a EF6.EPOSBatchTender object from the database using the given QueryString
        /// </summary>
        /// <param name="tenderId">The primary key value</param>
        /// <returns>A EF6.EPOSBatchTender object</returns>
        public static EF6.EPOSBatchTender Get(string whereClause)
        {
            EF6.EPOSBatchTender result = null;

            using (var ctx = new EF6.RT2020Entities())
            {
                result = ctx.EPOSBatchTender
                         .SqlQuery(string.Format("Select * from EPOSBatchTender Where {0}", whereClause))
                         .AsNoTracking()
                         .FirstOrDefault();
            }

            return(result);
        }