public TestResultsBO getResults(int TenantID, int SpecimenID) { TestResultsBO resBO = new TestResultsBO(); try { using (SqlConnection connect = new SqlConnection(Constant.DBConnectionString)) { using (SqlCommand command = new SqlCommand("select * from stblTestResults where TenantID = @TenantID and SpecimenID = @SpecimenID", connect)) { connect.Open(); command.Parameters.Add(new SqlParameter("@SpecimenID", SpecimenID)); command.Parameters.Add(new SqlParameter("@TenantID", TenantID)); command.CommandType = CommandType.Text; SqlDataReader read = command.ExecuteReader(); if (read.HasRows) { while (read.Read()) { resBO.ResultID = read["ResultID"] == DBNull.Value ? 0 : Convert.ToInt32(read["ResultID"]); resBO.SpecimenID = read["SpecimenID"] == DBNull.Value ? 0 : Convert.ToInt32(read["SpecimenID"]); resBO.AssayID = read["AssayID"] == DBNull.Value ? 0 : Convert.ToInt32(read["AssayID"]); resBO.TotalBuccalProteinyield = read["TotalBuccalProteinyield"] == DBNull.Value ? string.Empty : Convert.ToString(read["TotalBuccalProteinyield"]); resBO.CitrateSynthase = read["CitrateSynthase"] == DBNull.Value ? string.Empty : Convert.ToString(read["CitrateSynthase"]); resBO.RC_IV = read["RC_IV"] == DBNull.Value ? string.Empty : Convert.ToString(read["RC_IV"]); resBO.RC_I = read["RC_I"] == DBNull.Value ? string.Empty : Convert.ToString(read["RC_I"]); resBO.analysisReveals = read["analysisReveals"] == DBNull.Value ? string.Empty : Convert.ToString(read["analysisReveals"]); resBO.Interpretation = read["Interpretation"] == DBNull.Value ? string.Empty : Convert.ToString(read["Interpretation"]); resBO.Notes = read["Notes"] == DBNull.Value ? string.Empty : Convert.ToString(read["Notes"]); resBO.PerformedBy = read["PerformedBy"] == DBNull.Value ? string.Empty : Convert.ToString(read["PerformedBy"]); resBO.ResultDocID = read["ResultDocID"] == DBNull.Value ? 0 : Convert.ToInt32(read["ResultDocID"]); resBO.IsReleased = read["IsReleased"] == DBNull.Value ? false : Convert.ToBoolean(read["IsReleased"]); } } read.Close(); connect.Close(); } } } catch (Exception ex) { strErrorMsg = ex.Message; throw; } finally { if (sqlCon != null) { sqlCon.Dispose(); } } return(resBO); }
public int UpdateResults(TestResultsBO testResBO) { int resID = 0; try { using (SqlConnection connect = new SqlConnection(Constant.DBConnectionString)) { using (SqlCommand command = new SqlCommand("sspSaveResults", connect)) { connect.Open(); command.Parameters.Add(new SqlParameter("@ResultID", testResBO.ResultID)); command.Parameters.Add(new SqlParameter("@SpecimenID", testResBO.SpecimenID)); command.Parameters.Add(new SqlParameter("@AssayID", testResBO.AssayID)); command.Parameters.Add(new SqlParameter("@TotalBuccalProteinyield", testResBO.TotalBuccalProteinyield)); command.Parameters.Add(new SqlParameter("@CitrateSynthase", testResBO.CitrateSynthase)); command.Parameters.Add(new SqlParameter("@RC_IV", testResBO.RC_IV)); command.Parameters.Add(new SqlParameter("@RC_I", testResBO.RC_I)); command.Parameters.Add(new SqlParameter("@analysisReveals", testResBO.analysisReveals)); command.Parameters.Add(new SqlParameter("@Interpretation", testResBO.Interpretation)); command.Parameters.Add(new SqlParameter("@Notes", testResBO.Notes)); command.Parameters.Add(new SqlParameter("@TenantID", testResBO.TenantID)); command.Parameters.Add(new SqlParameter("@PerformedBy", testResBO.PerformedBy)); command.Parameters.Add(new SqlParameter("@ResultDocID", testResBO.ResultDocID)); command.Parameters.Add(new SqlParameter("@IsReleased", testResBO.IsReleased)); command.CommandType = CommandType.StoredProcedure; SqlDataReader read = command.ExecuteReader(); if (read.HasRows) { while (read.Read()) { resID = Convert.ToInt32(read[0]); } } read.Close(); connect.Close(); } } } catch (Exception ex) { strErrorMsg = ex.Message; throw; } finally { if (sqlCon != null) { sqlCon.Dispose(); } } return(resID); }