public static Object GetWorkDescription(Guid userID)
{
Object cell = DBL.ExecuteScalar($"select volWorkDescription from VolExperience where FK_UserId='{userID}'");
return(cell);
}
public static Object GetWorkRole(Guid userID)
{
Object cell = DBL.ExecuteScalar($"select Role from VolExperience where FK_UserId='{userID}'");
return(cell);
}
public static Object GetProjectDescription(Guid userID)
{
Object cell = DBL.ExecuteScalar($"select Description from Project where FK_UserId='{userID}'");
return(cell);
}
public static Object GetEndDate(Guid userID)
{
Object cell = DBL.ExecuteScalar($"select EndDate from Project where FK_UserId='{userID}'");
return(cell);
}
public static int GetLatestId()
{
object PicId = DBL.ExecuteScalar("select PicturesDB.Id from PicturesDB where PicturesDB.Id=(select max(PicturesDB.Id) from PicturesDB)");
return(Convert.ToInt32(PicId));
}
public static object GetImageOnlyByUserId(Guid userId)
{
object _Object = DBL.ExecuteScalar($"select top 1 PicturesDB.ImageData from PicturesDB where PicturesDB.FK_UserIdAddedBy='{userId}' ORDER BY PicturesDB.PictureId DESC");
return(_Object);
}
public static object GetImageOnlyById(int Id)
{
object _Object = DBL.ExecuteScalar(" select PicturesDB.ImageData from PicturesDB where PicturesDB.PictureId=" + Id);
return(_Object);
}