public void ActiveDeactiveOrderDetail(int OrderDetailID)
{
using (AustraliaDAL.DataSet1TableAdapters.tblOrderDetailTableAdapter objOrderDetail = new AustraliaDAL.DataSet1TableAdapters.tblOrderDetailTableAdapter())
{
objOrderDetail.ActiveDeactiveOrderDetail(OrderDetailID);
}
}
public DataTable GetOrderDetailByOrderID(int ID)
{
DataTable dt = new DataTable();
using (AustraliaDAL.DataSet1TableAdapters.tblOrderDetailTableAdapter objOrderDetail = new AustraliaDAL.DataSet1TableAdapters.tblOrderDetailTableAdapter())
{
dt = objOrderDetail.GetOrderDetailByOrderID(ID);
}
return(dt);
}
public int AddEditOrderDetail(int OrderDetailID, int CustomerID, int ProductID, int ID, int Qty, string Amount, string DelivaryDate, string orderno,
string ProductName, string weight, decimal Price, decimal Discount, decimal AfterDiscount, decimal taxrate, decimal total_amount, string Deliverycharge, string productimg)
{
int id;
DataTable dt = new DataTable();
using (AustraliaDAL.DataSet1TableAdapters.tblOrderDetailTableAdapter objOrderDetail = new AustraliaDAL.DataSet1TableAdapters.tblOrderDetailTableAdapter())
{
dt = objOrderDetail.AddEditOrderDetail(OrderDetailID, CustomerID, ProductID, ID, Qty, Amount, DelivaryDate, orderno,
ProductName, weight, Price, Discount, AfterDiscount, taxrate, total_amount, Deliverycharge, productimg);
}
id = Convert.ToInt32(dt.Rows[0]["OrderDetailID"].ToString());
return(id);
}
