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));
}
}
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));
}
}
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));
}
}
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));
}
}
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));
}
}
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));
}
}
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);
}
}
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);
}
}
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));
}
}
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));
}
}
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));
}
}
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));
}
}
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));
}
}
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));
}
}