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);
}
