//public List<DolMenu> GetMenuByRoleId(decimal RoleId)
//{
// string SQL = "select DolMenu.MenuId,DolMenu.MenuName,DolMenu.MenuURL,DolMenu.LinkIcon,DolMenu.ExternalUrl, DolRole_Menu.MenuId,DolMenu.ParentId,RoleId from DolMenu INNER JOIN DolRole_Menu ON DolMenu.MenuId=DolRole_Menu.MenuId WHERE DolRole_Menu.RoleId=" + RoleId;
// var actual = _db.Fetch<DolMenu>(SQL);
// return (actual);
//}
public List <UserMenuResp> GetMenuByRole(int RoleId)
{
string sql = "select A.*,B.*,C.* from Dol_MenuItem A inner join Role_Menu B on A.ItemId=B.ItemId inner join User_Role C on B.RoleId=C.RoleId where C.RoleId=@0";
var _actual = _db.Fetch <UserMenuResp>(sql, RoleId).ToList();
return(_actual);
}
public List <UserDetailsResponse> GetUserByCompany()
{
string sql = "SELECT A.FirstName,A.MiddleName,A.LastName,A.UserName,A.PhoneNos,A.UserStatus,A.UserImg,A.RoleId,A.UserId,B.CustomerAlias FROM DolUser A INNER JOIN DolCompany B ON A.CompanyId = B.CompanyId ";
var actual = _db.Fetch <UserDetailsResponse>(sql);
return(actual);
}
//Get all terminals
public List <TerminalDetailsObj> GetAllTerminals()
{
string sql = "select A.*,C.RegionTitle,E.ClientAlias from Dol_Terminal A inner join Dol_State B on A.StateId=B.StateId inner join Dol_Region C on B.RegionId=C.RegionId inner join Dol_Brand D on A.BrandId=D.BrandId inner join Dol_Client E on A.ClientId=E.ClientId";
var actual = _db.Fetch <TerminalDetailsObj>(sql).ToList();
return(actual);
}
public List <RoleObj> GetAllRole()
{
string sql = "select * from User_Role";
var _actual = _db.Fetch <RoleObj>(sql);
return(_actual);
}
public List <AuditObj> GetAuditById()
{
string sql = "select * from Audit_Trail order by AuditId desc";
var actual = _db.Fetch <AuditObj>(sql);
return(actual);
}
public List <AuditDetailsObj> GetAuditById()
{
return(_db.Fetch <AuditDetailsObj>("select * from Audit_Trail order by AuditId desc"));
}
public List <StockDetailsObj> GetAllStocks()
{
return(_db.Fetch <StockDetailsObj>("select * from Dol_Stocked_Part").ToList());
}
//private readonly AuditManagement _audit = new AuditManagement();
public List <IncidentDetailsObj> GetAllPendingCalls()
{
return(_db.Fetch <IncidentDetailsObj>("select * from Dol_Incident where IsCallResolved=@0", false).ToList());
}
//public List<DolClient> GetClientById()
//{
// var actual = _db.Fetch<DolClient>().ToList();
// return actual;
//}
public List <DolClient> GetClientList()
{
var actual = _db.Fetch <DolClient>().ToList();
return(actual);
}
public List <DolBrand> GetBrandById()
{
var actual = _db.Fetch <DolBrand>().ToList();
return(actual);
}
//Get list of clients
public List <ClientDetailsObj> GetClientList()
{
return(_db.Fetch <ClientDetailsObj>("select * from Dol_Client").ToList());
}
public List <RoleDetailsObj> GetAllRole()
{
return(_db.Fetch <RoleDetailsObj>("select * from User_Role"));
}
public List <DolBrand> GetBrandById()
{
return(_db.Fetch <DolBrand>().ToList());
}