public DataTable getItemNameAndPricingDetails() { DataTable dt = new DataTable(); try { string Query = "select pd.ItemID, pd.SalesPrice,pd.PurChasePrice,pd.MrpPrice,pd.Margin, id.ItemName,id.ItemCompName,id.groupid,id.unitid from itempriceDetail pd join ItemDetails id on pd.itemId=id.itemID"; DB_Main db = new DB_Main(); dt = db.getDetailByQuery(Query); } catch (Exception ex) { dt.Clear(); } return(dt); }
public DataTable GetVendorDetaisInDataTable() { DataTable dt = new DataTable(); try { DB_Main con = new DB_Main(); dt = con.getDetails("VendorDetails"); } catch (Exception ex) { dt.Clear(); } return(dt); }
public BS_layer() { db = new DB_Main(); }
public BL_DangNhap() { db = new DB_Main(); }