public static ClsMonthCalenderOutput GetMonthEventList(ClsMonthCalenderInput monthCal)
{
try
{
string sqlProc;
if (monthCal.groupCategory == "2")
{
sqlProc = "V7_USPGetDistrictEventByMonth_Calender";
}
else
{
sqlProc = "V7_USPGetEventByMonth_Calender";
}
MySqlParameter[] parameterList = new MySqlParameter[4];
parameterList[0] = new MySqlParameter("?GroupID", monthCal.groupId);
parameterList[1] = new MySqlParameter("?ProfileID", monthCal.profileId);
parameterList[2] = new MySqlParameter("?Curr_Date", monthCal.selectedDate);
parameterList[3] = new MySqlParameter("?UpdatedOn", monthCal.updatedOn);
DataSet result = MySqlHelper.ExecuteDataset(GlobalVar.strAppConn, CommandType.StoredProcedure, sqlProc, parameterList);
DataTable dtNewEvents = result.Tables[0];
DataTable dtUpdatedEvents = result.Tables[1];
DataTable dtDeletedEvents = result.Tables[2];
List <CalenderEventList> NewEventList = new List <CalenderEventList>();
if (dtNewEvents.Rows.Count > 0)
{
NewEventList = GlobalFuns.DataTableToList <CalenderEventList>(dtNewEvents);
}
List <CalenderEventList> UpdatedEventList = new List <CalenderEventList>();
if (dtUpdatedEvents.Rows.Count > 0)
{
UpdatedEventList = GlobalFuns.DataTableToList <CalenderEventList>(dtUpdatedEvents);
}
List <CalenderEventList> DeletedEventList = new List <CalenderEventList>();
if (dtDeletedEvents.Rows.Count > 0)
{
DeletedEventList = GlobalFuns.DataTableToList <CalenderEventList>(dtDeletedEvents);
}
ClsMonthCalenderOutput calender = new ClsMonthCalenderOutput();
calender.newEvents = NewEventList;
calender.updatedEvents = UpdatedEventList;
calender.deletedEvents = DeletedEventList;
return(calender);
}
catch
{
throw;
}
}
public object GetMonthEventListTypeWise(ClsMonthCalenderInput monthCal)
{
dynamic TBEventListTypeResult;
try
{
var Result = Celebration.GetMonthEventTypeList(monthCal);
if (Result != null)
{
TBEventListTypeResult = new { status = "0", message = "success", updatedOn = System.DateTime.Now.ToString("yyyy/MM/dd HHmm:ss"), Result };
}
else
{
TBEventListTypeResult = new { status = "1", message = "failed", updatedon = System.DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss") };
}
}
catch
{
TBEventListTypeResult = new { status = "1", message = "failed", updatedon = System.DateTime.Now.ToString("yyyy/MM/dd HH::mm:ss") };
}
return(new { TBEventListTypeResult });
}
public object GetMonthEventListDetails(ClsMonthCalenderInput monthCal)
{
dynamic TBEventListDtlsResult;
try
{
var Result = Celebration.GetMonthEventListDetails(monthCal);
if (Result != null)
{
TBEventListDtlsResult = new { status = "0", message = "success", Result };
}
else
{
TBEventListDtlsResult = new { status = "1", message = "failed" };
}
}
catch
{
TBEventListDtlsResult = new { status = "1", message = "failed" };
}
return(new { TBEventListDtlsResult });
}
public object GetTodaysBirthday(ClsMonthCalenderInput monthCal)
{
dynamic TBMemberListResult;
try
{
var Result = Celebration.GetTodaysBirthday(monthCal.groupId);
if (Result != null)
{
TBMemberListResult = new { status = "0", message = "success", Result };
}
else
{
TBMemberListResult = new { status = "0", message = "Record not found" };
}
}
catch
{
TBMemberListResult = new { status = "1", message = "failed" };
}
return(new { TBMemberListResult });
}
public static ClsMonthCalenderOutputNew GetMonthEventTypeList(ClsMonthCalenderInput monthCal)
{
try
{
string sqlProc;
if (monthCal.groupCategory == "2")
{
sqlProc = "V8_USPGetDistrictEventByMonth_Calender";
}
else
{
sqlProc = "V8_USPGetEventByMonth_Calender";
}
MySqlParameter[] parameterList = new MySqlParameter[5];
parameterList[0] = new MySqlParameter("?GroupID", monthCal.groupId);
parameterList[1] = new MySqlParameter("?ProfileID", monthCal.profileId);
parameterList[2] = new MySqlParameter("?Curr_Date", monthCal.selectedDate);
parameterList[3] = new MySqlParameter("?Type", monthCal.Type);
DataSet result = MySqlHelper.ExecuteDataset(GlobalVar.strAppConn, CommandType.StoredProcedure, sqlProc, parameterList);
DataTable dtNewEvents = result.Tables[0];
List <clsCalenderEventList> NewEventList = new List <clsCalenderEventList>();
if (dtNewEvents.Rows.Count > 0)
{
NewEventList = GlobalFuns.DataTableToList <clsCalenderEventList>(dtNewEvents);
}
//if (monthCal.Type == "E")
//{
foreach (clsCalenderEventList eve in NewEventList)
{
if (!string.IsNullOrEmpty(eve.eventImg))
{
string event_Image = eve.eventImg.ToString();
// string path = HttpContext.Current.Server.MapPath("~/Documents/Events/Group" + grpID + "/thumb/");
string path = ConfigurationManager.AppSettings["imgPath"] + "Documents/Event/Group" + monthCal.groupId + "/";
eve.eventImg = path + event_Image;
}
DataSet result1 = null;
List <clsCalenderMobileNo> MobileNoList = new List <clsCalenderMobileNo>();
List <clsCalenderEmailId> EmailIdsList = new List <clsCalenderEmailId>();
List <clsCalenderMobileNo> ListResult = new List <clsCalenderMobileNo>();
List <clsCalenderEmailId> ListResult1 = new List <clsCalenderEmailId>();
if (monthCal.Type != "E")
{
//if (string.IsNullOrEmpty(eve.ContactNumber))
//{
sqlProc = "V8_USPGetCalenderEvent_MobileNoEmailIds_New";
parameterList = new MySqlParameter[2];
if (monthCal.groupCategory == "2")
{
parameterList[0] = new MySqlParameter("?UniqueID", eve.MemberID.Substring(1));
}
else
{
parameterList[0] = new MySqlParameter("?UniqueID", eve.MemberID);
}
parameterList[1] = new MySqlParameter("?Type", "M");
result1 = MySqlHelper.ExecuteDataset(GlobalVar.strAppConn, CommandType.StoredProcedure, sqlProc, parameterList);
if (result1 != null)
{
MobileNoList = GlobalFuns.DataTableToList <clsCalenderMobileNo>(result1.Tables[0]);
}
//if (MobileNoList.Count > 0)
//{
// ListResult.Add(MobileNoList[0]);
//}
//}
//else if (string.IsNullOrEmpty(eve.EmailId))
//{
sqlProc = "V8_USPGetCalenderEvent_MobileNoEmailIds_New";
parameterList = new MySqlParameter[2];
if (monthCal.groupCategory == "2")
{
parameterList[0] = new MySqlParameter("?UniqueID", eve.MemberID.Substring(1));
}
else
{
parameterList[0] = new MySqlParameter("?UniqueID", eve.MemberID);
}
parameterList[1] = new MySqlParameter("?Type", "E");
result1 = MySqlHelper.ExecuteDataset(GlobalVar.strAppConn, CommandType.StoredProcedure, sqlProc, parameterList);
if (result1 != null)
{
EmailIdsList = GlobalFuns.DataTableToList <clsCalenderEmailId>(result1.Tables[0]);
}
//if (EmailIdsList.Count > 0)
//{
// ListResult1.Add(EmailIdsList[0]);
//}
//}
eve.EmailIds = EmailIdsList;
eve.MobileNo = MobileNoList;
}
else
{
eve.EmailIds = EmailIdsList;
eve.MobileNo = MobileNoList;
}
}
//}
ClsMonthCalenderOutputNew calender = new ClsMonthCalenderOutputNew();
calender.Events = NewEventList;
return(calender);
}
catch
{
throw;
}
}
