//פונקציה שמחזירה את נתוני השייכות של משתמש יחיד לעיר מסויימת בהתאם לתז שלו 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); }