public int DeleteAllDefinition(AllDefinition allDefinition)
        {
            using (DemsifyEntities dataContext = new DemsifyEntities())
            {
                ObjectParameter result = new ObjectParameter("Result", typeof(int));

                dataContext.AllDefinitionDelete(allDefinition.Id, allDefinition.ModifiedBy, result);

                return(Convert.ToInt32(result.Value));
            }
        }
        public int UpdateUserProfile(UserProfile userProfile)
        {
            using (DemsifyEntities dataContext = new DemsifyEntities())
            {
                ObjectParameter result = new ObjectParameter("Result", typeof(int));

                dataContext.UserProfileUpdate(userProfile.UserId, Utility.TrimString(userProfile.UserName), Utility.TrimString(userProfile.FirstName), Utility.TrimString(userProfile.LastName), Utility.TrimString(userProfile.Mobile), Utility.TrimString(userProfile.Gender), Utility.TrimString(userProfile.CompanyName), userProfile.ProfessionalQualificationId, Utility.TrimString(userProfile.City), Utility.TrimString(userProfile.MobileOTP), Utility.TrimString(userProfile.EmailOTP), userProfile.IsActive, userProfile.IsDeleted, userProfile.ModifiedBy, result);

                return(Convert.ToInt32(result.Value));
            }
        }
        public int UpdateFetersCodeGroupDetail(FetersCodeGroupDetail fetersCodeGroupDetail)
        {
            using (DemsifyEntities dataContext = new DemsifyEntities())
            {
                ObjectParameter result = new ObjectParameter("Result", typeof(int));

                dataContext.FetersCodeGroupDetailUpdate(fetersCodeGroupDetail.FetersCodeGroupDetailId, fetersCodeGroupDetail.FetersCodeDetailId, Utility.TrimString(fetersCodeGroupDetail.PurposeCode), Utility.TrimString(fetersCodeGroupDetail.Description), fetersCodeGroupDetail.ModifiedBy, result);

                return(Convert.ToInt32(result.Value));
            }
        }
        public int AddSector(Sector sector)
        {
            using (DemsifyEntities dataContext = new DemsifyEntities())
            {
                ObjectParameter result = new ObjectParameter("Result", typeof(int));

                dataContext.SectorAdd(Utility.TrimString(sector.Name), sector.CreatedBy, result);

                return(Convert.ToInt32(result.Value));
            }
        }
Example #5
0
        public int AddContactUs(ContactUs contactUs)
        {
            using (DemsifyEntities dataContext = new DemsifyEntities())
            {
                ObjectParameter result = new ObjectParameter("Result", typeof(int));

                dataContext.ContactUsAdd(Utility.TrimString(contactUs.Name), Utility.TrimString(contactUs.Email), Utility.TrimString(contactUs.Mobile), Utility.TrimString(contactUs.Comment), contactUs.CreatedBy, result);

                return(Convert.ToInt32(result.Value));
            }
        }
Example #6
0
        public int UpdateMasterDirectionIndex(MasterDirectionIndex masterDirectionIndex)
        {
            using (DemsifyEntities dataContext = new DemsifyEntities())
            {
                ObjectParameter result = new ObjectParameter("Result", typeof(int));

                dataContext.MasterDirectionIndexUpdate(masterDirectionIndex.MasterDirectionIndexId, masterDirectionIndex.MasterDirectionChapterId, Utility.TrimString(masterDirectionIndex.IndexNo), Utility.TrimString(masterDirectionIndex.IndexName), Utility.TrimString(masterDirectionIndex.IndexContent), masterDirectionIndex.SaveAfterIndexId, masterDirectionIndex.ModifiedBy, result);

                return(Convert.ToInt32(result.Value));
            }
        }
        public int UpdateFormSummaryDocumentationDetail(FormSummaryDocumentationDetail formSummaryDocumentationDetail)
        {
            using (DemsifyEntities dataContext = new DemsifyEntities())
            {
                ObjectParameter result = new ObjectParameter("Result", typeof(int));

                dataContext.FormSummaryDocumentationDetailUpdate(formSummaryDocumentationDetail.FormSummaryDocumentationDetailId, formSummaryDocumentationDetail.FormSummaryDocumentationId, Utility.TrimString(formSummaryDocumentationDetail.FormName), Utility.TrimString(formSummaryDocumentationDetail.WordFileName), Utility.TrimString(formSummaryDocumentationDetail.ExcelFileName), Utility.TrimString(formSummaryDocumentationDetail.PDFFileName), Utility.TrimString(formSummaryDocumentationDetail.SubMenuName), formSummaryDocumentationDetail.ModifiedBy, result);

                return(Convert.ToInt32(result.Value));
            }
        }
