// Save changes of object protected void btnSave_click(Object sender, EventArgs e) { SecondaryAntibody temp = new SecondaryAntibody(); temp.id = int.Parse(txtid.Value); temp.antibodyName = txtantibodyName.Text; temp.antigen = txtantigen.Text; temp.applications = txtapplications.Text; temp.concentration = txtconcentration.Text; temp.excitation = txtexcitation.Text; if (ddlfluorophore.SelectedValue != "Other") { temp.fluorophore = ddlfluorophore.SelectedValue; } else { temp.fluorophore = txtfluorophore.Text; } if (ddlhostSpecies.SelectedValue != "Other") { temp.hostSpecies = ddlhostSpecies.SelectedValue; } else { temp.hostSpecies = txthostSpecies.Text; } temp.labID = int.Parse(ddllabID.SelectedValue); temp.lotNumber = txtlotNumber.Text; String reactiveSpecies = ""; int i = 0; foreach (ListItem li in ddlreactiveSpecies.Items) { if (li.Selected == true) { if (i > 0) { reactiveSpecies += ","; } reactiveSpecies += li.Value; i++; } } temp.reactiveSpecies = reactiveSpecies; temp.workingDilution = txtworkingDilution.Text; myConn.updateSecondaryAntibody(temp); gvSecondaryAntibodies.DataBind(); }
/// <summary> /// Gets every SecondaryAntibody record in the database, saves each one in a new SecondaryAntibody object, and puts it in an ArrayList. /// </summary> /// <returns>ArrayList of Secondary Antibody objects</returns> public ArrayList getAllSecondaryAntibodies() { conn.Open(); ArrayList temp = new ArrayList(); SqlCommand cmd = new SqlCommand("dbo.getSecondaryAntibodyRecords", conn); cmd.CommandType = CommandType.StoredProcedure; SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { SecondaryAntibody tempSecondaryAntibody = new SecondaryAntibody(Convert.ToInt32(rdr.GetValue(0)), Convert.ToInt32(rdr.GetValue(1)), rdr.GetValue(2).ToString(), rdr.GetValue(3).ToString(), rdr.GetValue(4).ToString(), rdr.GetValue(5).ToString(), rdr.GetValue(6).ToString(), rdr.GetValue(7).ToString(), rdr.GetValue(8).ToString(), rdr.GetValue(9).ToString(), rdr.GetValue(10).ToString(), rdr.GetValue(11).ToString(), rdr.GetValue(13).ToString()); temp.Add(tempSecondaryAntibody); } conn.Close(); return(temp); }
// Save changes of object protected void btnSave_click(Object sender, EventArgs e) { SecondaryAntibody temp = new SecondaryAntibody(); temp.id = int.Parse(txtid.Value); temp.antibodyName = txtantibodyName.Text; temp.antigen = txtantigen.Text; temp.applications = txtapplications.Text; temp.concentration = txtconcentration.Text; temp.excitation = txtexcitation.Text; if (ddlfluorophore.SelectedValue != "Other") { temp.fluorophore = ddlfluorophore.SelectedValue; } else { temp.fluorophore = txtfluorophore.Text; } if (ddlhostSpecies.SelectedValue != "Other") { temp.hostSpecies = ddlhostSpecies.SelectedValue; } else { temp.hostSpecies = txthostSpecies.Text; } temp.labID = int.Parse(ddllabID.SelectedValue); temp.lotNumber = txtlotNumber.Text; String reactiveSpecies = ""; int i = 0; foreach (ListItem li in ddlreactiveSpecies.Items) { if (li.Selected == true) { if (i > 0) { reactiveSpecies += ","; } reactiveSpecies += li.Value; i++; } } temp.reactiveSpecies = reactiveSpecies; temp.workingDilution = txtworkingDilution.Text; myConn.updateSecondaryAntibody(temp); gvSecondaryAntibodies.DataBind(); }
/// <summary> /// Updates the secondary antibody record with the matching ID /// </summary> /// <param name="temp">SecondaryAntibody object to be written to the database</param> public Boolean updateSecondaryAntibody(SecondaryAntibody temp) { conn.Open(); SqlCommand cmd = new SqlCommand("UPDATE dbo.SecondaryAntibody SET LabID='" + temp.labID + "', Concentration='" + temp.concentration + "', Excitation='" + temp.excitation + "', AntibodyName='" + temp.antibodyName + "', HostSpecies='" + temp.hostSpecies + "', ReactiveSpecies='" + temp.reactiveSpecies + "', Fluorophore='" + temp.fluorophore + "', WorkingDilution='" + temp.workingDilution + "', LotNumber='" + temp.lotNumber + "', Antigen='" + temp.antigen + "', Applications='" + temp.applications + "' WHERE ID=" + temp.id + ";", conn); cmd.CommandType = CommandType.Text; int i = cmd.ExecuteNonQuery(); conn.Close(); if (i > 0) { return(true); } else { return(false); } }
/// <summary> /// Gets the SecondaryAntibody denoted by the provided ID /// </summary> /// <param name="id">ID of the SecondaryAntibody to be located</param> /// <returns>SecondaryAntibody object if found, null if not</returns> public SecondaryAntibody getSecondaryAntibodyByID(int id) { conn.Open(); SqlCommand cmd = new SqlCommand("SELECT * FROM SecondaryAntibody WHERE ID=" + id + ";", conn); SqlDataReader rdr = cmd.ExecuteReader(); SecondaryAntibody temp; if (rdr.Read()) { temp = new SecondaryAntibody(Convert.ToInt32(rdr.GetValue(0)), Convert.ToInt32(rdr.GetValue(1)), rdr.GetValue(2).ToString(), rdr.GetValue(3).ToString(), rdr.GetValue(4).ToString(), rdr.GetValue(5).ToString(), rdr.GetValue(6).ToString(), rdr.GetValue(7).ToString(), rdr.GetValue(8).ToString(), rdr.GetValue(9).ToString(), rdr.GetValue(10).ToString(), rdr.GetValue(11).ToString(), null); } else { temp = null; } conn.Close(); return(temp); }
/// <summary> /// Inserts the provided SecondaryAntibody object as a new record into the database /// </summary> /// <param name="temp">SecondaryAntibody object to be added to the database</param> /// <returns>True if add is successful, false otherwise</returns> public Boolean addSecondaryAntibody(SecondaryAntibody temp) { conn.Open(); SqlCommand cmd = new SqlCommand("INSERT INTO dbo.SecondaryAntibody VALUES(" + temp.labID + ",'" + temp.concentration + "','" + temp.excitation + "','" + temp.antibodyName + "','" + temp.hostSpecies + "','" + temp.reactiveSpecies + "','" + temp.fluorophore + "','" + temp.workingDilution + "','" + temp.lotNumber + "','" + temp.antigen + "','" + temp.applications + "');", conn); cmd.CommandType = CommandType.Text; int i = cmd.ExecuteNonQuery(); conn.Close(); if (i > 0) { return(true); } else { return(false); } }
// submit protected void btnSubmit_click(Object sender, EventArgs e) { SecondaryAntibody antibody = new SecondaryAntibody(); antibody.labID = int.Parse(ddlLabID.SelectedValue); antibody.antibodyName = txtName.Text; antibody.antigen = txtAntigen.Text; antibody.applications = txtApplications.Text; antibody.concentration = txtConcentration.Text; antibody.excitation = txtExcitation.Text; antibody.fluorophore = ddlFluorophore.SelectedValue; if (ddlHostSpecies.SelectedValue != "Other") { antibody.hostSpecies = ddlHostSpecies.SelectedValue; } else { antibody.hostSpecies = txthostSpecies.Text; } antibody.lotNumber = txtLotNumber.Text; String reactiveSpecies = ""; int i = 0; foreach (ListItem li in ddlReactiveSpecies.Items) { if (li.Selected == true) { if (i > 0) { reactiveSpecies += ","; } reactiveSpecies += li.Value; i++; } } antibody.reactiveSpecies = reactiveSpecies; antibody.workingDilution = txtWorkingDilution.Text; if (myConn.addSecondaryAntibody(antibody)) { Response.Redirect("SecondaryAntibodies.aspx"); } }
// submit protected void btnSubmit_click(Object sender, EventArgs e) { SecondaryAntibody antibody = new SecondaryAntibody(); antibody.labID = int.Parse(ddlLabID.SelectedValue); antibody.antibodyName = txtName.Text; antibody.antigen = txtAntigen.Text; antibody.applications = txtApplications.Text; antibody.concentration = txtConcentration.Text; antibody.excitation = txtExcitation.Text; antibody.fluorophore = ddlFluorophore.SelectedValue; if (ddlHostSpecies.SelectedValue != "Other") { antibody.hostSpecies = ddlHostSpecies.SelectedValue; } else { antibody.hostSpecies = txthostSpecies.Text; } antibody.lotNumber = txtLotNumber.Text; String reactiveSpecies = ""; int i = 0; foreach (ListItem li in ddlReactiveSpecies.Items) { if (li.Selected == true) { if (i > 0) { reactiveSpecies += ","; } reactiveSpecies += li.Value; i++; } } antibody.reactiveSpecies = reactiveSpecies; antibody.workingDilution = txtWorkingDilution.Text; if (myConn.addSecondaryAntibody(antibody)) { Response.Redirect("SecondaryAntibodies.aspx"); } }
/// <summary> /// Updates the secondary antibody record with the matching ID /// </summary> /// <param name="temp">SecondaryAntibody object to be written to the database</param> public Boolean updateSecondaryAntibody(SecondaryAntibody temp) { conn.Open(); SqlCommand cmd = new SqlCommand("UPDATE dbo.SecondaryAntibody SET LabID='" + temp.labID + "', Concentration='" + temp.concentration + "', Excitation='" + temp.excitation + "', AntibodyName='" + temp.antibodyName + "', HostSpecies='" + temp.hostSpecies + "', ReactiveSpecies='" + temp.reactiveSpecies + "', Fluorophore='" + temp.fluorophore + "', WorkingDilution='" + temp.workingDilution + "', LotNumber='" + temp.lotNumber + "', Antigen='" + temp.antigen + "', Applications='" + temp.applications + "' WHERE ID=" + temp.id + ";", conn); cmd.CommandType = CommandType.Text; int i = cmd.ExecuteNonQuery(); conn.Close(); if (i > 0) return true; else return false; }
/// <summary> /// Gets the SecondaryAntibody denoted by the provided ID /// </summary> /// <param name="id">ID of the SecondaryAntibody to be located</param> /// <returns>SecondaryAntibody object if found, null if not</returns> public SecondaryAntibody getSecondaryAntibodyByID(int id) { conn.Open(); SqlCommand cmd = new SqlCommand("SELECT * FROM SecondaryAntibody WHERE ID=" + id + ";", conn); SqlDataReader rdr = cmd.ExecuteReader(); SecondaryAntibody temp; if (rdr.Read()) temp = new SecondaryAntibody(Convert.ToInt32(rdr.GetValue(0)), Convert.ToInt32(rdr.GetValue(1)), rdr.GetValue(2).ToString(), rdr.GetValue(3).ToString(), rdr.GetValue(4).ToString(), rdr.GetValue(5).ToString(), rdr.GetValue(6).ToString(), rdr.GetValue(7).ToString(), rdr.GetValue(8).ToString(), rdr.GetValue(9).ToString(), rdr.GetValue(10).ToString(), rdr.GetValue(11).ToString(), null); else temp = null; conn.Close(); return temp; }
/// <summary> /// Gets every SecondaryAntibody record in the database, saves each one in a new SecondaryAntibody object, and puts it in an ArrayList. /// </summary> /// <returns>ArrayList of Secondary Antibody objects</returns> public ArrayList getAllSecondaryAntibodies() { conn.Open(); ArrayList temp = new ArrayList(); SqlCommand cmd = new SqlCommand("dbo.getSecondaryAntibodyRecords", conn); cmd.CommandType = CommandType.StoredProcedure; SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { SecondaryAntibody tempSecondaryAntibody = new SecondaryAntibody(Convert.ToInt32(rdr.GetValue(0)), Convert.ToInt32(rdr.GetValue(1)), rdr.GetValue(2).ToString(), rdr.GetValue(3).ToString(), rdr.GetValue(4).ToString(), rdr.GetValue(5).ToString(), rdr.GetValue(6).ToString(), rdr.GetValue(7).ToString(), rdr.GetValue(8).ToString(), rdr.GetValue(9).ToString(), rdr.GetValue(10).ToString(), rdr.GetValue(11).ToString(), rdr.GetValue(13).ToString()); temp.Add(tempSecondaryAntibody); } conn.Close(); return temp; }
/// <summary> /// Inserts the provided SecondaryAntibody object as a new record into the database /// </summary> /// <param name="temp">SecondaryAntibody object to be added to the database</param> /// <returns>True if add is successful, false otherwise</returns> public Boolean addSecondaryAntibody(SecondaryAntibody temp) { conn.Open(); SqlCommand cmd = new SqlCommand("INSERT INTO dbo.SecondaryAntibody VALUES(" + temp.labID + ",'" + temp.concentration + "','" + temp.excitation + "','" + temp.antibodyName + "','" + temp.hostSpecies + "','" + temp.reactiveSpecies + "','" + temp.fluorophore + "','" + temp.workingDilution + "','" + temp.lotNumber + "','" + temp.antigen + "','" + temp.applications + "');", conn); cmd.CommandType = CommandType.Text; int i = cmd.ExecuteNonQuery(); conn.Close(); if (i > 0) return true; else return false; }
protected void createPDF(Stream output) { //SecondaryAntibody tempAntibody = myConn.getSecondaryAntibodyByID(Convert.ToInt16(Request.QueryString["id"])); SecondaryAntibody tempAntibody = myConn.getSecondaryAntibodyByID(2); Response.ContentType = "application/pdf"; Response.AddHeader("Content-Disposition", "attachment; filename=secondary_antibody_" + tempAntibody.id + ".pdf"); iTextSharp.text.Document document = new iTextSharp.text.Document(iTextSharp.text.PageSize.LETTER, 72, 72, 72, 72); PdfWriter writer = PdfWriter.GetInstance(document, Response.OutputStream); document.Open(); //Page title and spacing iTextSharp.text.Chunk pageTitle = new iTextSharp.text.Chunk("Secondary Antibody Record", new iTextSharp.text.Font(iTextSharp.text.Font.FontFamily.HELVETICA, 20)); document.Add(pageTitle); iTextSharp.text.Paragraph spacing = new iTextSharp.text.Paragraph(" "); document.Add(spacing); //Antibody Name iTextSharp.text.Paragraph tempParagraph = new iTextSharp.text.Paragraph(); iTextSharp.text.Chunk tempLabel = new iTextSharp.text.Chunk("Antibody Name: ", new iTextSharp.text.Font(iTextSharp.text.Font.FontFamily.HELVETICA, 10)); iTextSharp.text.Chunk tempValue = new iTextSharp.text.Chunk(tempAntibody.antibodyName, new iTextSharp.text.Font(iTextSharp.text.Font.FontFamily.HELVETICA, 10)); tempParagraph.Add(tempLabel); tempParagraph.Add(tempValue); document.Add(tempParagraph); //Concentration tempParagraph = new iTextSharp.text.Paragraph(); tempLabel = new iTextSharp.text.Chunk("Concentration: ", new iTextSharp.text.Font(iTextSharp.text.Font.FontFamily.HELVETICA, 10)); tempValue = new iTextSharp.text.Chunk(tempAntibody.concentration, new iTextSharp.text.Font(iTextSharp.text.Font.FontFamily.HELVETICA, 10)); tempParagraph.Add(tempLabel); tempParagraph.Add(tempValue); document.Add(tempParagraph); //Excitation tempParagraph = new iTextSharp.text.Paragraph(); tempLabel = new iTextSharp.text.Chunk("Excitation: ", new iTextSharp.text.Font(iTextSharp.text.Font.FontFamily.HELVETICA, 10)); tempValue = new iTextSharp.text.Chunk(tempAntibody.excitation, new iTextSharp.text.Font(iTextSharp.text.Font.FontFamily.HELVETICA, 10)); tempParagraph.Add(tempLabel); tempParagraph.Add(tempValue); document.Add(tempParagraph); //Host Species tempParagraph = new iTextSharp.text.Paragraph(); tempLabel = new iTextSharp.text.Chunk("Host Species: ", new iTextSharp.text.Font(iTextSharp.text.Font.FontFamily.HELVETICA, 10)); tempValue = new iTextSharp.text.Chunk(tempAntibody.hostSpecies, new iTextSharp.text.Font(iTextSharp.text.Font.FontFamily.HELVETICA, 10)); tempParagraph.Add(tempLabel); tempParagraph.Add(tempValue); document.Add(tempParagraph); //Reactive Species tempParagraph = new iTextSharp.text.Paragraph(); tempLabel = new iTextSharp.text.Chunk("Reactive Species: ", new iTextSharp.text.Font(iTextSharp.text.Font.FontFamily.HELVETICA, 10)); tempValue = new iTextSharp.text.Chunk(tempAntibody.reactiveSpecies, new iTextSharp.text.Font(iTextSharp.text.Font.FontFamily.HELVETICA, 10)); tempParagraph.Add(tempLabel); tempParagraph.Add(tempValue); document.Add(tempParagraph); //Fluorophore tempParagraph = new iTextSharp.text.Paragraph(); tempLabel = new iTextSharp.text.Chunk("Fluorophore: ", new iTextSharp.text.Font(iTextSharp.text.Font.FontFamily.HELVETICA, 10)); tempValue = new iTextSharp.text.Chunk(tempAntibody.fluorophore, new iTextSharp.text.Font(iTextSharp.text.Font.FontFamily.HELVETICA, 10)); tempParagraph.Add(tempLabel); tempParagraph.Add(tempValue); document.Add(tempParagraph); //Working Dilution tempParagraph = new iTextSharp.text.Paragraph(); tempLabel = new iTextSharp.text.Chunk("Working Dilution: ", new iTextSharp.text.Font(iTextSharp.text.Font.FontFamily.HELVETICA, 10)); tempValue = new iTextSharp.text.Chunk(tempAntibody.workingDilution, new iTextSharp.text.Font(iTextSharp.text.Font.FontFamily.HELVETICA, 10)); tempParagraph.Add(tempLabel); tempParagraph.Add(tempValue); document.Add(tempParagraph); //Lot Number tempParagraph = new iTextSharp.text.Paragraph(); tempLabel = new iTextSharp.text.Chunk("Lot Number: ", new iTextSharp.text.Font(iTextSharp.text.Font.FontFamily.HELVETICA, 10)); tempValue = new iTextSharp.text.Chunk(tempAntibody.lotNumber, new iTextSharp.text.Font(iTextSharp.text.Font.FontFamily.HELVETICA, 10)); tempParagraph.Add(tempLabel); tempParagraph.Add(tempValue); document.Add(tempParagraph); //Antigen tempParagraph = new iTextSharp.text.Paragraph(); tempLabel = new iTextSharp.text.Chunk("Antigen: ", new iTextSharp.text.Font(iTextSharp.text.Font.FontFamily.HELVETICA, 10)); tempValue = new iTextSharp.text.Chunk(tempAntibody.antigen, new iTextSharp.text.Font(iTextSharp.text.Font.FontFamily.HELVETICA, 10)); tempParagraph.Add(tempLabel); tempParagraph.Add(tempValue); document.Add(tempParagraph); //Applications tempParagraph = new iTextSharp.text.Paragraph(); tempLabel = new iTextSharp.text.Chunk("Applications: ", new iTextSharp.text.Font(iTextSharp.text.Font.FontFamily.HELVETICA, 10)); tempValue = new iTextSharp.text.Chunk(tempAntibody.applications, new iTextSharp.text.Font(iTextSharp.text.Font.FontFamily.HELVETICA, 10)); tempParagraph.Add(tempLabel); tempParagraph.Add(tempValue); document.Add(tempParagraph); document.Close(); }
/// <summary> /// Compares the ID of the current SecondaryAntibody object to that of a provided SecondaryAntibody /// </summary> /// <param name="temp">SecondaryAntibody object to be compared to.</param> /// <returns>True if the ID's are equal (meaning the antibodies are the same), false otherwise.</returns> public Boolean Equals(SecondaryAntibody temp) { return(this.id == temp.id); }
/// <summary> /// Compares the ID of the current SecondaryAntibody object to that of a provided SecondaryAntibody /// </summary> /// <param name="temp">SecondaryAntibody object to be compared to.</param> /// <returns>True if the ID's are equal (meaning the antibodies are the same), false otherwise.</returns> public Boolean Equals(SecondaryAntibody temp) { return this.id == temp.id; }