private void button1_Click(object sender, EventArgs e)
{
deneme1 de1 = new deneme1
{
id = 1,
name = "altay",
name2 = "maltay"
};
deneme1Dto de2 = GM.Map <deneme1Dto, deneme1>(de1);
}
public string GetObjectById2([FromUri] int id, [FromUri] int c)
{
List <deneme1> ds = new List <deneme1>();
DataTable dt = Mydb.ExecuteReadertoDataTable("Select * from OBJECT where OBJECT_ID=@obj and CLIENT_ID=@c", new SqlParameter[] { new SqlParameter("@obj", id), new SqlParameter("@c", c) }, CommandType.Text);
foreach (DataRow item in dt.Rows)
{
deneme1 d = new deneme1();
d.deger1 = item["OBJECT_ADRESS"].ToString();
ds.Add(d);
}
return(JsonConvert.SerializeObject(ds));
}
public string searcServices([FromUri] string txt, int o)
{
DataTable dt = Mydb.ExecuteReadertoDataTable("GiveServiceBySearch", new SqlParameter[] { new SqlParameter("@objId", o), new SqlParameter("@txt", txt) }, CommandType.StoredProcedure);
//item["SERVICE_NAME"].ToString();
List <deneme1> ds = new List <deneme1>();
foreach (DataRow item in dt.Rows)
{
deneme1 d = new deneme1();
d.deger1 = item["SERVICE_NAME"].ToString();
ds.Add(d);
}
return(JsonConvert.SerializeObject(ds));
}
// GET: Deneme
public string getDenemeDatas()
{
List <deneme1> ds = new List <deneme1>();
DataTable dt = Mydb.ExecuteReadertoDataTable("Select * from OBJECT", new SqlParameter[] { }, CommandType.Text);
foreach (DataRow item in dt.Rows)
{
deneme1 d = new deneme1();
d.deger1 = item["OBJECT_ADRESS"].ToString();
d.deger2 = item["OBJECT_ID"].ToString();
d.deger3 = item["CLIENT_ID"].ToString();
ds.Add(d);
}
var result = "{\"result\":\"0\",\"SCORES\":\"" + JsonConvert.SerializeObject(ds) + "\"}";
return(result);//JsonConvert.SerializeObject(ds);
}
