////get_SamplesDB public List <sampleDetails> get_Sample_Details_DB() { List <sampleDetails> smpl_list = new List <sampleDetails>(); SqlConnection con = null; try { con = connect("DBConnectionString"); String query = "SELECT * FROM [SampleDetails_2020]"; SqlCommand cmd = new SqlCommand(query, con); cmd.CommandTimeout = 480; // enlarge T.O SqlDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); // the connection will close as reading completes while (dr.Read()) { sampleDetails smpl = new sampleDetails(); smpl.Batch_id = Convert.ToInt32(dr["batch_id"]); smpl.Date = Convert.ToDateTime(dr["date"]); smpl.Tank_temp = (float)dr["Tank_temp"]; smpl.Sample_temp = (float)dr["Sample_Temp"]; smpl.Rate = (float)dr["Rate"]; smpl.Gravity = (float)dr["Gravity"]; smpl.Ph = (float)dr["ph"]; smpl.Notes = (string)dr["notes"]; smpl.Row_num = Convert.ToInt32(dr["index"]); smpl_list.Add(smpl); } return(smpl_list); } catch (Exception ex) { throw (ex); } finally { if (con != null) { con.Close(); } } }
[HttpPut] // public HttpResponseMessage Put([FromBody] sampleDetails sample) // { int numEffected = 0; try { numEffected = sample.Update(); if (numEffected > 0) { return(Request.CreateResponse(HttpStatusCode.OK, numEffected)); } else { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Not Found")); } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex.Message)); } }
public HttpResponseMessage Delete([FromBody] string row_num) // row = row number in DB { int numEffected = 0; sampleDetails smp = new sampleDetails(); try { numEffected = smp.delete_line(Convert.ToInt32(row_num)); if (numEffected > 0) { return(Request.CreateResponse(HttpStatusCode.OK, numEffected)); } else { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Not Found")); } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex.Message)); } }
public int Post([FromBody] sampleDetails sample) { return(sample.insert()); }
public List <sampleDetails> Get() { sampleDetails sample = new sampleDetails(); return(sample.get_Samples()); }