Esempi in C# (CSharp) per DataAccessLayer.DataAccessComponents.DataAccessComponent

Esempio n. 1

        public static int GetMaxForQuickContacts()
        {
            DataAccessLayer.DataAccessComponents.DataAccessComponent dac = new DataAccessLayer.DataAccessComponents.DataAccessComponent();
            IDataReader reader = dac.SelectStatement("Select Max(QuickContactId) From QuickContact");
            int         result = 0;

            while (reader.Read())
            {
                result = reader.GetInt32(0);
            }
            return(result);
        }

Esempio n. 2

        public static string GetUserForQuickContacts(int id)
        {
            DataAccessLayer.DataAccessComponents.DataAccessComponent dac = new DataAccessLayer.DataAccessComponents.DataAccessComponent();
            IDataReader reader = dac.SelectStatement("Select Name From QuickContact Where QuickContactId = " + id);
            string      result = "";

            while (reader.Read())
            {
                result = reader.GetString(0);
            }
            return(result);
        }

Esempio n. 3

 public void Delete(string ids, string questionId)
 {
     DataAccessLayer.DataAccessComponents.DataAccessComponent c = new DataAccessLayer.DataAccessComponents.DataAccessComponent();
     c.EXQuery(String.Format("Delete From FormBuilder.FormFieldValue Where FormFieldValueId Not In({0}) and FormFieldId = {1}", ids, questionId));
 }

Esempio n. 4

File: FormFieldColumnLogic.cs Progetto: ramyothman/RBM

 public void DeleteByFormFieldId(int FormFieldId)
 {
     DataAccessLayer.DataAccessComponents.DataAccessComponent DAC = new DataAccessLayer.DataAccessComponents.DataAccessComponent("","");
     DAC.EXQuery("Delete From FormBuilder.FormFieldColumn where FormFieldId = " + FormFieldId);
 }

Esempio n. 5

File: FormFieldLogic.cs Progetto: ramyothman/Qiyas

 public void Delete(string questionIds, string surveyId)
 {
     DataAccessLayer.DataAccessComponents.DataAccessComponent DAC = new DataAccessLayer.DataAccessComponents.DataAccessComponent();
     DAC.EXQuery(String.Format("Delete From FormBuilder.FormField where FormFieldId Not In({0}) AND FormDocumentId = {1}", questionIds, surveyId));
 }

Esempio n. 6

File: HomePageLogic.cs Progetto: ramyothman/RBM

 public void Delete(string ids,int HomePageGroupID)
 {
     DataAccessLayer.DataAccessComponents.DataAccessComponent dac = new DataAccessLayer.DataAccessComponents.DataAccessComponent("","");
     dac.EXQuery("Delete From ContentManagement.HomePage where HomePageGroupID = " + HomePageGroupID + " and HomePageID Not In(" + ids + ")");
 }

Esempio n. 7

File: FormFieldColumnLogic.cs Progetto: ramyothman/Qiyas

 public void DeleteByFormFieldId(int FormFieldId)
 {
     DataAccessLayer.DataAccessComponents.DataAccessComponent DAC = new DataAccessLayer.DataAccessComponents.DataAccessComponent();
     DAC.EXQuery("Delete From FormBuilder.FormFieldColumn where FormFieldId = " + FormFieldId);
 }

Esempio n. 8

File: FormFieldLogic.cs Progetto: ramyothman/RBM

 public void Delete(string questionIds, string surveyId)
 {
     DataAccessLayer.DataAccessComponents.DataAccessComponent DAC = new DataAccessLayer.DataAccessComponents.DataAccessComponent("","");
     DAC.EXQuery(String.Format("Delete From FormBuilder.FormField where FormFieldId Not In({0}) AND FormDocumentId = {1}", questionIds, surveyId));
 }

Esempio n. 9

File: FormFieldValueLogic.cs Progetto: ramyothman/RBM

 public void Delete(string ids, string questionId)
 {
     DataAccessLayer.DataAccessComponents.DataAccessComponent c = new DataAccessLayer.DataAccessComponents.DataAccessComponent("","");
     c.EXQuery(String.Format("Delete From FormBuilder.FormFieldValue Where FormFieldValueId Not In({0}) and FormFieldId = {1}", ids, questionId));
 }

Esempio n. 10

File: Common.cs Progetto: ramyothman/RBM

 public static string GetUserForQuickContacts(int id)
 {
     DataAccessLayer.DataAccessComponents.DataAccessComponent dac = new DataAccessLayer.DataAccessComponents.DataAccessComponent("","");
     IDataReader reader = dac.SelectStatement("Select Name From QuickContact Where QuickContactId = " + id);
     string result = "";
     while (reader.Read())
     {
         result = reader.GetString(0);
     }
     return result;
 }

Esempio n. 11

File: Common.cs Progetto: ramyothman/RBM

 public static int GetMaxForQuickContacts()
 {
     DataAccessLayer.DataAccessComponents.DataAccessComponent dac = new DataAccessLayer.DataAccessComponents.DataAccessComponent("","");
     IDataReader reader = dac.SelectStatement("Select Max(QuickContactId) From QuickContact");
     int result = 0;
     while (reader.Read())
     {
         result = reader.GetInt32(0);
     }
     return result;
 }