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