Example #8
0
        public int UpdateSubscriptionMailSent(Subscription subscription)
        {
            using (DemsifyEntities dataContext = new DemsifyEntities())
            {
                ObjectParameter result = new ObjectParameter("Result", typeof(int));

                dataContext.SubscriptionMailSentUpdate(subscription.SubscriptionId, subscription.IsMailSentToUser, subscription.IsMailSentToAdmin, subscription.ModifiedBy, result);

                return(Convert.ToInt32(result.Value));
            }
        }
        public int AddMasterCircularDetail(MasterCircularDetail masterCircularDetail)
        {
            using (DemsifyEntities dataContext = new DemsifyEntities())
            {
                ObjectParameter result = new ObjectParameter("Result", typeof(int));

                dataContext.MasterCircularDetailAdd(masterCircularDetail.MasterCircularId, masterCircularDetail.Year, masterCircularDetail.PDF, masterCircularDetail.CreatedBy, result);

                return(Convert.ToInt32(result.Value));
            }
        }
Example #10
0
        public int AddSubscription(Subscription subscription)
        {
            using (DemsifyEntities dataContext = new DemsifyEntities())
            {
                ObjectParameter result = new ObjectParameter("Result", typeof(int));

                dataContext.SubscriptionAdd(subscription.UserId, subscription.PackageId, subscription.CreatedBy, result);

                return(Convert.ToInt32(result.Value));
            }
        }
Example #11
0
        public int UpdateSubscription(Subscription subscription)
        {
            using (DemsifyEntities dataContext = new DemsifyEntities())
            {
                ObjectParameter result = new ObjectParameter("Result", typeof(int));

                dataContext.SubscriptionUpdate(subscription.SubscriptionId, subscription.StartDate, subscription.PaymentDate, subscription.IsExpired, subscription.IsActive, subscription.ModifiedBy, result);

                return(Convert.ToInt32(result.Value));
            }
        }
Example #12
0
        public int UpdateSupportTicketMailSent(SupportTicket supportTicket)
        {
            using (DemsifyEntities dataContext = new DemsifyEntities())
            {
                ObjectParameter result = new ObjectParameter("Result", typeof(int));

                dataContext.SupportTicketMailSentUpdate(supportTicket.SupportTicketId, supportTicket.IsMailSentToAdmin, supportTicket.ModifiedBy, result);

                return Convert.ToInt32(result.Value);
            }
        }
Example #13
0
        public int AddSupportTicket(SupportTicket supportTicket)
        {
            using (DemsifyEntities dataContext = new DemsifyEntities())
            {
                ObjectParameter result = new ObjectParameter("Result", typeof(int));

                dataContext.SupportTicketAdd(supportTicket.UserId, supportTicket.TopicId, supportTicket.SubTopicId, Utility.TrimString(supportTicket.QueryTitle), supportTicket.DepartmentId, Utility.TrimString(supportTicket.Query), supportTicket.CreatedBy, result);

                return Convert.ToInt32(result.Value);
            }
        }
Example #14
0
        public int DeletePressNoteAPDIRCircular(PressNoteAPDIRCircular pressNoteAPDIRCircular)
        {
            using (DemsifyEntities dataContext = new DemsifyEntities())
            {
                ObjectParameter result = new ObjectParameter("Result", typeof(int));

                dataContext.PressNoteAPDIRCircularDelete(pressNoteAPDIRCircular.PressNoteAPDIRCircularId, pressNoteAPDIRCircular.ModifiedBy, result);

                return(Convert.ToInt32(result.Value));
            }
        }
