public BANK GetBank(string BankID)
{
string sql = @"SELECT *
FROM [BANK] where BnkAccNumber ='" + BankID + "'";
return(Db.Read(sql, Make));
}
public DepartmentEntity GetDepartment(string depID)
{
string sql = @"SELECT [DepID]
,[DepName]
FROM [DEPARTMENT] where DepID = '" + depID + "'";
return(Db.Read(sql, Make));
}
public PositionsEntity GetPosition(string PosID)
{
string sql = @"SELECT p.[PosID],p.[PosName],d.[DepID],d.DepName
FROM [POSITION] as p ,[DEPARTMENT] as d
where p.DepID = d.DepID and PosEnabled = 0 and PosID = '" + PosID + "'";
return(Db.Read(sql, Make));
}
public TradmarkEntity GetTradmark(string tradmarkID)
{
string sql = @"SELECT [TrdID]
,[TrdName]
,[TrdEnabled]
FROM [TRADEMARK] where TrdID = '" + tradmarkID + "'";
return(Db.Read(sql, Make));
}
public ColorEntity GetColor(string colorID)
{
string sql = @"SELECT [ClrID]
,[ClrName]
,[ClrEnabled]
FROM [COLOR] where ClrID ='" + colorID + "'";
return(Db.Read(sql, Make));
}
public TypeproductEntity GetTypeproduct(string typeproductID)
{
string sql = @"SELECT [TypeProductID]
,[TypeName]
,[TypeEnabled]
FROM [TYPEPRODUCT] where TypeProductID = '" + typeproductID + "'";
return(Db.Read(sql, Make));
}
public BrandEntity GetBrand(string brandID)
{
string sql = @"SELECT [BrandID]
,[BrandName]
,b.TrdID
,t.TrdName
,[BrandEnabled]
FROM [BRAND] as b , TRADEMARK as t
where t.TrdID = b.TrdID
and BrandID = '" + brandID + "'";
return(Db.Read(sql, Make));
}