public void Insert(string CustomerID,int EmployeeID,DateTime OrderDate,DateTime? RequiredDate,DateTime? ShippedDate,int? ShipVia,decimal? Freight,string ShipName,string ShipAddress,string ShipCity,string ShipRegion,string ShipPostalCode,string ShipCountry)
	    {
		    Order item = new Order();
		    
            item.CustomerID = CustomerID;
            
            item.EmployeeID = EmployeeID;
            
            item.OrderDate = OrderDate;
            
            item.RequiredDate = RequiredDate;
            
            item.ShippedDate = ShippedDate;
            
            item.ShipVia = ShipVia;
            
            item.Freight = Freight;
            
            item.ShipName = ShipName;
            
            item.ShipAddress = ShipAddress;
            
            item.ShipCity = ShipCity;
            
            item.ShipRegion = ShipRegion;
            
            item.ShipPostalCode = ShipPostalCode;
            
            item.ShipCountry = ShipCountry;
            
	    
		    item.Save(UserName);
	    }
Beispiel #2
0
	    public void Update(int OrderID,string CustomerID,int? EmployeeID,DateTime? OrderDate,DateTime? RequiredDate,DateTime? ShippedDate,int? ShipVia,float? Freight,string ShipName,string ShipAddress,string ShipCity,string ShipRegion,string ShipPostalCode,string ShipCountry)
	    {
		    Order item = new Order();
	        item.MarkOld();
	        item.IsLoaded = true;
		    
			item.OrderID = OrderID;
				
			item.CustomerID = CustomerID;
				
			item.EmployeeID = EmployeeID;
				
			item.OrderDate = OrderDate;
				
			item.RequiredDate = RequiredDate;
				
			item.ShippedDate = ShippedDate;
				
			item.ShipVia = ShipVia;
				
			item.Freight = Freight;
				
			item.ShipName = ShipName;
				
			item.ShipAddress = ShipAddress;
				
			item.ShipCity = ShipCity;
				
			item.ShipRegion = ShipRegion;
				
			item.ShipPostalCode = ShipPostalCode;
				
			item.ShipCountry = ShipCountry;
				
	        item.Save(UserName);
	    }