public int Update(StatusiLojtarit model)//,Lojtari lojtari)
{
try
{
SqlConnection sqlcon = new SqlConnection(_connectionString);
sqlcon.Open();
SqlCommand command = new SqlCommand("usp_Formacioni_ShtooseEditoFormacion", sqlcon);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("Pergjegjes", model.Pergjegjes);
command.Parameters.AddWithValue("Rezerve", model.Rezerv);
command.Parameters.AddWithValue("Huazim", model.Huazim);
command.Parameters.AddWithValue("Shoqerues", model.Shoqerues);
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("StatusiID", model.StatusiID);
command.Parameters.AddWithValue("LojtariID", model.Lojtariid);
command.Parameters.AddWithValue("FormacioniID", 1);
int rowAffected = command.ExecuteNonQuery();
command.Dispose();
sqlcon.Close();
sqlcon.Dispose();
return(rowAffected);
}
catch (Exception e)
{
return(-1);
}
}
public void Regjistro(StatusiLojtarit g)
{
try
{
StatusiLojtaritDAL dal = new StatusiLojtaritDAL();
dal.Shto(g);
}
catch (Exception ex)
{
throw ex;
}
}
public void Edito(StatusiLojtarit g)
{
try
{
StatusiLojtaritDAL dal = new StatusiLojtaritDAL();
dal.Update(g);
}
catch (Exception)
{
throw;
}
}
public int GjejStatusinELojtaritMeID(StatusiLojtarit g)
{
try
{
StatusiLojtaritDAL dal = new StatusiLojtaritDAL();
dal.MerriMeIdFormacion(g);
int rowsAffected = g.StatusiID;
return(rowsAffected);
}
catch (Exception ex)
{
throw ex;
}
}
public int Fshij(StatusiLojtarit g)
{
try
{
StatusiLojtaritDAL dal = new StatusiLojtaritDAL();
dal.Fshij(g);
int rowsAffected = g.StatusiID;
return(rowsAffected);
}
catch (Exception ex)
{
throw ex;
}
}
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)
{
StatusiLojtarit statusiLojtarit = new StatusiLojtarit();
statusiLojtarit.StatusiID = int.Parse(txtGjejMeIDFormacion.Text.Trim());
StatusiLojtaritBLL statusiLojtaritDAL = new StatusiLojtaritBLL();
statusiLojtaritDAL.Fshij(statusiLojtarit);
txtGjejMeIDFormacion.Text = "";
}
}
private void button2_Click(object sender, EventArgs e)
{
StatusiLojtarit statusiLojtarit = new StatusiLojtarit();
statusiLojtarit.StatusiID = int.Parse(txtGjejMeIDFormacion.Text.Trim());
StatusiLojtaritBLL statusiLojtarit1 = new StatusiLojtaritBLL();
statusiLojtarit1.GjejStatusinELojtaritMeID(statusiLojtarit);
txtPergjegjes.Text = statusiLojtarit.Pergjegjes;
txtRezerve.Text = statusiLojtarit.Rezerv;
txtHuazim.Text = statusiLojtarit.Huazim;
txtShoqerues.Text = statusiLojtarit.Shoqerues;
panel2.Visible = true;
}
// public string _connectionString = ConfigurationManager.ConnectionStrings["Gjeneta"].ConnectionString;
public int Fshij(StatusiLojtarit model)
{
try
{
SqlConnection sqlcon = new SqlConnection(_connectionString);
sqlcon.Open();
SqlCommand command = new SqlCommand("[dbo].[usp_Formacioni_FshijMeIDFormacion]", sqlcon);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("StatusiID", model.StatusiID);
int result = command.ExecuteNonQuery();
command.Dispose();
sqlcon.Close();
sqlcon.Dispose();
return(result);
}
catch (Exception e)
{
return(-1);
}
}
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)
{
var der2 = comboBox1.SelectedValue.ToString();
StatusiLojtarit statusiLojtarit = new StatusiLojtarit();
statusiLojtarit.Pergjegjes = txtPergjegjes.Text.Trim();
statusiLojtarit.Rezerv = txtRezerve.Text.Trim();
statusiLojtarit.Huazim = txtHuazim.Text.Trim();
statusiLojtarit.Shoqerues = txtShoqerues.Text.Trim();
statusiLojtarit.StatusiID = int.Parse(txtGjejMeIDFormacion.Text.Trim());
Lojtari lojtari = new Lojtari();
lojtari.LojtariID = int.Parse(der2);
StatusiLojtaritBLL statusiLojtaritDAL = new StatusiLojtaritBLL();
statusiLojtaritDAL.Edito(statusiLojtarit);
txtPergjegjes.Text = txtHuazim.Text = txtShoqerues.Text = comboBox1.Text = "";
}
}
public void MerriMeIdFormacion(StatusiLojtarit formacioni)
{
SqlConnection sqlcon = new SqlConnection(_connectionString);
sqlcon.Open();
SqlDataAdapter sqlDataAdapter = new SqlDataAdapter("[dbo].[usp_Formacioni_MerriFormacionID]", sqlcon);
sqlDataAdapter.SelectCommand.CommandType = CommandType.StoredProcedure;
sqlDataAdapter.SelectCommand.Parameters.AddWithValue("StatusiID", formacioni.StatusiID);
DataTable dataTable = new DataTable();
sqlDataAdapter.Fill(dataTable);
sqlDataAdapter.Dispose();
sqlcon.Close();
formacioni.Pergjegjes = dataTable.Rows[0]["Pergjegjes"].ToString();
formacioni.Rezerv = dataTable.Rows[0]["Rezerve"].ToString();
formacioni.Huazim = dataTable.Rows[0]["Huazim"].ToString();
formacioni.Shoqerues = dataTable.Rows[0]["Shoqerues"].ToString();
}
private void button1_Click(object sender, EventArgs e)
{
if (txtPergjegjes.Text == " ")
{
MessageBox.Show("Plotesoni te gjitha fushat");
}
else
{
var der2 = comboBox1.SelectedValue.ToString();
StatusiLojtarit statusiLojtarit = new StatusiLojtarit();
statusiLojtarit.Pergjegjes = txtPergjegjes.Text.Trim();
statusiLojtarit.Rezerv = txtRezerve.Text.Trim();
statusiLojtarit.Huazim = txtHuazim.Text.Trim();
statusiLojtarit.Shoqerues = txtShoqerues.Text.Trim();
statusiLojtarit.Lojtariid = int.Parse(der2);
StatusiLojtaritBLL statusiLojtaritDAL = new StatusiLojtaritBLL();
statusiLojtaritDAL.Regjistro(statusiLojtarit);
txtPergjegjes.Text = txtHuazim.Text = txtShoqerues.Text = comboBox1.Text = "";
MessageBox.Show("U regjistrua me sukses");
}
}
