コード例 #1
0
        public static Imgname createAlbum_New(ClsAddUpdateAlbumInput album)
        {
            string subgrpIDs = "";

            try
            {
                if (album.isSubGrpAdmin == "1" && album.type == "0")
                {
                    subgrpIDs = SubGroupDirectory.GetAdminSubGroupList(album.groupId, album.createdBy);
                }
                MySqlParameter[] ParameterList = new MySqlParameter[26];
                ParameterList[0] = new MySqlParameter("?p_gallery_id", album.albumId);
                ParameterList[1] = new MySqlParameter("?p_group_id", album.groupId);
                ParameterList[2] = new MySqlParameter("?p_gallery_type", album.type);

                ParameterList[3] = new MySqlParameter("?p_memprofileIDs", album.memberIds);

                ParameterList[4] = new MySqlParameter("?p_album_title", album.albumTitle);
                ParameterList[5] = new MySqlParameter("?p_album_description", string.IsNullOrEmpty(album.albumDescription) ? "" : album.albumDescription);
                ParameterList[6] = new MySqlParameter("?p_image", string.IsNullOrEmpty(album.albumImage) ? "0" : album.albumImage);

                ParameterList[7] = new MySqlParameter("?p_createdby", album.createdBy);
                ParameterList[8] = new MySqlParameter("?IsSubgrpAdmin", string.IsNullOrEmpty(album.isSubGrpAdmin) ? "0" : album.isSubGrpAdmin);
                ParameterList[9] = new MySqlParameter("?subGrpIDs", subgrpIDs);

                ParameterList[10] = new MySqlParameter("?moduleID", album.moduleId);   // Added for Gallery Replica
                ParameterList[11] = new MySqlParameter("?shareType", album.shareType); // Added for Gallery shareType


                ParameterList[12] = new MySqlParameter("?categoryId", album.categoryId);
                ParameterList[13] = new MySqlParameter("?dateofproect", album.dateofproject);
                ParameterList[14] = new MySqlParameter("?costofproject", album.costofproject);
                ParameterList[15] = new MySqlParameter("?beneficiary", album.beneficiary);
                ParameterList[16] = new MySqlParameter("?manhourspent", album.manhourspent);
                ParameterList[17] = new MySqlParameter("?manhourspenttype", album.manhourspenttype);
                ParameterList[18] = new MySqlParameter("?p_NumberofRotarian", album.NumberofRotarian);
                ParameterList[19] = new MySqlParameter("?p_OtherCategorytext", album.OtherCategorytext);
                ParameterList[20] = new MySqlParameter("?costofprojecttype", album.costofprojecttype);

                ParameterList[21] = new MySqlParameter("?Attendance", album.Attendance);
                ParameterList[22] = new MySqlParameter("?AttendancePer", album.AttendancePer);
                ParameterList[23] = new MySqlParameter("?MeetingType", album.MeetingType);
                ParameterList[24] = new MySqlParameter("?AgendaDocID", album.AgendaDocID);
                ParameterList[25] = new MySqlParameter("?MOMDocID", album.MOMDocID);

                using (TouchBaseWebAPI.Data.row_productionEntities context = new TouchBaseWebAPI.Data.row_productionEntities())
                {
                    context.Connection.Open();
                    var Result = context.ExecuteStoreQuery <Imgname>("CALL V7_1_USPAddEditGallery(?p_gallery_id, ?p_group_id, ?p_gallery_type, ?p_memprofileIDs, ?p_album_title, ?p_album_description, ?p_image, ?p_createdby, ?IsSubgrpAdmin, ?subGrpIDs, ?moduleID, ?shareType,?categoryId,?dateofproect,?costofproject,?beneficiary,?manhourspent,?manhourspenttype,?p_NumberofRotarian,?p_OtherCategorytext,?costofprojecttype,?Attendance,?AttendancePer,?MeetingType,?AgendaDocID,?MOMDocID)", ParameterList).SingleOrDefault();

                    return(Result);
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
コード例 #2
0
        /// <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;
            }
        }
コード例 #3
0
        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;
            }
        }
