public void createPost(Member member) { try { String connstr = "Data source = studentoracle.students.ittralee.ie/orcl;User id = t00171832;Password="******";"; OracleConnection conn = new OracleConnection(connstr); conn.Open(); string query = "insert into posts values('" + member.Username + "', '" + member.Email + "' , " + member.Phone + " , :BlobParameter , '" + member.Image + "' , '" + member.JoinDate + "' , " + member.MsgPrivate + " , '" + member.LastSeen + ")"; MessageBox.Show(query); //insert the byte as oracle parameter of type blob OracleParameter blobParameter = new OracleParameter(); blobParameter.OracleType = OracleType.Blob; blobParameter.ParameterName = "BlobParameter"; blobParameter.Value = member.Image; OracleCommand cmnd = new OracleCommand(query, conn); cmnd.Parameters.Add(blobParameter); cmnd.ExecuteNonQuery(); cmnd.Dispose(); conn.Close(); conn.Dispose(); } catch (Exception ex) { } }
public Member AuthenticateUser(String username, String password) { conn.Open(); try { cmd = conn.CreateCommand(); string sql = "Select * from members where username = '******' AND account_password = '******'" ; cmd = new OracleCommand(sql); cmd.CommandType = CommandType.Text; cmd.Connection = conn; da = new OracleDataAdapter(cmd); ds = new DataSet(); da.Fill(ds, "ss"); if (ds.Tables["ss"].Rows[0].ItemArray[0].Equals(username) && ds.Tables["ss"].Rows[0].ItemArray[2].Equals(password)) { member = createMember(ds); } return member; } catch (Exception ex) { MessageBox.Show(ex.Message); return null; } finally { conn.Close(); } }
private void btnLogIn_Click(object sender, EventArgs e) { member = memberDAO.AuthenticateUser(txtUsername.Text, txtPassword.Text); MainForm main = new MainForm(); if (member != null) { main.setMember(member); main.Show(); this.Hide(); } }
public void setMember(Member member) { this.member = member; isLoggedIn = true; tagLabel.Text = "Subscribed Tags"; userLabel.Text = "Users Followed"; btnCreatePost.Text = "Create Post"; btnUsername.Text = "" + member.Username; btnUsername.Show(); btnLogout.Text = "Logout"; }
private void btnRegister_Click(object sender, EventArgs e) { DateTime dateNow = DateTime.Now; member = new Member(txtUserName.Text, txtEmail.Text,long.Parse(txtPhone.Text),null, dateNow, false, dateNow); dao.InsertMember(member); if (image != null) { dao.UpdateMemberImage(image,member.Username); } MainForm main = new MainForm(); main.setMember(member); main.Show(); this.Hide(); }
public void DeleteMember(Member member) { try { conn.Open(); String sql = "Delete from Members where username = " + username; cmd = new OracleCommand(sql, conn); cmd.ExecuteNonQuery(); } catch (Exception ex) { } finally { if (conn.State == ConnectionState.Open) conn.Close(); } }
private Member createMember(DataSet ds) { String username, email; long phone; Image image; DateTime lastSeen, joinDate; bool msgPrivate; username = (String)ds.Tables["ss"].Rows[0].ItemArray[0]; email = (String)ds.Tables["ss"].Rows[0].ItemArray[1]; phone = long.Parse(ds.Tables["ss"].Rows[0].ItemArray[3].ToString()); joinDate = (DateTime)ds.Tables["ss"].Rows[0].ItemArray[5]; int mPrivate = int.Parse(ds.Tables["ss"].Rows[0].ItemArray[6].ToString()); if (mPrivate == 1) msgPrivate = true; else msgPrivate = false; lastSeen =(DateTime)ds.Tables["ss"].Rows[0].ItemArray[7]; image = null; Member member = new Member(username, email, phone,image, joinDate, msgPrivate,lastSeen); return member; }
public void InsertMember(Member member) { try { conn.Open(); string query = "insert into members values('" + member.Username + "', '" + member.Email + "' , " + member.Phone + " , null , '" + member.Image + "' , '" + dateNow + "' , 0 , '" + dateNow + "')"; // MessageBox.Show(query); cmd = new OracleCommand(query, conn); cmd.ExecuteNonQuery(); MessageBox.Show("Member Insert Successful\n\t\t" + member.Username); }catch(Exception ex) { MessageBox.Show(ex.Message); } finally{ if (conn.State == ConnectionState.Open) conn.Close(); } }
private void GetUserDetails() { //Get Details of the specific member //lblUsername.Text += member.getMember(); DateTime value = new DateTime(2014, 1, 18); //Member member = new Member("Name", "email", 1234567890, null, value, false, value, 5, 7); connection connection = new connection(); string userName = GetSingleValue("Select Username from member where username = '******'", "Username"); string email = GetSingleValue("Select Username from member where username = '******'", "Username"); //long phone = long.Parse(GetSingleValue("Select Username from member where username = '******'", "Username")); long phone = 087986677; System.Drawing.Image image = null; System.DateTime joinDate = DateTime.Now; bool msgPrivate = false; System.DateTime lastSeen = DateTime.Now; int postsMade = 0; int likesReceived = 0; Member member = new Member(userName, email, phone, image, joinDate, msgPrivate, lastSeen); lblUsername.Text += member.Username; lblEmail.Text += member.Email; lblPhoneNumber.Text += member.Phone; lblJoinDate.Text += member.JoinDate; /* Random rnd = new Random(); Member member = new Member(); member.Username = txtTitle.Text; member.Email = txtText.Text; member.Phone = txtTag.Text; member.JoinDate = DateTime.Now.ToString("dd-MMM-yy hh:mm:ss:fffffff"); member.PostsMade = 0; member.LikesReceived = 0; FileStream fls = new FileStream(imagename, FileMode.Open, FileAccess.Read); byte[] blob = new byte[fls.Length]; fls.Read(blob, 0, Convert.ToInt32(fls.Length)); fls.Close(); member.Image = blob; PostDaoImpl dao = new PostDaoImpl(); dao.createPost(member); */ }