public void CustomerSaveTest()
{
Customer customer = new Customer("Ali");
customer.Email = "*****@*****.**";
Address address = new Address();
address.Street = "2534 Lorong 2 Taman India";
address.Postal = "12345";
address.State = "Melaka";
Stock stock = new Stock(3);
Nisan nisan = new Nisan(stock);
nisan.Name = "Ramli" + new System.Random().Next(100) + " bin Taib";
nisan.Death = RandomDate();
Order target = new Order();
target.Status = TransactionStage.Submit;
//target.Agent = new Agent("W002");
target.Amount = stock.Price;
target.Quantity = 1;
target.Stock = nisan;
target.ShipTo = address;
target.Parent.CreatedBy = customer;//can be an agent
Assert.IsTrue(target.Save());
}
public void CustomerAddressSaveTest()
{
Customer target = new Customer("Ahmad bin talib");
target.Email = "*****@*****.**";
Address address = new Address();
address.Street = "963 Jalan 6 Machang Bubok";
address.Postal = "14020";
address.State = "Penang";
target.Address = address;
Assert.IsTrue(target.Save());
}
public void AgentSaveTest()
{
Agent target = new Agent("W002");
target.Name = "roslan bt Ali";
target.Email = "*****@*****.**";
Address address = new Address();
address.Street = "963 Jalan 6 Machang Bubok";
address.Postal = "33320";
address.State = "Kuala Lumpur";
target.Address = address;
Assert.IsTrue(target.Save());
}
public void AgentSaveTest()
{
Address address = new Address();
address.Street = "1234 Lorong 2 Taman Bangla";
address.Postal = "12345";
address.State = "Pahang";
Stock stock = new Stock(3);
Nisan nisan = new Nisan(stock);
nisan.Name = "Che Som" + new System.Random().Next(100) + " bin Said";
nisan.Death = RandomDate();
Agent agent = new Agent("W002");
Order target = new Order();
target.Status = TransactionStage.Submit;
target.Agent = agent;
target.Amount = stock.Price;
target.Quantity = 1;
target.Stock = nisan;
target.ShipTo = address;
Assert.IsTrue(target.Save());
}
protected List<Order> GetSales(string code)
{
List<Order> sales = new List<Order>();
using (DbConnection connection = factory.CreateConnection())
{
connection.ConnectionString = connectionString;
connection.Open();
using (DbCommand command = connection.CreateCommand())
{
command.CommandType = System.Data.CommandType.Text;
string sql =
@"SELECT Orders.Status
,Orders.AddressId,Addresses.Street,Addresses.Postal,Addresses.State
,Orders.Quantity,Stocks.Type
,Nisans.*
,Users.Id,Users.Code,Users.Name AS Customer
,TransactionItems.Id AS TransactionItemId, TransactionItems.Amount
,Transactions.Id AS TransactionId,Transactions.No AS No, Transactions.CreatedAt
FROM Orders JOIN Nisans ON Orders.NisanId=Nisans.Id
JOIN Addresses ON Orders.AddressId=Addresses.Id
JOIN Stocks ON Nisans.Type = Stocks.Id
JOIN TransactionItems ON Orders.ItemId=TransactionItems.Id
JOIN Transactions ON TransactionItems.Parent=Transactions.Id
JOIN Users ON Transactions.CreatedBy=Users.Id";
if (code != null && code.Length > 0)
sql += " WHERE Users.Code=@Code;";
command.CommandText = sql;
if (code != null && code.Length > 0)
command.Parameters.Add(CreateParameter("@Code", this.codeField));
using (DbDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
Transaction parent = new Transaction();
parent.CreatedAt = Convert.ToDateTime(reader["CreatedAt"]);
Order order = new Order();
order.Parent = parent;
order.Status = (TransactionStage)Convert.ToInt32(reader["Status"]);
if (reader["Code"] != DBNull.Value && reader["Code"].ToString().Length>0)
order.Agent = new Agent(reader["Code"].ToString());
order.Id = Convert.ToInt32(reader["TransactionItemId"]);
order.Amount = Convert.ToDecimal(reader["Amount"]);
order.Quantity = Convert.ToInt32(reader["Quantity"]);
Nisan nisan = new Nisan();
nisan.Type = reader["Type"].ToString();
nisan.Id = Convert.ToInt32(reader["Id"]);
nisan.Name = reader["Name"].ToString();
nisan.Death = Convert.ToDateTime(reader["Death"]);
if (reader["Deathm"] != DBNull.Value)
nisan.Deathm = ToMuslimDate(reader["Deathm"].ToString());
if (reader["Age"] != DBNull.Value)
nisan.Age = Convert.ToInt32(reader["Age"]);
if (reader["Born"] != DBNull.Value)
nisan.Born = Convert.ToDateTime(reader["Born"]);
nisan.Remarks = reader["Remarks"].ToString();
nisan.Uri = reader["Uri"].ToString();
order.Stock = nisan;
Address shipTo = new Address();
shipTo.Street = reader["Street"].ToString();
shipTo.Postal = reader["Postal"].ToString();
shipTo.State = reader["State"].ToString();
order.ShipTo = shipTo;
//order.ShipTo = new Address((int)reader["AddressId"]);
sales.Add(order);
}
}
}
connection.Close();
}//end
return sales;
}
