public void GjejReferMeID(Referi referi)
{
try
{
SqlConnection sqlcon = new SqlConnection(_connectionString);
SqlDataAdapter sqlDataAdapter = new SqlDataAdapter("usp_Referat_GjejMeID", sqlcon);
sqlDataAdapter.SelectCommand.CommandType = System.Data.CommandType.StoredProcedure;
sqlDataAdapter.SelectCommand.Parameters.AddWithValue("@ReferatID", referi.ReferiID);
DataTable dtbl = new DataTable();
sqlDataAdapter.Fill(dtbl);
sqlDataAdapter.Dispose();
sqlcon.Close();
referi.Emri = dtbl.Rows[0]["Emri"].ToString();
referi.Mbiemri = dtbl.Rows[0]["Mbiemri"].ToString();
referi.EmriIPerdoruesit = dtbl.Rows[0]["EmriIPerdoruesit"].ToString();
referi.Fjalkalimi = dtbl.Rows[0]["Fjalekalimi"].ToString();
referi.Specializimi = dtbl.Rows[0]["Specializimi"].ToString();
referi.Titulli = dtbl.Rows[0]["Titulli"].ToString();
referi.Gjinia = dtbl.Rows[0]["Gjinia"].ToString();
referi.Ditelindja = DateTime.Parse(dtbl.Rows[0]["Ditelindja"].ToString());
referi.Vendlindja = dtbl.Rows[0]["Vendlindja"].ToString();
referi.Shteti = dtbl.Rows[0]["Shteti"].ToString();
referi.Vendbanimi = dtbl.Rows[0]["Vendbanimi"].ToString();
referi.Telefoni = dtbl.Rows[0]["Telefoni"].ToString();
referi.Mail = dtbl.Rows[0]["Email"].ToString();
referi.Pozita = dtbl.Rows[0]["Pozita"].ToString();
}
catch (Exception ex)
{
throw ex;
}
}
private void button1_Click(object sender, EventArgs e)
{
if (txtEmri.Text == "" || txtMbiemri.Text == "" || txtEmriPerdoruesit.Text == "" || txtFjalkalimi.Text == "" || txtSpecializimi.Text == "" || txtTitulli.Text == "" ||
txtGjinia.Text == "" || txtDitelindja.Text == "" || txtVendlindja.Text == "" || txtShteti.Text == "" || txtVendbanimi.Text == "" || txtTelefoni.Text == "" ||
txtEmail.Text == "" || txtPozita.Text == "")
{
MessageBox.Show("Plotesoni te gjitha fushat");
}
else
{
Referi referi = new Referi();
referi.Emri = txtEmri.Text.Trim();
referi.Mbiemri = txtMbiemri.Text.Trim();
referi.EmriIPerdoruesit = txtEmriPerdoruesit.Text.Trim();
referi.Fjalkalimi = txtFjalkalimi.Text.Trim();
referi.Specializimi = txtSpecializimi.Text.Trim();
referi.Titulli = txtTitulli.Text.Trim();
referi.Gjinia = txtGjinia.Text.Trim();
referi.Ditelindja = DateTime.Parse(txtDitelindja.Text.Trim());
referi.Vendlindja = txtVendlindja.Text.Trim();
referi.Shteti = txtShteti.Text.Trim();
referi.Vendbanimi = txtVendbanimi.Text.Trim();
referi.Telefoni = txtTelefoni.Text.Trim();
referi.Mail = txtEmail.Text.Trim();
referi.Pozita = txtPozita.Text.Trim();
ReferiBLL del = new ReferiBLL();
del.Regjistro(referi);
txtEmri.Text = txtMbiemri.Text = txtEmriPerdoruesit.Text = txtFjalkalimi.Text = txtSpecializimi.Text = txtTitulli.Text = txtGjinia.Text =
txtVendlindja.Text = txtShteti.Text = txtVendbanimi.Text = txtTelefoni.Text = txtEmail.Text = txtPozita.Text = "";
MessageBox.Show("U regjistrua me sukses");
}
}
public Game(Team team1, Team team2, Referi referi)
{
FirstTeam = team1;
SecondTeam = team2;
Referi = referi;
FailHandler += referi.Fail;
GoalHandler += referi.Goal;
AdditionalHandler += referi.Additional;
}
public void Regjistro(Referi g)
{
try
{
ReferiDAL dal = new ReferiDAL();
dal.Shto(g);
}
catch (Exception ex)
{
throw ex;
}
}
//public DataTable ShfaqListenEGolaShenuesve()
//{
// try
// {
// ReferiDAL dal = new ReferiDAL();
// var r = dal.();
// return r;
// }
// catch (Exception ex)
// {
// throw ex;
// }
//}
public void Edito(Referi g)
{
try
{
ReferiDAL dal = new ReferiDAL();
dal.Edito(g);
}
catch (Exception)
{
throw;
}
}
//public int Fshij(Referi g)
//{
// try
// {
// ReferiDAL dal = new ReferiDAL();
// dal.(g);
// int rowsAffected = g.;
// return rowsAffected;
// }
// catch (Exception ex)
// {
// throw ex;
// }
//}
public int GjejReferMeID(Referi g)
{
try
{
ReferiDAL dal = new ReferiDAL();
dal.GjejReferMeID(g);
int rowsAffected = g.ReferiID;
return(rowsAffected);
}
catch (Exception ex)
{
throw ex;
}
}
public void Edito(Referi referi)
{
try
{
SqlConnection sqlcon = new SqlConnection(_connectionString);
sqlcon.Open();
SqlCommand command = new SqlCommand("usp_Referat_ShtooseEdito", sqlcon);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@Emri", referi.Emri);
command.Parameters.AddWithValue("@Mbiemri", referi.Mbiemri);
command.Parameters.AddWithValue("@EmriIPerdoruesit", referi.EmriIPerdoruesit);
command.Parameters.AddWithValue("@Fjalekalimi", referi.Fjalkalimi);
command.Parameters.AddWithValue("@Specializimi", referi.Specializimi);
command.Parameters.AddWithValue("@Titulli", referi.Titulli);
command.Parameters.AddWithValue("@Gjinia", referi.Gjinia);
command.Parameters.AddWithValue("@Ditelindja", referi.Ditelindja);
command.Parameters.AddWithValue("@Vendlindja", referi.Vendlindja);
command.Parameters.AddWithValue("@Shteti", referi.Shteti);
command.Parameters.AddWithValue("@Vendbanimi", referi.Vendbanimi);
command.Parameters.AddWithValue("@Telefoni", referi.Telefoni);
command.Parameters.AddWithValue("@Email", referi.Mail);
command.Parameters.AddWithValue("@InsertBy", 1);
command.Parameters.AddWithValue("@InsertDate", "06/05/2020");
command.Parameters.AddWithValue("@LUB", 1);
command.Parameters.AddWithValue("@LUD", "06/05/2020");
command.Parameters.AddWithValue("@LUN", 1);
command.Parameters.AddWithValue("@RoliID", 4);
command.Parameters.AddWithValue("@PersoneliID", referi.ReferiID);
command.Parameters.AddWithValue("@Pozita", referi.Pozita);
command.Parameters.AddWithValue("@NdeshjaID", 1);
command.ExecuteNonQuery();
command.Dispose();
sqlcon.Close();
sqlcon.Dispose();
}
catch (Exception ex)
{
throw ex;
}
}
private void button2_Click(object sender, EventArgs e)
{
Referi referi = new Referi();
referi.ReferiID = int.Parse(txtKerko.Text.Trim());
ReferiBLL gjejRefer = new ReferiBLL();
gjejRefer.GjejReferMeID(referi);
txtEmri.Text = referi.Emri;
txtMbiemri.Text = referi.Mbiemri;
txtEmriPerdoruesit.Text = referi.EmriIPerdoruesit;
txtFjalkalimi.Text = referi.Fjalkalimi;
txtSpecializimi.Text = referi.Specializimi;
txtTitulli.Text = referi.Titulli;
txtGjinia.Text = referi.Gjinia;
txtDitelindja.Text = referi.Ditelindja.ToString();
txtVendlindja.Text = referi.Vendlindja.ToString();
txtShteti.Text = referi.Shteti;
txtVendbanimi.Text = referi.Vendbanimi;
txtTelefoni.Text = referi.Telefoni.ToString();
txtEmail.Text = referi.Mail;
txtPozita.Text = referi.Pozita;
panel2.Visible = false;
}
static void Main(string[] args)
{
Random random = new Random();
Team team1 = new Team("Шахтер", new Coach("Виталий", random.Next(5, 16) / 10.0));
Team team2 = new Team("Днепр", new Coach("Славик", random.Next(5, 16) / 10.0));
Referi.Preferences preferences = Referi.Preferences.Neutral;
switch (random.Next(0, 3))
{
case 1: preferences = Referi.Preferences.ForFirst;
break;
case 2:
preferences = Referi.Preferences.ForSecond;
break;
}
Referi referi = new Referi("Богдан", preferences);
Console.WriteLine("Первая команда:" + team1.Name);
team1.Coach.GetInfo();
for (int i = 1; i <= 11; i++)
{
team1.Add(new Soccer("Игрок" + i.ToString(), random.Next(20, 40), random.Next(0, 101)));
team1.Soccers.Last().GetInfo();
}
Console.WriteLine("Мастерство:" + team1.Skill);
Console.WriteLine();
Console.WriteLine("Вторая команда:" + team2.Name);
team2.Coach.GetInfo();
for (int i = 1; i <= 11; i++)
{
team2.Add(new Soccer("Игрок" + i.ToString(), random.Next(20, 40), random.Next(0, 101)));
team2.Soccers.Last().GetInfo();
}
Console.WriteLine("Мастерство:" + team2.Skill);
Console.WriteLine();
Game game = new Game(team1, team2, referi);
game.Referi.GetInfo();
Console.WriteLine();
Console.WriteLine("История:");
Game.GetGames();
Console.WriteLine();
Console.WriteLine("Сортировка по алфавиту команды " + team1.Name);
foreach (var i in team1.GetByName())
{
i.GetInfo();
}
Console.WriteLine();
Console.WriteLine("Сортировка по алфавиту команды " + team2.Name);
foreach (var i in team2.GetByName())
{
i.GetInfo();
}
Console.WriteLine();
Console.WriteLine("Сортировка по мастерству команды " + team1.Name);
foreach (var i in team1.GetBySkill())
{
i.GetInfo();
}
Console.WriteLine();
Console.WriteLine("Сортировка по мастерству команды " + team2.Name);
foreach (var i in team2.GetBySkill())
{
i.GetInfo();
}
Console.WriteLine();
game.Start();
Console.ReadKey();
}
