Example #1
0
		public void ExecuteNonQuery()
		{
			OrderBusinessContext businessContext = new OrderBusinessContext(UserId, CityId, connStr);

			Order o = new Order();
			o.Title = CustomerA + "'s Order";
			o.CustomerName = CustomerA;

			using (IEntityContext entityContext = businessContext.CreateEntityContext())
			{
				entityContext.Add<Order>(o);

				Assert.IsTrue(o.OrderID > 0);
			}

			using (IEntityContext entityContext = businessContext.CreateEntityContext())
			{
				entityContext.ExecuteNonQuery("delete from [" + entityContext.GetMappingToTable(typeof(Order)) + "] where OrderID = @p0", o.OrderID);

				Order order = entityContext.FindByPrimaryKey<Order>(o.OrderID);

				Assert.IsNull(order);

				Dictionary<string, object> parameters = new Dictionary<string, object>();
				parameters["OrderID"] = o.OrderID;
				Assert.IsTrue(0 == entityContext.ExecuteNonQuery("delete from [" + entityContext.GetMappingToTable(typeof(Order)) + "] where OrderID = @OrderID", parameters));
			}
		}
Example #2
0
		public void ExecuteList_Paged()
		{
			OrderBusinessContext businessContext = new OrderBusinessContext(UserId, CityId, connStr);

			using (IEntityContext entityContext = businessContext.CreateEntityContext())
			{
				List<Order> orders = entityContext.ExecuteList<Order>("OrderID,Title,CustomerName,TS", "CustomerName=@p0 or CustomerName=@p1", "CustomerName desc", 2, 5, new object[] { CustomerA, CustomerB });

				Assert.IsTrue(orders.Count >= 0 && orders.Count <= 5);

				Dictionary<string, object> parameters = new Dictionary<string, object>();
				parameters["CustomerName1"] = CustomerA;
				parameters["CustomerName2"] = CustomerB;
				orders = entityContext.ExecutePagedList<Order>("OrderID,Title,CustomerName,TS", "CustomerName=@CustomerName1 or CustomerName=@CustomerName2", "CustomerName desc", 2, 5, parameters);

				Assert.IsTrue(orders.Count >= 0 && orders.Count <= 5);
			}

		}
Example #3
0
		public void QueryableDataSource()
		{
			OrderBusinessContext businessContext = new OrderBusinessContext(UserId, CityId, connStr);

			using (IEntityContext entityContext = businessContext.CreateEntityContext())
			{
				IQueryable<Order> queryable = entityContext.GetQueryableDataSource<Order>();

				List<Order> orders1 = queryable
					.OrderByDescending(order => order.CustomerName)
					.ThenBy(order => order.OrderID)
					.Where(order => order.CustomerName == CustomerA || order.CustomerName == CustomerB )
					.Skip(10).Take(5).ToList();

				Assert.IsTrue(orders1.Count >= 0 && orders1.Count <= 5);

				List<Order> orders2 = (from order in queryable
									   where order.CustomerName == CustomerA || order.Title == CustomerB
									   orderby order.CustomerName descending, order.OrderID ascending
									   select order
								 )
								.Skip(10).Take(5).ToList();

				Assert.IsTrue(orders2.Count >= 0 && orders2.Count <= 5);
			}
		}
Example #4
0
		public void FindByProperty()
		{
			OrderBusinessContext businessContext = new OrderBusinessContext(UserId, CityId, connStr);
			using (IEntityContext entityContext = businessContext.CreateEntityContext())
			{
				List<Order> orders = entityContext.FindByProperty<Order>("CustomerName", CustomerA);

				Assert.IsTrue(orders.Count > 0);
			}
		}
Example #5
0
		public void FindByAny()
		{
			OrderBusinessContext businessContext = new OrderBusinessContext(UserId, CityId, connStr);

			List<KeyValuePair<string, object>> propertyValues = new List<KeyValuePair<string, object>>();
			propertyValues.Add(new KeyValuePair<string, object>("CustomerName", CustomerA));
			propertyValues.Add(new KeyValuePair<string, object>("CustomerName", CustomerB));

			using (IEntityContext entityContext = businessContext.CreateEntityContext())
			{
				List<Order> orders = entityContext.FindByAny<Order>(propertyValues);

				Assert.IsTrue(orders.Count >= 0);
			}
		}
