public async Task <ScreenResponse> GetScreenById(int screenId)
{
ScreenResponse screen = new ScreenResponse();
try
{
screen = (from s in ObjContext.Screens
where s.ScreensId == screenId && s.IsDeleted == false
select new ScreenResponse
{
ScreensId = s.ScreensId,
ScreensName = s.ScreensName,
Description = s.ScreensName,
CreatedOn = s.CreatedOn,
CreatedBy = s.CreatedBy,
ModifiedBy = s.ModifiedBy,
}).FirstOrDefault();
return(screen);
}
catch (System.Exception ex)
{
var msg = ex.Message;
throw;
}
}
public async Task <MainScreenResponse> GetScreenById(int screenId)
{
try
{
var isExist = _screenRepository.GetScreenById(screenId);
if (isExist.Result != null)
{
screenResponse = isExist.Result;
_response.screenResponse = screenResponse;
_response.Message = Constants.Screen_Exist;
_response.Status = true;
}
else
{
_response.Message = Constants.Screen_Not_Exist;
_response.Status = false;
}
;
}
catch (Exception ex)
{
var msg = ex.Message;
_response.Status = false;
_response.Message = Constants.DEFAULT_ERROR_MSG;
}
return(_response);
}
public List <ScreenResponse> GetScreen()
{
SqlCommand sqlCommand = new SqlCommand();
sqlCommand = connection.CreateCommand("[dbo].[GetScreens]", CommandType.StoredProcedure);
SqlDataReader sqlDr = sqlCommand.ExecuteReader();
var resultList = new List <ScreenResponse>();
while (sqlDr.Read())
{
var result = new ScreenResponse();
result.Id = (int)sqlDr["Id"];
result.Title = (string)sqlDr["Title"];
resultList.Add(result);
}
sqlCommand.Dispose();
return(resultList);
}
public async Task <ScreenResponse> GetScreenByIdAndName(ScreenRequest screenRequest)
{
ScreenResponse screen = new ScreenResponse();
try
{
screen = (from s in ObjContext.Screens
where s.ScreensName == screenRequest.ScreensName && s.IsDeleted == false
select new ScreenResponse
{
ScreensId = s.ScreensId,
ScreensName = s.ScreensName,
Description = s.Description,
}).FirstOrDefault();
return(screen);
}
catch (System.Exception ex)
{
var msg = ex.Message;
throw;
}
}
