//web config - centralno mjesto za pohranu public List <User> GetAllUsers() { List <User> users = new List <User>(); //nadji sqlelper u nugget packagima microsoft DataSet dsUsers = SqlHelper.ExecuteDataset(cs, "GetUsers"); //nezovi proceduru kako smo nazvali metodu //KUHARICA SPRANCA CESLJANJE PODATAKA OD STRANE SQL HELPERA TOE TO foreach (DataRow row in dsUsers.Tables[0].Rows)//dataset je kolekcija tablica, imat ce onoliko tablica koliko ima select upita //u nasem slucaju jedan, u slucaju vise slectova imali bi vise tablica { int ID = (int)row["IDUser"]; User user = new User(); user.IDUser = ID; user.Firstname = row["Firstname"].ToString(); user.Lastname = row["Lastname"].ToString(); user.Phone = row["Phone"].ToString(); user.City = row["City"].ToString(); user.Role = row["Role"].ToString(); user.Password = row["Password"].ToString(); user.Email = row["Email"].ToString(); users.Add(user); } return(users); }
public void UpdateUser(int userId, string name, string lastname, string phone, string password, string city, string role, string email) { SqlHelper.ExecuteNonQuery(cs, "UpdateUser", userId, name, lastname, phone, password, city, role, email); }
public void DeleteUser(int id) { SqlHelper.ExecuteNonQuery(cs, "DeleteUser", id); }
public void AddUser(string name, string lastname, string phone, string password, string city, string role, string email) { SqlHelper.ExecuteNonQuery(cs, "AddUser", name, lastname, phone, password, city, role, email); }