protected void removeUsersInRole() { foreach (ListItem li in lbxUsersInRole.Items) { if (li.Selected == true) { //Update indProfile table string userName = li.Text; using (skillsforhireEntities myEntities = new skillsforhireEntities()) { var getUser = (from u in myEntities.indprofiles where u.UserName == userName select u).Single(); if (getUser != null) { getUser.IsGoldMember = false; } myEntities.SaveChanges(); } //Update membership table Roles.RemoveUserFromRole(li.ToString(), ddlAllRoles.SelectedItem.Text); } } }
protected void btnSend_Click(object sender, EventArgs e) { if (Page.IsValid) { try { //All Users Email if (ddlToGroup.SelectedValue == "1") { using (skillsforhireEntities myEntities = new skillsforhireEntities()) { var allEmails = from u in myEntities.indprofiles select u.EmailAddr; if (allEmails != null) { foreach (var itm in allEmails) { //send email MailMessage myMessage = new MailMessage(); myMessage.To.Add(new MailAddress(itm.ToString())); myMessage.From = new MailAddress(AppConfiguration.FromNoreplyAddress, AppConfiguration.FromName); myMessage.Subject = tbxSubject.Text; myMessage.Body = tbxBody.Text; SmtpClient mySmtpClient = new SmtpClient(); mySmtpClient.Send(myMessage); } } } } //New Users < 1month Email else if (ddlToGroup.SelectedValue == "2") { DateTime dateCreated = DateTime.Now.AddDays(-30); using (skillsforhireEntities myEntities = new skillsforhireEntities()) { var allEmails = from u in myEntities.indprofiles where u.DateCreated > dateCreated select u.EmailAddr; if (allEmails != null) { foreach (var itm in allEmails) { //send email MailMessage myMessage = new MailMessage(); myMessage.To.Add(new MailAddress(itm.ToString())); myMessage.From = new MailAddress(AppConfiguration.FromNoreplyAddress, AppConfiguration.FromName); myMessage.Subject = tbxSubject.Text; myMessage.Body = tbxBody.Text; SmtpClient mySmtpClient = new SmtpClient(); mySmtpClient.Send(myMessage); } } } } //Expired Gold Users Email else if (ddlToGroup.SelectedValue == "3") { using (skillsforhireEntities myEntities = new skillsforhireEntities()) { var allEmails = from u in myEntities.indprofiles where u.GoldSubExpire < DateTime.Now select u.EmailAddr; if (allEmails != null) { foreach (var itm in allEmails) { //send email MailMessage myMessage = new MailMessage(); myMessage.To.Add(new MailAddress(itm.ToString())); myMessage.From = new MailAddress(AppConfiguration.FromNoreplyAddress, AppConfiguration.FromName); myMessage.Subject = tbxSubject.Text; myMessage.Body = tbxBody.Text; SmtpClient mySmtpClient = new SmtpClient(); mySmtpClient.Send(myMessage); } } } } // seleted no skill/profession else if (ddlToGroup.SelectedValue == "4") { using (skillsforhireEntities myEntities = new skillsforhireEntities()) { var allEmails = from u in myEntities.indprofiles where u.SkillsId == 78 select u.EmailAddr; if (allEmails != null) { foreach (var itm in allEmails) { //send email MailMessage myMessage = new MailMessage(); myMessage.To.Add(new MailAddress(itm.ToString())); myMessage.From = new MailAddress(AppConfiguration.FromNoreplyAddress, AppConfiguration.FromName); myMessage.Subject = tbxSubject.Text; myMessage.Body = tbxBody.Text; SmtpClient mySmtpClient = new SmtpClient(); mySmtpClient.Send(myMessage); } } } } pnlSendMessage.Visible = false; lblSendFeedback.Visible = true; lblSendFeedback.Text = "Message sent"; lblSendFeedback.CssClass = "text-success"; } catch { pnlSendMessage.Visible = false; lblSendFeedback.Visible = true; lblSendFeedback.Text = "Sending message failed"; lblSendFeedback.CssClass = "text-warning"; } } }
protected void btnPost_Click(object sender, EventArgs e) { if (Page.IsValid) { using (skillsforhireEntities myEntities = new skillsforhireEntities()) { int id = Convert.ToInt32(Request.QueryString.Get("JobId")); jobprofile myJobProfile; myJobProfile = (from P in myEntities.jobprofiles where P.idJobProfile == id select P).Single(); myJobProfile.LastModified = DateTime.Now; myJobProfile.LastModifiedBy = User.Identity.Name; //Job Status myJobProfile.JobStatusId = Convert.ToInt32(ddlJobStatus.SelectedValue); //Start Time myJobProfile.StartTimeId = Convert.ToInt32(ddlStartTime.SelectedValue); //Job loc. state myJobProfile.JobLocationStateId = Convert.ToInt32(ddlJobLocState.SelectedValue); //Job loc. LG myJobProfile.JobLocationLGId = Convert.ToInt32(ddlJobLocLG.SelectedValue); //Job loc. town if (tbxJobLocTown.Text != "") { myJobProfile.JobLocationTown = tbxJobLocTown.Text; } else { myJobProfile.JobLocationTown = "-"; } //Job title myJobProfile.JobTitle = tbxJobTitle.Text; //Job description myJobProfile.JobDescription = tbxJobDescription.Text; //Profession myJobProfile.SkillId = Convert.ToInt32(ddlSkill.SelectedValue); //Specialisation if (tbxSkillSpecific.Text != "") { myJobProfile.SpecificSkill = tbxSkillSpecific.Text; } else { myJobProfile.SpecificSkill = "-"; } //Budget myJobProfile.BudgetId = Convert.ToInt32(ddlBudget.SelectedValue); //Full Name myJobProfile.ContactFullName = tbxFullName.Text; //Contact Number myJobProfile.ContactNumber = tbxContactNumb.Text; //Email myJobProfile.ContactEmail = tbxEmail.Text; //Publicise myJobProfile.Publicise = Convert.ToBoolean(cbxPublicise.Checked); //Expiry Date myJobProfile.ExpiryDate = DateTime.Today.AddDays(Convert.ToDouble(ddlAdvertDuration.SelectedValue)); //save changes myEntities.SaveChanges(); Response.Redirect("~/Management/AllJobs.aspx"); } } }
//int _id = -1; //to distinguish between a new and existing post protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack && !string.IsNullOrEmpty(Request.QueryString.Get("JobId"))) { int id = Convert.ToInt32(Request.QueryString.Get("JobId")); using (skillsforhireEntities myEntities = new skillsforhireEntities()) { var jobAd = (from j in myEntities.jobprofiles where j.idJobProfile == id select j).SingleOrDefault(); if (jobAd != null) { //Get job status ddlJobStatus.DataBind(); ListItem myddlJobStatus = ddlJobStatus.Items.FindByValue(jobAd.JobStatusId.ToString()); if (myddlJobStatus != null) { myddlJobStatus.Selected = true; } //Start Time ddlStartTime.DataBind(); ListItem myddlStartTime = ddlStartTime.Items.FindByValue(jobAd.StartTimeId.ToString()); if (myddlStartTime != null) { myddlStartTime.Selected = true; } //Job loc. state ddlJobLocState.DataBind(); ListItem myddlState = ddlJobLocState.Items.FindByValue(jobAd.JobLocationStateId.ToString()); if (myddlState != null) { myddlState.Selected = true; } //Job loc. LG ddlJobLocLG.DataBind(); ListItem myddlLG = ddlJobLocLG.Items.FindByValue(jobAd.JobLocationLGId.ToString()); if (myddlLG != null) { myddlLG.Selected = true; } //Job loc. town tbxJobLocTown.Text = jobAd.JobLocationTown.ToString(); //Job title tbxJobTitle.Text = jobAd.JobTitle.ToString(); //Job description tbxJobDescription.Text = jobAd.JobDescription; //Profession ddlSkill.DataBind(); ListItem myddlSkill = ddlSkill.Items.FindByValue(jobAd.SkillId.ToString()); if (myddlSkill != null) { myddlSkill.Selected = true; } //Specialisation tbxSkillSpecific.Text = jobAd.SpecificSkill.ToString(); //Budget ddlBudget.DataBind(); ListItem myddlBudget = ddlBudget.Items.FindByValue(jobAd.BudgetId.ToString()); if (myddlBudget != null) { myddlBudget.Selected = true; } //Full Name tbxFullName.Text = jobAd.ContactFullName; //Contact Number tbxContactNumb.Text = jobAd.ContactNumber; //Email tbxEmail.Text = jobAd.ContactEmail; //Expiry Date //Publicise cbxPublicise.Checked = Convert.ToBoolean(jobAd.Publicise); } } } }
protected void btnDelMembership_Click(object sender, EventArgs e) { if (Page.IsValid) { if (Membership.GetUser(tbxUserName.Text) != null) { string userName = tbxUserName.Text; //Delete Job Postings using (skillsforhireEntities myEntities = new skillsforhireEntities()) { var jobPosts = from p in myEntities.jobprofiles where p.CreatedBy == userName select p; if (jobPosts != null) { foreach (var jPost in jobPosts) { myEntities.jobprofiles.Remove(jPost); } myEntities.SaveChanges(); } } //Delete Profile using (skillsforhireEntities myObjects = new skillsforhireEntities()) { var ind = (from i in myObjects.indprofiles where i.UserName == userName select i).SingleOrDefault(); if (ind != null) { //send confirmation email string fileName = Server.MapPath("~/App_Data/AccountDeleteConfirmation.txt"); string mailBody = File.ReadAllText(fileName); mailBody = mailBody.Replace("##UserName##", ind.UserName); MailMessage myMessage = new MailMessage(); myMessage.Subject = "Your www.skills4hire.com.ng Account is Deleted"; myMessage.Body = mailBody; myMessage.From = new MailAddress(AppConfiguration.FromAccAddress, "Accounts"); myMessage.To.Add(new MailAddress(ind.EmailAddr)); SmtpClient mySmtpClient = new SmtpClient(); mySmtpClient.Send(myMessage); //Remove user profile myObjects.indprofiles.Remove(ind); } myObjects.SaveChanges(); } //Delete user Membership.DeleteUser(userName); lblUserFeed.Text = "User Account deleted!"; } else { lblUserFeed.Text = "User Name not found"; } } }