public List <smsoutbox> smsoutbox(smsoutboxPost db) { SqlConnection con = conection.serverChoice(db.branch); var list = new List <smsoutbox> { }; con.Open(); SqlCommand cmd = new SqlCommand("select top 100 * from tsms_outbox where doc_no like'%" + db.doc_no + "%' and doc_typ like '%" + db.doc_typ + "%' order by sms_dt desc", con); SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { var ss = new smsoutbox { ids = rdr["ids"].ToString(), date = rdr["sms_dt"].ToString(), smsto = rdr["smsto"].ToString(), smsmsg = rdr["smsmsg"].ToString(), process = rdr["processed"].ToString(), docno = rdr["doc_no"].ToString(), token = rdr["token"].ToString(), doctype = rdr["doc_typ"].ToString() }; list.Add(ss); } con.Close(); return(list); }
public HttpResponseMessage Post([FromBody] smsoutboxPost db) { var res = brcdb.smsoutbox(db); var response = new HttpResponseMessage(HttpStatusCode.Created) { Content = new StringContent(JsonConvert.SerializeObject(res), System.Text.Encoding.UTF8, "application/json") }; return(response); }