コード例 #1
0
        /// <summary>
        /// Get a single customer
        /// </summary>
        /// <param name="cust">Customer parameter</param>
        /// <returns></returns>
        public Customer GetCustomer(Customer cust)
        {
            SqlConnection corpcn = new SqlConnection(Settings.Default.cnHelpDesk);

            var sb = new StringBuilder();
            sb.Append("Select CustID, CustName, CustAddress, CustState, CustZip ");
            sb.Append("From Customer Where CustID = '").Append(cust.CustID).Append("'");
            sb.Append(";");

            using (corpcn)
            {
                //Needed this here to be able to use the variable towards the end. Some type of scope error.
                Customer customer = null;

                SqlCommand corpCmd = corpcn.CreateCommand();
                corpCmd.CommandType = CommandType.Text;
                corpCmd.CommandText = sb.ToString();
                corpcn.Open();
                SqlDataReader corprdr = corpCmd.ExecuteReader();

                while (corprdr.Read())
                {
                    customer = CreateCustomer(corprdr);
                }

                corprdr.Close();

                return customer;
            }
        }
コード例 #2
0
        /// <summary>
        /// Add a customer
        /// </summary>
        /// <param name="cust">Customer Property</param>
        public void InsertCustomer(Customer cust)
        {
            SqlConnection corpcn = new SqlConnection(Settings.Default.cnHelpDesk);

            var sb = new StringBuilder();
            sb.Append("Insert Into [Customer]");
            sb.Append(" ([CustName], [CustAddress], [CustState], [CustZip])");
            sb.Append(" Values (");
            sb.Append("'").Append(cust.CustName).Append("',");
            sb.Append("'").Append(cust.CustAddress).Append("',");
            sb.Append("'").Append(cust.CustState).Append("',");
            sb.Append("'").Append(cust.CustZip).Append("')");

            using (corpcn)
            {
                SqlCommand corpCmd = corpcn.CreateCommand();
                corpCmd.CommandType = CommandType.Text;
                corpCmd.CommandText = sb.ToString();
                corpcn.Open();
                corpCmd.ExecuteNonQuery();
            }
        }
コード例 #3
0
        /// <summary>
        /// Update Customer
        /// </summary>
        /// <param name="cust">Customer Parameter</param>
        public void UpdateCustomer(Customer cust)
        {
            SqlConnection corpcn = new SqlConnection(Settings.Default.cnHelpDesk);

            var sb = new StringBuilder();
            sb.Append("Update [Customer]");
            sb.Append(" Set ");
            sb.Append("[CustName]='").Append(cust.CustName).Append("',");
            sb.Append("[CustAddress]='").Append(cust.CustAddress).Append("',");
            sb.Append("[CustState]='").Append(cust.CustState).Append("',");
            sb.Append("[CustZip]='").Append(cust.CustZip).Append("'");
            sb.Append("Where [CustID]=").Append(cust.CustID);

            using (corpcn)
            {
                SqlCommand corpCmd = corpcn.CreateCommand();
                corpCmd.CommandType = CommandType.Text;
                corpCmd.CommandText = sb.ToString();
                corpcn.Open();
                corpCmd.ExecuteNonQuery();
            }
        }
コード例 #4
0
 /// <summary>
 /// Creates an internal customer
 /// </summary>
 /// <param name="dr">SQL Data Reader</param>
 /// <returns></returns>
 private Customer CreateCustomer(SqlDataReader dr)
 {
     var c = new Customer();
     c.CustID = (int)dr["CustID"];
     c.CustName = dr["CustName"].ToString();
     c.CustAddress = dr["CustAddress"].ToString();
     c.CustState = dr["CustState"].ToString();
     c.CustZip = (int)dr["CustZip"];
     return c;
 }
コード例 #5
0
 /// <summary>
 /// Get a Customer by it's ID
 /// </summary>
 /// <param name="cID">Customer ID</param>
 /// <returns>Customer</returns>
 public Tuple<int, string, string, string, int> GetCustomerByID(int cID)
 {
     Customer cluster = new Customer();
     foreach (Customer cust in custsList)
     {
         if (cust.CustID == cID)
         {
             cluster = cust;
         }
     }
     cluster = cR.GetCustomer(cluster);
     //Returns a single customer
     return new Tuple<int, string, string, string, int>(cluster.CustID, cluster.CustName, cluster.CustAddress, cluster.CustState, cluster.CustZip);
 }