コード例 #1
0
        public static int updateGroupSetting(GrpSettingResult grp)
        {
            try
            {
                var GroupId        = new MySqlParameter("?GrpId", grp.GroupId);
                var ModuleId       = new MySqlParameter("?ModuleId", grp.ModuleId);
                var GroupProfileId = new MySqlParameter("?profileId", grp.GroupProfileId);

                var UpdatedValue = new MySqlParameter("?UpdatedValue", grp.UpdatedValue);

                var mobileSelf    = new MySqlParameter("?showMobileSeflfClub", grp.showMobileSeflfClub);
                var mobileOutside = new MySqlParameter("?showMobileOutsideClub", grp.showMobileOutsideClub);
                var emailSelf     = new MySqlParameter("?showEmailSeflfClub", grp.showEmailSeflfClub);
                var emailOutside  = new MySqlParameter("?showEmailOutsideClub", grp.showEmailOutsideClub);

                using (TouchBaseWebAPI.Data.row_productionEntities context = new TouchBaseWebAPI.Data.row_productionEntities())
                {
                    context.Connection.Open();
                    var Result = context.ExecuteStoreCommand("CALL USPGroupSettings(?GrpId,?ModuleId,?profileId,?UpdatedValue,?showMobileSeflfClub,?showMobileOutsideClub,?showEmailSeflfClub,?showEmailOutsideClub)",
                                                             GroupId, ModuleId, GroupProfileId, UpdatedValue, mobileSelf, mobileOutside, emailSelf, emailOutside);

                    return(Result);
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
コード例 #2
0
ファイル: Ticket.cs プロジェクト: KaizenInfotechIT/ChakiatAPI
        //private static TouchBaseWebAPI.Data.row_productionEntities _DBTouchbase = new TouchBaseWebAPI.Data.row_productionEntities();

        public static int createTicket(SendTicket tkt)
        {
            try
            {
                var grpID     = new MySqlParameter("?groupId", tkt.groupId);
                var profileId = new MySqlParameter("?memberProfileId", tkt.memberProfileId);
                var smsText   = new MySqlParameter("?smsText", tkt.smsText);
                var createBy  = new MySqlParameter("?createBy", tkt.createBy);

                using (TouchBaseWebAPI.Data.row_productionEntities context = new TouchBaseWebAPI.Data.row_productionEntities())
                {
                    context.Connection.Open();
                    var Result = context.ExecuteStoreCommand("CALL V2_USPAddTicket(?groupId,?memberProfileId,?smsText,?createBy)",
                                                             grpID, profileId, smsText, createBy);
                    return(Result);
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                GC.Collect();
            }
        }
コード例 #3
0
        public static int updateTouchbaseSetting(GroupDetail grp)
        {
            try
            {
                var grpId       = new MySqlParameter("?grpId", grp.GroupId);
                var updateValue = new MySqlParameter("?updateValue", grp.UpdatedValue);
                var mainMstId   = new MySqlParameter("?mainMstId", grp.mainMasterId);

                var Result = _DbTouchbase.ExecuteStoreCommand("CALL USPtouchbase_rowSettings(?grpId,?updateValue,?mainMstId)", grpId, updateValue, mainMstId);

                return(Result);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
コード例 #4
0
        public static int GetEbulletinDetails(EbulletinDetails ebull)
        {
            try
            {
                var EbullID         = new MySqlParameter("?EbullID", ebull.ebulletinID);
                var memberProfileID = new MySqlParameter("?memberProfileID", ebull.memberProfileID);

                var Result = _DBTouchbase.ExecuteStoreCommand("CALL USPGetEbulletinDetails(?EbullID,?memberProfileID)", EbullID, memberProfileID);
                return(Result);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
コード例 #5
0
        public static int UpdateDocumentDetails(UpdateReadFlag doc)
        {
            try
            {
                var docID           = new MySqlParameter("?docID", doc.docID);
                var memberProfileID = new MySqlParameter("?memberProfileID", doc.memberProfileID);

                var Result = _DBTouchbase.ExecuteStoreCommand("CALL USPUpdateDocumentDetails(?docID,?memberProfileID)", docID, memberProfileID);
                return(Result);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
コード例 #6
0
 public static int GetEbulletinDetails(EbulletinDetails ebull)
 {
     try
     {
         var EbullID         = new MySqlParameter("?EbullID", ebull.ebulletinID);
         var memberProfileID = new MySqlParameter("?memberProfileID", ebull.memberProfileID);
         using (TouchBaseWebAPI.Data.row_productionEntities context = new TouchBaseWebAPI.Data.row_productionEntities())
         {
             context.Connection.Open();
             var Result = context.ExecuteStoreCommand("CALL USPGetEbulletinDetails(?EbullID,?memberProfileID)", EbullID, memberProfileID);
             return(Result);
         }
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
コード例 #7
0
 public static int UpdateDocumentDetails(UpdateReadFlag doc)
 {
     try
     {
         var docID           = new MySqlParameter("?docID", doc.docID);
         var memberProfileID = new MySqlParameter("?memberProfileID", doc.memberProfileID);
         using (TouchBaseWebAPI.Data.row_productionEntities context = new TouchBaseWebAPI.Data.row_productionEntities())
         {
             context.Connection.Open();
             var Result = context.ExecuteStoreCommand("CALL USPUpdateDocumentDetails(?docID,?memberProfileID)", docID, memberProfileID);
             return(Result);
         }
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
コード例 #8
0
        //private static TouchBaseWebAPI.Data.row_productionEntities _DbTouchbase = new TouchBaseWebAPI.Data.row_productionEntities();

        public static int updateTouchbaseSetting(GroupDetail grp)
        {
            try
            {
                var grpId       = new MySqlParameter("?grpId", grp.GroupId);
                var updateValue = new MySqlParameter("?updateValue", grp.UpdatedValue);
                var mainMstId   = new MySqlParameter("?mainMstId", grp.mainMasterId);

                using (TouchBaseWebAPI.Data.row_productionEntities context = new TouchBaseWebAPI.Data.row_productionEntities())
                {
                    context.Connection.Open();
                    var Result = context.ExecuteStoreCommand("CALL USPtouchbase_rowSettings(?grpId,?updateValue,?mainMstId)", grpId, updateValue, mainMstId);
                    return(Result);
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
コード例 #9
0
ファイル: Ticket.cs プロジェクト: KaizenInfotechIT/ChakiatAPI
        public static int createTicket(SendTicket tkt)
        {
            try
            {
                var grpID     = new MySqlParameter("?groupId", tkt.groupId);
                var profileId = new MySqlParameter("?memberProfileId", tkt.memberProfileId);
                var smsText   = new MySqlParameter("?smsText", tkt.smsText);
                var createBy  = new MySqlParameter("?createBy", tkt.createBy);

                var Result = _DBTouchbase.ExecuteStoreCommand("CALL V2_USPAddTicket(?groupId,?memberProfileId,?smsText,?createBy)",
                                                              grpID, profileId, smsText, createBy);
                return(Result);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                GC.Collect();
            }
        }