private void SetDataNews(string refNo) { try { BLNews blNews = new BLNews(); DataSet ds = blNews.GetNews("", "", "", "", "", refNo); if (ds.Tables.Count > 0) { if (ds.Tables[0].Rows.Count > 0) { foreach (DataRow dr in ds.Tables[0].Rows) { txtRefNo.InnerText = refNo; txtNewsName.Text = dr["SUBJECT"].ToString(); ddlUserType.Items.FindByText(dr["USER_TYPE_NAME"].ToString()).Selected = true; rdStatus.SelectedValue = dr["IS_ACTIVE"].ToString(); //.Items.FindByValue(dr["STATUS"].ToString()).Selected = true; if (!String.IsNullOrEmpty(dr["DATE_FROM"].ToString())) { DateTime dt = Convert.ToDateTime(dr["DATE_FROM"].ToString()); txtStartDate.Value = dt.Day.ToString() + '/' + dt.Month.ToString() + '/' + dt.Year.ToString(); } if (!String.IsNullOrEmpty(dr["DATE_TO"].ToString())) { DateTime dt = Convert.ToDateTime(dr["DATE_TO"].ToString()); txtEndDate.Value = dt.Day.ToString() + '/' + dt.Month.ToString() + '/' + dt.Year.ToString(); } hdEditor.Value = dr["DETAIL"].ToString(); if (!String.IsNullOrEmpty(dr["THUMBNAIL"].ToString())) { byte[] bytes = (byte[])dr["THUMBNAIL"]; string base64String = Convert.ToBase64String(bytes, 0, bytes.Length); imgPreview.Src = "data:image/jpg;base64," + base64String; hdHasImage.Value = "Y"; } } } } } catch (Exception ex) { throw ex; } }
public static string GetNews(string newsName, string newsStartDate, string newsEndDate, string userType, string status, string refNo) { string result = ""; try { BLNews blNews = new BLNews(); DataSet ds = new DataSet(); Utility utility = new Utility(); ds = blNews.GetNews(newsName, newsStartDate, newsEndDate, userType, status, refNo); result = utility.DataTableToJSONWithJavaScriptSerializer(ds.Tables[0]); } catch (Exception ex) { throw ex; } return(result); }