public object GetEventListNew(eventdtl eve)
{
dynamic EventListDetailResult;
string grp_SMSCount;
List <object> EventsListResult = new List <object>();
try
{
EventListNew Result = EventMaster.GetEventListNew(eve.groupProfileID, eve.grpId, out grp_SMSCount, eve.updatedOn);
//for (int i = 0; i < Result.Count; i++)
//{
// EventsListResult.Add(new { EventList = Result[i] });
//}
if (Result != null)
{
EventListDetailResult = new { status = "0", message = "success", smsCount = grp_SMSCount, updatedOn = System.DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss"), EventsListResult = Result };
}
else
{
EventListDetailResult = new { status = "1", smsCount = grp_SMSCount, updatedOn = System.DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss"), message = "Record not found" };
}
}
catch
{
EventListDetailResult = new { status = "1", message = "failed", smsCount = 0, updatedOn = System.DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss"), };
}
return(new { EventListDetailResult });
}
/// <summary>
/// Created By : Nandu
/// Returns List of Group Created Event List, Update Event List and Deleted Event List
/// created On 25/07/2016
/// </summary>
public static EventListNew GetEventListNew(string memberID, string grpID, out string Grp_SMSCount, string updatedOn)
{
try
{
MySqlParameter[] param = new MySqlParameter[4];
param[0] = new MySqlParameter("?memberId", memberID);
param[1] = new MySqlParameter("?grpId", grpID);
param[2] = new MySqlParameter("?SMS_Count", 0);
param[3] = new MySqlParameter("?updatedOn", updatedOn);
param[2].Direction = ParameterDirection.InputOutput;
DataSet Result = MySqlHelper.ExecuteDataset(GlobalVar.strAppConn, CommandType.StoredProcedure, "V3_USPGetEventList", param);
DataTable dt = Result.Tables[0];
DataTable dt2 = Result.Tables[1];
DataTable dt3 = Result.Tables[2];
EventListNew res = new EventListNew();
List <EventList1> createdList = GlobalFuns.DataTableToList <EventList1>(dt);
if (dt.Rows.Count > 0)
{
foreach (EventList1 eve in createdList)
{
if (!string.IsNullOrEmpty(eve.eventImg))
{
string event_Image = eve.eventImg.ToString();
string path = ConfigurationManager.AppSettings["imgPath"] + "Documents/Event/Group" + grpID + "/thumb/";
eve.eventImg = path + event_Image;
}
}
}
List <EventList1> updatedList = GlobalFuns.DataTableToList <EventList1>(dt2);
if (dt2.Rows.Count > 0)
{
foreach (EventList1 eve in updatedList)
{
if (!string.IsNullOrEmpty(eve.eventImg))
{
string event_Image = eve.eventImg.ToString();
string path = ConfigurationManager.AppSettings["imgPath"] + "Documents/Event/Group" + grpID + "/thumb/";
eve.eventImg = path + event_Image;
}
}
}
List <EventList1> deletedList = GlobalFuns.DataTableToList <EventList1>(dt3);
if (dt3.Rows.Count > 0)
{
foreach (EventList1 eve in deletedList)
{
if (!string.IsNullOrEmpty(eve.eventImg))
{
string event_Image = eve.eventImg.ToString();
string path = ConfigurationManager.AppSettings["imgPath"] + "Documents/Event/Group" + grpID + "/thumb/";
eve.eventImg = path + event_Image;
}
}
}
Grp_SMSCount = param[2].Value.ToString();
res.CreatedEventList = createdList;
res.UpdatedEventList = updatedList;
res.DeletedEventList = deletedList;
return(res);
}
catch (Exception ex)
{
throw ex;
}
}