Example #15
0
        public int UpdateRegulation(Regulation regulation)
        {
            using (DemsifyEntities dataContext = new DemsifyEntities())
            {
                ObjectParameter result = new ObjectParameter("Result", typeof(int));

                dataContext.RegulationUpdate(regulation.RegulationId, Utility.TrimString(regulation.RegulationName), Utility.TrimString(regulation.RegulationNumber), Utility.TrimString(regulation.Year), regulation.PublicationDate, regulation.ModifiedBy, result);

                return(Convert.ToInt32(result.Value));
            }
        }
        public int DeleteMasterCircularDetail(MasterCircularDetail masterCircularDetail)
        {
            using (DemsifyEntities dataContext = new DemsifyEntities())
            {
                ObjectParameter result = new ObjectParameter("Result", typeof(int));

                dataContext.MasterCircularDetailDelete(masterCircularDetail.MasterCircularDetailId, masterCircularDetail.ModifiedBy, result);

                return(Convert.ToInt32(result.Value));
            }
        }
Example #17
0
        public int DeleteRegulation(Regulation regulation)
        {
            using (DemsifyEntities dataContext = new DemsifyEntities())
            {
                ObjectParameter result = new ObjectParameter("Result", typeof(int));

                dataContext.RegulationDelete(regulation.RegulationId, regulation.ModifiedBy, result);

                return(Convert.ToInt32(result.Value));
            }
        }
        public int DeleteSupportTicketReply(SupportTicketReply supportTicketReply)
        {
            using (DemsifyEntities dataContext = new DemsifyEntities())
            {
                ObjectParameter result = new ObjectParameter("Result", typeof(int));

                dataContext.SupportTicketReplyDelete(supportTicketReply.SupportTicketReplyId, supportTicketReply.ModifiedBy, result);

                return(Convert.ToInt32(result.Value));
            }
        }
Example #19
0
        public int DeleteMasterDirectionIndex(MasterDirectionIndex masterDirectionIndex)
        {
            using (DemsifyEntities dataContext = new DemsifyEntities())
            {
                ObjectParameter result = new ObjectParameter("Result", typeof(int));

                dataContext.MasterDirectionIndexDelete(masterDirectionIndex.MasterDirectionIndexId, masterDirectionIndex.MasterDirectionChapterId, masterDirectionIndex.ModifiedBy, result);

                return(Convert.ToInt32(result.Value));
            }
        }
        public int AddLoginHistory(LoginHistory loginHistory)
        {
            using (DemsifyEntities dataContext = new DemsifyEntities())
            {
                ObjectParameter result = new ObjectParameter("Result", typeof(int));

                dataContext.LoginHistoryAdd(Utility.TrimString(loginHistory.LoginFrom), loginHistory.UserId, Utility.TrimString(loginHistory.AccessToken), result);

                return(Convert.ToInt32(result.Value));
            }
        }
        public int DeleteFormSummaryDocumentationDetail(FormSummaryDocumentationDetail formSummaryDocumentationDetail)
        {
            using (DemsifyEntities dataContext = new DemsifyEntities())
            {
                ObjectParameter result = new ObjectParameter("Result", typeof(int));

                dataContext.FormSummaryDocumentationDetailDelete(formSummaryDocumentationDetail.FormSummaryDocumentationDetailId, formSummaryDocumentationDetail.ModifiedBy, result);

                return(Convert.ToInt32(result.Value));
            }
        }
        public bool CheckAccessToken(LoginHistory loginHistory)
        {
            using (DemsifyEntities dataContext = new DemsifyEntities())
            {
                ObjectParameter isValid = new ObjectParameter("IsValid", typeof(int));

                dataContext.AccessTokenCheck(Utility.TrimString(loginHistory.AccessToken), isValid);

                return(Convert.ToBoolean(isValid.Value));
            }
        }
        public int DeleteSector(Sector sector)
        {
            using (DemsifyEntities dataContext = new DemsifyEntities())
            {
                ObjectParameter result = new ObjectParameter("Result", typeof(int));

                dataContext.SectorDelete(sector.SectorId, sector.ModifiedBy, result);

                return(Convert.ToInt32(result.Value));
            }
        }
