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();
}
