public void GetShipperByIDTest()
{
ShipperDAL dal = new ShipperDAL(ConfigurationManager.ConnectionStrings["Shipper"].ConnectionString);
var result = dal.GetShipperById(13);
Assert.IsTrue(result.ShipperID == 13, "returned ID does not match request");
}
public void DeleteShipperTest()
{
ShipperDAL dal = new ShipperDAL(ConfigurationManager.ConnectionStrings["Shipper"].ConnectionString);
dal.DeleteShipper(13);
Assert.IsTrue(dal.GetShipperById(13).ShipperID != 13, "item still in db");;
}
private void btnAdd_Click(object sender, EventArgs e)
{
ShipperDAL dal = new ShipperDAL();
int deger = dal.ShipperAdd(new ShipperDAO()
{
CompanyName = txtName.Text,
Phone = mstPhone.Text
});
}
public void GetCustomerTest()
{
ItemDAL itemDAL = new ItemDAL(ConfigurationManager.ConnectionStrings["Shipper"].ConnectionString);
ShipperDAL shipperDAL = new ShipperDAL(ConfigurationManager.ConnectionStrings["Shipper"].ConnectionString);
CustomerDAL customerDAL = new CustomerDAL(ConfigurationManager.ConnectionStrings["Shipper"].ConnectionString);;
OrderDAL orderDAL = new OrderDAL(ConfigurationManager.ConnectionStrings["Shipper"].ConnectionString);;
AddToOrderDAL addtoorderDAL = new AddToOrderDAL(ConfigurationManager.ConnectionStrings["Shipper"].ConnectionString);
Customer result = new Customer(customerDAL, addtoorderDAL, itemDAL, orderDAL);
Assert.IsTrue(result.GetCustomer(2).CustomerID == 2, "Cannot find the customer");
}
public void GetItemTest()
{
ItemDAL itemDAL = new ItemDAL(ConfigurationManager.ConnectionStrings["Shipper"].ConnectionString);
ShipperDAL shipperDAL = new ShipperDAL(ConfigurationManager.ConnectionStrings["Shipper"].ConnectionString);
CustomerDAL customerDAL = new CustomerDAL(ConfigurationManager.ConnectionStrings["Shipper"].ConnectionString);;
OrderDAL orderDAL = new OrderDAL(ConfigurationManager.ConnectionStrings["Shipper"].ConnectionString);;
AddToOrderDAL addtoorderDAL = new AddToOrderDAL(ConfigurationManager.ConnectionStrings["Shipper"].ConnectionString);
User result = new User(shipperDAL, itemDAL, customerDAL, orderDAL, addtoorderDAL);
Assert.IsTrue(result.GetItem(4).ItemID == 4, "Cannot find the item");
}
public static void Initialize(string connectionString)
{
SupplierDB = new SupplierDAL(connectionString);
CustomerDB = new CustomerDAL(connectionString);
ShipperDB = new ShipperDAL(connectionString);
CategoryDB = new CategoryDAL(connectionString);
ProductDB = new ProductDAL(connectionString);
ProductAttributeDB = new ProductAttributeDAL(connectionString);
AttributeDB = new AttributeDAL(connectionString);
CountryDB = new CountryDAL(connectionString);
}
public void GetShipperTest()
{
ItemDAL itemDAL = new ItemDAL(ConfigurationManager.ConnectionStrings["Shipper"].ConnectionString);
ShipperDAL shipperDAL = new ShipperDAL(ConfigurationManager.ConnectionStrings["Shipper"].ConnectionString);
CustomerDAL customerDAL = new CustomerDAL(ConfigurationManager.ConnectionStrings["Shipper"].ConnectionString);;
OrderDAL orderDAL = new OrderDAL(ConfigurationManager.ConnectionStrings["Shipper"].ConnectionString);;
AddToOrderDAL addtoorderDAL = new AddToOrderDAL(ConfigurationManager.ConnectionStrings["Shipper"].ConnectionString);
User result = new User(shipperDAL, itemDAL, customerDAL, orderDAL, addtoorderDAL);
result.GetShipper(2);
Assert.IsTrue(result.GetShipper(2).ShipperID == 2, "Shipper was not found");
}
public void DeletePositionTest()
{
ItemDAL itemDAL = new ItemDAL(ConfigurationManager.ConnectionStrings["Shipper"].ConnectionString);
ShipperDAL shipperDAL = new ShipperDAL(ConfigurationManager.ConnectionStrings["Shipper"].ConnectionString);
CustomerDAL customerDAL = new CustomerDAL(ConfigurationManager.ConnectionStrings["Shipper"].ConnectionString);;
OrderDAL orderDAL = new OrderDAL(ConfigurationManager.ConnectionStrings["Shipper"].ConnectionString);;
AddToOrderDAL addtoorderDAL = new AddToOrderDAL(ConfigurationManager.ConnectionStrings["Shipper"].ConnectionString);
Customer result = new Customer(customerDAL, addtoorderDAL, itemDAL, orderDAL);
result.DeletePosition(1);
Assert.IsTrue(result.SameOrderPositions(1).Count == 0, "Position was not deleted");
}
public void GetItemTest()
{
ItemDAL itemDAL = new ItemDAL(ConfigurationManager.ConnectionStrings["Shipper"].ConnectionString);
ShipperDAL shipperDAL = new ShipperDAL(ConfigurationManager.ConnectionStrings["Shipper"].ConnectionString);
CustomerDAL customerDAL = new CustomerDAL(ConfigurationManager.ConnectionStrings["Shipper"].ConnectionString);;
OrderDAL orderDAL = new OrderDAL(ConfigurationManager.ConnectionStrings["Shipper"].ConnectionString);;
AddToOrderDAL addtoorderDAL = new AddToOrderDAL(ConfigurationManager.ConnectionStrings["Shipper"].ConnectionString);
Customer result = new Customer(customerDAL, addtoorderDAL, itemDAL, orderDAL);
result.GetItem(1);
Assert.IsTrue(result.GetItem(1).ItemID == 1, "Item was not found");
}
public void DeleteItemTest()
{
ItemDAL itemDAL = new ItemDAL(ConfigurationManager.ConnectionStrings["Shipper"].ConnectionString);
ShipperDAL shipperDAL = new ShipperDAL(ConfigurationManager.ConnectionStrings["Shipper"].ConnectionString);
CustomerDAL customerDAL = new CustomerDAL(ConfigurationManager.ConnectionStrings["Shipper"].ConnectionString);;
OrderDAL orderDAL = new OrderDAL(ConfigurationManager.ConnectionStrings["Shipper"].ConnectionString);;
AddToOrderDAL addtoorderDAL = new AddToOrderDAL(ConfigurationManager.ConnectionStrings["Shipper"].ConnectionString);
User result = new User(shipperDAL, itemDAL, customerDAL, orderDAL, addtoorderDAL);
result.RemoveItem(33);
Assert.IsTrue(result.GetItem(33).ItemID != 33, "Item was not deleted");
}
public void DeleteOrderTest()
{
ItemDAL itemDAL = new ItemDAL(ConfigurationManager.ConnectionStrings["Shipper"].ConnectionString);
ShipperDAL shipperDAL = new ShipperDAL(ConfigurationManager.ConnectionStrings["Shipper"].ConnectionString);
CustomerDAL customerDAL = new CustomerDAL(ConfigurationManager.ConnectionStrings["Shipper"].ConnectionString);;
OrderDAL orderDAL = new OrderDAL(ConfigurationManager.ConnectionStrings["Shipper"].ConnectionString);;
AddToOrderDAL addtoorderDAL = new AddToOrderDAL(ConfigurationManager.ConnectionStrings["Shipper"].ConnectionString);
User result = new User(shipperDAL, itemDAL, customerDAL, orderDAL, addtoorderDAL);
result.DeleteOrder(1);
Assert.IsTrue(result.GetOrder(1).OrderID != 1, "Order was not deleted");
}
public void CompleteOrderTest()
{
ItemDAL itemDAL = new ItemDAL(ConfigurationManager.ConnectionStrings["Shipper"].ConnectionString);
ShipperDAL shipperDAL = new ShipperDAL(ConfigurationManager.ConnectionStrings["Shipper"].ConnectionString);
CustomerDAL customerDAL = new CustomerDAL(ConfigurationManager.ConnectionStrings["Shipper"].ConnectionString);;
OrderDAL orderDAL = new OrderDAL(ConfigurationManager.ConnectionStrings["Shipper"].ConnectionString);;
AddToOrderDAL addtoorderDAL = new AddToOrderDAL(ConfigurationManager.ConnectionStrings["Shipper"].ConnectionString);
User result = new User(shipperDAL, itemDAL, customerDAL, orderDAL, addtoorderDAL);
result.CompleteOrder(2);
Assert.IsTrue(result.CompleteOrder(2).Comment == "Completed", "Order was not comleted");
}
public void DeleteCustomerTest()
{
ItemDAL itemDAL = new ItemDAL(ConfigurationManager.ConnectionStrings["Shipper"].ConnectionString);
ShipperDAL shipperDAL = new ShipperDAL(ConfigurationManager.ConnectionStrings["Shipper"].ConnectionString);
CustomerDAL customerDAL = new CustomerDAL(ConfigurationManager.ConnectionStrings["Shipper"].ConnectionString);;
OrderDAL orderDAL = new OrderDAL(ConfigurationManager.ConnectionStrings["Shipper"].ConnectionString);;
AddToOrderDAL addtoorderDAL = new AddToOrderDAL(ConfigurationManager.ConnectionStrings["Shipper"].ConnectionString);
Customer result = new Customer(customerDAL, addtoorderDAL, itemDAL, orderDAL);
result.RemoveCustomer(3);
Assert.IsTrue(result.GetCustomer(3).CustomerID != 3, "Customer was not deleted");
}
public void LogTest()
{
ItemDAL itemDAL = new ItemDAL(ConfigurationManager.ConnectionStrings["Shipper"].ConnectionString);
ShipperDAL shipperDAL = new ShipperDAL(ConfigurationManager.ConnectionStrings["Shipper"].ConnectionString);
CustomerDAL customerDAL = new CustomerDAL(ConfigurationManager.ConnectionStrings["Shipper"].ConnectionString);;
OrderDAL orderDAL = new OrderDAL(ConfigurationManager.ConnectionStrings["Shipper"].ConnectionString);;
AddToOrderDAL addtoorderDAL = new AddToOrderDAL(ConfigurationManager.ConnectionStrings["Shipper"].ConnectionString);
Customer result = new Customer(customerDAL, addtoorderDAL, itemDAL, orderDAL);
result.Log("Test2", "Test2");
Assert.IsTrue(result.Log("Test2", "Test2") == true, "Customer was not logged");
}
// GET: Admin/Shippers/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
var shipper = new ShipperDAL().ViewDetail(id);
if (shipper == null)
{
return(HttpNotFound());
}
return(View(shipper));
}
public ActionResult delupship(int id)
{
string connectionString = ConfigurationManager
.ConnectionStrings["LiteCommerceDB"]
.ConnectionString;
IShipperDAL dal = new ShipperDAL(connectionString);
Shipper s = new Shipper()
{
ShipperName = "KAKA",
Phone = "03399"
};
var data = dal.Update(8, s);
return(Json(data, JsonRequestBehavior.AllowGet));
}
private void btnAdd_Click(object sender, EventArgs e)
{
ShipperDAL dal = new ShipperDAL();
ShipperDAO dao = new ShipperDAO()
{
CompanyName = txtShipperName.Text,
Phone = txtmskTelNo.Text
};
int nResult = dal.SihipperAdd(dao);
if (nResult == 0)
{
MessageBox.Show("Veri Boş Geldi.");
}
}
private void Form1_Load(object sender, EventArgs e)
{
ShipperDAL dal = new ShipperDAL();
List <ShipperDAO> listShipper = dal.ShiperSelect();
if (listShipper == null)
{
MessageBox.Show("Veri Boş Geldi.");
}
foreach (var item in dal.ShiperSelect())
{
lstShippers.Items.Add(item);
}
}
public void UpdateItemTest()
{
ItemDAL itemDAL = new ItemDAL(ConfigurationManager.ConnectionStrings["Shipper"].ConnectionString);
ShipperDAL shipperDAL = new ShipperDAL(ConfigurationManager.ConnectionStrings["Shipper"].ConnectionString);
CustomerDAL customerDAL = new CustomerDAL(ConfigurationManager.ConnectionStrings["Shipper"].ConnectionString);;
OrderDAL orderDAL = new OrderDAL(ConfigurationManager.ConnectionStrings["Shipper"].ConnectionString);;
AddToOrderDAL addtoorderDAL = new AddToOrderDAL(ConfigurationManager.ConnectionStrings["Shipper"].ConnectionString);
User result = new User(shipperDAL, itemDAL, customerDAL, orderDAL, addtoorderDAL);
var item = new ItemDTO
{
ItemID = 32,
Price = 25,
OnStock = 20
};
Assert.IsTrue(result.ChangeItem(item).Price == 25, "Item was not updated");
}
public void UpdateShipperTest()
{
ShipperDAL dal = new ShipperDAL(ConfigurationManager.ConnectionStrings["Shipper"].ConnectionString);
var shupper = dal.GetShipperById(13);
ShipperDTO upd = new ShipperDTO
{
ShipperID = 13,
EMail = "Updated",
Addres = "Updated",
Phone = "Updated",
Description = "Updated"
};
var result = dal.UpdateShipper(upd);
Assert.IsTrue(result.EMail == "Updated", "Shipper was not updated");
}
static void Main(string[] args)
{
IShipperDAL _shipperDAL = new ShipperDAL(ConfigurationManager.ConnectionStrings["Shipper"].ConnectionString);
IItemDAL _itemDAL = new ItemDAL(ConfigurationManager.ConnectionStrings["Shipper"].ConnectionString); ;
ICustomerDAL _customerDAL = new CustomerDAL(ConfigurationManager.ConnectionStrings["Shipper"].ConnectionString); ;
IOrderDAL _orderDAL = new OrderDAL(ConfigurationManager.ConnectionStrings["Shipper"].ConnectionString); ;
IAddToOrderDAL _addtoorderDAL = new AddToOrderDAL(ConfigurationManager.ConnectionStrings["Shipper"].ConnectionString);
ICustomer user2 = new Customer(_customerDAL, _addtoorderDAL, _itemDAL, _orderDAL);
IUser user1 = new User(_shipperDAL, _itemDAL, _customerDAL, _orderDAL, _addtoorderDAL);
Application.EnableVisualStyles();
Application.SetCompatibleTextRenderingDefault(false);
Application.Run(new RoleChoiceForm(user1,user2));
}
public void UpdateCustomerTest()
{
ItemDAL itemDAL = new ItemDAL(ConfigurationManager.ConnectionStrings["Shipper"].ConnectionString);
ShipperDAL shipperDAL = new ShipperDAL(ConfigurationManager.ConnectionStrings["Shipper"].ConnectionString);
CustomerDAL customerDAL = new CustomerDAL(ConfigurationManager.ConnectionStrings["Shipper"].ConnectionString);;
OrderDAL orderDAL = new OrderDAL(ConfigurationManager.ConnectionStrings["Shipper"].ConnectionString);;
AddToOrderDAL addtoorderDAL = new AddToOrderDAL(ConfigurationManager.ConnectionStrings["Shipper"].ConnectionString);
Customer result = new Customer(customerDAL, addtoorderDAL, itemDAL, orderDAL);
var customer = new CustomerDTO
{
EMail = "EmailTest",
CustomerID = 2,
Phone = "TestPhone",
Addres = "TestAddress",
Description = "TestDescription"
};
Assert.IsTrue(result.ChangeCustomer(customer).EMail == "EmailTest", "Customer was not updated");
}
//Test URL: https://localhost:44398/Test/PaginationCustomer?page=1&pageSize=10&searchValue
/// <summary>
/// Hiển thị danh sách Shipper(nhà vận chuyển) Tìm kiếm, phân trang
/// </summary>
/// <param name="page"></param>
/// <param name="pageSize"></param>
/// <param name="searchValue"></param>
/// <returns></returns>
public ActionResult PaginationShipper(int page, int pageSize, string searchValue)
{
string connectionString = ConfigurationManager.ConnectionStrings["LiteCommerceDB"].ConnectionString;
IShipperDAL dal = new ShipperDAL(connectionString);
/*var data = dal.List(page, pageSize, searchValue);
*
* return Json(data, JsonRequestBehavior.AllowGet);*/
Shipper data = new Shipper()
{
ShipperID = 4,
ShipperName = "Lệ Quyên",
Phone = "0988712"
};
//var data = dal.Count("");
//var data = dal.Get(4);
return(Json(dal.Update(data), JsonRequestBehavior.AllowGet));
}
public void AddCustomerTest()
{
ItemDAL itemDAL = new ItemDAL(ConfigurationManager.ConnectionStrings["Shipper"].ConnectionString);
ShipperDAL shipperDAL = new ShipperDAL(ConfigurationManager.ConnectionStrings["Shipper"].ConnectionString);
CustomerDAL customerDAL = new CustomerDAL(ConfigurationManager.ConnectionStrings["Shipper"].ConnectionString);;
OrderDAL orderDAL = new OrderDAL(ConfigurationManager.ConnectionStrings["Shipper"].ConnectionString);;
AddToOrderDAL addtoorderDAL = new AddToOrderDAL(ConfigurationManager.ConnectionStrings["Shipper"].ConnectionString);
Customer result = new Customer(customerDAL, addtoorderDAL, itemDAL, orderDAL);
var customer = new CustomerDTO
{
EMail = "Test2",
Addres = "Test2",
Phone = "Test2",
Description = "Test2"
};
result.AddCustomer(customer);
Assert.IsTrue(customer.CustomerID >= 0, "returned ID should be more than zero");
}
public void CreateShipperTest()
{
ShipperDAL dal = new ShipperDAL(ConfigurationManager.ConnectionStrings["Shipper"].ConnectionString);
PasswordActions password = new PasswordActions();
var result = new ShipperDTO
{
Login = "******",
Password = password.PasswordEncryption("1234"),
EMail = "Test",
Addres = "Test",
Phone = "Test",
Description = "Test"
};
result = dal.CreateShipper(result);
Assert.IsTrue(result.ShipperID >= 0, "returned ID should be more than zero");
}
public void AddItemTest()
{
ItemDAL itemDAL = new ItemDAL(ConfigurationManager.ConnectionStrings["Shipper"].ConnectionString);
ShipperDAL shipperDAL = new ShipperDAL(ConfigurationManager.ConnectionStrings["Shipper"].ConnectionString);
CustomerDAL customerDAL = new CustomerDAL(ConfigurationManager.ConnectionStrings["Shipper"].ConnectionString);;
OrderDAL orderDAL = new OrderDAL(ConfigurationManager.ConnectionStrings["Shipper"].ConnectionString);;
AddToOrderDAL addtoorderDAL = new AddToOrderDAL(ConfigurationManager.ConnectionStrings["Shipper"].ConnectionString);
User result = new User(shipperDAL, itemDAL, customerDAL, orderDAL, addtoorderDAL);
var item = new ItemDTO
{
Name = "BL Test",
Price = 100,
OnStock = 2
};
var r = result.AddItem(item);
Assert.IsTrue(r.ItemID != 0, "returned ID should be more than zero");
}
public void AddShipperTest()
{
ItemDAL itemDAL = new ItemDAL(ConfigurationManager.ConnectionStrings["Shipper"].ConnectionString);
ShipperDAL shipperDAL = new ShipperDAL(ConfigurationManager.ConnectionStrings["Shipper"].ConnectionString);
CustomerDAL customerDAL = new CustomerDAL(ConfigurationManager.ConnectionStrings["Shipper"].ConnectionString);;
OrderDAL orderDAL = new OrderDAL(ConfigurationManager.ConnectionStrings["Shipper"].ConnectionString);;
AddToOrderDAL addtoorderDAL = new AddToOrderDAL(ConfigurationManager.ConnectionStrings["Shipper"].ConnectionString);
User result = new User(shipperDAL, itemDAL, customerDAL, orderDAL, addtoorderDAL);
var shipper = new ShipperDTO
{
Login = "******",
Password = new ConsoleProject.PasswordActions().PasswordEncryption("1234"),
EMail = "Test2",
Addres = "Test2",
Phone = "Test2",
Description = "Test2"
};
shipper = result.AddShipper(shipper);
Assert.IsTrue(shipper.ShipperID >= 0, "returned ID should be more than zero");
}
public ActionResult Edit([Bind(Include = "ShipperID,Name,Email,Phone,Fax,Address,CreateDate,CreateUser,ModifiedDate,ModifiedUser,IsActive")] Shipper shipper)
{
var UserSession = (UserLogin)Session[TechDeviShopVs002.Common.CommonConstants.USER_SESSION];
if (ModelState.IsValid)
{
var _dal = new ShipperDAL();
shipper.ModifiedUser = UserSession.UserID;
var _result = _dal.Update(shipper);
if (_result)
{
return(RedirectToAction("Index", "Shippers"));
}
else
{
ModelState.AddModelError("", "Cập nhật shipper ko thành công");
}
}
return(View(shipper));
}
public void AddOrderTest()
{
ItemDAL itemDAL = new ItemDAL(ConfigurationManager.ConnectionStrings["Shipper"].ConnectionString);
ShipperDAL shipperDAL = new ShipperDAL(ConfigurationManager.ConnectionStrings["Shipper"].ConnectionString);
CustomerDAL customerDAL = new CustomerDAL(ConfigurationManager.ConnectionStrings["Shipper"].ConnectionString);;
OrderDAL orderDAL = new OrderDAL(ConfigurationManager.ConnectionStrings["Shipper"].ConnectionString);;
AddToOrderDAL addtoorderDAL = new AddToOrderDAL(ConfigurationManager.ConnectionStrings["Shipper"].ConnectionString);
Customer result = new Customer(customerDAL, addtoorderDAL, itemDAL, orderDAL);
var order = new OrderDTO
{
ShipperIDKEY = 2,
CustomerIDKEY = 2,
Price = 0.00,
Date = DateTime.Now,
Comment = "No info"
};
var r = result.AddOrder(order);
Assert.IsTrue(r.OrderID != 0, "returned ID should be more than zero");
}
public Task <Shipper> GetShipperById(int ShipperId)
{
return(Task.FromResult(ShipperDAL.GetShipperById(ShipperId)));
}
