public static int addUpdateWebLink(clsAddWebLinkInput obj) { try { MySqlParameter[] param = new MySqlParameter[5]; param[0] = new MySqlParameter("?weblinkId", obj.WeblinkId); param[1] = new MySqlParameter("?groupId", obj.GroupId); param[2] = new MySqlParameter("?createdBy", obj.CreateBy); param[3] = new MySqlParameter("?title", obj.Title); param[4] = new MySqlParameter("?description", string.IsNullOrEmpty(obj.Description) ? "" : obj.Description); param[5] = new MySqlParameter("?url", string.IsNullOrEmpty(obj.LinkUrl) ? "" : obj.LinkUrl); MySqlHelper.ExecuteNonQuery(GlobalVar.strAppConn, CommandType.StoredProcedure, "WEBAddUpdateWebLink", param); int result = Convert.ToInt32(param[0].Value); return(result); } catch (Exception ex) { ManageExceptions.TraceException("WebLinks/addUpdateWebLink", "addUpdateWebLink()", Convert.ToString(ex.InnerException), Convert.ToString(ex.Message), Convert.ToString(ex.StackTrace)); throw ex; } }
public static EventJoinResult AnsweringEvent(AnsweringEvent obj_Responce) { try { dynamic EventJoinResult = null; MySqlParameter[] param = new MySqlParameter[5]; param[0] = new MySqlParameter("?profileID", Convert.ToInt32(obj_Responce.profileID)); param[1] = new MySqlParameter("?eventId", Convert.ToInt32(obj_Responce.eventId)); param[2] = new MySqlParameter("?joiningStatus", obj_Responce.joiningStatus); param[3] = new MySqlParameter("?questionId", string.IsNullOrEmpty(obj_Responce.questionId) ? "0" : obj_Responce.questionId); param[4] = new MySqlParameter("?answer", string.IsNullOrEmpty(obj_Responce.answerByme) ? "" : obj_Responce.answerByme); using (TouchBaseWebAPI.Data.row_productionEntities context = new TouchBaseWebAPI.Data.row_productionEntities()) { context.Connection.Open(); EventJoinResult = context.ExecuteStoreQuery <EventJoinResult>("CALL V4_USPAnsweringEvent(?profileID,?eventId,?joiningStatus,?questionId,?answer)", param).ToList(); return(EventJoinResult[0]); } } catch (Exception ex) { ManageExceptions.TraceException("Event/AnsweringEvent", "AnsweringEvent()", Convert.ToString(ex.InnerException), Convert.ToString(ex.Message), Convert.ToString(ex.StackTrace)); throw ex; } }
/// <summary> /// Created By : Madhavi /// Add and update event data /// created On 16/03/2018 /// </summary> public static Imgname AddEvent_New(AddEventResult obj_Input) { string subGrpIDs = ""; try { if (obj_Input.isSubGrpAdmin == "1") { subGrpIDs = SubGroupDirectory.GetAdminSubGroupList(obj_Input.grpID, obj_Input.userID); } MySqlParameter[] param = new MySqlParameter[28]; param[0] = new MySqlParameter("?eventID", string.IsNullOrEmpty(obj_Input.eventID) ? "0" : obj_Input.eventID); param[1] = new MySqlParameter("?questionEnable", string.IsNullOrEmpty(obj_Input.questionEnable) ? "0" : obj_Input.questionEnable); param[2] = new MySqlParameter("?eventType", obj_Input.eventType); param[3] = new MySqlParameter("?membersIDs", obj_Input.membersIDs); param[4] = new MySqlParameter("?eventImageID", string.IsNullOrEmpty(obj_Input.eventImageID) ? "0" : obj_Input.eventImageID); param[5] = new MySqlParameter("?evntTitle", obj_Input.evntTitle); param[6] = new MySqlParameter("?evntDesc", obj_Input.evntDesc); param[7] = new MySqlParameter("?eventVenue", obj_Input.eventVenue); param[8] = new MySqlParameter("?venueLat", obj_Input.venueLat); param[9] = new MySqlParameter("?venueLong", obj_Input.venueLong); param[10] = new MySqlParameter("?evntDate", obj_Input.evntDate); param[11] = new MySqlParameter("?publishDate", obj_Input.publishDate); param[12] = new MySqlParameter("?expiryDate", obj_Input.expiryDate); param[13] = new MySqlParameter("?sendSMSAll", obj_Input.sendSMSAll); param[14] = new MySqlParameter("?rsvpEnable", obj_Input.rsvpEnable); param[15] = new MySqlParameter("?sendSMSNonSmartPh", obj_Input.sendSMSNonSmartPh); param[16] = new MySqlParameter("?userID", obj_Input.userID); param[17] = new MySqlParameter("?grpID", obj_Input.grpID); param[18] = new MySqlParameter("?questionID", string.IsNullOrEmpty(obj_Input.questionId) ? "" : obj_Input.questionId); param[19] = new MySqlParameter("?questionText", string.IsNullOrEmpty(obj_Input.questionText) ? "" : obj_Input.questionText); param[20] = new MySqlParameter("?questionType", string.IsNullOrEmpty(obj_Input.questionType) ? "" : obj_Input.questionType); param[21] = new MySqlParameter("?option1", string.IsNullOrEmpty(obj_Input.option1) ? "" : obj_Input.option1); param[22] = new MySqlParameter("?option2", string.IsNullOrEmpty(obj_Input.option2) ? "" : obj_Input.option2); param[23] = new MySqlParameter("?rsvpRepeatDate", string.IsNullOrEmpty(obj_Input.repeatDateTime) ? "" : obj_Input.repeatDateTime); param[24] = new MySqlParameter("?IsSubGrpAdmin", string.IsNullOrEmpty(obj_Input.isSubGrpAdmin) ? "0" : obj_Input.isSubGrpAdmin); param[25] = new MySqlParameter("?subgrpIDs", subGrpIDs); param[26] = new MySqlParameter("?displayonbanner", obj_Input.displayonbanner); param[27] = new MySqlParameter("?reglink", obj_Input.reglink); using (TouchBaseWebAPI.Data.row_productionEntities context = new TouchBaseWebAPI.Data.row_productionEntities()) { context.Connection.Open(); //var Result = _DbTouchbase.ExecuteStoreQuery<Imgname> var Result = context.ExecuteStoreQuery <Imgname> ("CALL V8_USPAddEvent(?eventID,?questionEnable,?eventType,?membersIDs,?eventImageID,?evntTitle,?evntDesc,?eventVenue,?venueLat,?venueLong,?evntDate,?publishDate,?expiryDate,?userID,?grpID,?sendSMSNonSmartPh,?sendSMSAll,?rsvpEnable,?rsvpRepeatDate,?questionId,?questionText,?questionType,?option1,?option2,?IsSubGrpAdmin,?subgrpIDs,?displayonbanner,?reglink)", param).SingleOrDefault(); return(Result); } } catch (Exception ex) { ManageExceptions.TraceException("Event/AddEvent", "AddEvent()", Convert.ToString(ex.InnerException), Convert.ToString(ex.Message), Convert.ToString(ex.StackTrace)); throw; } }
public static List <EventsDetail> GetEventBySearchText(string text) { try { var searchText = new MySqlParameter("?Search_Text", text); var Result = _DbTouchbase.ExecuteStoreQuery <EventsDetail>("CALL USPEventSearchBYText(?Search_Text)", searchText).ToList(); return(Result); } catch (Exception ex) { ManageExceptions.TraceException("Event/GetEventBySearchText", "GetEventBySearchText()", Convert.ToString(ex.InnerException), Convert.ToString(ex.Message), Convert.ToString(ex.StackTrace)); throw ex; } }
public static Imgname createAnnouncement(AddAnnouncement ann) { string subgrpIDs = ""; try { if (ann.isSubGrpAdmin == "1" && ann.annType == "0") { subgrpIDs = SubGroupDirectory.GetAdminSubGroupList(ann.grpID, ann.memID); } MySqlParameter[] param = new MySqlParameter[17]; param[0] = new MySqlParameter("?annID", string.IsNullOrEmpty(ann.announID) ? "0" : ann.announID); param[1] = new MySqlParameter("?annType", ann.annType); param[2] = new MySqlParameter("?announTitle", ann.announTitle); param[3] = new MySqlParameter("?announceDEsc", string.IsNullOrEmpty(ann.announceDEsc) ? "" : ann.announceDEsc); param[4] = new MySqlParameter("?memID", ann.memID); param[5] = new MySqlParameter("?grpID", ann.grpID); param[6] = new MySqlParameter("?memprofileIDs", string.IsNullOrEmpty(ann.inputIDs) ? "" : ann.inputIDs); param[7] = new MySqlParameter("?moduleId", ann.moduleId); // Added by Nandu on 07/11/2016 Task--> Module replica param[8] = new MySqlParameter("?announcementImg", string.IsNullOrEmpty(ann.announImg) ? "0" : ann.announImg); param[9] = new MySqlParameter("?sendSMSAll", string.IsNullOrEmpty(ann.sendSMSAll) ? "0" : ann.sendSMSAll); param[10] = new MySqlParameter("?sendSMSNonSmartPh", string.IsNullOrEmpty(ann.sendSMSNonSmartPh) ? "0" : ann.sendSMSNonSmartPh); param[11] = new MySqlParameter("?publishDate", ann.publishDate); param[12] = new MySqlParameter("?expiryDate", ann.expiryDate); param[13] = new MySqlParameter("?IsSubGrpAdmin", string.IsNullOrEmpty(ann.isSubGrpAdmin) ? "0" : ann.isSubGrpAdmin); param[14] = new MySqlParameter("?subgrpIDs", subgrpIDs); param[15] = new MySqlParameter("?annRepeatDate", string.IsNullOrEmpty(ann.AnnouncementRepeatDates) ? "" : ann.AnnouncementRepeatDates); param[16] = new MySqlParameter("?reglink", ann.reglink); using (TouchBaseWebAPI.Data.row_productionEntities context = new TouchBaseWebAPI.Data.row_productionEntities()) { context.Connection.Open(); var Result = context.ExecuteStoreQuery <Imgname>("CALL V6_USPAddAnnouncement(?annID,?annType,?announTitle,?announceDEsc,?memID,?grpID,?memprofileIDs,?moduleId,?announcementImg,?publishDate,?expiryDate,?sendSMSAll,?sendSMSNonSmartPh,?IsSubGrpAdmin,?subgrpIDs,?annRepeatDate,?reglink)", param).SingleOrDefault(); return(Result); } } catch (Exception ex) { ManageExceptions.TraceException("Announcement/AddAnnouncement", "createAnnouncement()", Convert.ToString(ex.InnerException), Convert.ToString(ex.Message), Convert.ToString(ex.StackTrace)); throw ex; } }
public static List <EventsDetail> GetEventBySearchText(string text) { try { using (TouchBaseWebAPI.Data.row_productionEntities context = new TouchBaseWebAPI.Data.row_productionEntities()) { context.Connection.Open(); var searchText = new MySqlParameter("?Search_Text", text); var Result = context.ExecuteStoreQuery <EventsDetail>("CALL USPEventSearchBYText(?Search_Text)", searchText).ToList(); return(Result); } } catch (Exception ex) { ManageExceptions.TraceException("Event/GetEventBySearchText", "GetEventBySearchText()", Convert.ToString(ex.InnerException), Convert.ToString(ex.Message), Convert.ToString(ex.StackTrace)); throw ex; } }
public static List <EventList> GetEventList(string memberID, string grpID, string SearchText, string type, string Admin, out string Grp_SMSCount) { try { MySqlParameter[] param = new MySqlParameter[6]; param[0] = new MySqlParameter("?memberId", memberID); param[1] = new MySqlParameter("?grpId", grpID); param[2] = new MySqlParameter("?searchText", SearchText); param[3] = new MySqlParameter("?filterType", type); param[4] = new MySqlParameter("?Admin", Admin); param[5] = new MySqlParameter("?SMS_Count", 0); param[5].Direction = ParameterDirection.InputOutput; DataSet Result = MySqlHelper.ExecuteDataset(GlobalVar.strAppConn, CommandType.StoredProcedure, "V4_USPEventSearchBYText", param); DataTable dt = Result.Tables[0]; List <EventList> res = new List <EventList>(); if (dt.Rows.Count > 0) { res = GlobalFuns.DataTableToList <EventList>(dt); foreach (EventList eve in res) { 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[5].Value.ToString(); return(res); } catch (Exception ex) { ManageExceptions.TraceException("Event/GetEventList", "GetEventList()", Convert.ToString(ex.InnerException), Convert.ToString(ex.Message), Convert.ToString(ex.StackTrace)); throw ex; } }