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 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 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 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 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 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("@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 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 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("@SuppId", SqlDbType.Int, id);
SqlDataReader reader = sql.ExecuteSqlReader("Delete Supplier Where SuppId = @SuppId");
}
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("@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);
}
