public void IsApproved(int ID) { using (AustraliaDAL.DataSet1TableAdapters.tblOrderTableAdapter objOrder = new AustraliaDAL.DataSet1TableAdapters.tblOrderTableAdapter()) { objOrder.IsApproved(ID); } }
public void ActiveDeactiveOrder(int ID) { using (AustraliaDAL.DataSet1TableAdapters.tblOrderTableAdapter objOrder = new AustraliaDAL.DataSet1TableAdapters.tblOrderTableAdapter()) { objOrder.ActiveDeactiveOrder(ID); } }
public void DeleteOrder(int ID) { using (AustraliaDAL.DataSet1TableAdapters.tblOrderTableAdapter objOrder = new AustraliaDAL.DataSet1TableAdapters.tblOrderTableAdapter()) { objOrder.DeleteOrder(ID); } }
public DataTable GetOrderByCustomerID(int CustomerID) { DataTable dt = new DataTable(); using (AustraliaDAL.DataSet1TableAdapters.tblOrderTableAdapter objOrder = new AustraliaDAL.DataSet1TableAdapters.tblOrderTableAdapter()) { dt = objOrder.GetOrderByCustomerID(CustomerID); } return(dt); }
public DataTable GetOrderByDate(string AddDate) { DataTable dt = new DataTable(); using (AustraliaDAL.DataSet1TableAdapters.tblOrderTableAdapter objOrder = new AustraliaDAL.DataSet1TableAdapters.tblOrderTableAdapter()) { dt = objOrder.GetOrderByDate(AddDate); } return(dt); }
public int AddEditOrder(int ID, int CustomerID, string OrderStatus, bool IsApproved, string TransactionID, int Extra1, string Extra2, string OrderID, string Amount, string DelivaryDate, string Name, string Mobile_No, string Address, string Country, string State, string City, string Zip, string Locality, string LandMark, string Alternate_MobileNo) { int id; DataTable dt = new DataTable(); using (AustraliaDAL.DataSet1TableAdapters.tblOrderTableAdapter objOrder = new AustraliaDAL.DataSet1TableAdapters.tblOrderTableAdapter()) { dt = objOrder.AddEditOrder(ID, CustomerID, OrderStatus, IsApproved, TransactionID, Extra1, Extra2, OrderID, Amount, DelivaryDate, Name, Mobile_No, Address, Country, State, City, Zip, Locality, LandMark, Alternate_MobileNo); } id = Convert.ToInt32(dt.Rows[0]["ID"].ToString()); return(id); }