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();
}
