//select Users.name, id_user ,job_title, job_type, description, OperationField.name as operating_field from UserNotifications inner join OperationField on UserNotifications.operation_field = OperationField.Id inner join Users on Users.id = UserNotifications.id_user where operation_field in(select operatingField from User_Preferences where id_user = @id) private void CreateNotifications() { int user = Convert.ToInt32(Session["id"]); String query = "select Users.name AS username, id_user ,job_title, jobType.type as job_type, description, OperationField.name as operating_field from UserNotifications inner join OperationField on UserNotifications.operation_field = OperationField.Id inner join Users on Users.id = UserNotifications.id_user inner join jobType on UserNotifications.job_type = jobType.Id where operation_field in(select operatingField from User_Preferences where id_user = @id)"; SqlConnection connect = UsersDB.GetConnection(); SqlCommand command = new SqlCommand(query, connect); command.Parameters.AddWithValue("@id", user); connect.Open(); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { CreateDiv(Convert.ToString(reader["username"]), Convert.ToInt32(reader["id_user"]), Convert.ToString(reader["job_title"]), Convert.ToString(reader["job_type"]), Convert.ToString(reader["description"]), Convert.ToString(reader["operating_field"])); } }
protected void send_Click(object sender, EventArgs e) { String email = ""; int id = Convert.ToInt32(Session["id"]); String query = "SELECT * FROM Users WHERE id = @id"; SqlConnection connect = UsersDB.GetConnection(); SqlCommand command = new SqlCommand(query, connect); command.Parameters.AddWithValue("@id", id); connect.Open(); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { email = Convert.ToString(reader["Email"]); } System.Web.UI.HtmlControls.HtmlTextArea textArea = (System.Web.UI.HtmlControls.HtmlTextArea)(form1.FindControl("message")); String message = textArea.Value; String body = message; System.Net.Mail.MailMessage m = new System.Net.Mail.MailMessage(); SmtpClient sc = new SmtpClient(); try { m.From = new MailAddress("*****@*****.**", "*****@*****.**"); m.To.Add(new MailAddress(useremail.Text, useremail.Text)); m.Bcc.Add(new MailAddress(email, email)); String usertype = "normal"; m.Subject = subject.Text; m.IsBodyHtml = true; m.Body = body; sc.Host = "smtp.gmail.com"; sc.Port = 587; sc.Credentials = new System.Net.NetworkCredential("*****@*****.**", "Serena123!"); sc.EnableSsl = true; sc.Send(m); textArea.Value = ""; Label5.Text = "Email-i u dergua me sukses!"; } catch (Exception ex) { } }
//select Users.name, id_user ,job_title, job_type, description, OperationField.name as operating_field from UserNotifications inner join OperationField on UserNotifications.operation_field = OperationField.Id inner join Users on Users.id = UserNotifications.id_user where operation_field in(select operatingField from User_Preferences where id_user = @id) public void CreateNotifications() { int user = Convert.ToInt32(Session["id"]); String query = "select CompanyNotifications.id_user, CompanyInfo.name as username, OperationField.name as operatingfield, skills, type, job_title, job_description, education_description, year_experience from CompanyNotifications inner join OperationField on CompanyNotifications.operation_field = OperationField.Id inner join Users on Users.id = CompanyNotifications.id_user inner join jobType ON jobType.Id = CompanyNotifications.job_type inner join CompanyInfo on CompanyInfo.id_user = Users.Id where CompanyNotifications.operation_field in(select operatingField from User_Preferences where id_user = @id)"; SqlConnection connect = UsersDB.GetConnection(); SqlCommand command = new SqlCommand(query, connect); command.Parameters.AddWithValue("@id", user); connect.Open(); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { CreateDiv(Convert.ToString(reader["username"]), Convert.ToInt32(reader["id_user"]), Convert.ToString(reader["job_title"]), Convert.ToString(reader["type"]), Convert.ToString(reader["operatingfield"]), Convert.ToString(reader["skills"]), Convert.ToString(reader["job_description"]), Convert.ToString(reader["education_description"]), Convert.ToInt32(reader["year_experience"])); } }
protected void Page_Load(object sender, EventArgs e) { if (Convert.ToString(Session["sessionValue"]) == "set") { if (Convert.ToInt32(UsersDB.userType(Convert.ToString(Session["email"]))) == 1) { if (UsersDB.profileFilled(Convert.ToInt32(Session["id"]), "company")) { profile.NavigateUrl = "~/companyProfile.aspx"; } else { profile.NavigateUrl = "~/companyProfileToFill.aspx"; } home.NavigateUrl = "~/mainPageCompany.aspx"; notification.NavigateUrl = "~/UserNotifications.aspx"; } else if (Convert.ToInt32(UsersDB.userType(Convert.ToString(Session["email"]))) != 1) { if (UsersDB.profileFilled(Convert.ToInt32(Session["id"]), "user")) { profile.NavigateUrl = "~/profile.aspx"; } else { profile.NavigateUrl = "~/profileToFill.aspx"; } home.NavigateUrl = "~/mainPageUser.aspx"; notification.NavigateUrl = "~/CompanyNotifications.aspx"; } } else { System.Windows.Forms.MessageBox.Show("Kjo faqe nuk mund te aksesohet sepse ju nuk jeni te loguar!"); Response.Redirect("Login.aspx"); } int idcomp = Convert.ToInt32(Session["id"]); String query = "SELECT * FROM Users WHERE id = @id"; SqlConnection connect = UsersDB.GetConnection(); SqlCommand command = new SqlCommand(query, connect); command.Parameters.AddWithValue("@id", idcomp); connect.Open(); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { ouremail.Text = Convert.ToString(reader["email"]); } int id = Convert.ToInt32(Request.QueryString["id"]); query = "SELECT * FROM Users WHERE id = @id"; connect = UsersDB.GetConnection(); command = new SqlCommand(query, connect); command.Parameters.AddWithValue("@id", id); connect.Open(); reader = command.ExecuteReader(); while (reader.Read()) { useremail.Text = Convert.ToString(reader["email"]); subject.Text = "Pergjigje per lajmerimin"; } }