public static MsCrmResultObject GetEducationInfo(Guid educationId, SqlDataAccess sda) { MsCrmResultObject returnValue = new MsCrmResultObject(); try { #region | SQL QUERY | string query = @"SELECT E.new_educationId EducationId ,E.new_name Name ,E.new_summary Summary ,E.new_content [Description] ,E.new_imageurl [Image] ,CAST({2}.dbo.fn_UTCToTzSpecificLocalTime(E.CreatedOn, us.TimeZoneBias, us.TimeZoneDaylightBias,us.TimeZoneDaylightYear, us.TimeZoneDaylightMonth, us.TimeZoneDaylightDay, us.TimeZoneDaylightHour,us.TimeZoneDaylightMinute, us.TimeZoneDaylightSecond, 0, us.TimeZoneDaylightDayOfWeek,us.TimeZoneStandardBias, us.TimeZoneStandardYear, us.TimeZoneStandardMonth, us.TimeZoneStandardDay,us.TimeZoneStandardHour, us.TimeZoneStandardMinute, us.TimeZoneStandardSecond, 0,us.TimeZoneStandardDayOfWeek) as DATETIME) CreatedOn FROM new_education E (NoLock) INNER JOIN dbo.UserSettingsBase US (NoLock) ON US.SystemUserId ='{1}' WHERE E.new_educationId = '{0}'" ; #endregion DataTable dt = sda.getDataTable(string.Format(query, educationId, Globals.AdminId, Globals.DatabaseName)); if (dt != null && dt.Rows.Count > 0) { Education _education = new Education(); _education.EducationId = (Guid)dt.Rows[0]["EducationId"]; _education.Name = dt.Rows[0]["Name"].ToString(); _education.Summary = dt.Rows[0]["Summary"].ToString(); _education.Description = dt.Rows[0]["Description"].ToString(); _education.ImagePath = dt.Rows[0]["Image"] != DBNull.Value ? dt.Rows[0]["Image"].ToString() : "no_image_available.png"; _education.CreatedOnString = dt.Rows[0]["CreatedOn"] != DBNull.Value ? ((DateTime)dt.Rows[0]["CreatedOn"]).ToString("dd MMMM yyyy ddddd HH:mm", new CultureInfo("tr-TR", false)) : string.Empty; MsCrmResultObject resultLike = LikeHelper.GetEntityLikeInfo(_education.EducationId, "new_graffiti", sda); if (resultLike.Success) { _education.LikeDetail = (LikeInfo)resultLike.ReturnObject; } #region | GET COMMENTS | MsCrmResultObject commentResult = CommentHelper.GetEducationComments(educationId, sda); if (commentResult.Success) { _education.CommentList = (List <Comment>)commentResult.ReturnObject; } #endregion #region | GET ATTACHMENTS | MsCrmResultObject attachmentResult = AttachmentFileHelper.GetEducationAttachmentFiles(educationId, sda); if (attachmentResult.Success) { _education.AttachmentFileList = (List <AttachmentFile>)attachmentResult.ReturnObject; } #endregion returnValue.Success = true; returnValue.ReturnObject = _education; } else { returnValue.Success = true; returnValue.Result = "M017"; //"Eğitim kaydına ulaşılamadı."; } } catch (Exception ex) { returnValue.Success = false; returnValue.Result = ex.Message; } return(returnValue); }