示例#1
0
 public void SetPaymentFree()
 {
     try
     {
         String           query = String.Format("UPDATE Customer SET User3 = 0 WHERE CustId = '{0}'", this.customerID);
         DataBaseSettings db    = new DataBaseSettings();
         db.ExecuteQuery(query);
     } catch (Exception ex)
     {
         throw ex;
     }
 }
示例#2
0
 public void Register()
 {
     try
     {
         String           query = String.Format("INSERT INTO PaymentsUsers (UserName, Password, Name) VALUES ('{0}', '{1}', '{2}')", user.userName, user.password, user.name);
         DataBaseSettings db    = new DataBaseSettings();
         db.ExecuteQuery(query);
     } catch (Exception ex)
     {
         throw ex;
     }
 }
示例#3
0
 public void SavePhone(Phone phone)
 {
     try
     {
         String           query = String.Format(@"INSERT INTO PaymentsCustomerPhone (FKCustomerSL, PhoneType, Phone) VALUES ('{0}', '{1}', '{2}')", this.fkHolder, phone.phoneType, phone.phone);
         DataBaseSettings db    = new DataBaseSettings();
         db.ExecuteQuery(query);
     } catch (Exception ex)
     {
         throw ex;
     }
 }
示例#4
0
 private void InsertQueueByUser()
 {
     try
     {
         String           query = String.Format(@"INSERT INTO PaymentsQueueUsers (FKQueueU, FKUser) VALUES ({0}, {1})", this.pkQueueU, this.pkUser);
         DataBaseSettings db    = new DataBaseSettings();
         db.ExecuteQuery(query);
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
示例#5
0
 private void UpdateQueueByUser()
 {
     try
     {
         String           query = String.Format(@"UPDATE PaymentsQueueUsers SET FKQueueU = {0} WHERE FKUser = {1}", this.pkQueueU, this.pkUser);
         DataBaseSettings db    = new DataBaseSettings();
         db.ExecuteQuery(query);
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
示例#6
0
        public void Save()
        {
            try
            {
                String query = String.Format(@"INSERT INTO PaymentsRecord (FKUser, FKCusId, FKCallType, PhoneCalled, FkStatusCall, Coments, StartDate, FinalDate) 
                                               VALUES ({0}, '{1}', {2}, '{3}', {4}, '{5}', '{6}', '{7}')", fkUser, PKCustomer, fkCallType, phoneCalled, fkStatusCall, coments, startTime.ToString("yyyy-MM-dd HH:mm:ss"), DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));

                DataBaseSettings db = new DataBaseSettings();
                db.ExecuteQuery(query);
            } catch (Exception ex)
            {
                throw ex;
            }
        }
示例#7
0
 public void SaveQueueU(String queueName, String moraValue, String historialMoraValue, String status, String productoFinanciadoValue, String creditoSimpleValue, String arrendamientoValue)
 {
     try
     {
         String           query = String.Format(@"INSERT INTO PaymentsQueueU (QueueUName) VALUES ('{0}')", queueName);
         DataBaseSettings db    = new DataBaseSettings();
         db.ExecuteQuery(query);
         SetPKQueueU(queueName);
         SaveQueueMix(moraValue, historialMoraValue, status, productoFinanciadoValue, creditoSimpleValue, arrendamientoValue);
     } catch (Exception ex)
     {
         throw ex;
     }
 }
示例#8
0
        public void SaveAddrees(Address information)
        {
            try
            {
                String query = String.Format(@"INSERT INTO PaymentsGuaranteeAddress (FKGuarantee, AddressType, Address, BetweenStreets, Colony, City, AreaCode, Reference)
                                               VALUES ('{0}', '{1}', '{2}', '{3}', '{4}', '{5}', '{6}', '{7}')", this.pkGuarantee, information.addressType, information.myAddress, information.betweenStreets, information.colony, information.city, information.CP, information.reference);

                DataBaseSettings db = new DataBaseSettings();
                db.ExecuteQuery(query);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
示例#9
0
        private void SaveQueueMix(String moraValue, String historialMoraValue, String status, String productoFinanciadoValue, String creditoSimpleValue, String arrendamientoValue)
        {
            try
            {
                SetPKQueueC();
                String           query = String.Empty;
                DataBaseSettings db    = new DataBaseSettings();
                foreach (int pkQueueC in pkQueueC)
                {
                    switch (pkQueueC)
                    {
                    case 1:
                        query = String.Format(@"INSERT INTO PaymentsQueueMix (FKQueueC, FKQueueU, Value) VALUES ({0}, {1}, '{2}')", pkQueueC, this.pkQueueU, moraValue);
                        break;

                    case 3:
                        query = String.Format(@"INSERT INTO PaymentsQueueMix (FKQueueC, FKQueueU, Value) VALUES ({0}, {1}, '{2}')", pkQueueC, this.pkQueueU, historialMoraValue);
                        break;

                    case 6:
                        query = String.Format(@"INSERT INTO PaymentsQueueMix (FKQueueC, FKQueueU, Value) VALUES ({0}, {1}, '{2}')", pkQueueC, this.pkQueueU, status);
                        break;

                    case 8:
                        query = String.Format(@"INSERT INTO PaymentsQueueMix (FKQueueC, FKQueueU, Value) VALUES ({0}, {1}, '{2}')", pkQueueC, this.pkQueueU, productoFinanciadoValue);
                        break;

                    /*
                     * case 9:
                     *  query = String.Format(@"INSERT INTO PaymentsQueueMix (FKQueueC, FKQueueU, Value) VALUES ({0}, {1}, '{2}')", pkQueueC, this.pkQueueU, creditoSimpleValue);
                     *  break;
                     *
                     * case 10:
                     *  query = String.Format(@"INSERT INTO PaymentsQueueMix (FKQueueC, FKQueueU, Value) VALUES ({0}, {1}, '{2}')", pkQueueC, this.pkQueueU, arrendamientoValue);
                     *  break;
                     */

                    default:
                        query = String.Format(@"INSERT INTO PaymentsQueueMix (FKQueueC, FKQueueU) VALUES ({0}, {1})", pkQueueC, this.pkQueueU);     //without value
                        break;
                    }
                    db.ExecuteQuery(query);
                }
            } catch (Exception ex)
            {
                throw ex;
            }
        }