private void btnDodajIgrac_Click(object sender, EventArgs e) { if (ValidateForm()) { OsobaModel p = new OsobaModel(); p.Ime = txtIme.Text; p.Prezime = txtPrezime.Text; p.EmailAdresa = txtEmail.Text; p.BrojMobitela = txtBroj.Text; p = GlobalConfig.Connection.CreatePerson(p); selectedTeamMembers.Add(p); WireUpList(); txtIme.Text = ""; txtPrezime.Text = ""; txtEmail.Text = ""; txtBroj.Text = ""; } else { MessageBox.Show("Ispuni svba polja"); } }
public List <TransakcjaModel> GetUserTransactions(OsobaModel user) { Database.Database.Instance.Connect(); var allUserTransactions = Database.Database.Instance.SelectAll <TransakcjaModel>().Where(trans => trans.IdO == user.IdO); Database.Database.Instance.Dispose(); return(allUserTransactions.ToList()); }
private void ButtonDodajClana_Click(object sender, EventArgs e) { OsobaModel p = (OsobaModel)comboBoxOdaberiIgraca.SelectedItem; availableTeamMembers.Remove(p); selectedTeamMembers.Add(p); WireUpList(); }
private void Buttonizbrisi_Click(object sender, EventArgs e) { OsobaModel p = (OsobaModel)listBoxTeamMembers.SelectedItem; selectedTeamMembers.Remove(p); availableTeamMembers.Add(p); WireUpList(); }
private void btnIzbrisi_Click(object sender, EventArgs e) { OsobaModel p = (OsobaModel)lstIgraca.SelectedItem; if (p != null) { selectedTeamMembers.Remove(p); availabaleTeamMembers.Add(p); WireUpList(); } }
private void btnDodaj_Click(object sender, EventArgs e) { OsobaModel p = (OsobaModel)cmbNoviIgrac.SelectedItem; if (p != null) { availabaleTeamMembers.Remove(p); selectedTeamMembers.Add(p); WireUpList(); } }
private void btnDodajIgraca_Click(object sender, EventArgs e) { OsobaModel p = (OsobaModel)comboBox1.SelectedItem; if (p != null) { dostupniIgraciEkipe.Remove(p); izabraniIgraciEkipe.Add(p); WireUpLists(); } }
private void btnMakniIzabrano_Click(object sender, EventArgs e) { OsobaModel p = (OsobaModel)lstIgrači.SelectedItem; if (p != null) { izabraniIgraciEkipe.Remove(p); dostupniIgraciEkipe.Add(p); WireUpLists(); } }
private void ButtonNext1_Click(object sender, RoutedEventArgs e) { Database.Database.Instance.Connect(); var users = Database.Database.Instance.SelectAll <OsobaModel>(); var currentLogin = users.FirstOrDefault(user => user.Login == LoginBox1.Text && user.Haslo == PasswordBox1.Password); if (currentLogin != null) { var permissions = Database.Database.Instance.SelectAll <UprawnienieModel>(); var userPermission = permissions.FirstOrDefault(perm => perm.IdOD == currentLogin.IdO && perm.Poziom == 0); if (userPermission != null) { OsobaModel newUser = new OsobaModel { Login = Login, Haslo = Password, Imie = NameBox.Text, Nazwisko = Surname, DataU = DateTime.Now }; Database.Database.Instance.Insert(newUser); var dbUser = Database.Database.Instance.SelectAll <OsobaModel>().FirstOrDefault(user => user.Login == newUser.Login); UprawnienieModel uprawnienie1 = new UprawnienieModel { IdOBene = dbUser.IdO, IdOD = dbUser.IdO, Poziom = 1 }; UprawnienieModel uprawnienie2 = new UprawnienieModel { IdOBene = dbUser.IdO, IdOD = dbUser.IdO, Poziom = 2 }; UprawnienieModel uprawnienie3 = new UprawnienieModel { IdOBene = dbUser.IdO, IdOD = dbUser.IdO, Poziom = 3 }; Database.Database.Instance.Insert(uprawnienie1); Database.Database.Instance.Insert(uprawnienie2); Database.Database.Instance.Insert(uprawnienie3); Database.Database.Instance.Dispose(); StateMachine.Instance.PushState <LoggedinLogicState>(new LoggedinStatePushParameters() { user = dbUser, saveLogged = false }); } } else { SurnameErrorText1.Visibility = Visibility.Visible; } Database.Database.Instance.Dispose(); }
public bool CanWriteToUser(OsobaModel other) { if (IsAdmin) { bool val = Permissions.Where(p => p.IdOD == other.IdO).All(p => p.Poziom > UprawnienieModel.WRITE_BAN); return(val); } else { bool val = Permissions.Where(p => p.IdOD == other.IdO).Any(p => p.Poziom == UprawnienieModel.WRITE_ALLOW); return(val); } }
public OsobaModel IzradiOsobu(OsobaModel model) { List <OsobaModel> osoba = OsobaFile.FullFilePath().LoadFile().ConvertToOsobaModels(); int currentID = 1; if (osoba.Count > 0) { currentID = osoba.OrderByDescending(x => x.ID).First().ID + 1; } model.ID = currentID; osoba.Add(model); osoba.SaveToOsobaFile(OsobaFile); return(model); }
public OsobaModel IzradiOsobu(OsobaModel model) { using (IDbConnection connection = new System.Data.SqlClient.SqlConnection(GlobalConfig.CnnString(db))) { var p = new DynamicParameters(); p.Add("@Ime", model.Ime); p.Add("@Prezime", model.Prezime); p.Add("@EmailAdresa", model.EmailAdresa); p.Add("@BrojMobitela", model.BrojMobitela); p.Add("@id", 0, dbType: DbType.Int32, direction: ParameterDirection.Output); connection.Execute("dbo.spPeople1_Insert", p, commandType: CommandType.StoredProcedure); model.ID = p.Get <int>("@id"); return(model); } }
public static List <OsobaModel> ConvertToOsobaModels(this List <string> lines) { List <OsobaModel> output = new List <OsobaModel>(); foreach (string line in lines) { string[] cols = line.Split(','); OsobaModel p = new OsobaModel(); p.ID = int.Parse(cols[0]); p.Ime = cols[1]; p.Prezime = cols[2]; p.EmailAdresa = cols[3]; p.BrojMobitela = cols[4]; output.Add(p); } return(output); }
private void btnIzradiIgrača_Click(object sender, EventArgs e) { if (ValidateForm()) { OsobaModel p = new OsobaModel(); p.Ime = textBox2.Text; p.Prezime = textBox3.Text; p.EmailAdresa = textBox4.Text; p.BrojMobitela = textBox5.Text; GlobalConfig.Connection.IzradiOsobu(p); textBox2.Text = ""; textBox3.Text = ""; textBox4.Text = ""; textBox5.Text = ""; } else { MessageBox.Show("Morate popuniti sva polja."); } }
private void Dodaj_clana_Click(object sender, EventArgs e) { if (ValidateForm()) { OsobaModel p = new OsobaModel(); p.FirstName = textBoxImeClana.Text; p.LastName = textBoxPrezimeClana.Text; p.CellphoneNumber = textBoxBrojTelClana.Text; p.EmailAdress = textBoxEmailClana.Text; GlobalConfig.Connection.CreatePerson(p); selectedTeamMembers.Add(p); WireUpList(); textBoxImeClana.Text = " "; textBoxPrezimeClana.Text = ""; textBoxBrojTelClana.Text = ""; textBoxEmailClana.Text = ""; } else { MessageBox.Show("Moraš popuniti sva polja"); } }
public static OsobaModel Read1Osoba(string a) //return jedan objekt OsobaModel-a { var connectionString = ConfigurationManager.ConnectionStrings["Name"].ConnectionString; using (SqlConnection connection = new SqlConnection(connectionString)) { var model = new OsobaModel(); DataTable dt = new DataTable(); SqlDataAdapter adapter = null; adapter = new SqlDataAdapter("SELECT * FROM OSOBA WHERE oib = " + a + ";", connection); adapter.Fill(dt); DataRow row = dt.Rows[0]; model.id = int.Parse(row[0].ToString()); model.ime = row[1].ToString(); model.prezime = row[2].ToString(); model.oib = row[3].ToString(); return(model); } }
public void WriteOsoba(string ime, string prezime, string oib) { var model = new OsobaModel(); model.ime = ime; model.prezime = prezime; model.oib = oib; var connectionString = ConfigurationManager.ConnectionStrings["Name"].ConnectionString; using (SqlConnection connection = new SqlConnection(connectionString)) { SqlCommand cmd = new SqlCommand("INSERT INTO OSOBA ( ime, prezime, oib) VALUES ( @ime, @prezime, @oib)"); //treba dodati id možda /* * cmd.Parameters.Add("id", SqlDbType.Int); * cmd.Parameters["id"].Value = model.id ; */ cmd.Connection = connection; cmd.Parameters.Add("ime", SqlDbType.VarChar); cmd.Parameters["ime"].Value = model.ime; cmd.Parameters.Add("prezime", SqlDbType.VarChar); cmd.Parameters["prezime"].Value = model.prezime; cmd.Parameters.Add("oib", SqlDbType.NVarChar); cmd.Parameters["oib"].Value = model.oib; if (connection.State != ConnectionState.Open) { connection.Open(); } cmd.ExecuteNonQuery(); connection.Close(); } }
private void UpdateUserView(OsobaModel selectedUser) { LoggedinLogicState.CurrentSelectedUser = selectedUser; SetMonth(); }