private void viewAllReferences_Load(object sender, EventArgs e)
{
try
{
string qry;
if (Tag == null)
{
qry = "select * from [tbl_References]";
txtHeader.Text = " References added by every user ";
}
else
{
qry = "select * from [tbl_References] where Title like '%" + Tag
+ "%' or Authors_Fname like '%" + Tag + "%' or Authors_Lname like '%"
+ Tag + "%' or Document_type like '%" + Tag + "%' or Year like '%"
+ Tag + "%' or Publisher like '%" + Tag + "%' or Abstract like '%"
+ Tag + "%' or Name like '%" + Tag + "%' or Issue like '%" + Tag
+ "%' or Volume like '%" + Tag + "%' or Notes like '%" + Tag + "%'";
txtHeader.Text = " References that are tagged in ";
}
DatabaseCon dbcon = new DatabaseCon();
dbcon.Query = qry;
DataTable dt = dbcon.GetData();
dataGridView1.DataSource = dt;
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
private void loadReferences()
{
try
{
string qry;
if (Tag == null)
{
qry = "select * from tbl_References where UserId =" + userid;
txtHeader.Text = " References you have added ";
}
else
{
this.txtSearch.Hide();
this.pictureBox2.Hide();
qry = "select * from [tbl_References] where UserId=" + userid + " and Title like '%"
+ Tag + "%' or Authors_Fname like '%" + Tag + "%' or Authors_Lname like '%" + Tag
+ "%' or Document_type like '%" + Tag + "%' or Year like '%" + Tag
+ "%' or Publisher like '%" + Tag + "%' or Abstract like '%" + Tag
+ "%' or Name like '%" + Tag + "%' or Issue like '%" + Tag + "%' or Volume like '%"
+ Tag + "%' or Notes like '%" + Tag + "%'";
txtHeader.Text = " References that are tagged in ";
}
DatabaseCon dbcon = new DatabaseCon();
dbcon.Query = qry;
DataTable dt = dbcon.GetData();
dataGridView1.DataSource = dt;
}
catch (Exception ex)
{
throw ex;
}
}
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
string command = dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString();
int tag_Id = Convert.ToInt32(dataGridView1.Rows[e.RowIndex].Cells[1].Value);
if (command == "Tagged Article")
{
try
{
string qry = "select Tag from [tbl_Tags] where Tag_Id =" + tag_Id;
DatabaseCon dbcon = new DatabaseCon();
dbcon.Query = qry;
DataTable dt = dbcon.GetData();
string Tag = dt.Rows[0]["Tag"].ToString();
viewAllReferences var = new viewAllReferences();
var.Tag = Tag;
var.Show();
}
catch (Exception ex)
{
throw ex;
}
}
}
private void Home_Load(object sender, EventArgs e)
{
try
{
string qry = "select First_Name from [tbl_User] where ID =" + userId;
DatabaseCon dbcon = new DatabaseCon();
dbcon.Query = qry;
DataTable dt = dbcon.GetData();
Label lbl_welcome = new Label();
lbl_welcome.AutoSize = true;
lbl_welcome.Font = new System.Drawing.Font("Century Gothic", 13.8F, System.Drawing.FontStyle.Bold,
System.Drawing.GraphicsUnit.Point, ((byte)(0)));
lbl_welcome.Location = new System.Drawing.Point(20, 45);
lbl_welcome.Size = new System.Drawing.Size(188, 43);
lbl_welcome.Text = "Welcome, " + dt.Rows[0]["First_Name"].ToString() + "!!!";
this.Controls.Add(lbl_welcome);
combo_style.Items.Add("Harvard");
combo_style.Items.Add("APA");
combo_style.Items.Add("Chicago");
combo_style.SelectedIndex = 0;
}
catch (Exception ex)
{
throw ex;
}
}
private void Edit_References_Load(object sender, EventArgs e)
{
string qry = "select * from tbl_References where Ref_Id =" + referenceId;
DatabaseCon dbcon = new DatabaseCon();
dbcon.Query = qry;
DataTable dt = dbcon.GetData();
if (dt.Rows.Count > 0)
{
txtTitle.Text = dt.Rows[0]["Title"].ToString();
txtAuthors_Fname.Text = dt.Rows[0]["Authors_Fname"].ToString();
txtAuthors_Lname.Text = dt.Rows[0]["Authors_Lname"].ToString();
txtDocumenttype.Text = dt.Rows[0]["Document_type"].ToString();
txtYear.Text = dt.Rows[0]["Year"].ToString();
txtPublisher.Text = dt.Rows[0]["Publisher"].ToString();
txtCity.Text = dt.Rows[0]["Publisher"].ToString();
txtAbstract.Text = dt.Rows[0]["Abstract"].ToString();
txtName.Text = dt.Rows[0]["Name"].ToString();
txtIssue.Text = dt.Rows[0]["Issue"].ToString();
txtVolume.Text = dt.Rows[0]["Volume"].ToString();
txtPageno.Text = dt.Rows[0]["Page_no"].ToString();
txtNotes.Text = dt.Rows[0]["Notes"].ToString();
}
}
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
string command = dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString();
int tag_Id = Convert.ToInt32(dataGridView1.Rows[e.RowIndex].Cells[3].Value);
if (command == "Edit")
{
Edit_Tags et = new Edit_Tags(tag_Id);
et.UserID = userId;
this.Close();
et.Show();
}
else if (command == "Delete")
{
try
{
string qry = "delete from [tbl_Tags] where Tag_Id =" + tag_Id;
DatabaseCon dbcon = new DatabaseCon();
dbcon.Query = qry;
dbcon.ExecuteQuery();
MessageBox.Show("Data deleted successfully");
loadTag();
}
catch (Exception ex)
{
throw ex;
}
}
else if (command == "Tagged Article")
{
try
{
string qry = "select Tag from [tbl_Tags] where Tag_Id =" + tag_Id;
DatabaseCon dbcon = new DatabaseCon();
dbcon.Query = qry;
DataTable dt = dbcon.GetData();
string Tag = dt.Rows[0]["Tag"].ToString();
View_myReferences vr = new View_myReferences(userId);
vr.Tag = Tag;
this.Close();
vr.Show();
}
catch (Exception ex)
{
throw ex;
}
}
}
private void ViewAllTags_Load(object sender, EventArgs e)
{
try
{
string qry = "select * from [tbl_Tags]";
DatabaseCon dbcon = new DatabaseCon();
dbcon.Query = qry;
DataTable dt = dbcon.GetData();
dataGridView1.DataSource = dt;
}
catch (Exception ex)
{
throw ex;
}
}
public DataTable userdata(int userid)
{
try
{
string qry = "select * from tbl_User where ID =" + userid;
DatabaseCon dbcon = new DatabaseCon();
dbcon.Query = qry;
DataTable dt = dbcon.GetData();
return(dt);
}
catch (Exception ex)
{
throw ex;
}
}
public DataTable login(string email, string pw)
{
try
{
string qry = "select * from tbl_User where Email= '" + email + "' and Password = '******'";
DatabaseCon dbcon = new DatabaseCon();
dbcon.Query = qry;
DataTable dt = dbcon.GetData();
return(dt);
}
catch (Exception ex)
{
throw ex;
}
}
private void loadTag()
{
try
{
string qry = "select * from tbl_Tags where UserId =" + userId;
DatabaseCon dbcon = new DatabaseCon();
dbcon.Query = qry;
DataTable dt = dbcon.GetData();
dataGridView1.DataSource = dt;
}
catch (Exception ex)
{
throw ex;
}
}
private void Edit_Tags_Load(object sender, EventArgs e)
{
try
{
string qry = "select * from tbl_Tags where Tag_Id =" + tagId;
DatabaseCon dbcon = new DatabaseCon();
dbcon.Query = qry;
DataTable dt = dbcon.GetData();
if (dt.Rows.Count > 0)
{
txtTag.Text = dt.Rows[0]["Tag"].ToString();
}
}
catch (Exception ex)
{
throw ex;
}
}
private void Export_Load(object sender, EventArgs e)
{
combo_Export.Items.Add("Harvard");
combo_Export.Items.Add("APA");
combo_Export.Items.Add("Chicago");
combo_Export.SelectedIndex = 0;
try
{
string qry = "select * from tbl_References where UserId =" + userId;
DatabaseCon dbcon = new DatabaseCon();
dbcon.Query = qry;
DataTable dt = dbcon.GetData();
dataGridView1.DataSource = dt;
}
catch (Exception ex)
{
throw ex;
}
}
private void pictureBox2_Click(object sender, EventArgs e)
{
try
{
string search = txtSearch.Text;
string qry = "select * from [tbl_References] where UserID = " + userid + "and Title like '%"
+ search + "%' or Authors_Fname like '%" + search + "%' or Authors_Lname like '%"
+ search + "%' or Document_type like '%" + search + "%' or Year like '%" + search
+ "%' or Publisher like '%" + search + "%' or Abstract like '%" + search
+ "%' or Name like '%" + search + "%' or Issue like '%" + search + "%' or Volume like '%"
+ search + "%' or Notes like '%" + search + "%'";
DatabaseCon dbcon = new DatabaseCon();
dbcon.Query = qry;
DataTable dt = dbcon.GetData();
dataGridView1.DataSource = dt;
}
catch (Exception ex)
{
throw ex;
}
}
public bool CheckEmail(string Email)
{
try
{
DatabaseCon dbcon = new DatabaseCon();
string qry = "select Email from [tbl_User]";
dbcon.Query = qry;
DataTable dt = dbcon.GetData();
foreach (DataRow dr in dt.Rows)
{
if (Email == (string)dr["Email"])
{
return(false);
}
}
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
private void viewreference(string style, string query)
{
try
{
string qry = "";
if (!string.IsNullOrEmpty(query))
{
qry = query;
}
else
{
qry = "select * from tbl_References where UserId =" + userId;
}
DatabaseCon dbcon = new DatabaseCon();
dbcon.Query = qry;
DataTable dt = dbcon.GetData();
panel1.Controls.Clear();
int y = 10;
foreach (DataRow dr in dt.Rows)
{
string title = (string)dr["Title"];
string authorsFname = (string)dr["Authors_Fname"];
string authorsLname = (string)dr["Authors_Lname"];
string documentType = (string)dr["Document_type"];
string year = (string)dr["Year"];
string Publisher = (string)dr["Publisher"];
string City = (string)dr["City"];
string Abstract = (string)dr["Abstract"];
string name = (string)dr["Name"];
string issue = (string)dr["Issue"];
string volume = (string)dr["Volume"];
int pageno = Convert.ToInt32(dr["Page_no"].ToString());
authorsFname = authorsFname.Substring(0, 1);
RichTextBox txt1 = new RichTextBox();
txt1.BorderStyle = BorderStyle.None;
txt1.Location = new Point(90, y);
txt1.Width = 1000;
txt1.Height = 30;
txt1.ReadOnly = true;
txt1.Font = new Font(FontFamily.GenericSansSerif, 16, FontStyle.Regular);
y = y + 30;
if (style == "Harvard")
{
if (documentType == "Book")
{
//Last name, First initial. (Year published).Title. City published: Publisher, Page(s).
txt1.Text = authorsLname + ", " + authorsFname + ". " + "(" + year + ")." + name
+ ". " + City + ": " + Publisher + ", " + pageno + ".";
this.makeItalic(name, txt1);
}
else if (documentType == "Journal")
{
//Last name, First initial. (Year published). Article title. Journal, Volume (Issue),
//Page(s).
txt1.Text = authorsLname + ", " + authorsFname + ". " + "(" + year + ")." + title + ". "
+ name + ", " + volume + "(" + issue + ")" + pageno + ".";
this.makeItalic(name, txt1);
}
else if (documentType == "Conference Processing")
{
//Last name, First initial. (Conference Year). Title of Paper or Proceedings.
//In: Name or Title of Conference. City: Publisher of the Proceedings, pages.
txt1.Text = authorsLname + ", " + authorsFname + ". " + "(" + year + ")." + title
+ ". In:" + name + ". " + City + ":" + Publisher + ", " + pageno + ".";
this.makeItalic(name, txt1);
}
}
else if (style == "APA")
{
if (documentType == "Book")
{
//Author, A. (Year of Publication). Title of work. Publisher City : Publisher.
txt1.Text = authorsLname + "," + authorsFname + "." + "(" + year + "). " + name
+ ". " + City + ":" + Publisher + ".";
this.makeItalic(name, txt1);
}
else if (documentType == "Journal")
{
//Last, FN. (Year Published). Article title. Journal Name, Volume(Issue), Pages.
txt1.Text = authorsLname + ", " + authorsFname + ". " + "(" + year + ")." + title
+ ". " + name + ", " + volume + "(" + issue + ")" + pageno + ".";
this.makeItalic(name, txt1);
}
else if (documentType == "Conference Processing")
{
//Last name, FN. (Year published). Title of Paper or Proceedings, Title of Conference,
//Issue. Place of publication: Publisher.
txt1.Text = authorsLname + ", " + authorsFname + ". " + "(" + year + ")." + title
+ ", " + name + ", " + issue + ", " + City + ": " + Publisher + ".";
this.makeItalic(name, txt1);
this.makeItalic(volume, txt1);
}
}
else if (style == "Chicago")
{
if (documentType == "Book")
{
//Last Name, First Name. Title of Book. Publisher City: Publisher Name, Year Published.
txt1.Text = authorsLname + "," + authorsFname + ". " + name + ". " + City + ": "
+ Publisher + ", " + year + ".";
this.makeItalic(name, txt1);
}
else if (documentType == "Journal")
{
//Last name, First name. “Article Title.” Journal Title, volume, no. issue
//(year of publication). Pages.
txt1.Text = authorsLname + "," + authorsFname + ". '" + title + ".' " + name + ", "
+ volume + ", " + issue + "(" + year + "). " + pageno + ".";
this.makeItalic(name, txt1);
}
else if (documentType == "Conference Processing")
{
//Last name, First name. “Title of the Paper.” Paper presented at the Title of
//the Conference, Location of Conference, Year of Conference.
txt1.Text = authorsLname + "," + authorsFname + ". '" + title + ".' " + name
+ ", " + City + ", " + year + ".";
}
}
else
{
MessageBox.Show("Please select valid referencing style.");
}
panel1.Controls.Add(txt1);
panel1.AutoScroll = true;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}