Example #24
0
        public int UpdateFormSummaryDocumentation(FormSummaryDocumentation formSummaryDocumentation)
        {
            using (DemsifyEntities dataContext = new DemsifyEntities())
            {
                ObjectParameter result = new ObjectParameter("Result", typeof(int));

                dataContext.FormSummaryDocumentationUpdate(formSummaryDocumentation.FormSummaryDocumentationId, Utility.TrimString(formSummaryDocumentation.TopicName), Utility.TrimString(formSummaryDocumentation.SubMenuName), formSummaryDocumentation.ModifiedBy, result);

                return(Convert.ToInt32(result.Value));
            }
        }
Example #25
0
        public int DeleteContactUs(ContactUs contactUs)
        {
            using (DemsifyEntities dataContext = new DemsifyEntities())
            {
                ObjectParameter result = new ObjectParameter("Result", typeof(int));

                dataContext.ContactUsDelete(contactUs.ContactUsId, contactUs.ModifiedBy, result);

                return(Convert.ToInt32(result.Value));
            }
        }
        public int UpdateFDICircularIndex(FDICircularIndex fDICircularIndex)
        {
            using (DemsifyEntities dataContext = new DemsifyEntities())
            {
                ObjectParameter result = new ObjectParameter("Result", typeof(int));

                dataContext.FDICircularIndexUpdate(fDICircularIndex.FDICircularIndexId, fDICircularIndex.FDIChapterId, Utility.TrimString(fDICircularIndex.IndexNo), Utility.TrimString(fDICircularIndex.IndexName), Utility.TrimString(fDICircularIndex.IndexContent), fDICircularIndex.SaveAfterIndexId, fDICircularIndex.ModifiedBy, result);

                return(Convert.ToInt32(result.Value));
            }
        }
        public int OTPUpdateForUserProfile(UserProfile userProfile)
        {
            using (DemsifyEntities dataContext = new DemsifyEntities())
            {
                ObjectParameter result = new ObjectParameter("Result", typeof(int));

                dataContext.OTPUpdateForUserProfile(userProfile.UserId, Utility.TrimString(userProfile.Mobile), Utility.TrimString(userProfile.MobileOTP), Utility.TrimString(userProfile.EmailOTP), userProfile.IsVerified, result);

                return(Convert.ToInt32(result.Value));
            }
        }
        public int DeleteFDICircularIndex(FDICircularIndex fDICircularIndex)
        {
            using (DemsifyEntities dataContext = new DemsifyEntities())
            {
                ObjectParameter result = new ObjectParameter("Result", typeof(int));

                dataContext.FDICircularIndexDelete(fDICircularIndex.FDICircularIndexId, fDICircularIndex.FDIChapterId, fDICircularIndex.ModifiedBy, result);

                return(Convert.ToInt32(result.Value));
            }
        }
        public int DeleteFetersCodeGroupDetail(FetersCodeGroupDetail fetersCodeGroupDetail)
        {
            using (DemsifyEntities dataContext = new DemsifyEntities())
            {
                ObjectParameter result = new ObjectParameter("Result", typeof(int));

                dataContext.FetersCodeGroupDetailDelete(fetersCodeGroupDetail.FetersCodeGroupDetailId, fetersCodeGroupDetail.ModifiedBy, result);

                return(Convert.ToInt32(result.Value));
            }
        }
        public int UpdateAllDefinition(AllDefinition allDefinition)
        {
            using (DemsifyEntities dataContext = new DemsifyEntities())
            {
                ObjectParameter result = new ObjectParameter("Result", typeof(int));

                dataContext.AllDefinitionUpdate(allDefinition.Id, allDefinition.ActId, Utility.TrimString(allDefinition.DefinitionName), Utility.TrimString(allDefinition.FullDInsertion), Utility.TrimString(allDefinition.AuthorNote), allDefinition.ModifiedBy, result);

                return(Convert.ToInt32(result.Value));
            }
        }