public int Update(Stadiumi stadiumi)
{
try
{
SqlConnection sqlcon = new SqlConnection(_connectionString);
sqlcon.Open();
SqlCommand command = new SqlCommand("[dbo].[usp_Stadiume_ShtoOseEditoStadiume]", sqlcon);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@Emertimi", stadiumi.Emertimi);
command.Parameters.AddWithValue("@Vendi", stadiumi.Vendi);
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("@StadiumeID", stadiumi.StadiumiID);
int rowAffected = command.ExecuteNonQuery();
command.Dispose();
sqlcon.Close();
sqlcon.Dispose();
return(rowAffected);
}
catch (Exception e)
{
return(-1);
}
}
private void btnKerko_Click(object sender, EventArgs e)
{
Stadiumi stadiumi = new Stadiumi();
stadiumi.StadiumiID = int.Parse(txtKerkoMeID.Text.Trim());
StadiumiBLL stadiumiBLL = new StadiumiBLL();
stadiumiBLL.GjejStadiuminMeID(stadiumi);
txtEmertimiStadiumit.Text = stadiumi.Emertimi;
txtVendiStadiumit.Text = stadiumi.Vendi;
}
public void Regjistro(Stadiumi g)
{
try
{
StadiumiDAL dal = new StadiumiDAL();
dal.Shto(g);
}
catch (Exception ex)
{
throw ex;
}
}
public void Edito(Stadiumi g)
{
try
{
StadiumiDAL dal = new StadiumiDAL();
dal.Update(g);
}
catch (Exception)
{
throw;
}
}
private void button1_Click(object sender, EventArgs e)
{
var rez = MessageBox.Show("A jeni te sigurt qe deshironi te fshij", "Kujdes", MessageBoxButtons.YesNo);
if (rez == DialogResult.Yes)
{
Stadiumi stadiumi = new Stadiumi();
stadiumi.StadiumiID = int.Parse(txtGjejStadiumMeID.Text.Trim());
StadiumiBLL stadiumiBLL = new StadiumiBLL();
stadiumiBLL.Fshij(stadiumi);
txtGjejStadiumMeID.Text = "";
}
}
public int GjejStadiuminMeID(Stadiumi g)
{
try
{
StadiumiDAL dal = new StadiumiDAL();
dal.GjejStadiumMeID(g);
int rowsAffected = g.StadiumiID;
return(rowsAffected);
}
catch (Exception ex)
{
throw ex;
}
}
public void GjejStadiumMeID(Stadiumi stadiumi)
{
SqlConnection sqlcon = new SqlConnection(_connectionString);
SqlDataAdapter sqlDataAdapter = new SqlDataAdapter("[dbo].[usp_Stadiume_GjejMeIDStadium]", sqlcon);
sqlDataAdapter.SelectCommand.CommandType = CommandType.StoredProcedure;
sqlDataAdapter.SelectCommand.Parameters.AddWithValue("@StadiumeID", stadiumi.StadiumiID);
DataTable dt = new DataTable();
sqlDataAdapter.Fill(dt);
sqlDataAdapter.Dispose();
sqlcon.Close();
stadiumi.Emertimi = dt.Rows[0]["Emertimi"].ToString();
stadiumi.Vendi = dt.Rows[0]["Vendi"].ToString();
}
private void btnEditoStadium_Click(object sender, EventArgs e)
{
var rez = MessageBox.Show("A jeni te sigurt qe deshironi te editoni", "Kujdes", MessageBoxButtons.YesNo);
if (rez == DialogResult.Yes)
{
Stadiumi stadiumi = new Stadiumi();
stadiumi.Emertimi = txtEmertimiStadiumit.Text.Trim();
stadiumi.Vendi = txtVendiStadiumit.Text.Trim();
stadiumi.StadiumiID = int.Parse(txtKerkoMeID.Text.Trim());
StadiumiBLL stadiumiBLL = new StadiumiBLL();
stadiumiBLL.Edito(stadiumi);
txtEmertimiStadiumit.Text = txtVendiStadiumit.Text = "";
}
}
private void btnRegjistroStadium_Click(object sender, EventArgs e)
{
if (txtEmertimiStadiumit.Text == " " || txtVendiStadiumit.Text == "")
{
MessageBox.Show("Plotesoni te gjitha fushat");
}
else
{
Stadiumi stadiumi = new Stadiumi();
stadiumi.Emertimi = txtEmertimiStadiumit.Text.Trim();
stadiumi.Vendi = txtVendiStadiumit.Text.Trim();
StadiumiBLL stadiumibll = new StadiumiBLL();
stadiumibll.Regjistro(stadiumi);
txtEmertimiStadiumit.Text = txtVendiStadiumit.Text = "";
MessageBox.Show("U regjistrua me sukses");
}
}
public int FshijMeID(Stadiumi stadiumi)
{
try
{
SqlConnection sqlcon = new SqlConnection(_connectionString);
sqlcon.Open();
SqlCommand sqc = new SqlCommand("[dbo].[usp_Stadiume_FshijStadiumMeID]", sqlcon);
sqc.CommandType = CommandType.StoredProcedure;
sqc.Parameters.AddWithValue("@Stadiumi", stadiumi.StadiumiID);
int result = sqc.ExecuteNonQuery();
sqc.Dispose();
sqlcon.Close();
sqlcon.Dispose();
return(result);
}
catch (Exception e)
{
return(-1);
}
}
