public void delete(OrderProductDTO DTO)
{
try
{
SqlConnection con = new SqlConnection();
con.ConnectionString = conString;
con.Open();
string sqlQuery = "DELETE FROM [ShopBase].[dbo].[ORDERPRODUCT] WHERE Product_Id=@Product_Id";
SqlCommand sc = new SqlCommand(sqlQuery, con);
sc.Parameters.AddWithValue("@Product_Id", DTO.PRODUCTID);
try
{
sc.ExecuteNonQuery();
con.Close();
}
catch (Exception)
{
MessageBox.Show("Data Not Deleted!", "ERROR");
}
}
catch (Exception)
{
MessageBox.Show("Connection To Database Failed!", "ERROR");
}
}
public void insert(OrderProductDTO dto)
{
try
{
con = new SqlConnection();
con.ConnectionString = conString;
con.Open();
string sqlQuery = "INSERT INTO [ShopBase].[dbo].[ORDERPRODUCT] (Order_Id,Product_Id,Quantity,Size)"
+ " VALUES (@Order_Id,@Product_Id,@Quantity,@Size)";
SqlCommand cm = new SqlCommand(sqlQuery, con);
cm.Parameters.AddWithValue("@Order_Id", dto.ORDERID);
cm.Parameters.AddWithValue("@Product_Id", dto.PRODUCTID);
cm.Parameters.AddWithValue("@Quantity", dto.QUANTITY);
cm.Parameters.AddWithValue("@Size", dto.SIZE);
try
{
cm.ExecuteNonQuery();
con.Close();
}
catch (Exception)
{
MessageBox.Show("Data Not Inserted!", "Error");
}
}
catch (Exception)
{
MessageBox.Show("Connection Not Successful to Database!", "Error");
}
}
public async Task <OrderProduct> AddProductToOrder(OrderProductDTO orderProductDTO)
{
//await orderService.UpdateOrder(productId, orderId);
return(await orderService.UpdateOrder(orderProductDTO.ProductId, orderProductDTO.OrderId));
//return NoContent();
}
public OrderProduct UpdateOrderProduct(OrderProductDTO orderProductDTO)
{
OrderProduct orderProduct = mapper.Map <OrderProduct>(orderProductDTO);
unitOfWork.OrderProductRepository.UpdateOrderProduct(orderProduct);
//await unitOfWork.Save();
return(orderProduct);
}
public static OrderProduct DTOToDAL(OrderProductDTO order)
{
return(new OrderProduct
{
code = order.Code,
orderCode = order.orderCode,
productCode = order.productCode,
amount = order.amount
});
}
public IHttpActionResult PostOrderProduct(OrderProductDTO orderProduct)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
OrderProductDTO op = OrderProductBLL.Add(orderProduct);
return(Ok(op));
}
public static OrderProductDTO Add(OrderProductDTO orderProducts)
{
OrderProduct op = OrderProductConverter.DTOToDAL(orderProducts);
using (GetCoffeeDBEntities db = new GetCoffeeDBEntities())
{
db.OrderProducts.Add(op);
db.SaveChanges();
}
return(OrderProductConverter.DALToDTO(op));
}
void deleteProductOfOrder(string product)
{
ProductDTO DTO = new ProductDTO(1, product);
productBLL = new ProductManagementBLL();
Int64 productID = productBLL.prodNameToID(DTO);
OrderProductDTO opDTO = new OrderProductDTO(orderId, productID);
opBLL = new OrderProductBLL();
opBLL.delete(opDTO);
}
public ArrayList search(OrderProductDTO DTO)
{
try
{
con = new SqlConnection();
con.ConnectionString = conString;
con.Open();
string sqlQuery = "SELECT Order_Id,Product_Id,Quantity,Size"
+ " FROM [ShopBase].[dbo].[ORDERPRODUCT] WHERE Order_Id=@Order_Id";
SqlCommand cm = new SqlCommand(sqlQuery, con);
cm.Parameters.AddWithValue("@Order_Id", DTO.ORDERID);
try
{
using (var reader = cm.ExecuteReader())
{
if (reader.HasRows)
{
//Check the reader has data:
while (reader.Read())
{
// Do something
Int64 opID = reader.GetInt64(reader.GetOrdinal("Order_Id"));
Int64 opProduct = reader.GetInt64(reader.GetOrdinal("Product_Id"));
string oQuantity = reader.GetString(reader.GetOrdinal("Quantity"));
string oSize = reader.GetString(reader.GetOrdinal("Size"));
arr.Add(new OrderProductDTO(opID, opProduct, oQuantity, oSize));
}
con.Close();
return(arr);
}
else
{
MessageBox.Show("Record Not Found", "Error");
return(arr);
}
}
}
catch (Exception)
{
MessageBox.Show("Query Execution error!", "Error");
return(arr);
}
}
catch (Exception)
{
MessageBox.Show("Connection Not Successful to Database!", "Error");
return(arr);
}
}
private IList <OrderProductDTO> GetOrderList(IFormCollection data)
{
IList <OrderProductDTO> orders = new List <OrderProductDTO>();
for (int i = 0; i < Convert.ToInt32(data["ordersLength"]); i++)
{
OrderProductDTO order = new OrderProductDTO();
order.Product_id = Int32.Parse(data["orders" + i + ".product_id"]);
order.Product_qty = Convert.ToInt32(data["orders" + i + ".product_quantity"]);
order.Product_name = data["orders" + i + ".product_name"];
orders.Add(order);
}
return(orders);
}
public static OrderProduct MapToOrderProduct(this OrderProductDTO source)
{
if (source == null)
{
return(null);
}
return(new OrderProduct
{
Id = source.Id.IsNotNullOrEmpty() ? new Guid(source.Id) : (Guid?)null,
OrderId = source.OrderId.IsNotNullOrEmpty() ? new Guid(source.OrderId) : (Guid?)null,
ProductId = source.ProductId.IsNotNullOrEmpty() ? new Guid(source.ProductId) : (Guid?)null,
Quantity = Convert.ToInt32(source.Quantity)
});
}
private void btnAdd_Click(object sender, EventArgs e)
{
string pname = cmbProduct.Text;
string pcategory = cmbCategory.Text;
string pQuantity = tbQuantity.Text;
string pSize = cmbSize.Text;
ProductDTO dto = new ProductDTO(0, pname, "", "", "", 1, pcategory); ////// To
productBLL = new ProductManagementBLL(); /////////////////////////// Convert product name
Int64 productID = productBLL.prodNameToID(dto); ///////////////////////////////////// to ID
OrderProductDTO oDTO = new OrderProductDTO(orderId, productID, pQuantity, pSize);
orderProductBLL = new OrderProductBLL();
orderProductBLL.insert(oDTO);
ClearAllFields();
}
/// <summary>
/// returns list of order details where order id match
/// </summary>
/// <returns></returns>
public IList <OrderProductDTO> GetOrderDetails(int id)
{
IList <OrderProduct> orderDetails = _orderDataAccess.GetOrderDetails().Where(o => o.OrderID == id).ToList();
IList <OrderProductDTO> orderDetailsDTO = new List <OrderProductDTO>();
foreach (var orderProduct in orderDetails)
{
OrderProductDTO orderProductDTO = new OrderProductDTO();
orderProductDTO.ID = orderProduct.ID;
orderProductDTO.OrderID = orderProduct.OrderID;
orderProductDTO.Product_id = orderProduct.Product_id;
orderProductDTO.Product_name = orderProduct.Product_name;
orderProductDTO.Product_qty = orderProduct.Product_qty;
orderDetailsDTO.Add(orderProductDTO);
}
return(orderDetailsDTO);
}
public async Task <IHttpActionResult> GetOrderProductInstance(int id)
{
OrderProduct b = await db.OrderProducts.FindAsync(id);
if (b == null)
{
return(NotFound());
}
OrderProductDTO orderProduct = new OrderProductDTO
{
productId = b.productId,
productName = b.product.name,
price = b.price,
productDescription = b.product.description,
quantity = b.quantity
};
return(Ok(orderProduct));
}
void loadProductsOfOrder()
{
opDTO = new OrderProductDTO(orderId);
opBLL = new OrderProductBLL();
ArrayList arr = opBLL.search(opDTO);
dataGridView.Rows.Clear();
dataGridView.Refresh();
foreach (object o in arr)
{
OrderProductDTO orderDTO = (OrderProductDTO)o;
ProductDTO DTO = new ProductDTO(orderDTO.PRODUCTID);
productBLL = new ProductManagementBLL();
string productName = productBLL.prodIdToName(DTO);
int a = dataGridView.Rows.Add();
dataGridView.Rows[a].Cells[0].Value = productName;
dataGridView.Rows[a].Cells[1].Value = orderDTO.QUANTITY;
dataGridView.Rows[a].Cells[2].Value = orderDTO.SIZE;
}
}
public async Task AddOrderProduct(OrderProductDTO orderProductDTO)
{
_dbOperation.OrderProducts.Create(_mapper.Map <OrderProduct>(orderProductDTO));
await _dbOperation.Save();
}
public void delete(OrderProductDTO dto)
{
oproductDAL = new OrderProductDAL();
oproductDAL.delete(dto);
}
public void insert(OrderProductDTO dto)
{
oproductDAL = new OrderProductDAL();
oproductDAL.insert(dto);
}
public async Task Update(OrderProductDTO obj)
{
var model = _mapper.Map <OrderProductDTO, OrderProduct>(obj);
await UOW.OrderProductRepository.Update(model);
}
public ArrayList search(OrderProductDTO dto)
{
oproductDAL = new OrderProductDAL();
ArrayList arr = oproductDAL.search(dto);
return arr;
}
public ActionResult OrdersCurrent()
{
OrdersDataDTO order1 = new OrdersDataDTO();
order1.OrderDate = new DateTime(2008, 5, 1);
order1.OrderNumber = "1";
order1.DeliveryDate = new DateTime(2008, 5, 2);
order1.OrderStatus = "В сборке";
OrderProductDTO orderProduct1 = new OrderProductDTO();
orderProduct1.ProductNumber = "1111";
orderProduct1.Name = "Рубашка";
orderProduct1.Quantity = 1;
orderProduct1.Price = 100;
OrderProductDTO orderProduct2 = new OrderProductDTO();
orderProduct2.ProductNumber = "2222";
orderProduct2.Name = "Куртка";
orderProduct2.Quantity = 2;
orderProduct2.Price = 200;
OrderProductDTO orderProduct3 = new OrderProductDTO();
orderProduct3.ProductNumber = "3333";
orderProduct3.Name = "Свитер";
orderProduct3.Quantity = 3;
orderProduct3.Price = 300;
order1.OrdersProducts.Add(orderProduct1);
order1.OrdersProducts.Add(orderProduct2);
order1.OrdersProducts.Add(orderProduct3);
OrdersDataDTO order2 = new OrdersDataDTO();
order2.OrderDate = new DateTime(2008, 6, 12);
order2.OrderNumber = "2";
order2.DeliveryDate = new DateTime(2008, 6, 13);
order2.OrderStatus = "В пути";
OrderProductDTO orderProduct4 = new OrderProductDTO();
orderProduct4.ProductNumber = "4444";
orderProduct4.Name = "Пальто";
orderProduct4.Quantity = 4;
orderProduct4.Price = 400;
OrderProductDTO orderProduct5 = new OrderProductDTO();
orderProduct5.ProductNumber = "5555";
orderProduct5.Name = "Валенки";
orderProduct5.Quantity = 5;
orderProduct5.Price = 500;
OrderProductDTO orderProduct6 = new OrderProductDTO();
orderProduct6.ProductNumber = "6666";
orderProduct6.Name = "Платок";
orderProduct6.Quantity = 6;
orderProduct6.Price = 600;
order2.OrdersProducts.Add(orderProduct4);
order2.OrdersProducts.Add(orderProduct5);
order2.OrdersProducts.Add(orderProduct6);
OrdersDataDTO order3 = new OrdersDataDTO();
order3.OrderDate = new DateTime(2008, 7, 21);
order3.OrderNumber = "3";
order3.DeliveryDate = new DateTime(2008, 7, 22);
order3.OrderStatus = "В пути";
OrderProductDTO orderProduct7 = new OrderProductDTO();
orderProduct7.ProductNumber = "7777";
orderProduct7.Name = "Туалетная бумага";
orderProduct7.Quantity = 7;
orderProduct7.Price = 700;
OrderProductDTO orderProduct8 = new OrderProductDTO();
orderProduct8.ProductNumber = "8888";
orderProduct8.Name = "Книга";
orderProduct8.Quantity = 8;
orderProduct8.Price = 800;
OrderProductDTO orderProduct9 = new OrderProductDTO();
orderProduct9.ProductNumber = "9999";
orderProduct9.Name = "Гречка";
orderProduct9.Quantity = 9;
orderProduct9.Price = 900;
order3.OrdersProducts.Add(orderProduct7);
order3.OrdersProducts.Add(orderProduct8);
order3.OrdersProducts.Add(orderProduct9);
List <OrdersDataDTO> orders = new List <OrdersDataDTO>();
orders.Add(order1);
orders.Add(order2);
orders.Add(order3);
return(View(orders));
}
public ActionResult OrdersHistory()
{
OrdersDataDTO order1 = new OrdersDataDTO();
order1.OrderDate = new DateTime(2008, 5, 1);
order1.OrderNumber = "1";
order1.DeliveryDate = new DateTime(2008, 5, 2);
order1.OrderStatus = "Получен";
OrderProductDTO orderProduct1 = new OrderProductDTO();
orderProduct1.ProductNumber = "1111";
orderProduct1.Name = "Сало";
orderProduct1.Quantity = 1;
orderProduct1.Price = 100;
OrderProductDTO orderProduct2 = new OrderProductDTO();
orderProduct2.ProductNumber = "2222";
orderProduct2.Name = "Мыло";
orderProduct2.Quantity = 2;
orderProduct2.Price = 200;
OrderProductDTO orderProduct3 = new OrderProductDTO();
orderProduct3.ProductNumber = "3333";
orderProduct3.Name = "Рыло";
orderProduct3.Quantity = 3;
orderProduct3.Price = 300;
order1.OrdersProducts.Add(orderProduct1);
order1.OrdersProducts.Add(orderProduct2);
order1.OrdersProducts.Add(orderProduct3);
OrdersDataDTO order2 = new OrdersDataDTO();
order2.OrderDate = new DateTime(2008, 6, 12);
order2.OrderNumber = "2";
order2.DeliveryDate = new DateTime(2008, 6, 13);
order2.OrderStatus = "Получен";
OrderProductDTO orderProduct4 = new OrderProductDTO();
orderProduct4.ProductNumber = "4444";
orderProduct4.Name = "Тело";
orderProduct4.Quantity = 4;
orderProduct4.Price = 400;
OrderProductDTO orderProduct5 = new OrderProductDTO();
orderProduct5.ProductNumber = "5555";
orderProduct5.Name = "Шило";
orderProduct5.Quantity = 5;
orderProduct5.Price = 500;
OrderProductDTO orderProduct6 = new OrderProductDTO();
orderProduct6.ProductNumber = "6666";
orderProduct6.Name = "Поло";
orderProduct6.Quantity = 6;
orderProduct6.Price = 600;
order2.OrdersProducts.Add(orderProduct4);
order2.OrdersProducts.Add(orderProduct5);
order2.OrdersProducts.Add(orderProduct6);
OrdersDataDTO order3 = new OrdersDataDTO();
order3.OrderDate = new DateTime(2008, 7, 21);
order3.OrderNumber = "3";
order3.DeliveryDate = new DateTime(2008, 7, 22);
order3.OrderStatus = "Получен";
OrderProductDTO orderProduct7 = new OrderProductDTO();
orderProduct7.ProductNumber = "7777";
orderProduct7.Name = "Жало";
orderProduct7.Quantity = 7;
orderProduct7.Price = 700;
OrderProductDTO orderProduct8 = new OrderProductDTO();
orderProduct8.ProductNumber = "8888";
orderProduct8.Name = "Соло";
orderProduct8.Quantity = 8;
orderProduct8.Price = 800;
OrderProductDTO orderProduct9 = new OrderProductDTO();
orderProduct9.ProductNumber = "9999";
orderProduct9.Name = "Дело";
orderProduct9.Quantity = 9;
orderProduct9.Price = 900;
order3.OrdersProducts.Add(orderProduct7);
order3.OrdersProducts.Add(orderProduct8);
order3.OrdersProducts.Add(orderProduct9);
List <OrdersDataDTO> orders = new List <OrdersDataDTO>();
orders.Add(order1);
orders.Add(order2);
orders.Add(order3);
return(View(orders));
}