Example #6
0
		public void Update2()
		{
			OrderBusinessContext businessContext = new OrderBusinessContext(UserId, CityId, connStr);

			Order o = new Order();
			o.Title = CustomerA + "'s Order";
			o.CustomerName = CustomerA;

			using (IEntityContext entityContext = businessContext.CreateEntityContext())
			{
				entityContext.Add<Order>(o);

				Assert.IsTrue(o.OrderID > 0);

				Order o2 = new Order();
				o2.CustomerName = CustomerB;
				o2.OrderID = o.OrderID;
				o2.Title = o.Title;

				entityContext.Update(o2);
			}

			using (IEntityContext entityContext = businessContext.CreateEntityContext())
			{
				Order order = entityContext.FindByPrimaryKey<Order>(o.OrderID);

				Assert.IsNotNull(order);
				Assert.AreEqual(order.CustomerName, CustomerB);
			}
		}
Example #7
0
		public void FindByPrimaryKey()
		{
			OrderBusinessContext businessContext = new OrderBusinessContext(UserId, CityId, connStr);

			Order o = new Order();
			o.Title = CustomerA + "'s Order";
			o.CustomerName = CustomerA;

			using (IEntityContext entityContext = businessContext.CreateEntityContext())
			{
				entityContext.Add<Order>(o);

				Assert.IsTrue(o.OrderID > 0);
			}

			using (IEntityContext entityContext = businessContext.CreateEntityContext())
			{
				Order order = entityContext.FindByPrimaryKey<Order>(o.OrderID);

				Assert.IsNotNull(order);
			}
		}
Example #8
0
		public void Transaction3()
		{
			OrderBusinessContext businessContext = new OrderBusinessContext(UserId, CityId, connStr);

			Order o2 = new Order();
			o2.Title = CustomerA + "'s Order";
			o2.CustomerName = CustomerA;

			using (IEntityContext entityContext = businessContext.CreateEntityContext())
			{
				Order o1 = entityContext.FindByPrimaryKey<Order>(4);

				entityContext.Delete<Order>(o1);
				
				entityContext.BeginTransaction();
				try
				{
					o1.CustomerName = "test delete";

					entityContext.Update<Order>(o1);
					
					entityContext.Add<Order>(o2);


					entityContext.Commit();
				}
				catch (Exception err)
				{
					entityContext.Rollback();
					throw err;
				}

				Assert.IsTrue(o2.OrderID > 0);
			}
		}
Example #9
0
		public void Update()
		{
			OrderBusinessContext businessContext = new OrderBusinessContext(UserId, CityId, connStr);

			Order o = new Order();
			o.Title = CustomerA + "'s Order";
			o.CustomerName = CustomerA;

			using (IEntityContext entityContext = businessContext.CreateEntityContext())
			{
				entityContext.BeginTransaction();
				try
				{
					entityContext.Add<Order>(o);

					Assert.IsTrue(o.OrderID > 0);

					o.CustomerName = CustomerB;
					entityContext.Update(o);

					entityContext.Commit();
				}
				catch
				{
					entityContext.Rollback();
				}
			}

			using (IEntityContext entityContext = businessContext.CreateEntityContext())
			{
				Order order = entityContext.FindByPrimaryKey<Order>(o.OrderID);

				Assert.IsNotNull(order);
				Assert.AreEqual(order.CustomerName, CustomerB);
			}
		}
Example #10
0
		public void Transaction()
		{
			OrderBusinessContext businessContext = new OrderBusinessContext(UserId, CityId, connStr);

			Order o1 = new Order();
			o1.Title = CustomerA + "'s Order";
			o1.CustomerName = CustomerA;

			Order o2 = new Order();
			o2.Title = "Test";
			o2.CustomerName = CustomerB;

			using (IEntityContext entityContext = businessContext.CreateEntityContext())
			{
				o1 = entityContext.FindByPrimaryKey<Order>(88);

				entityContext.BeginTransaction();
				try
				{
					//o1.CustomerName = "test11";

					//entityContext.Update<Order>(o1);

					entityContext.Add<Order>(o2);

					entityContext.Commit();
				}
				catch (Exception err)
				{
					entityContext.Rollback();
					throw err;
				}
			}

			using (IEntityContext entityContext = businessContext.CreateEntityContext())
			{
				Order order = entityContext.FindByPrimaryKey<Order>(o2.OrderID);
			}
		}
