public HttpResponseMessage Post([FromBody] resendoutboxsms db) { var res = brcdb.resend_sms_outbox(db); var response = new HttpResponseMessage(HttpStatusCode.Created) { Content = new StringContent(JsonConvert.SerializeObject(res), System.Text.Encoding.UTF8, "application/json") }; return(response); }
public List <connection> resend_sms_outbox(resendoutboxsms db) { SqlConnection con = conection.serverChoice(db.branch); var list = new List <connection> { }; con.Open(); SqlCommand cmd = new SqlCommand("update tsms_outbox set processed=0 where ids='" + db.ids + "'", con); SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { var ss = new connection { result = "Resend Success" }; list.Add(ss); } con.Close(); return(list); }