public VendorModel GetVendorById(long Id)
{
using (StratasFairDBEntities context = new StratasFairDBEntities())
{
return(context.tblVendors.Where(x => x.VendorId == Id).Select(v => new VendorModel()
{
ActualImageFile = v.ActualImageFile,
EmailId = v.EmailId,
CompanyBrief = v.CompanyBrief,
TradeAndBusinessFile = v.TradeAndBusinessFile,
ImageFile = v.ImageFile,
Password = v.Password,
VendorName = v.VendorName,
ActualTradeAndBusinessFile = v.ActualTradeAndBusinessFile,
AdminApproval = v.AdminApproval,
CreatedBy = v.CreatedBy,
CreatedFromIp = v.CreatedFromIp,
CreatedOn = v.CreatedOn,
DisciplineId = v.DisciplineId,
MobileNumber = v.MobileNumber,
ModifiedBy = v.ModifiedBy,
ModifiedFromIP = v.ModifiedFromIP,
ModifiedOn = v.ModifiedOn,
OtherDisciplineName = v.OtherDisciplineName,
Remark = v.Remark,
Status = v.Status,
VendorId = v.VendorId,
DisciplineName = context.tblDisciplines.Where(d => d.DisciplineId == v.DisciplineId).FirstOrDefault().DisciplineName,
PasswordResetDate = v.Pwd_Reset_Req_Date,
PasswordResetStatus = v.Pwd_Reset_Req_Status
}).FirstOrDefault());
}
}
public SubscriptionHelper()
{
if (context == null)
{
context = new StratasFairDBEntities();
}
}
public ClientLoginHelper()
{
if (_context == null)
{
_context = new StratasFairDBEntities();
}
}
public BillHelper()
{
if (_context == null)
{
_context = new StratasFairDBEntities();
}
}
public List <PMBModel> GetPMB(long QuotationRequestId)
{
try
{
using (StratasFairDBEntities context = new StratasFairDBEntities())
{
return(context.Usp_GetPMB(QuotationRequestId).Select(x => new PMBModel()
{
PMBId = x.PMBId,
QuotatoinId = QuotationRequestId,
VendorId = x.VendorId,
VendorName = x.VendorName,
VendorImage = x.ImageFile,
ClientUserId = x.UserClientId,
ClientUserName = x.FullName,
Message = x.Message,
ClientImage = x.ProfilePicture,
AttachedActualFileName = x.AttachedFileActualName,
AttachedFileName = x.AttachedFileName,
CreatedBy = x.CreatedBy,
CreatedFromIP = x.CreatedFromIP,
CreatedOn = x.CreatedOn,
CreatedByUserType = x.CreatedByUserType,
StrataBoardId = x.StratasBoardId
}).OrderBy(m => m.CreatedOn).ToList());
}
}
catch (Exception ex)
{
return(null);
}
}
public List <UserClientPrivilege> GetUserClientPrivileges()
{
try
{
_context = new StratasFairDBEntities();
var objMember = _context.vw_UserClientPrivileges.ToList();
var UserPrivilegeList = new List <UserClientPrivilege>();
foreach (var item in objMember)
{
UserClientPrivilege model = new UserClientPrivilege
{
PageId = item.PageId,
PageName = item.PageName,
PageLink = item.PageLink,
IsChecked = false
};
UserPrivilegeList.Add(model);
}
return(UserPrivilegeList);
}
catch
{
return(new List <UserClientPrivilege>());
}
}
public NoticeBoardHelper()
{
if (_context == null)
{
_context = new StratasFairDBEntities();
}
}
public static bool IsVendorEmailExists(string email)
{
using (var context = new StratasFairDBEntities())
{
return(context.tblVendors.Any(x => x.EmailId == email));
}
}
public AdvertisementHelper()
{
if (context == null)
{
context = new StratasFairDBEntities();
}
}
public static string GetAdminEmailForNotification()
{
using (var context = new StratasFairDBEntities())
{
return(context.tblAdminEmailNotificationSettings.Where(x => x.Status == 1).FirstOrDefault().EmailAddress);
}
}
/// <summary>
/// Get all the stratas unique name
/// </summary>
/// <returns></returns>
public static List <string> GetStratasUniqueName()
{
using (var context = new StratasFairDBEntities())
{
return(context.vw_GetStratasBoard.Where(x => x.STATUS == 1).Select(x => x.PortalLink).ToList());
}
}
public List <VendorQuotationModel> GetAllQuotations()
{
try
{
using (StratasFairDBEntities context = new StratasFairDBEntities())
{
return(context.Usp_GetQuotationRequest(string.IsNullOrEmpty(ClientSessionData.ClientUserName) ? null : ClientSessionData.ClientUserName).Select(m => new VendorQuotationModel()
{
VendorId = m.VendorId,
RequesterEmailId = m.RequesterEmailId,
RequesterName = m.RequesterName,
VendorName = m.VendorName,
DisciplineId = m.DisciplineId,
DisciplineName = m.DisciplineName,
Details = m.Details,
IsShowEmail = m.IsShowEmail,
CreatedBy = m.CreatedBy,
CreatedOn = m.CreatedOn,
CreatedFromIP = m.CreatedFromIP,
StrataBoardId = m.StratasBoardId,
StrataBoardName = m.StratasBoardName,
QuotationId = m.QuotationId
}).OrderByDescending(m => m.CreatedOn).ToList());
}
}
catch (Exception)
{
throw;
}
}
public ReportsHelper()
{
if (context == null)
{
context = new StratasFairDBEntities();
}
}
public List <VendorModel> GetVendorsByDiscipline(long DisciplineId)
{
using (StratasFairDBEntities context = new StratasFairDBEntities())
{
return(context.vw_GetVendor.Where(x => x.DisciplineId == DisciplineId && x.Status == 1 && x.AdminApproval == 1).Select(v => new VendorModel()
{
ActualImageFile = v.ActualImageFile,
EmailId = v.EmailId,
CompanyBrief = v.CompanyBrief,
TradeAndBusinessFile = v.TradeAndBusinessFile,
ImageFile = v.ImageFile,
Password = v.Password,
VendorName = v.VendorName,
ActualTradeAndBusinessFile = v.ActualTradeAndBusinessFile,
AdminApproval = v.AdminApproval,
CreatedBy = v.CreatedBy,
CreatedFromIp = v.CreatedFromIp,
CreatedOn = v.CreatedOn,
DisciplineId = v.DisciplineId,
MobileNumber = v.MobileNumber,
ModifiedBy = v.ModifiedBy,
ModifiedFromIP = v.ModifiedFromIP,
ModifiedOn = v.ModifiedOn,
OtherDisciplineName = v.OtherDisciplineName,
Remark = v.Remark,
Status = v.Status,
VendorId = v.VendorId,
DisciplineName = v.DisciplineName
}).OrderByDescending(o => o.CreatedOn).ToList());
}
}
public PollQuestionModel GetPollAnswersByPollId(long strataFairAdminId, long PollId)
{
try
{
using (StratasFairDBEntities context = new StratasFairDBEntities())
{
return(context.tblPollQuestions.Where(x => x.CreatedBy == strataFairAdminId && x.PollId == PollId && x.Status == 1).Select(p => new PollQuestionModel()
{
PollId = p.PollId,
PollHeader = p.PollHeader,
EndDate = p.EndDate,
CreatedBy = p.CreatedBy,
CreatedOn = p.CreatedOn,
CreatedFromIP = p.CreatedFromIP,
ModifiedBy = p.ModifiedBy,
ModifiedFromIP = p.ModifiedFromIP,
ModifiedOn = p.ModifiedOn,
StrataBoardId = p.StrataBoardId,
pollAnswerList = p.tblPollAnswers.Where(a => a.Status == 1).Select(o => new PollAnswerModel()
{
PollOptionId = o.PollOptionId,
PollId = o.PollId,
PollOptionText = p.tblPollOptions.Where(po => po.PollOptionId == o.PollId).FirstOrDefault().OptionText
}).ToList()
}).FirstOrDefault());
}
}
catch (Exception)
{
return(null);
}
}
public DisciplineHelper()
{
if (context == null)
{
context = new StratasFairDBEntities();
}
}
public SubAdminHelper()
{
if (_context == null)
{
_context = new StratasFairDBEntities();
}
}
public SettingHelper()
{
if (context == null)
{
context = new StratasFairDBEntities();
}
}
public BookingRequestHelper()
{
if (context == null)
{
context = new StratasFairDBEntities();
}
}
public StrataBoardHelper()
{
if (context == null)
{
context = new StratasFairDBEntities();
}
}
public TestimonialHelper()
{
if (context == null)
{
context = new StratasFairDBEntities();
}
}
public EmailNotificationHelper()
{
if (context == null)
{
context = new StratasFairDBEntities();
}
}
public List <AdminPMBModel> GetAdminPMB(long?StrataBoardId, long?CreatedFor)
{
try
{
using (StratasFairDBEntities context = new StratasFairDBEntities())
{
return(context.Usp_GetAdminPMB(StrataBoardId, CreatedFor).Select(x => new AdminPMBModel()
{
PMBId = x.PMBId,
OwnerId = x.OwnerId,
OwnerFullName = x.OwnerFullName,
OwnerProfilePicture = x.OwnerProfilePicture,
AdminId = x.AdminId,
AdminFullName = x.AdminFullName,
AdminProfilePicture = x.AdminProfilePicture,
Message = x.Message,
AttachedFileActualName = x.AttachedFileActualName,
AttachedFileName = x.AttachedFileName,
CreatedBy = x.CreatedBy,
CreatedFromIP = x.CreatedFromIP,
CreatedOn = x.CreatedOn,
CreatedFor = x.CreatedFor,
CreatedByUserType = x.CreatedByUserType,
StratasBoardId = x.StratasBoardId,
StratasBoardName = x.StratasBoardName,
CreatedByUserName = x.CreatedByUserName
}).OrderBy(m => m.CreatedOn).ToList());
}
}
catch (Exception ex)
{
return(null);
}
}
public ForumHelper()
{
if (context == null)
{
context = new StratasFairDBEntities();
}
}
public MyReminderHelper()
{
if (_context == null)
{
_context = new StratasFairDBEntities();
}
}
public PollQuestionModel GetPollQuestionById(long PollId)
{
try
{
using (StratasFairDBEntities context = new StratasFairDBEntities())
{
return(context.tblPollQuestions.Where(x =>
x.StrataBoardId == ClientSessionData.ClientStrataBoardId &&
x.PollId == PollId &&
x.Status == 1).Select(p => new PollQuestionModel()
{
PollId = p.PollId,
PollHeader = p.PollHeader,
EndDate = p.EndDate,
CreatedBy = p.CreatedBy,
CreatedOn = p.CreatedOn,
CreatedFromIP = p.CreatedFromIP,
ModifiedBy = p.ModifiedBy,
ModifiedFromIP = p.ModifiedFromIP,
ModifiedOn = p.ModifiedOn,
StrataBoardId = p.StrataBoardId,
pollOptionList = p.tblPollOptions.Where(to => to.Status == 1).Select(o => new PollOptionModel()
{
PollOptionId = o.PollOptionId,
OptionText = o.OptionText
}).ToList()
}).FirstOrDefault());
}
}
catch (Exception)
{
return(null);
}
}
public UserCalendarHelper()
{
if (context == null)
{
context = new StratasFairDBEntities();
}
}
public int UpdatePoll(PollQuestionModel _model)
{
try
{
using (StratasFairDBEntities context = new StratasFairDBEntities())
{
var _poll = context.tblPollQuestions.Where(x => x.PollId == _model.PollId && x.StrataBoardId == ClientSessionData.ClientStrataBoardId).FirstOrDefault();
if (_poll != null)
{
_poll.Status = _model.Status;
_poll.ModifiedBy = _model.ModifiedBy;
_poll.ModifiedOn = DateTime.UtcNow;
_poll.ModifiedFromIP = HttpContext.Current.Request.UserHostAddress;
context.tblPollQuestions.Attach(_poll);
context.Entry(_poll).Property(x => x.Status).IsModified = true;
context.Entry(_poll).Property(x => x.ModifiedBy).IsModified = true;
context.Entry(_poll).Property(x => x.ModifiedOn).IsModified = true;
context.Entry(_poll).Property(x => x.ModifiedFromIP).IsModified = true;
return(context.SaveChanges());
}
else
{
return(-1);
}
}
}
catch (Exception ex)
{
return(-1);
}
}
public static string FncSendOwnerReminderMailBoxMessage(long?UserClientId, string ReminderSubject, string ReminderNote)
{
try
{
using (var db = new StratasFairDBEntities())
{
var userClients = db.tblUserClients.Where(m => m.UserClientId == UserClientId).SingleOrDefault();
if (userClients != null)
{
string url = ConfigurationManager.AppSettings["WebsiteRootPath"].ToString();
string body = "";
getConfigValue("stratasboard_owner_reminder", out body);
EmailSender emailSender = GetCommonDataForSendMailClient(userClients.EmailId, ReminderSubject, userClients.StratasBoardId);
StringBuilder mailBody = new StringBuilder();
mailBody.Append(body);
mailBody.Replace("{BASEPATH}", url);
mailBody.Replace("{NAME}", userClients.FirstName + " " + userClients.LastName);
mailBody.Replace("{NOTE}", ReminderNote);
mailBody.Replace("{YEAR}", DateTime.Now.Year.ToString());
emailSender.Body = mailBody.ToString();
emailSender = FncSendMail(emailSender);
return(emailSender.ErrorMessage);
}
else
{
return("");
}
}
}
catch (Exception ex)
{
return(ex.Message.ToString());
}
}
public bool IsVendorActive(string emailId)
{
using (StratasFairDBEntities context = new StratasFairDBEntities())
{
return(context.tblVendors.Any(x => x.Status == 1 && x.EmailId == emailId));
}
}
