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);
*/
}