Example #11
0
		public void DataTabaleAdapterTest()
		{
			OrderBusinessContext businessContext = new OrderBusinessContext(UserId, CityId, connStr);

			Order o1 = new Order();
			o1.Title = CustomerA + "'s Order";
			o1.CustomerName = CustomerA;

			Order o2 = new Order();
			o2.Title = CustomerA + "'s Order";
			o2.CustomerName = CustomerA;

			using (IEntityContext entityContext = businessContext.CreateEntityContext())
			{
				o1 = entityContext.FindByPrimaryKey<Order>(3);

				entityContext.BeginTransaction();
				try
				{
					//entityContext.Add<Order>(o1);

					entityContext.Add<Order>(o2);

					DataTable table = null;
					XMS.Core.Data.DataTableAdapter adapter = entityContext.CreateDataTableAdapter();

					table = new DataTable(entityContext.GetPartitionTableName("Order"));
					adapter.SetSelectCommand("select * from " + entityContext.GetPartitionTableName("Order")).Fill(table);

					for (int i = 0; i < table.Rows.Count; i++)
					{
						if (table.Rows[i]["OrderId"].ToString() != "3")
						{
							table.Rows[i]["Title"] = table.Rows[i]["Title"].ToString() + i.ToString();
						}
					}
					adapter.BuildCommands().Update(table);



					if (table != null)
					{
						XMS.Core.Data.DataTableAdapter adapter2 = entityContext.CreateDataTableAdapter();

						for (int i = 0; i < table.Rows.Count; i++)
						{
							if (table.Rows[i]["OrderId"].ToString() != "3")
							{
								table.Rows[i]["CustomerName"] = table.Rows[i]["CustomerName"].ToString() + i.ToString();
							}
							//if ((int)table.Rows[i]["OrderId"] > 10)
							//{
							//    table.Rows[i].Delete();
							//}
						}

						//adapter2.SetUpdateCommand("update " + entityContext.GetPartitionTableName("Order") + " set Title=@Title,CustomerName=@CustomerName,A=@A where OrderId=@OrderId",
						//"Title", "CustomerName", "OrderId", "TS", "A", "I"
						//);
						//adapter2.SetDeleteCommand("delete from " + entityContext.GetPartitionTableName("Order") + " where OrderId=@OrderId", "OrderId");

						adapter2.SetUpdateCommand("update " + entityContext.GetPartitionTableName("Order") + " set Title=@Title,CustomerName=@CustomerName,A=@A where OrderId=@OrderId",
							new System.Data.Common.DbParameter[]{
									adapter2.CreateParameter("Title", DbType.String, 100),
									adapter2.CreateParameter("@CustomerName", DbType.String, 200),
									adapter2.CreateParameter("@A", DbType.String, 1000),
									adapter2.CreateParameter("OrderId", DbType.Int32)
								});

						adapter2.SetDeleteCommand("delete from " + entityContext.GetPartitionTableName("Order") + " where OrderId=@OrderId",
							new System.Data.Common.DbParameter[]{
									adapter2.CreateParameter("OrderId", DbType.Int32)
								});

						Dictionary<string, object> parameters = new Dictionary<string, object>();
						parameters["Title"] = null;
						parameters["CustomerName"] = null;
						parameters["OrderId"] = null;
						parameters["TS"] = null;
						parameters["A"] = null;

						//adapter2.SetUpdateCommand("update " + entityContext.GetPartitionTableName("Order") + " set Title=@Title,CustomerName=@CustomerName where OrderId=@OrderId",
						//    new System.Data.Common.DbParameter[]{
						//    XMS.Core.Data.DataTableAdapter.CreateParameter("@Title", SqlDbType.NVarChar, 32),
						//    XMS.Core.Data.DataTableAdapter.CreateParameter("@CustomerName", SqlDbType.NVarChar, 64),
						//    XMS.Core.Data.DataTableAdapter.CreateParameter("@OrderId", SqlDbType.Int),
						//    XMS.Core.Data.DataTableAdapter.CreateParameter("@TS", SqlDbType.Binary)
						//    }
						//    );

						//XMS.Core.Data.DataTableAdapter.AssignParameterValues(adapter2.UpdateCommand.Parameters, table.Rows[0]);

						adapter2.Update(table);
					}

					o1.CustomerName = "test";

					entityContext.Update<Order>(o1);

					//o1.CustomerName = CustomerB;
					//entityContext.Update(o1);

					entityContext.Commit();
				}
				catch (Exception err)
				{
					entityContext.Rollback();
					throw err;
				}

				Order order = entityContext.FindByPrimaryKey<Order>(o1.OrderID);

				//Assert.IsNotNull(order);
				//Assert.AreEqual(order.CustomerName, CustomerB);
			}

			using (IEntityContext entityContext = businessContext.CreateEntityContext())
			{
				Order order = entityContext.FindByPrimaryKey<Order>(o1.OrderID);

				Assert.IsNotNull(order);
				Assert.AreEqual(order.CustomerName, CustomerB);
			}
		}
