public List <smsinbox> smsinbox(databasePost db) { SqlConnection con = conection.serverChoice(db.branch); var list = new List <smsinbox> { }; con.Open(); SqlCommand cmd = new SqlCommand("select top 100 * from tsms_inbox order by sms_dt desc", con); SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { var ss = new smsinbox { ids = rdr["ids"].ToString(), date = rdr["sms_dt"].ToString(), smsfrom = rdr["smsfrom"].ToString(), smsmsg = rdr["smsmsg"].ToString(), process = rdr["processed"].ToString() }; list.Add(ss); } con.Close(); return(list); }
public List <tsynch> tsynch(databasePost db) { SqlConnection con = conection.serverChoice(db.branch); var list = new List <tsynch> { }; con.Open(); SqlCommand cmd = new SqlCommand("select * from [dbo].[tsynclog] where sync_dt BETWEEN GETDATE()-1 AND GETDATE() ORDER BY sync_dt desc", con); SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { var ss = new tsynch { ids = rdr["ids"].ToString(), sync_dt = rdr["sync_dt"].ToString(), sync_typ = rdr["sync_typ"].ToString(), salespointcd = rdr["salespointcd"].ToString(), count_branch = rdr["count_branch"].ToString(), count_ho = rdr["count_ho"].ToString() }; list.Add(ss); } con.Close(); return(list); }
public HttpResponseMessage Post([FromBody] databasePost db) { var res = brcdb.tsynch(db); var response = new HttpResponseMessage(HttpStatusCode.Created) { Content = new StringContent(JsonConvert.SerializeObject(res), System.Text.Encoding.UTF8, "application/json") }; return(response); }
public List <idBranch> branchId(databasePost db) { SqlConnection con = conection.serverChoice(db.branch); var list = new List <idBranch> { }; con.Open(); SqlCommand cmd = new SqlCommand("select * from tmst_salespoint", con); SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { var ss = new idBranch { salespointcd = rdr["salespointcd"].ToString(), salespoint_nm = rdr["salespoint_nm"].ToString(), salespoint_sn = rdr["salespoint_sn"].ToString(), salespoint_typ = rdr["salespoint_typ"].ToString() }; list.Add(ss); } con.Close(); return(list); }