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);
}