Example #12
0
		public void Add()
		{
			bool exists = false;

			OrderBusinessContext businessContext = new OrderBusinessContext(UserId, CityId, connStr);
			using (IEntityContext entityContext = businessContext.CreateEntityContext())
			{
				exists = entityContext.IsTableExists(typeof(Order));

				exists = entityContext.IsDatabaseExists();

				Order o = new Order();
				o.Title = CustomerA + "'s Order";
				o.CustomerName = CustomerA;

				entityContext.Add<Order>(o);

				List<OrderEx> orders = entityContext.ExecuteList<OrderEx>("select * from " + entityContext.GetMappingToTable(typeof(Order)));

				Assert.IsTrue(orders.Count > 0);

				Assert.IsTrue(o.OrderID > 0);
			}

			using (IEntityContext entityContext = businessContext.CreateEntityContext())
			{
				GroupMessage message = new GroupMessage();
				message.Title = "test";
				message.Content = "testtest";
				message.From = UserId;
				message.To = "all";
				message.SendTime = DateTime.Now;
				message.ValidPeriodFrom = DateTime.Now;
				message.ValidPeriodTo = DateTime.Now.AddYears(1);
				message.IsDeleted = false;

				entityContext.Add<GroupMessage>(message);

				Assert.IsTrue(message.ID > 0);
			}
		}
Example #13
0
		public void ExecuteList()
		{
			OrderBusinessContext businessContext = new OrderBusinessContext(UserId, CityId, connStr);

			using (IEntityContext entityContext = businessContext.CreateEntityContext())
			{
				List<int> list = entityContext.ExecuteList<int>("select OrderID from [" + entityContext.GetMappingToTable(typeof(Order)) + "] where CustomerName = @p0", CustomerA);

				Assert.IsTrue(list.Count >= 0);

				Dictionary<string, object> parameters = new Dictionary<string, object>();
				parameters["CustomerName"] = CustomerA;

				list = entityContext.ExecuteList<int>("select OrderID from [" + entityContext.GetMappingToTable(typeof(Order)) + "] where CustomerName = @CustomerName", parameters);

				Assert.IsTrue(list.Count >= 0);
			}
		}
Example #14
0
		public void ExecuteScalar()
		{
			OrderBusinessContext businessContext = new OrderBusinessContext(UserId, CityId, connStr);

			Order o = new Order();
			o.Title = CustomerA + "'s Order";
			o.CustomerName = CustomerA;

			using (IEntityContext entityContext = businessContext.CreateEntityContext())
			{
				entityContext.Add<Order>(o);

				Assert.IsTrue(o.OrderID > 0);
			}

			using (IEntityContext entityContext = businessContext.CreateEntityContext())
			{
				Dictionary<string, object> parameters = new Dictionary<string, object>();
				parameters["CustomerName"] = "not exist customer";
				int orderId = entityContext.ExecuteScalar<int>("select OrderId from [" + entityContext.GetMappingToTable(typeof(Order)) + "] where CustomerName=@CustomerName", parameters);

				Assert.IsTrue(orderId == 0);

				string customerName = entityContext.ExecuteScalar<string>("select CustomerName from [" + entityContext.GetMappingToTable(typeof(Order)) + "] where OrderID = @p0", o.OrderID);

				Assert.AreEqual(customerName, CustomerA);

				parameters.Clear();
				parameters["OrderID"] = o.OrderID;

				Assert.AreEqual(entityContext.ExecuteScalar<string>("select CustomerName from [" + entityContext.GetMappingToTable(typeof(Order)) + "] where OrderID = @OrderID", parameters), CustomerA);
			}
		}