//פונקציה שמחזירה את נתוני השייכות של משתמש יחיד לעיר מסויימת בהתאם לתז שלו
public CityBelonging ReturnOneUserCityBelonging(string id)
{
SqlCommand cmd = new SqlCommand();
SqlConnection con;
try
{
con = connect("ConnectionStringName");
}
catch (Exception ex)
{
throw (ex);
}
SqlDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
string q = "SELECT * FROM CityBelongingTbl WHERE UserId = " + id;
cmd = new SqlCommand(q, con);
CityBelonging CB = new CityBelonging();
CB.UserId = (string)dr["UserId"];
CB.WithoutPreferencePercent = (float)Convert.ToDouble(dr["WithoutPreferencePresent"]);
CB.HaifaPercent = (float)Convert.ToDouble(dr["HaifaPercent"]);
CB.JerusalemPercent = (float)Convert.ToDouble(dr["JerusalemPercent"]);
CB.TlvPercent = (float)Convert.ToDouble(dr["TlvPercent"]);
CB.EilatPercent = (float)Convert.ToDouble(dr["EilatPercent"]);
con.Close();
return(CB);
}
// GET api/<controller>/5
public CityBelonging Get(string id)
{
CityBelonging getCB = new CityBelonging();
getCB = getCB.ReturnOneUserCityBelonging(id);
return(getCB);
}
//=============================CityBelonging
// פונקציה שמכניסה למסד שורת שיוך של משתמש לעיר מסויימת
public int InsertOneUserCityBelonging(CityBelonging CB)
{
SqlConnection con;
SqlCommand cmd;
string query;
StringBuilder sb = new StringBuilder();
String prefix;
int numEffected;
try
{
con = connect("ConnectionStringName");
}
catch (Exception ex)
{
return(0);
throw (ex);
}
sb.AppendFormat("Values('{0}', {1}, {2}, {3}, {4}, {5})", CB.UserId, CB.WithoutPreferencePercent, CB.HaifaPercent, CB.JerusalemPercent, CB.TlvPercent, CB.EilatPercent);
prefix = "INSERT INTO CityBelongingTbl (UserId, WithoutPreferencePrecent, HaifaPercent, JerusalemPercent, TlvPercent, EilatPercent)";
query = prefix + sb.ToString(); //כאן יש לי כרגע את הפקודה להכניס רשומות לטבלת - וקטור העדפות חיפוש למשתמש
cmd = new SqlCommand(query, con);
cmd.CommandTimeout = 3;
try
{
numEffected = cmd.ExecuteNonQuery(); // execute the command
return(numEffected);
}
catch (Exception ex)
{
return(0);
throw (ex);
}
finally
{
con.Close();
}
}
// POST api/<controller>
public void Post([FromBody] CityBelonging newCB)
{
CityBelonging CB = new CityBelonging();
CB.InsertCityBelonging(newCB);
}
