Example #1
0
 /// <summary>
 /// Injects the dependencies
 /// Used for testing
 /// </summary>
 /// <param name="connStringIn"></param>
 public HDRoutesModel(string connStringIn, Volunteers clsVol)
 {
     conn = new System.Data.SqlClient.SqlConnection();
     conn.ConnectionString = connStringIn;
     dtbl        = new DataTable();
     dadAdpt     = new SqlDataAdapter();
     this.clsVol = clsVol;
 }
 public FBJobsPlanForm()
 {
     InitializeComponent();
     clsJobsPlan = new FBJobsPlan(CCFBGlobal.connectionString);
     clsVols     = new Volunteers(CCFBGlobal.connectionString);
     showJobsView();
     InitlvwJobs(CCFBGlobal.TypeCodesArray(CCFBGlobal.parmTbl_FBJobs));
     tsb1.Checked = true;
     setupCopyMenu();
 }
Example #3
0
 public void loadDriverInfo(int volId)
 {
     driverName  = "";
     driverPhone = "";
     if (volId > 0)
     {
         Volunteers clsVol = new Volunteers(connString);
         if (clsVol.open(volId) == true)
         {
             driverName  = clsVol.Name;
             driverPhone = clsVol.Phone;
         }
     }
 }
Example #4
0
        /// <summary>
        /// Injects the dependencies
        /// Used for testing
        /// </summary>
        /// <param name="connStringIn"></param>
        public HDRoutesModel(string connStringIn, Volunteers clsVol)
        {
            conn = new System.Data.SqlClient.SqlConnection();
            conn.ConnectionString = connStringIn;
            dtbl        = new DataTable();
            dadAdpt     = new SqlDataAdapter();
            this.clsVol = clsVol;

            // Example of using the CLientcardORM
            //ClientcardORM.ClientcardORM orm = new ClientcardORM.ClientcardORM();
            //var query = from item in orm.HDRoutes
            //            select item;

            //foreach (var item in query)
            //{
            //    Console.WriteLine(item.FBContact);
            //}
        }