Пример #1
0
        public bool PutPeriod(string from, string until, string payDate)
        {
            bool answer = false;

            try
            {
                using (SqlConnection connection = new SqlConnection(ConnectionString))
                {
                    connection.Open();
                    DaBonus daBonus = new DaBonus();
                    answer = daBonus.PutPeriod(connection, from, until, payDate);
                    connection.Close();
                }
            }
            catch (Exception e)
            {
                RecordLog(e.Message, e.StackTrace);
            }
            return(answer);
        }
Пример #2
0
        public bool ChangeStatus(int idBonusPeriod, int status)
        {
            bool answer = false;

            try
            {
                using (SqlConnection connection = new SqlConnection(ConnectionString))
                {
                    connection.Open();
                    DaBonus daBonus = new DaBonus();
                    answer = daBonus.ChangeStatus(connection, idBonusPeriod, status);
                    connection.Close();
                }
            }
            catch (Exception e)
            {
                RecordLog(e.Message, e.StackTrace);
            }
            return(answer);
        }
Пример #3
0
        public string GetPeriod(string userName)
        {
            string answer = "";

            using (SqlConnection connection = new SqlConnection(ConnectionString))
            {
                try
                {
                    connection.Open();
                    DaBonus daBonus = new DaBonus();
                    answer = daBonus.GetPeriod(connection, userName);
                    connection.Close();
                }
                catch (Exception e)
                {
                    answer = "";
                    RecordLog(e.Message, e.StackTrace);
                }
            }
            return(answer);
        }
Пример #4
0
        public string GetEmailPayWallet(int id)
        {
            string answer = "";

            using (SqlConnection connection = new SqlConnection(ConnectionString))
            {
                try
                {
                    connection.Open();
                    DaBonus daBonus = new DaBonus();
                    answer = daBonus.GetEmailPayWallet(connection, id);
                    connection.Close();
                }
                catch (Exception e)
                {
                    answer = "";
                    RecordLog(e.Message, e.StackTrace);
                }
            }
            return(answer);
        }