public int Update(Raporti ndeshjaModel)
{
try
{
SqlConnection sqlcon = new SqlConnection(_connectionString);
sqlcon.Open();
SqlCommand command = new SqlCommand("usp_Raporte_ShtoOseEditoRaport", sqlcon);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@NdeshjaID", ndeshjaModel.NdeshjaID);
command.Parameters.AddWithValue("@DataENdeshjes", ndeshjaModel.dataNdeshjes);
command.Parameters.AddWithValue("@Sezoni", ndeshjaModel.Sezoni);
command.Parameters.AddWithValue("@RaportiIAmbulances", ndeshjaModel.RaportiAmbulances);
command.Parameters.AddWithValue("@RaportiIPolicis", ndeshjaModel.RaportiPolicor);
command.Parameters.AddWithValue("@Raporti", ndeshjaModel.Raportii);
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("@KlubiVendasID", 1);
command.Parameters.AddWithValue("@KlubiNikoqirID", 2);
command.Parameters.AddWithValue("@FormacioniID", 1);
command.Parameters.AddWithValue("@StadiumiID", 2);
int rowAffected = command.ExecuteNonQuery();
command.Dispose();
sqlcon.Close();
sqlcon.Dispose();
return(rowAffected);
}
catch (Exception e)
{
return(-1);
}
}
public void Regjistro(Raporti g)
{
try
{
RaportiDAL dal = new RaportiDAL();
dal.Shto(g);
}
catch (Exception ex)
{
throw ex;
}
}
public void Edito(Raporti g)
{
try
{
RaportiDAL dal = new RaportiDAL();
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)
{
Raporti raporti = new Raporti();
raporti.NdeshjaID = int.Parse(txtGjejMeid.Text.Trim());
RaportiBLL raportibll = new RaportiBLL();
raportibll.Fshij(raporti);
txtGjejMeid.Text = "";
}
}
public int GjejRaportMeID(Raporti g)
{
try
{
RaportiDAL dal = new RaportiDAL();
dal.MerrNdeshjeMeID(g);
int rowsAffected = g.NdeshjaID;
return(rowsAffected);
}
catch (Exception ex)
{
throw ex;
}
}
public int Fshij(Raporti g)
{
try
{
RaportiDAL dal = new RaportiDAL();
dal.Fshij(g);
int rowsAffected = g.NdeshjaID;
return(rowsAffected);
}
catch (Exception ex)
{
throw ex;
}
}
private void button2_Click(object sender, EventArgs e)
{
Raporti raporti = new Raporti();
raporti.NdeshjaID = int.Parse(txtGjejMeid.Text.Trim());
RaportiBLL dali = new RaportiBLL();
dali.GjejRaportMeID(raporti);
dtpDataNdeshjes.Text = raporti.dataNdeshjes.ToString();
txtSezoni.Text = raporti.Sezoni;
rtbRaportiAmbullances.Text = raporti.RaportiAmbulances;
rtbRaportiPolicor.Text = raporti.RaportiPolicor;
rtbRaporti.Text = raporti.Raportii;
panel2.Visible = true;
}
private void button1_Click(object sender, EventArgs e)
{
var rez = MessageBox.Show("A jeni te sigurt qe deshironi te editoni", "Kujdes", MessageBoxButtons.YesNo);
if (rez == DialogResult.Yes)
{
Raporti raporti = new Raporti();
raporti.dataNdeshjes = DateTime.Parse(dtpDataNdeshjes.Text.Trim());
raporti.Sezoni = txtSezoni.Text.Trim();
raporti.RaportiAmbulances = rtbRaportiAmbullances.Text.Trim();
raporti.RaportiPolicor = rtbRaportiPolicor.Text.Trim();
raporti.Raportii = rtbRaporti.Text.Trim();
raporti.NdeshjaID = int.Parse(txtGjejMeid.Text);
RaportiBLL raportibll = new RaportiBLL();
raportibll.Edito(raporti);
dtpDataNdeshjes.Text = txtSezoni.Text = rtbRaportiAmbullances.Text = rtbRaportiPolicor.Text = rtbRaporti.Text = "";
}
}
private void button1_Click(object sender, EventArgs e)
{
if (dtpDataNdeshjes.Text == "" || txtSezoni.Text == " " || rtbRaportiAmbullances.Text == "" || rtbRaportiPolicor.Text == "" || rtbRaporti.Text == "")
{
MessageBox.Show("Plotesoni te gjitha fushat");
}
else
{
Raporti raporti = new Raporti();
raporti.dataNdeshjes = DateTime.Parse(dtpDataNdeshjes.Text.Trim());
raporti.Sezoni = txtSezoni.Text.Trim();
raporti.RaportiAmbulances = rtbRaportiAmbullances.Text.Trim();
raporti.RaportiPolicor = rtbRaportiPolicor.Text.Trim();
raporti.Raportii = rtbRaporti.Text.Trim();
RaportiBLL raportibll = new RaportiBLL();
raportibll.Regjistro(raporti);
dtpDataNdeshjes.Text = txtSezoni.Text = rtbRaportiAmbullances.Text = rtbRaportiPolicor.Text = rtbRaporti.Text = "";
MessageBox.Show("U regjistrua me sukses");
}
}
// public string _connectionString = ConfigurationManager.ConnectionStrings["Gjeneta"].ConnectionString;
public int Fshij(Raporti model)
{
try
{
SqlConnection sqlcon = new SqlConnection(_connectionString);
sqlcon.Open();
SqlCommand command = new SqlCommand("[dbo].[usp_Raport_FshijRaportMeID]", sqlcon);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@RaportID", model.NdeshjaID);
int result = command.ExecuteNonQuery();
command.Dispose();
sqlcon.Close();
sqlcon.Dispose();
return(result);
}
catch (Exception e)
{
return(-1);
}
}
public void MerrNdeshjeMeID(Raporti ndeshja)
{
try
{
SqlConnection sqlcon = new SqlConnection(_connectionString);
sqlcon.Open();
SqlDataAdapter sqlda = new SqlDataAdapter("usp_Raport_GjejRaportMeID", sqlcon);
sqlda.SelectCommand.CommandType = CommandType.StoredProcedure;
sqlda.SelectCommand.Parameters.AddWithValue("@RaportID", ndeshja.NdeshjaID);
DataTable dt = new DataTable();
sqlda.Fill(dt);
sqlda.Dispose();
sqlcon.Close();
ndeshja.dataNdeshjes = DateTime.Parse(dt.Rows[0]["DataENdeshjes"].ToString());
ndeshja.Sezoni = dt.Rows[0]["Sezoni"].ToString();
ndeshja.RaportiAmbulances = dt.Rows[0]["RaportiIAmbulances"].ToString();
ndeshja.RaportiPolicor = dt.Rows[0]["RaportiIPolicise"].ToString();
}
catch (Exception ex)
{
throw ex;
}
}
