public void Update() { SqlService sql = new SqlService(); StringBuilder queryParameters = new StringBuilder(); sql.AddParameter("@SuppId", SqlDbType.Int, Id); queryParameters.Append("SuppId = @SuppId"); sql.AddParameter("@Name", SqlDbType.VarChar, Name); queryParameters.Append(", Name = @Name"); sql.AddParameter("@Status", SqlDbType.VarChar, Status); queryParameters.Append(", Status = @Status"); sql.AddParameter("@Addr1", SqlDbType.VarChar, Addr1); queryParameters.Append(", Addr1 = @Addr1"); sql.AddParameter("@Addr2", SqlDbType.VarChar, Addr2); queryParameters.Append(", Addr2 = @Addr2"); sql.AddParameter("@City", SqlDbType.VarChar, City); queryParameters.Append(", City = @City"); sql.AddParameter("@State", SqlDbType.VarChar, State); queryParameters.Append(", State = @State"); sql.AddParameter("@Zip", SqlDbType.VarChar, Zip); queryParameters.Append(", Zip = @Zip"); sql.AddParameter("@Phone", SqlDbType.VarChar, Phone); queryParameters.Append(", Phone = @Phone"); string query = String.Format("Update Supplier Set {0} Where SuppId = @SuppId", queryParameters.ToString()); SqlDataReader reader = sql.ExecuteSqlReader(query); }
public void Create() { SqlService sql = new SqlService(); StringBuilder queryParameters = new StringBuilder(); sql.AddParameter("@SuppId", SqlDbType.Int, Id); queryParameters.Append("@SuppId"); sql.AddParameter("@Name", SqlDbType.VarChar, Name); queryParameters.Append(", @Name"); sql.AddParameter("@Status", SqlDbType.VarChar, Status); queryParameters.Append(", @Status"); sql.AddParameter("@Addr1", SqlDbType.VarChar, Addr1); queryParameters.Append(", @Addr1"); sql.AddParameter("@Addr2", SqlDbType.VarChar, Addr2); queryParameters.Append(", @Addr2"); sql.AddParameter("@City", SqlDbType.VarChar, City); queryParameters.Append(", @City"); sql.AddParameter("@State", SqlDbType.VarChar, State); queryParameters.Append(", @State"); sql.AddParameter("@Zip", SqlDbType.VarChar, Zip); queryParameters.Append(", @Zip"); sql.AddParameter("@Phone", SqlDbType.VarChar, Phone); queryParameters.Append(", @Phone"); string query = String.Format("Insert Into Supplier ({0}) Values ({1})", queryParameters.ToString().Replace("@", ""), queryParameters.ToString()); SqlDataReader reader = sql.ExecuteSqlReader(query); }
public static void Delete(int id) { SqlService sql = new SqlService(); sql.AddParameter("@OrderId", SqlDbType.Int, id); SqlDataReader reader = sql.ExecuteSqlReader("Delete Orders Where OrderId = @OrderId"); }
public static void Delete(string id) { SqlService sql = new SqlService(); sql.AddParameter("@ProductId", SqlDbType.VarChar, id); SqlDataReader reader = sql.ExecuteSqlReader("Delete Product Where ProductId = @ProductId"); }
public static void Delete(int id) { SqlService sql = new SqlService(); sql.AddParameter("@UniqueID", SqlDbType.Int, id); SqlDataReader reader = sql.ExecuteSqlReader("Delete Profiles Where UniqueID = @UniqueID"); }
public void Update() { SqlService sql = new SqlService(); StringBuilder queryParameters = new StringBuilder(); sql.AddParameter("@ProductId", SqlDbType.VarChar, Id); queryParameters.Append("ProductId = @ProductId"); sql.AddParameter("@CategoryId", SqlDbType.VarChar, CategoryId); queryParameters.Append(", CategoryId = @CategoryId"); sql.AddParameter("@Name", SqlDbType.VarChar, Name); queryParameters.Append(", Name = @Name"); sql.AddParameter("@Descn", SqlDbType.VarChar, Descn); queryParameters.Append(", Descn = @Descn"); sql.AddParameter("@Image", SqlDbType.VarChar, Image); queryParameters.Append(", Image = @Image"); string query = String.Format("Update Product Set {0} Where ProductId = @ProductId", queryParameters.ToString()); SqlDataReader reader = sql.ExecuteSqlReader(query); }
public void Create() { SqlService sql = new SqlService(); StringBuilder queryParameters = new StringBuilder(); sql.AddParameter("@ProductId", SqlDbType.VarChar, Id); queryParameters.Append("@ProductId"); sql.AddParameter("@CategoryId", SqlDbType.VarChar, CategoryId); queryParameters.Append(", @CategoryId"); sql.AddParameter("@Name", SqlDbType.VarChar, Name); queryParameters.Append(", @Name"); sql.AddParameter("@Descn", SqlDbType.VarChar, Descn); queryParameters.Append(", @Descn"); sql.AddParameter("@Image", SqlDbType.VarChar, Image); queryParameters.Append(", @Image"); string query = String.Format("Insert Into Product ({0}) Values ({1})", queryParameters.ToString().Replace("@", ""), queryParameters.ToString()); SqlDataReader reader = sql.ExecuteSqlReader(query); }
public Supplier(int id) { SqlService sql = new SqlService(); sql.AddParameter("@SuppId", SqlDbType.Int, id); SqlDataReader reader = sql.ExecuteSqlReader("SELECT * FROM Supplier WHERE SuppId = @SuppId"); if (reader.Read()) { this.LoadFromReader(reader); reader.Close(); } else { if (!reader.IsClosed) reader.Close(); throw new ApplicationException("Supplier does not exist."); } }
public Product(string id) { SqlService sql = new SqlService(); sql.AddParameter("@ProductId", SqlDbType.VarChar, id); SqlDataReader reader = sql.ExecuteSqlReader("SELECT * FROM Product WHERE ProductId = @ProductId"); if (reader.Read()) { this.LoadFromReader(reader); reader.Close(); } else { if (!reader.IsClosed) reader.Close(); throw new ApplicationException("Product does not exist."); } }
public Profile(int id) { SqlService sql = new SqlService(); sql.AddParameter("@UniqueID", SqlDbType.Int, id); SqlDataReader reader = sql.ExecuteSqlReader("SELECT * FROM Profiles WHERE UniqueID = @UniqueID"); if (reader.Read()) { this.LoadFromReader(reader); reader.Close(); } else { if (!reader.IsClosed) { reader.Close(); } throw new ApplicationException("Profile does not exist."); } }
public Product(string id) { SqlService sql = new SqlService(); sql.AddParameter("@ProductId", SqlDbType.VarChar, id); SqlDataReader reader = sql.ExecuteSqlReader("SELECT * FROM Product WHERE ProductId = @ProductId"); if (reader.Read()) { this.LoadFromReader(reader); reader.Close(); } else { if (!reader.IsClosed) { reader.Close(); } throw new ApplicationException("Product does not exist."); } }
public Order(int id) { SqlService sql = new SqlService(); sql.AddParameter("@OrderId", SqlDbType.Int, id); SqlDataReader reader = sql.ExecuteSqlReader("SELECT * FROM Orders WHERE OrderId = @OrderId"); if (reader.Read()) { this.LoadFromReader(reader); reader.Close(); } else { if (!reader.IsClosed) { reader.Close(); } throw new ApplicationException("Order does not exist."); } }
public void Update() { SqlService sql = new SqlService(); StringBuilder queryParameters = new StringBuilder(); sql.AddParameter("@UniqueID", SqlDbType.Int, Id); queryParameters.Append("UniqueID = @UniqueID"); sql.AddParameter("@Username", SqlDbType.VarChar, Username); queryParameters.Append(", Username = @Username"); sql.AddParameter("@ApplicationName", SqlDbType.VarChar, ApplicationName); queryParameters.Append(", ApplicationName = @ApplicationName"); sql.AddParameter("@IsAnonymous", SqlDbType.Bit, IsAnonymous); queryParameters.Append(", IsAnonymous = @IsAnonymous"); sql.AddParameter("@LastActivityDate", SqlDbType.DateTime, LastActivityDate); queryParameters.Append(", LastActivityDate = @LastActivityDate"); sql.AddParameter("@LastUpdatedDate", SqlDbType.DateTime, LastUpdatedDate); queryParameters.Append(", LastUpdatedDate = @LastUpdatedDate"); string query = String.Format("Update Profiles Set {0} Where UniqueID = @UniqueID", queryParameters.ToString()); SqlDataReader reader = sql.ExecuteSqlReader(query); }
public void Create() { SqlService sql = new SqlService(); StringBuilder queryParameters = new StringBuilder(); sql.AddParameter("@UniqueID", SqlDbType.Int, Id); queryParameters.Append("@UniqueID"); sql.AddParameter("@Username", SqlDbType.VarChar, Username); queryParameters.Append(", @Username"); sql.AddParameter("@ApplicationName", SqlDbType.VarChar, ApplicationName); queryParameters.Append(", @ApplicationName"); sql.AddParameter("@IsAnonymous", SqlDbType.Bit, IsAnonymous); queryParameters.Append(", @IsAnonymous"); sql.AddParameter("@LastActivityDate", SqlDbType.DateTime, LastActivityDate); queryParameters.Append(", @LastActivityDate"); sql.AddParameter("@LastUpdatedDate", SqlDbType.DateTime, LastUpdatedDate); queryParameters.Append(", @LastUpdatedDate"); string query = String.Format("Insert Into Profiles ({0}) Values ({1})", queryParameters.ToString().Replace("@", ""), queryParameters.ToString()); SqlDataReader reader = sql.ExecuteSqlReader(query); }
public void Create() { SqlService sql = new SqlService(); StringBuilder queryParameters = new StringBuilder(); sql.AddParameter("@OrderId", SqlDbType.Int, Id); queryParameters.Append("@OrderId"); sql.AddParameter("@UserId", SqlDbType.VarChar, UserId); queryParameters.Append(", @UserId"); sql.AddParameter("@OrderDate", SqlDbType.DateTime, OrderDate); queryParameters.Append(", @OrderDate"); sql.AddParameter("@ShipAddr1", SqlDbType.VarChar, ShipAddr1); queryParameters.Append(", @ShipAddr1"); sql.AddParameter("@ShipAddr2", SqlDbType.VarChar, ShipAddr2); queryParameters.Append(", @ShipAddr2"); sql.AddParameter("@ShipCity", SqlDbType.VarChar, ShipCity); queryParameters.Append(", @ShipCity"); sql.AddParameter("@ShipState", SqlDbType.VarChar, ShipState); queryParameters.Append(", @ShipState"); sql.AddParameter("@ShipZip", SqlDbType.VarChar, ShipZip); queryParameters.Append(", @ShipZip"); sql.AddParameter("@ShipCountry", SqlDbType.VarChar, ShipCountry); queryParameters.Append(", @ShipCountry"); sql.AddParameter("@BillAddr1", SqlDbType.VarChar, BillAddr1); queryParameters.Append(", @BillAddr1"); sql.AddParameter("@BillAddr2", SqlDbType.VarChar, BillAddr2); queryParameters.Append(", @BillAddr2"); sql.AddParameter("@BillCity", SqlDbType.VarChar, BillCity); queryParameters.Append(", @BillCity"); sql.AddParameter("@BillState", SqlDbType.VarChar, BillState); queryParameters.Append(", @BillState"); sql.AddParameter("@BillZip", SqlDbType.VarChar, BillZip); queryParameters.Append(", @BillZip"); sql.AddParameter("@BillCountry", SqlDbType.VarChar, BillCountry); queryParameters.Append(", @BillCountry"); sql.AddParameter("@Courier", SqlDbType.VarChar, Courier); queryParameters.Append(", @Courier"); sql.AddParameter("@TotalPrice", SqlDbType.Decimal, TotalPrice); queryParameters.Append(", @TotalPrice"); sql.AddParameter("@BillToFirstName", SqlDbType.VarChar, BillToFirstName); queryParameters.Append(", @BillToFirstName"); sql.AddParameter("@BillToLastName", SqlDbType.VarChar, BillToLastName); queryParameters.Append(", @BillToLastName"); sql.AddParameter("@ShipToFirstName", SqlDbType.VarChar, ShipToFirstName); queryParameters.Append(", @ShipToFirstName"); sql.AddParameter("@ShipToLastName", SqlDbType.VarChar, ShipToLastName); queryParameters.Append(", @ShipToLastName"); sql.AddParameter("@AuthorizationNumber", SqlDbType.Int, AuthorizationNumber); queryParameters.Append(", @AuthorizationNumber"); sql.AddParameter("@Locale", SqlDbType.VarChar, Locale); queryParameters.Append(", @Locale"); string query = String.Format("Insert Into Orders ({0}) Values ({1})", queryParameters.ToString().Replace("@", ""), queryParameters.ToString()); SqlDataReader reader = sql.ExecuteSqlReader(query); }
public void Update() { SqlService sql = new SqlService(); StringBuilder queryParameters = new StringBuilder(); sql.AddParameter("@OrderId", SqlDbType.Int, Id); queryParameters.Append("OrderId = @OrderId"); sql.AddParameter("@UserId", SqlDbType.VarChar, UserId); queryParameters.Append(", UserId = @UserId"); sql.AddParameter("@OrderDate", SqlDbType.DateTime, OrderDate); queryParameters.Append(", OrderDate = @OrderDate"); sql.AddParameter("@ShipAddr1", SqlDbType.VarChar, ShipAddr1); queryParameters.Append(", ShipAddr1 = @ShipAddr1"); sql.AddParameter("@ShipAddr2", SqlDbType.VarChar, ShipAddr2); queryParameters.Append(", ShipAddr2 = @ShipAddr2"); sql.AddParameter("@ShipCity", SqlDbType.VarChar, ShipCity); queryParameters.Append(", ShipCity = @ShipCity"); sql.AddParameter("@ShipState", SqlDbType.VarChar, ShipState); queryParameters.Append(", ShipState = @ShipState"); sql.AddParameter("@ShipZip", SqlDbType.VarChar, ShipZip); queryParameters.Append(", ShipZip = @ShipZip"); sql.AddParameter("@ShipCountry", SqlDbType.VarChar, ShipCountry); queryParameters.Append(", ShipCountry = @ShipCountry"); sql.AddParameter("@BillAddr1", SqlDbType.VarChar, BillAddr1); queryParameters.Append(", BillAddr1 = @BillAddr1"); sql.AddParameter("@BillAddr2", SqlDbType.VarChar, BillAddr2); queryParameters.Append(", BillAddr2 = @BillAddr2"); sql.AddParameter("@BillCity", SqlDbType.VarChar, BillCity); queryParameters.Append(", BillCity = @BillCity"); sql.AddParameter("@BillState", SqlDbType.VarChar, BillState); queryParameters.Append(", BillState = @BillState"); sql.AddParameter("@BillZip", SqlDbType.VarChar, BillZip); queryParameters.Append(", BillZip = @BillZip"); sql.AddParameter("@BillCountry", SqlDbType.VarChar, BillCountry); queryParameters.Append(", BillCountry = @BillCountry"); sql.AddParameter("@Courier", SqlDbType.VarChar, Courier); queryParameters.Append(", Courier = @Courier"); sql.AddParameter("@TotalPrice", SqlDbType.Decimal, TotalPrice); queryParameters.Append(", TotalPrice = @TotalPrice"); sql.AddParameter("@BillToFirstName", SqlDbType.VarChar, BillToFirstName); queryParameters.Append(", BillToFirstName = @BillToFirstName"); sql.AddParameter("@BillToLastName", SqlDbType.VarChar, BillToLastName); queryParameters.Append(", BillToLastName = @BillToLastName"); sql.AddParameter("@ShipToFirstName", SqlDbType.VarChar, ShipToFirstName); queryParameters.Append(", ShipToFirstName = @ShipToFirstName"); sql.AddParameter("@ShipToLastName", SqlDbType.VarChar, ShipToLastName); queryParameters.Append(", ShipToLastName = @ShipToLastName"); sql.AddParameter("@AuthorizationNumber", SqlDbType.Int, AuthorizationNumber); queryParameters.Append(", AuthorizationNumber = @AuthorizationNumber"); sql.AddParameter("@Locale", SqlDbType.VarChar, Locale); queryParameters.Append(", Locale = @Locale"); string query = String.Format("Update Orders Set {0} Where OrderId = @OrderId", queryParameters.ToString()); SqlDataReader reader = sql.ExecuteSqlReader(query); }
public static void Delete(int id) { SqlService sql = new SqlService(); sql.AddParameter("@SuppId", SqlDbType.Int, id); SqlDataReader reader = sql.ExecuteSqlReader("Delete Supplier Where SuppId = @SuppId"); }