Ejemplo n.º 1
0
        public static string SaveData(IFormCollection forms, IConfiguration Config, string clientIP)
        {
            var        conStr = Config.GetSection("ConnectionStrings").GetSection("DefaultConnection").Value;
            string     uniqueGuid;
            MainEntity mainEntity;

            if (forms["inSHidGuid"].ToString().Trim() != string.Empty)
            {
                uniqueGuid = forms["inSHidGuid"].ToString().Trim();
                mainEntity = MainEntity.Init(forms, clientIP, uniqueGuid, "UPDATE");
            }
            else
            {
                uniqueGuid = GetGuid(Config, clientIP);
                mainEntity = MainEntity.Init(forms, clientIP, uniqueGuid, "CREATE");
            }
            MainEntityRepository mainEntityRepository = new MainEntityRepository(mainEntity);

            try
            {
                using (SqlConnection connection = new SqlConnection(conStr))
                {
                    mainEntityRepository.PerformSQLOperation(connection);
                }
            }
            catch (Exception e)
            {
                //Logger.SaveErrToLog(e.Message, Config, clientIP);
            }
            return(uniqueGuid);
        }
Ejemplo n.º 2
0
        public static string GetOffers(IConfiguration Config)
        {
            var conStr = Config.GetSection("ConnectionStrings").GetSection("DefaultConnection").Value;
            //updateStatusAll(Config);
            ForGridInOfferListEntity list = null;

            try
            {
                using (SqlConnection connection = new SqlConnection(conStr))
                {
                    list = new ForGridInOfferListEntity(MainEntityRepository.GetListOfItems(connection));
                }
            }
            catch (Exception e)
            {
                //Logger.SaveErrToLog(e.Message, Config, clientIP);
            }

            return(JsonConvert.SerializeObject(list));
        }