コード例 #4
0
        public static string createEbulletin(AddEbulletin ebulletin)
        {
            string subgrpIDs = "";

            try
            {
                if (ebulletin.isSubGrpAdmin == "1" && ebulletin.ebulletinType == "0")
                {
                    subgrpIDs = SubGroupDirectory.GetAdminSubGroupList(ebulletin.grpID, ebulletin.memID);
                }

                MySqlParameter[] param = new MySqlParameter[14];
                param[0] = new MySqlParameter("?bulletinID", string.IsNullOrEmpty(ebulletin.ebulletinID) ? "0" : ebulletin.ebulletinID);

                param[1] = new MySqlParameter("?bulletinType", string.IsNullOrEmpty(ebulletin.ebulletinType) ? "0" : ebulletin.ebulletinType);
                param[2] = new MySqlParameter("?ebulletinTitle", ebulletin.ebulletinTitle);
                param[3] = new MySqlParameter("?ebulletinlink", string.IsNullOrEmpty(ebulletin.ebulletinlink) ? "" : ebulletin.ebulletinlink);
                param[4] = new MySqlParameter("?ebulletinfile", string.IsNullOrEmpty(ebulletin.ebulletinfileid) ? "" : ebulletin.ebulletinfileid);

                param[5] = new MySqlParameter("?memID", ebulletin.memID);
                param[6] = new MySqlParameter("?grpID", ebulletin.grpID);
                param[7] = new MySqlParameter("?memprofileIDs", string.IsNullOrEmpty(ebulletin.inputIDs) ? "" : ebulletin.inputIDs);

                param[8] = new MySqlParameter("?publishDate", ebulletin.publishDate);
                param[9] = new MySqlParameter("?expiryDate", ebulletin.expiryDate);

                param[10] = new MySqlParameter("?sendSMSAll", string.IsNullOrEmpty(ebulletin.sendSMSAll) ? "0" : ebulletin.sendSMSAll);
                param[11] = new MySqlParameter("?sendSMSNonSmartPh", string.IsNullOrEmpty(ebulletin.sendSMSNonSmartPh) ? "0" : ebulletin.sendSMSNonSmartPh);

                param[12] = new MySqlParameter("?IsSubGrpAdmin", string.IsNullOrEmpty(ebulletin.isSubGrpAdmin) ? "0" : ebulletin.isSubGrpAdmin);
                param[13] = new MySqlParameter("?subgrpIDs", subgrpIDs);
                using (TouchBaseWebAPI.Data.row_productionEntities context = new TouchBaseWebAPI.Data.row_productionEntities())
                {
                    context.Connection.Open();
                    var Result = context.ExecuteStoreQuery <string>("CALL V5_USPAddEbulletin(?bulletinID,?bulletinType,?ebulletinTitle,?ebulletinlink,?ebulletinfile,?memID,?grpID,?memprofileIDs,?publishDate,?expiryDate,?sendSMSAll,?sendSMSNonSmartPh,?IsSubGrpAdmin,?subgrpIDs)", param).SingleOrDefault();
                    return(Result);
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
コード例 #5
0
        public static AddDocResult createDocument(AddDocument doc)
        {
            string subgrpIDs = "";

            try
            {
                if (doc.isSubGrpAdmin == "1" && doc.docType == "0")
                {
                    subgrpIDs = SubGroupDirectory.GetAdminSubGroupList(doc.grpID, doc.memID);
                }

                MySqlParameter[] param = new MySqlParameter[12];
                param[0] = new MySqlParameter("?docID", string.IsNullOrEmpty(doc.docID) ? "0" : doc.docID);
                param[1] = new MySqlParameter("?documentType", doc.docType);
                param[2] = new MySqlParameter("?documentTitle", doc.docTitle);

                param[3] = new MySqlParameter("?docAccessType", doc.docAccessType);

                param[4] = new MySqlParameter("?memID", doc.memID);
                param[5] = new MySqlParameter("?grpID", doc.grpID);
                param[6] = new MySqlParameter("?memprofileIDs", string.IsNullOrEmpty(doc.inputIDs) ? "" : doc.inputIDs);

                param[7] = new MySqlParameter("?documentFileId", string.IsNullOrEmpty(doc.documentFileId) ? "0" : doc.documentFileId);
                param[8] = new MySqlParameter("?isSubGrpAdmin", string.IsNullOrEmpty(doc.isSubGrpAdmin)?"0":doc.isSubGrpAdmin);
                param[9] = new MySqlParameter("?subgrpIDs", subgrpIDs);

                param[10] = new MySqlParameter("?publishDate", doc.publishDate);
                param[11] = new MySqlParameter("?expiryDate", doc.expiryDate);

                using (TouchBaseWebAPI.Data.row_productionEntities context = new TouchBaseWebAPI.Data.row_productionEntities())
                {
                    context.Connection.Open();
                    var Result = context.ExecuteStoreQuery <AddDocResult>("CALL V6_USPAddDocument(?docID,?documentType,?documentTitle,?docAccessType,?memID,?grpID,?memprofileIDs,?documentFileId,?isSubGrpAdmin,?subgrpIDs,?publishDate,?expiryDate)", param).SingleOrDefault();
                    return(Result);
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
コード例 #6
0
        public static Imgname createAlbum(ClsAddUpdateAlbumInput album)
        {
            string subgrpIDs = "";

            try
            {
                if (album.isSubGrpAdmin == "1" && album.type == "0")
                {
                    subgrpIDs = SubGroupDirectory.GetAdminSubGroupList(album.groupId, album.createdBy);
                }
                MySqlParameter[] ParameterList = new MySqlParameter[12];
                ParameterList[0] = new MySqlParameter("?p_gallery_id", album.albumId);
                ParameterList[1] = new MySqlParameter("?p_group_id", album.groupId);
                ParameterList[2] = new MySqlParameter("?p_gallery_type", album.type);

                ParameterList[3] = new MySqlParameter("?p_memprofileIDs", album.memberIds);

                ParameterList[4] = new MySqlParameter("?p_album_title", album.albumTitle);
                ParameterList[5] = new MySqlParameter("?p_album_description", string.IsNullOrEmpty(album.albumDescription) ? "" : album.albumDescription);
                ParameterList[6] = new MySqlParameter("?p_image", string.IsNullOrEmpty(album.albumImage) ? "0" : album.albumImage);

                ParameterList[7] = new MySqlParameter("?p_createdby", album.createdBy);
                ParameterList[8] = new MySqlParameter("?IsSubgrpAdmin", string.IsNullOrEmpty(album.isSubGrpAdmin) ? "0" : album.isSubGrpAdmin);
                ParameterList[9] = new MySqlParameter("?subGrpIDs", subgrpIDs);

                ParameterList[10] = new MySqlParameter("?moduleID", album.moduleId);   // Added for Gallery Replica
                ParameterList[11] = new MySqlParameter("?shareType", album.shareType); // Added for Gallery shareType
                using (TouchBaseWebAPI.Data.row_productionEntities context = new TouchBaseWebAPI.Data.row_productionEntities())
                {
                    context.Connection.Open();
                    var Result = context.ExecuteStoreQuery <Imgname>("CALL V6_1_USPAddEditGallery(?p_gallery_id, ?p_group_id, ?p_gallery_type, ?p_memprofileIDs, ?p_album_title, ?p_album_description, ?p_image, ?p_createdby, ?IsSubgrpAdmin, ?subGrpIDs, ?moduleID, ?shareType)", ParameterList).SingleOrDefault();

                    return(Result);
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }