private static VendorCollection PrepareNewVendorCollection() { VendorCollection vendors = new VendorCollection(); //不变的 vendors.Add(new Vendor() { Code = "1", Description = "vendor 1", Name = "vendor 1", VendorID = "vendorID1" }); //变化的 vendors.Add(new Vendor() { Code = "2", Description = "vendor 22", Name = "vendor 22", VendorID = "vendorID2" }); //增加的 vendors.Add(new Vendor() { Code = "4", Description = "vendor 4", Name = "vendor 4", VendorID = "vendorID4" }); return(vendors); }
public static Vendor Select(int Id) { VendorCollection vendors = Vendor.Select($"Id = {Id}", "Id"); Vendor vendor = (vendors.Count == 1) ? vendors[0] : null; return(vendor); }
private static VendorCollection PrepareOldVendorCollection() { VendorCollection vendors = new VendorCollection(); vendors.Add(new Vendor() { Code = "1", Description = "vendor 1", Name = "vendor 1", VendorID = "vendorID1" }); vendors.Add(new Vendor() { Code = "2", Description = "vendor 2", Name = "vendor 2", VendorID = "vendorID2" }); //将被删除的 vendors.Add(new Vendor() { Code = "3", Description = "vendor 3", Name = "vendor 3", VendorID = "vendorID3" }); return(vendors); }
public static bool Insert(Product product) { string Sql = string.Format("insert into [product] " + " (VendorId, Name, VendorPartNumber, Price, Unit, PhotoPath) " + " values " + " (@VendorId, @Name, @VendorPartNumber, @Price, @Unit, @PhotoPath)"); //string ConnStr = @"Server=STUDENT05;Database=prs;Trusted_Connection=True;"; SqlCommand Cmd = CreateConnection(ConnStr, Sql, "Connection didn't open"); AddSqlInsertUpdateParameters(Cmd, product); int recsAffected = ExecuteSqlInsUpdDelCommand(Cmd, "Insert failed!"); product.Id = GetLastIdGenerated(ConnStr, "Product"); // get the vendor VendorCollection vendors = Vendor.Select("Id = " + product.VendorId, "Id"); if (vendors.Count > 0) { product.Vendor = vendors[0]; } Cmd.Connection.Close(); return(recsAffected == 1); }
public void CompareSourceEnumerableObjectNullTest() { VendorCollection newVendors = PrepareNewVendorCollection(); ObjectCollectionCompareResult result = ObjectCompareHelper.CompareEnumerableObject(null, newVendors); Assert.IsTrue(result.AreDifferent); Assert.AreEqual(3, result.Added.Count); for (int i = 0; i < newVendors.Count; i++) { Assert.IsNotNull(result.Added[i].FindByNewPropertyValue("Name", newVendors[i].Name)); } }
public void CompareTargetEnumerableObjectNullTest() { VendorCollection oldVendors = PrepareOldVendorCollection(); ObjectCollectionCompareResult result = ObjectCompareHelper.CompareEnumerableObject(oldVendors, null); Assert.IsTrue(result.AreDifferent); Assert.AreEqual(3, result.Deleted.Count); for (int i = 0; i < oldVendors.Count; i++) { Assert.IsNotNull(result.Deleted[i].FindByOldPropertyValue("Name", oldVendors[i].Name)); } }
//Select public static VendorCollection Select(string WhereClause, string OrderByClause) { string Sql = string.Format("SELECT * from [Vendor] WHERE {0} ORDER BY {1}", WhereClause, OrderByClause); string ConnStr = @"Server=STUDENT05;Database=prs;Trusted_Connection=True;"; SqlConnection Conn = new SqlConnection(ConnStr); Conn.Open(); if (Conn.State != System.Data.ConnectionState.Open) { throw new ApplicationException("Connection didn't open"); } SqlCommand Cmd = new SqlCommand(Sql, Conn); SqlDataReader Reader = Cmd.ExecuteReader(); if (!Reader.HasRows) { throw new ApplicationException("Result set has no rows!"); } VendorCollection vendors = new VendorCollection(); while (Reader.Read()) { int id = Reader.GetInt32(Reader.GetOrdinal("Id")); string code = Reader.GetString(Reader.GetOrdinal("Code")); string name = Reader.GetString(Reader.GetOrdinal("Name")); string address = Reader.GetString(Reader.GetOrdinal("Address")); string city = Reader.GetString(Reader.GetOrdinal("City")); string state = Reader.GetString(Reader.GetOrdinal("State")); string zip = Reader.GetString(Reader.GetOrdinal("Zip")); string phone = Reader.GetString(Reader.GetOrdinal("Phone")); string email = Reader.GetString(Reader.GetOrdinal("Email")); bool isRecommended = Reader.GetBoolean(Reader.GetOrdinal("IsRecommended")); Vendor vendor = new Vendor(); vendor.Id = id; vendor.Code = code; vendor.Name = name; vendor.Address = address; vendor.City = city; vendor.State = state; vendor.Zip = zip; vendor.IsRecommended = isRecommended; vendors.Add(vendor); } return(vendors); }
public static VendorCollection LoadForGroup(Int32 groupId, int maximumRows, int startRowIndex, string sortExpression) { //CREATE THE DYNAMIC SQL TO LOAD OBJECT StringBuilder selectQuery = new StringBuilder(); selectQuery.Append("SELECT"); if (maximumRows > 0) { selectQuery.Append(" TOP " + (startRowIndex + maximumRows).ToString()); } selectQuery.Append(" " + Vendor.GetColumnNames("ac_Vendors")); selectQuery.Append(" FROM ac_Vendors, ac_VendorGroups"); selectQuery.Append(" WHERE ac_Vendors.VendorId = ac_VendorGroups.VendorId"); selectQuery.Append(" AND ac_VendorGroups.GroupId = @groupId"); selectQuery.Append(" AND StoreId = @storeId"); if (!string.IsNullOrEmpty(sortExpression)) { selectQuery.Append(" ORDER BY " + sortExpression); } Database database = Token.Instance.Database; DbCommand selectCommand = database.GetSqlStringCommand(selectQuery.ToString()); database.AddInParameter(selectCommand, "@groupId", System.Data.DbType.Int32, groupId); database.AddInParameter(selectCommand, "@storeId", System.Data.DbType.Int32, Token.Instance.StoreId); //EXECUTE THE COMMAND VendorCollection results = new VendorCollection(); int thisIndex = 0; int rowCount = 0; using (IDataReader dr = database.ExecuteReader(selectCommand)) { while (dr.Read() && ((maximumRows < 1) || (rowCount < maximumRows))) { if (thisIndex >= startRowIndex) { Vendor vendor = new Vendor(); Vendor.LoadDataReader(vendor, dr); results.Add(vendor); rowCount++; } thisIndex++; } dr.Close(); } return(results); }
public void CompareEnumerableObjectTest() { VendorCollection oldVendors = PrepareOldVendorCollection(); VendorCollection newVendors = PrepareNewVendorCollection(); ObjectCollectionCompareResult result = ObjectCompareHelper.CompareEnumerableObject(oldVendors, newVendors); Assert.IsTrue(result.AreDifferent); Assert.AreEqual(1, result.Added.Count); Assert.AreEqual(1, result.Updated.Count); Assert.AreEqual(1, result.Deleted.Count); Assert.IsNotNull(result.Updated[0].FindByOldPropertyValue("Name", "vendor 2")); Assert.IsNotNull(result.Updated[0].FindByNewPropertyValue("Name", "vendor 22")); Assert.IsNotNull(result.Added[0].FindByNewPropertyValue("Name", "vendor 4")); Assert.IsNotNull(result.Deleted[0].FindByOldPropertyValue("Name", "vendor 3")); }
public static VendorCollection LoadForCriteria(string sqlCriteria, int maximumRows, int startRowIndex, string sortExpression) { //CREATE THE DYNAMIC SQL TO LOAD OBJECT StringBuilder selectQuery = new StringBuilder(); selectQuery.Append("SELECT"); if (maximumRows > 0) { selectQuery.Append(" TOP " + (startRowIndex + maximumRows).ToString()); } selectQuery.Append(" " + Vendor.GetColumnNames(string.Empty)); selectQuery.Append(" FROM ac_Vendors"); string whereClause = string.IsNullOrEmpty(sqlCriteria) ? string.Empty : " WHERE " + sqlCriteria; selectQuery.Append(whereClause); if (!string.IsNullOrEmpty(sortExpression)) { selectQuery.Append(" ORDER BY " + sortExpression); } Database database = Token.Instance.Database; DbCommand selectCommand = database.GetSqlStringCommand(selectQuery.ToString()); //EXECUTE THE COMMAND VendorCollection results = new VendorCollection(); int thisIndex = 0; int rowCount = 0; using (IDataReader dr = database.ExecuteReader(selectCommand)) { while (dr.Read() && ((maximumRows < 1) || (rowCount < maximumRows))) { if (thisIndex >= startRowIndex) { Vendor vendor = new Vendor(); Vendor.LoadDataReader(vendor, dr); results.Add(vendor); rowCount++; } thisIndex++; } dr.Close(); } return(results); }
public VendorCollection GetAllVendorsDynamicCollection(string whereExpression, string orderBy) { IDBManager dbm = new DBManager(); VendorCollection cols = new VendorCollection(); try { dbm.CreateParameters(2); dbm.AddParameters(0, "@WhereCondition", whereExpression); dbm.AddParameters(1, "@OrderByExpression", orderBy); IDataReader reader = dbm.ExecuteReader(CommandType.StoredProcedure, "SelectVendorsDynamic"); while (reader.Read()) { Vendor vendor = new Vendor(); vendor.VendorID = Int32.Parse(reader["VendorID"].ToString()); vendor.AddressID = Int32.Parse(reader["AddressID"].ToString()); vendor.ActiveFlag = bool.Parse(reader["ActiveFlag"].ToString()); vendor.ContactName = reader["ContactName"].ToString(); vendor.AccountNumber = reader["AccountNumber"].ToString(); vendor.CreditRating = byte.Parse(reader["CreditRating"].ToString()); vendor.PreferredVendorStatus = bool.Parse(reader["PreferredVendorStatus"].ToString()); vendor.Name = reader["Name"].ToString(); vendor.Email = reader["Email"].ToString(); vendor.Phone = reader["Phone"].ToString(); vendor.Fax = reader["Fax"].ToString(); vendor.ModifiedDate = DateTime.Parse(reader["ModifiedDate"].ToString()); vendor.AltPhone = reader["AltPhone"].ToString(); vendor.Terms = reader["Terms"].ToString(); cols.Add(vendor); } } catch (Exception ex) { log.Write(ex.Message, "GetAllVendorsDynamicCollection"); throw (ex); } finally { dbm.Dispose(); } return(cols); }
public VendorCollection GetAllVendorsCollection() { IDBManager dbm = new DBManager(); VendorCollection cols = new VendorCollection(); try { IDataReader reader = dbm.ExecuteReader(CommandType.StoredProcedure, "SelectVendorsAll"); while (reader.Read()) { Vendor vendor = new Vendor(); vendor.VendorID = Int32.Parse(reader["VendorID"].ToString()); vendor.ActiveFlag = Boolean.Parse(reader["ActiveFlag"].ToString()); vendor.ContactName = reader["ContactName"].ToString(); vendor.AccountNumber = reader["AccountNumber"].ToString(); vendor.CreditRating = Byte.Parse(reader["CreditRating"].ToString()); vendor.PreferredVendorStatus = Boolean.Parse(reader["PreferredVendorStatus"].ToString()); vendor.Name = reader["Name"].ToString(); vendor.Email = reader["Email"].ToString(); vendor.Phone = reader["Phone"].ToString(); vendor.Fax = reader["Fax"].ToString(); vendor.AddressID = Int32.Parse(reader["AddressID"].ToString()); vendor.ModifiedDate = DateTime.Parse(reader["ModifiedDate"].ToString()); vendor.AltPhone = reader["AltPhone"].ToString(); vendor.Terms = reader["Terms"].ToString(); cols.Add(vendor); } } catch (Exception ex) { log.Write(ex.Message, "GetAllVendorsCollection"); throw (ex); } finally { dbm.Dispose(); } return(cols); }
private string GetVendorName(int VendorId) { string ret = ""; VendorCollection vend = (VendorCollection)cmbPrimaryVendor.DataSource; foreach (Vendor v in vend) { if (v.VendorID == VendorId) { ret = v.Name; } } // DataSet dt = (DataSet)cmbPrimaryVendor.DataSource; //for (int i = 0; i < dt.Tables[0].Rows.Count; i++) //{ // if (VendorId == Int32.Parse(dt.Tables[0].Rows[i]["VendorId"].ToString())) // { // ret = dt.Tables[0].Rows[i]["Name"].ToString(); // } //} return(ret); }
private void LoadVendors(int PrimaryVendor, int SecondaryVendor) { Vendor v = new Vendor(); VendorCollection Primary = new VendorCollection(); VendorCollection Secondary = new VendorCollection(); try { Primary = v.GetAllVendorsCollection(); //Secondary = v.GetAllVendorsCollection(); Primary.Insert(0, new Vendor(0, 0, "", "<Select One>", "", 1, false, "", "", "", false, DateTime.Today, "", "")); cmbPrimaryVendor.DataSource = Primary; cmbPrimaryVendor.DisplayMember = "Name"; cmbPrimaryVendor.ValueMember = "VendorId"; foreach (Vendor vend in Primary) { Secondary.Add(vend); } //Primary.Insert(0, new Vendor(0, 0, "", "<Select One>", "", 1, false, "", "", "", false, DateTime.Today, "", "")); cmbSecondaryVendor.DataSource = Secondary; cmbSecondaryVendor.DisplayMember = "Name"; cmbSecondaryVendor.ValueMember = "VendorId"; } catch (Exception ex) { log.Write(ex.Message, ""); MessageBox.Show(ex.Message); } finally { v = null; Primary = null; Secondary = null; } }
private static VendorCollection PrepareNewVendorCollection() { VendorCollection vendors = new VendorCollection(); //不变的 vendors.Add(new Vendor() { Code = "1", Description = "vendor 1", Name = "vendor 1", VendorID = "vendorID1" }); //变化的 vendors.Add(new Vendor() { Code = "2", Description = "vendor 22", Name = "vendor 22", VendorID = "vendorID2" }); //增加的 vendors.Add(new Vendor() { Code = "4", Description = "vendor 4", Name = "vendor 4", VendorID = "vendorID4" }); return vendors; }
private static VendorCollection PrepareOldVendorCollection() { VendorCollection vendors = new VendorCollection(); vendors.Add(new Vendor() { Code = "1", Description = "vendor 1", Name = "vendor 1", VendorID = "vendorID1" }); vendors.Add(new Vendor() { Code = "2", Description = "vendor 2", Name = "vendor 2", VendorID = "vendorID2" }); //将被删除的 vendors.Add(new Vendor() { Code = "3", Description = "vendor 3", Name = "vendor 3", VendorID = "vendorID3" }); return vendors; }
static void Main(string[] args) { string ConnStr = @"Server=STUDENT05;Database=prs;Trusted_Connection=True;"; SqlConnection Conn = new SqlConnection(ConnStr); Conn.Open(); if (Conn.State != System.Data.ConnectionState.Open) { throw new ApplicationException("Connection didn't open"); } // //insert // string SqlInsert = @"insert [user] (UserName, Password, FirstName, LastName, Phone, Email, IsAdmin, IsReviewer) //values(@username, @password, @firstname, @lastname, @phone, @email, @isadmin, @isreviewer)"; // SqlCommand CmdInsert = new SqlCommand(SqlInsert, Conn); // creating new command' // CmdInsert.Parameters.Add(new SqlParameter("@username", "acobb")); // CmdInsert.Parameters.Add(new SqlParameter("@isadmin", "1")); // CmdInsert.Parameters.Add(new SqlParameter("@password", "password")); // CmdInsert.Parameters.Add(new SqlParameter("@firstname", "alex")); // CmdInsert.Parameters.Add(new SqlParameter("@lastname", "cobb")); // CmdInsert.Parameters.Add(new SqlParameter("@phone", "513-592-0744")); // CmdInsert.Parameters.Add(new SqlParameter("@email", "*****@*****.**")); // CmdInsert.Parameters.Add(new SqlParameter("@isreviewer", "1")); // int recsAffected = CmdInsert.ExecuteNonQuery(); // if(recsAffected != 1) { // checking if the operation works // throw new ApplicationException("Insert failed!"); // } //Select - using UserCollection class string whereClause = "Id = 3"; string orderByClause = "Username desc"; UserCollection users = User.Select(whereClause, orderByClause); User user = users[0]; user.FirstName = "Alex"; bool success = User.Update(user); success = User.Delete(user); //Insert function User user2Insert = new User { UserName = "******", Password = "******", FirstName = "alex", LastName = "cobb", Phone = "5135920744", Email = "*****@*****.**", IsReviewer = false, IsAdmin = false }; success = User.Insert(user2Insert); VendorCollection vendors = Vendor.Select("1 - 1", "Id"); Vendor vendor = new Vendor { Code = "Krog0002", Name = "Kroger", Address = "123 Any St.", City = "Cincinnati", State = "OH", Zip = "45201", Email = "*****@*****.**", Phone = "513-555-1212", IsRecommended = true }; bool rc = Vendor.Insert(vendor); vendors = Vendor.Select("Code = 'Krog0001'", "Code"); vendor = vendors[0]; vendor.Code = "KROG1111"; rc = Vendor.Update(vendor); rc = Vendor.Delete(vendor); int i = 0; }
/// <summary> /// Generates mail messages for this email template /// </summary> /// <returns>An array of MailMessage objects generated</returns> public MailMessage[] GenerateMailMessages() { //BUILD AN ARRAY OF MESSAGES TO BE SENT List <MailMessage> messages = new List <MailMessage>(); NVelocityEngine velocityEngine = NVelocityEngine.Instance; //PARSE THE ADDRESSES bool hasVendor; List <MailAddress> addressList = this.ParseAddresses(this.ToAddress, out hasVendor); List <MailAddress> ccList = this.ParseAddresses(this.CCList); List <MailAddress> bccList = this.ParseAddresses(this.BCCList); //CHECK FOR TO ADDRESSES if (addressList.Count > 0) { //BUILD MESSAGE GOING TO SPECIFIC ADDRESSES MailMessage mailMessage = new MailMessage(); //ADD TO ADDRESSES foreach (MailAddress item in addressList) { mailMessage.To.Add(item); } //ADD CC ADDRESSES foreach (MailAddress item in ccList) { mailMessage.CC.Add(item); } //ADD BCC ADDRESSES foreach (MailAddress item in bccList) { mailMessage.Bcc.Add(item); } //SET FROM ADDRESS mailMessage.From = new MailAddress(this.FromAddress); //PROCESS THE SUBJECT AND BODY mailMessage.Subject = velocityEngine.Process(this.Parameters, this.Subject); mailMessage.Body = velocityEngine.Process(this.Parameters, this.Body); mailMessage.IsBodyHtml = this.IsHTML; messages.Add(mailMessage); } //PROCESS VENDOR MESSAGES IF WE HAVE AN ORDER CONTEXT if (hasVendor && this.Parameters.ContainsKey("order")) { Order order = (Order)this.Parameters["order"]; //DECIDE WHICH VENDORS NEED TO HAVE MESSAGES COMPILED VendorCollection vendors = VendorDataSource.LoadForOrder(order.OrderId); if (vendors.Count > 0) { //VENDORS ARE FOUND, WE MUST COMPILE ONE MESSAGE FOR EACH VENDOR foreach (Vendor vendor in vendors) { List <string> emailList = GetValidEmailList(vendor.Email); if (emailList != null && emailList.Count > 0) { //BUILD VENDOR SPECIFIC ITEM COLLECTIONS OrderItemCollection vendorItems = new OrderItemCollection(); OrderItemCollection vendorNonShippingItems = new OrderItemCollection(); foreach (OrderItem item in order.Items) { if (item.Product != null) { //SEE IF THIS IS A PRODUCT THAT BELONGS TO THE VENDOR if (item.Product.VendorId == vendor.VendorId) { vendorItems.Add(item); if (item.OrderShipmentId == 0) { vendorNonShippingItems.Add(item); } } } else { //SEE IF THIS IS A NON-PRODUCT ITEM THAT APPLIES //E.G. A DISCOUNT ON A VENDOR ITEM if (vendorItems.IndexOf(item.ParentItemId) > -1) { vendorItems.Add(item); if (item.OrderShipmentId == 0) { vendorNonShippingItems.Add(item); } } } } //BUILD VENDOR SPECIFIC SHIPMENT COLLECTION OrderShipmentCollection vendorShipments = new OrderShipmentCollection(); foreach (OrderItem item in vendorItems) { if ((item.OrderShipment != null) && (vendorShipments.IndexOf(item.OrderShipmentId) < 0)) { vendorShipments.Add(item.OrderShipment); } } //CREATE VENDOR SPECIFIC PARAMETERS Hashtable vendorParameters = new Hashtable(this.Parameters); vendorParameters["Vendor"] = vendor; vendorParameters["VendorShipments"] = vendorShipments; vendorParameters["VendorItems"] = vendorItems; vendorParameters["VendorNonShippingItems"] = vendorNonShippingItems; //COMPILE VENDOR SPECIFIC MAIL MESSAGE MailMessage mailMessage = new MailMessage(); //ADD TO ADDRESSES foreach (string email in emailList) { mailMessage.To.Add(email); } //ADD CC ADDRESSES foreach (MailAddress item in ccList) { mailMessage.CC.Add(item); } //ADD BCC ADDRESSES foreach (MailAddress item in bccList) { mailMessage.Bcc.Add(item); } //SET FROM ADDRESS mailMessage.From = new MailAddress(this.FromAddress); //PROCESS THE SUBJECT AND BODY mailMessage.Subject = velocityEngine.Process(vendorParameters, this.Subject); mailMessage.Body = velocityEngine.Process(vendorParameters, this.Body); mailMessage.IsBodyHtml = this.IsHTML; messages.Add(mailMessage); } else { Logger.Warn("Could not process vendor notification for '" + vendor.Name + "'; email address is invalid."); } } } } else if (hasVendor && this.Parameters.ContainsKey("vendors")) { Vendor[] vendors = (Vendor[])this.Parameters["vendors"]; Product[] products = (Product[])this.Parameters["products"]; ProductVariant[] variants = (ProductVariant[])this.Parameters["variants"]; if (vendors != null && vendors.Length > 0) { foreach (Vendor vendor in vendors) { List <string> emailList = GetValidEmailList(vendor.Email); if (emailList != null && emailList.Count > 0) { List <Product> vendorProducts = new List <Product>(); List <ProductVariant> vendorVariants = new List <ProductVariant>(); if (products != null) { foreach (Product product in products) { if (product.Vendor != null && product.VendorId == vendor.VendorId) { vendorProducts.Add(product); } } } if (variants != null) { foreach (ProductVariant variant in variants) { if (variant.Product.Vendor != null && variant.Product.Vendor.VendorId == vendor.VendorId) { vendorVariants.Add(variant); } } } //CREATE VENDOR SPECIFIC PARAMETERS Hashtable vendorParameters = new Hashtable(this.Parameters); vendorParameters["vendor"] = vendor; vendorParameters["products"] = vendorProducts; vendorParameters["variants"] = vendorVariants; //COMPILE VENDOR SPECIFIC MAIL MESSAGE MailMessage mailMessage = new MailMessage(); //ADD TO ADDRESSES foreach (string email in emailList) { mailMessage.To.Add(email); } //ADD CC ADDRESSES foreach (MailAddress item in ccList) { mailMessage.CC.Add(item); } //ADD BCC ADDRESSES foreach (MailAddress item in bccList) { mailMessage.Bcc.Add(item); } //SET FROM ADDRESS mailMessage.From = new MailAddress(this.FromAddress); //PROCESS THE SUBJECT AND BODY mailMessage.Subject = velocityEngine.Process(vendorParameters, this.Subject); mailMessage.Body = velocityEngine.Process(vendorParameters, this.Body); mailMessage.IsBodyHtml = this.IsHTML; messages.Add(mailMessage); } else { Logger.Warn("Could not process vendor notification for '" + vendor.Name + "'; email address is invalid."); } } } } //RETURN THE GENERATED MAIL MESSAGE if (messages.Count == 0) { return(null); } return(messages.ToArray()); }
static void Main(string[] args) { // Select string whereClause = "LastName = 'Cobb'"; string orderByClause = "UserName desc"; UserCollection users = User.Select(whereClause, orderByClause); User user = users[0]; user.FirstName = "Alex"; bool success = User.Update(user); success = User.Delete(user); User user2Insert = new User { UserName = "******", Password = "******", FirstName = "Nbr 88", LastName = "Cobb", Phone = "513-555-1212", Email = "*****@*****.**", IsReviewer = false, IsAdmin = false }; success = User.Insert(user2Insert); VendorCollection vendors = Vendor.Select("1 = 1", "Id"); Vendor vendor = new Vendor { Code = "Krog0010", Name = "Kroger", Address = "123 Any Street", City = "Cincinnati", State = "OH", Zip = "45201", Email = "*****@*****.**", Phone = "513-555-1212", IsRecommended = true }; bool rc = Vendor.Insert(vendor); vendor.Code = "KROG1111"; rc = Vendor.Update(vendor); rc = Vendor.Delete(vendor); ProductCollection products = Product.Select("1 = 1", "Id"); Product product = new Product { VendorId = 2, Name = "Widget1", VendorPartNumber = "BWidget", Price = 12345.67M, Unit = "Each", PhotoPath = "http://www.maxtrain.com" }; rc = Product.Insert(product); product.Price = 76543.21m; rc = Product.Update(product); rc = Product.Delete(product); PurchaseRequestCollection purchaseRequests = PurchaseRequest.Select("1 = 1", "Id"); PurchaseRequest purchaseRequest = new PurchaseRequest(); purchaseRequest.UserId = 1; purchaseRequest.Description = "My first purchase request"; purchaseRequest.Justification = "My birthday"; purchaseRequest.DateNeeded = DateTime.Now; purchaseRequest.DeliveryMode = "USPS"; purchaseRequest.DocsAttached = false; purchaseRequest.Status = "New"; //purchaseRequest.Total = 0.0M; //purchaseRequest.SubmittedDate = DateTime.Now; rc = PurchaseRequest.Insert(purchaseRequest); purchaseRequest.DateNeeded = DateTime.Now.AddDays(1); rc = PurchaseRequest.Update(purchaseRequest); purchaseRequests = PurchaseRequest.Select("1 = 1", "Id"); rc = PurchaseRequest.Delete(purchaseRequest); purchaseRequests = PurchaseRequest.Select("1 = 1", "Id"); //LineItemCollection lineitems = LineItem.Select("1 = 1", "Id"); //LineItem lineitem = new LineItem { // PurchaseRequestId = 3, // ProductId = 3, // Quantity = 1 //}; //rc = LineItem.Insert(lineitem); //PurchaseRequest NewPurchaseRequest = new PurchaseRequest { // UserId = 2, // Description = "First full add of PR", // Justification = "I just want to" //}; //rc = PurchaseRequest.Insert(NewPurchaseRequest); //rc = NewPurchaseRequest.AddLineItem(1, 10); //rc = NewPurchaseRequest.AddLineItem(2, 20); //rc = NewPurchaseRequest.AddLineItem(3, 30); PurchaseRequest NewPurchaseRequest = PurchaseRequest.Select(12); //rc = NewPurchaseRequest.UpdateLineItem(5, 11); int i = 0; }