public int CreateConnection(ConnectionProperty connection) { if (connection != null) { _dbContext.ConnectionProperties.Add(connection); } return(_dbContext.SaveChanges()); }
public ActionResult ForgotPassword(string email) { string message = ""; bool status = false; using (AlphasoftWebsiteContext dc = new AlphasoftWebsiteContext()) { var account = dc.Users.FirstOrDefault(a => a.Email == email); if (account != null) { string resetCode = Guid.NewGuid().ToString(); SendVerificationLinkEmail(account.Email, resetCode, "ResetPassword"); account.ResetPasswordCode = resetCode; dc.Configuration.ValidateOnSaveEnabled = false; dc.SaveChanges(); message = "Reset password link has been sent to your email id."; } else { message = "Account not found"; } } ViewBag.Message = message; return(View()); }
public int AddOrEdit(NewsletterSubscriber newsletterSubscriber) { if (newsletterSubscriber.NewsletterSubscriberId == 0) { newsletterSubscriber.MachineIP = HttpContext.Current.Request.UserHostAddress; newsletterSubscriber.SubscriptionDate = DateTime.Now; _dbContext.NewsletterSubscribers.Add(newsletterSubscriber); } else { newsletterSubscriber.MachineIP = HttpContext.Current.Request.UserHostAddress; newsletterSubscriber.SubscriptionDate = DateTime.Now; _dbContext.Entry(newsletterSubscriber).State = EntityState.Modified; } return(_dbContext.SaveChanges()); }
public int CreateUser(ChatUser chatUser) { if (chatUser != null) { _dbContext.ChatUsers.Add(chatUser); } return(_dbContext.SaveChanges()); }
public int AddOrEdit(NewsletterMail newsletterMail) { if (newsletterMail.NewsletterMailId == 0) { newsletterMail.CreatedBy = "Ayesha"; newsletterMail.CreatedDate = DateTime.Now; _dbContext.NewsletterMails.Add(newsletterMail); } else { newsletterMail.UpdatedBy = "Ayesha"; newsletterMail.UpdatedDate = DateTime.Now; _dbContext.Entry(newsletterMail).State = EntityState.Modified; } return(_dbContext.SaveChanges()); }
public int AddOrEdit(OnlineUserFeedBackDetail onlineUserFeedBackDetail) { if (onlineUserFeedBackDetail.UserFeedBackId == 0) { onlineUserFeedBackDetail.MachineIP = HttpContext.Current.Request.UserHostAddress; onlineUserFeedBackDetail.CreatedDate = DateTime.Now; _dbContext.OnlineUserFeedBackDetails.Add(onlineUserFeedBackDetail); } else { onlineUserFeedBackDetail.MachineIP = HttpContext.Current.Request.UserHostAddress; onlineUserFeedBackDetail.CreatedDate = DateTime.Now; _dbContext.Entry(onlineUserFeedBackDetail).State = EntityState.Modified; } return(_dbContext.SaveChanges()); }
public ActionResult Login(UserLogin login, string ReturnUrl = "") { string message = ""; using (AlphasoftWebsiteContext dc = new AlphasoftWebsiteContext()) { var v = dc.Users.FirstOrDefault(a => a.Email == login.Email); if (v != null) { if (!v.IsEmailVerified) { ViewBag.Message = "Please verify your email first"; return(View()); } if (String.CompareOrdinal(Crypto.Hash(login.Password), v.Password) == 0) { int timeout = login.RememberMe ? 525600 : 20; // 525600 min = 1 year var ticket = new FormsAuthenticationTicket(login.Email, login.RememberMe, timeout); string encrypted = FormsAuthentication.Encrypt(ticket); var cookie = new HttpCookie(FormsAuthentication.FormsCookieName, encrypted); cookie.Expires = DateTime.Now.AddMinutes(timeout); cookie.HttpOnly = true; Response.Cookies.Add(cookie); Session["User"] = login.Email; Session["UserName"] = v.UserName; #region AddLogin info var logininfo = new LoginInfo(); logininfo.UserId = v.UserId; logininfo.LogInTime = DateTime.Now; logininfo.LoginIp = Request.UserHostAddress; dc.LoginInfoes.Add(logininfo); dc.SaveChanges(); #endregion if (Url.IsLocalUrl(ReturnUrl)) { return(Redirect(ReturnUrl)); } else { return(RedirectToAction("Index", "Registration")); } } else { message = "Invalid credential provided"; } } else { message = "Invalid credential provided"; } } ViewBag.Message = message; return(View()); }
public int AddOrEdit(BlogCategory blogCategory) { if (blogCategory.BlogCategoryId == 0) { blogCategory.CreatedDate = DateTime.Now; blogCategory.UpdatedDate = DateTime.Now; blogCategory.CreatedBy = 1; blogCategory.UpdatedBy = 1; _dbContext.BlogCategories.Add(blogCategory); } else { blogCategory.UpdatedBy = 1; blogCategory.UpdatedDate = DateTime.Now; _dbContext.Entry(blogCategory).State = EntityState.Modified; } return(_dbContext.SaveChanges()); }
public int AddOrEdit(Employee employee) { if (employee.EmployeeId == 0) { employee.CreatedDate = DateTime.Now; employee.UpdatedDate = DateTime.Now; employee.CreatedBy = 1; employee.UpdatedBy = 1; _dbContext.Employees.Add(employee); } else { employee.UpdatedBy = 1; employee.UpdatedDate = DateTime.Now; _dbContext.Entry(employee).State = EntityState.Modified; } return(_dbContext.SaveChanges()); }
public int AddOrEdit(SocialAccountType socialAccountType) { if (socialAccountType.SocialAccountTypeId == 0) { socialAccountType.CreatedDate = DateTime.Now; socialAccountType.UpdatedDate = DateTime.Now; socialAccountType.CreatedBy = 1; socialAccountType.UpdatedBy = 1; _dbContext.SocialAccountTypes.Add(socialAccountType); } else { socialAccountType.UpdatedBy = 1; socialAccountType.UpdatedDate = DateTime.Now; _dbContext.Entry(socialAccountType).State = EntityState.Modified; } return(_dbContext.SaveChanges()); }
public int AddOrEdit(Designation designation) { if (designation.DesignationId == 0) { designation.CreatedDate = DateTime.Now; designation.UpdatedDate = DateTime.Now; designation.CreatedBy = 1; designation.UpdatedBy = 1; _dbContext.Designations.Add(designation); } else { designation.UpdatedBy = 1; designation.UpdatedDate = DateTime.Now; _dbContext.Entry(designation).State = EntityState.Modified; } return(_dbContext.SaveChanges()); }
public int AddOrEdit(FeatureDetail featureDetail) { if (featureDetail.FeatureDetailId == 0) { featureDetail.CreatedDate = DateTime.Now; featureDetail.UpdatedDate = DateTime.Now; featureDetail.CreatedBy = 1; featureDetail.UpdatedBy = 1; _dbContext.FeatureDetails.Add(featureDetail); } else { featureDetail.UpdatedBy = 1; featureDetail.UpdatedDate = DateTime.Now; _dbContext.Entry(featureDetail).State = EntityState.Modified; } return(_dbContext.SaveChanges()); }
public int AddOrEdit(Blog blog) { if (blog.BlogId == 0) { blog.CreatedDate = DateTime.Now; blog.UpdatedDate = DateTime.Now; blog.CreatedBy = 1; blog.UpdatedBy = 1; _dbContext.Blogs.Add(blog); } else { blog.UpdatedBy = 1; blog.UpdatedDate = DateTime.Now; _dbContext.Entry(blog).State = EntityState.Modified; } return(_dbContext.SaveChanges()); }
public int AddOrEdit(Service service) { if (service.ServiceId == 0) { service.CreatedDate = DateTime.Now; service.UpdatedDate = DateTime.Now; service.CreatedBy = 1; service.UpdatedBy = 1; _dbContext.Services.Add(service); } else { service.UpdatedBy = 1; service.UpdatedDate = DateTime.Now; _dbContext.Entry(service).State = EntityState.Modified; } return(_dbContext.SaveChanges()); }
public int AddOrEdit(ProductCategory productCategory) { if (productCategory.ProductCategoryId == 0) { productCategory.CreatedDate = DateTime.Now; productCategory.UpdatedDate = DateTime.Now; productCategory.CreatedBy = 1; productCategory.UpdatedBy = 1; _dbContext.ProductCategories.Add(productCategory); } else { productCategory.UpdatedBy = 1; productCategory.UpdatedDate = DateTime.Now; _dbContext.Entry(productCategory).State = EntityState.Modified; } return(_dbContext.SaveChanges()); }
public int AddOrEdit(PricingDetail pricingDetail) { if (pricingDetail.PricingDetailID == 0) { pricingDetail.CreatedDate = DateTime.Now; pricingDetail.UpdatedDate = DateTime.Now; pricingDetail.CreatedBy = 1; pricingDetail.UpdatedBy = 1; _dbContext.PricingDetails.Add(pricingDetail); } else { pricingDetail.UpdatedBy = 1; pricingDetail.UpdatedDate = DateTime.Now; _dbContext.Entry(pricingDetail).State = EntityState.Modified; } return(_dbContext.SaveChanges()); }
public int AddOrEdit(IconList iconList) { if (iconList.IconId == 0) { iconList.CreatedDate = DateTime.Now; iconList.UpdatedDate = DateTime.Now; iconList.CreatedBy = 1; iconList.UpdatedBy = 1; _dbContext.IconLists.Add(iconList); } else { iconList.UpdatedBy = 1; iconList.UpdatedDate = DateTime.Now; _dbContext.Entry(iconList).State = EntityState.Modified; } return(_dbContext.SaveChanges()); }
public int AddOrEdit(FeatureHeader featureHeader) { if (featureHeader.FeatureHeaderId == 0) { featureHeader.CreatedDate = DateTime.Now; featureHeader.UpdatedDate = DateTime.Now; featureHeader.CreatedBy = 1; featureHeader.UpdatedBy = 1; _dbContext.FeatureHeaders.Add(featureHeader); } else { featureHeader.UpdatedBy = 1; featureHeader.UpdatedDate = DateTime.Now; _dbContext.Entry(featureHeader).State = EntityState.Modified; } return(_dbContext.SaveChanges()); }
public int AddOrEdit(HomeBanner homeBanner) { if (homeBanner.HomeBannerId == 0) { homeBanner.CreatedDate = DateTime.Now; homeBanner.UpdatedDate = DateTime.Now; homeBanner.CreatedBy = 1; homeBanner.UpdatedBy = 1; _dbContext.HomeBanners.Add(homeBanner); } else { homeBanner.UpdatedBy = 1; homeBanner.UpdatedDate = DateTime.Now; _dbContext.Entry(homeBanner).State = EntityState.Modified; } return(_dbContext.SaveChanges()); }
public int AddOrEdit(ClientList clientList) { if (clientList.ClientID == 0) { clientList.CreatedDate = DateTime.Now; clientList.UpdatedDate = DateTime.Now; clientList.CreatedBy = 1; clientList.UpdatedBy = 1; _dbContext.ClientLists.Add(clientList); } else { clientList.UpdatedBy = 1; clientList.UpdatedDate = DateTime.Now; _dbContext.Entry(clientList).State = EntityState.Modified; } return(_dbContext.SaveChanges()); }
public int AddOrEdit(SoftwareCategory softwareCategory) { if (softwareCategory.SoftwareCategoryId == 0) { softwareCategory.CreatedDate = DateTime.Now; softwareCategory.UpdatedDate = DateTime.Now; softwareCategory.CreatedBy = 1; softwareCategory.UpdatedBy = 1; _dbContext.SoftwareCategories.Add(softwareCategory); } else { softwareCategory.UpdatedBy = 1; softwareCategory.UpdatedDate = DateTime.Now; _dbContext.Entry(softwareCategory).State = EntityState.Modified; } return(_dbContext.SaveChanges()); }
public int AddOrEdit(CompanyDetail companyDetail) { if (companyDetail.CompanyId == 0) { companyDetail.CreatedDate = DateTime.Now; companyDetail.UpdatedDate = DateTime.Now; companyDetail.CreatedBy = 1; companyDetail.UpdatedBy = 1; _dbContext.CompanyDetails.Add(companyDetail); } else { companyDetail.UpdatedBy = 1; companyDetail.UpdatedDate = DateTime.Now; _dbContext.Entry(companyDetail).State = EntityState.Modified; } return(_dbContext.SaveChanges()); }
public int AddOrEdit(PricingTableType pricingTableType) { if (pricingTableType.PricingTableTypeID == 0) { pricingTableType.CreatedDate = DateTime.Now; pricingTableType.UpdatedDate = DateTime.Now; pricingTableType.CreatedBy = 1; pricingTableType.UpdatedBy = 1; _dbContext.PricingTableTypes.Add(pricingTableType); } else { pricingTableType.UpdatedBy = 1; pricingTableType.UpdatedDate = DateTime.Now; _dbContext.Entry(pricingTableType).State = EntityState.Modified; } return(_dbContext.SaveChanges()); }
public int AddOrEdit(FAQ FAQ) { if (FAQ.FAQId == 0) { FAQ.CreatedDate = DateTime.Now; FAQ.UpdatedDate = DateTime.Now; FAQ.CreatedBy = 1; FAQ.UpdatedBy = 1; _dbContext.FAQs.Add(FAQ); } else { FAQ.UpdatedBy = 1; FAQ.UpdatedDate = DateTime.Now; _dbContext.Entry(FAQ).State = EntityState.Modified; } return(_dbContext.SaveChanges()); }
public ActionResult Registration([Bind(Exclude = "IsEmailVerified,ActivationCode")] User user) { bool Status = false; string message = ""; // // Model Validation if (ModelState.IsValid) { #region //Email is already Exist var isExist = IsEmailExist(user.Email); if (isExist) { ModelState.AddModelError("EmailExist", "Email already exist"); return(View(user)); } #endregion #region Generate Activation Code user.ActivationCode = Guid.NewGuid().ToString(); #endregion #region Password Hashing user.Password = Crypto.Hash(user.Password); #endregion user.IsEmailVerified = false; user.RegistrationDate = DateTime.Now; #region Save to Database using (AlphasoftWebsiteContext dc = new AlphasoftWebsiteContext()) { dc.Users.Add(user); dc.SaveChanges(); //Send Email to User SendVerificationLinkEmail(user.Email, user.ActivationCode.ToString()); message = "Registration successfully done. Account activation link " + " has been sent to your email id:" + user.Email; Status = true; } #endregion } else { message = "Invalid Request"; } ViewBag.Message = message; ViewBag.Status = Status; return(View(user)); }
public int AddOrEdit(SmtpHost smtpHost) { if (smtpHost.SmtpHostId == 0) { string password = new EncryptionDecryption().Encrypt(smtpHost.UserName, smtpHost.Password); smtpHost.Password = password; smtpHost.CreatedBy = "Ayesha"; smtpHost.CreatedDate = DateTime.Now; _dbContext.SmtpHosts.Add(smtpHost); } else { string password = new EncryptionDecryption().Encrypt(smtpHost.UserName, smtpHost.Password); smtpHost.Password = password; smtpHost.UpdatedBy = "Ayesha"; smtpHost.UpdatedDate = DateTime.Now; _dbContext.Entry(smtpHost).State = EntityState.Modified; } return(_dbContext.SaveChanges()); }
public ActionResult RegisterUser(ChatUser chatUser) { if (chatUser != null) { ChatUser user = new ChatUser(); user.ChatUserName = chatUser.ChatUserName; using (AlphasoftWebsiteContext db = new AlphasoftWebsiteContext()) { db.ChatUsers.Add(user); db.SaveChanges(); } Session["UserName"] = chatUser.ChatUserName; return(View()); } return(View()); }
public ActionResult VerifyAccount(string id) { bool Status = false; using (AlphasoftWebsiteContext dc = new AlphasoftWebsiteContext()) { var v = dc.Users.FirstOrDefault(a => a.ActivationCode == new Guid(id).ToString()); if (v != null) { v.IsEmailVerified = true; dc.SaveChanges(); Status = true; } else { ViewBag.Message = "Invalid Request"; } } ViewBag.Status = Status; return(View()); }
public ActionResult ResetPassword(ResetPassword model) { var message = ""; if (ModelState.IsValid) { using (AlphasoftWebsiteContext dc = new AlphasoftWebsiteContext()) { var user = dc.Users.FirstOrDefault(a => a.ResetPasswordCode == model.ResetCode); if (user != null) { user.Password = Crypto.Hash(model.NewPassword); user.ResetPasswordCode = ""; #region Add ResetPassword info var resetpassword = new ResetPassword(); resetpassword.UserId = user.UserId; resetpassword.ResetCode = model.ResetCode; resetpassword.NewPassword = user.Password; resetpassword.ResetTime = DateTime.Now; dc.ResetPasswords.Add(resetpassword); #endregion dc.Configuration.ValidateOnSaveEnabled = false; dc.SaveChanges(); message = "New password updated successfully"; } } } else { message = "Something invalid"; } ViewBag.Message = message; return(View(model)); }
public ActionResult ViewAll(FormCollection formCollection, int NewsletterMailId, int SmtpHostId) { MailMessage mailMessage = new MailMessage(); SentMailLog sentMailLog = new SentMailLog(); //List<SentMailLog> sentMailLogList= new List<SentMailLog>(); //var newsLetterMailList = _iNewsletterMailManager.GetAllNewsletterMail().Select(x => new //{ // x.NewsletterMailId, // x.Subject //}).ToList(); //ViewBag.NewsletterMailId = new SelectList(newsLetterMailList, "NewsletterMailId", "Subject"); NewsletterMail newsletterMail = _iNewsletterMailManager.GetANewsletterMail(NewsletterMailId); SmtpHost smtpHost = _iSmtpHostManager.GetASmtpHost(SmtpHostId); string[] ids = formCollection["NewsletterSubscriberId"].Split(new char[] { ',' }); foreach (string id in ids) { var newsletterSubscriber = _iNewsletterSubscriberManager.GetANewsletterSubscriber(int.Parse(id)); if (newsletterSubscriber.IsActive == true) { mailMessage.To.Add(new MailAddress(newsletterSubscriber.NewsletterSubscriberEmail)); //mailMessage.From = new MailAddress(ConfigurationManager.AppSettings["UserName"]); mailMessage.From = new MailAddress(smtpHost.UserName); mailMessage.Subject = newsletterMail.Subject; mailMessage.IsBodyHtml = true; mailMessage.Body = newsletterMail.Body; var allowedExtensions = new[] { ".GIF", ".PNG", ".JPG", ".JPEG" }; string myfile = Path.GetFileName(newsletterMail.AttachFile); var path = ConfigurationManager.AppSettings["AttachFile"]; var file = Path.Combine(Server.MapPath(path), myfile); Attachment data = new Attachment(file); ContentDisposition disposition = data.ContentDisposition; disposition.CreationDate = System.IO.File.GetCreationTime(file); disposition.ModificationDate = System.IO.File.GetLastWriteTime(file); disposition.ReadDate = System.IO.File.GetLastAccessTime(file); mailMessage.Attachments.Add(data); //mailMessage.DeliveryNotificationOptions= DeliveryNotificationOptions.OnSuccess; SmtpClient client = new SmtpClient(); //client.Host = ConfigurationManager.AppSettings["Host"]; client.Host = smtpHost.HostType.HostName; //client.EnableSsl = Convert.ToBoolean(ConfigurationManager.AppSettings["EnableSsl"]); client.EnableSsl = smtpHost.HostType.EnableSsl; System.Net.NetworkCredential NetworkCred = new System.Net.NetworkCredential(); //NetworkCred.UserName = ConfigurationManager.AppSettings["UserName"]; NetworkCred.UserName = smtpHost.UserName; //NetworkCred.Password = ConfigurationManager.AppSettings["Password"]; NetworkCred.Password = smtpHost.Password; //string encryptedPassword = smtpHost.Password; //string password = new EncryptionDecryption().Decrypt(smtpHost.UserName, encryptedPassword); client.UseDefaultCredentials = true; client.Credentials = NetworkCred; //client.Port = int.Parse(ConfigurationManager.AppSettings["Port"]); client.Port = int.Parse(smtpHost.HostType.PortNumber); try { client.Send(mailMessage); ViewBag.Result = "Mail Sent"; //if (ViewBag.Result==null) //{ // ViewBag.Result="Mail not sent" + newsletterSubscriber.NewsletterSubscriberEmail; //} sentMailLog.NewsletterSubscriberEmailId = newsletterSubscriber.NewsletterSubscriberEmail; sentMailLog.NewsletterMailSubject = newsletterMail.Subject; sentMailLog.CreatedBy = 1; sentMailLog.CreatedDate = DateTime.Now; sentMailLog.IsSent = true; AlphasoftWebsiteContext db = new AlphasoftWebsiteContext(); db.SentMailLogs.Add(sentMailLog); db.SaveChanges(); } catch (SmtpFailedRecipientException ex) { ViewBag.Result = ex.Message; } } } return(RedirectToAction("Index")); }