public object GetAnnouncementDetails(AnnouncementDetail ann)
{
dynamic TBAnnounceListResult;
List <object> AnnounListResult = new List <object>();
try
{
List <AnnounceList> Result = Announcement.GetAnnouncementDetails(ann);
for (int i = 0; i < Result.Count; i++)
{
AnnounListResult.Add(new { AnnounceList = Result[i] });
}
if (Result != null && Result.Count != 0)
{
TBAnnounceListResult = new { status = "0", message = "success", AnnounListResult = AnnounListResult };
}
else
{
TBAnnounceListResult = new { status = "1", message = "Record not found", AnnounListResult = AnnounListResult };
}
}
catch
{
TBAnnounceListResult = new { status = "1", message = "failed" };
}
return(new { TBAnnounceListResult });
}
public static List <AnnounceList> GetAnnouncementDetails(AnnouncementDetail ann)
{
string repeatDateTime = "";
try
{
MySqlParameter[] param = new MySqlParameter[3];
param[0] = new MySqlParameter("@announID", ann.announID);
param[1] = new MySqlParameter("@grpID", ann.grpID);
param[2] = new MySqlParameter("@memberProfileID", ann.memberProfileID);
DataSet Result = MySqlHelper.ExecuteDataset(GlobalVar.strAppConn, CommandType.StoredProcedure, "V6_USPGetAnnouncementDetails", param);
DataTable dtAnnouncement = Result.Tables[0];
DataTable dtRepeatAnnouncement = Result.Tables[1];
List <AnnounceList> Anndetail = new List <AnnounceList>();
if (dtAnnouncement.Rows.Count > 0)
{
Anndetail = GlobalFuns.DataTableToList <AnnounceList>(dtAnnouncement);
if (!string.IsNullOrEmpty(Anndetail[0].announImg))
{
string announ_Image = Anndetail[0].announImg.ToString();
string path = ConfigurationManager.AppSettings["imgPath"] + "Documents/announcement/Group" + ann.grpID + "/";
Anndetail[0].announImg = path + announ_Image;
}
if (dtRepeatAnnouncement.Rows.Count > 0)
{
for (int i = 0; i < dtRepeatAnnouncement.Rows.Count; i++)
{
repeatDateTime += dtRepeatAnnouncement.Rows[i]["annRepeatDate"].ToString() + ",";
}
repeatDateTime = repeatDateTime.TrimEnd(',');
}
Anndetail[0].repeatDateTime = repeatDateTime;
}
return(Anndetail);
}
catch (Exception ex)
{
throw ex;
}
}
