public int Update(Vlersimet model)
{
try
{
SqlConnection connection = new SqlConnection(_connectionString);
connection.Open();
SqlCommand command = new SqlCommand("[dbo].[usp_Vlersimet_ShtooseEdito]", connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@StatusiID", model.StatusiID);
command.Parameters.AddWithValue("@LojtariID", model.lojtariID);
command.Parameters.AddWithValue("@Vlersimi", model.Vlersimi);
command.Parameters.AddWithValue("@InsertBy", 1);
command.Parameters.AddWithValue("InsertDate", "01/01/1999");
command.Parameters.AddWithValue("LUB", 1);
command.Parameters.AddWithValue("LUD", "01/01/1999");
command.Parameters.AddWithValue("LUN", 1);
int rowAffected = command.ExecuteNonQuery();
command.Dispose();
connection.Close();
connection.Dispose();
return(rowAffected);
}
catch (Exception e)
{
return(-1);
}
}
private void btnKerko_Click(object sender, EventArgs e)
{
Vlersimet vler = new Vlersimet();
vler.StatusiID = int.Parse(txtKerko.Text.Trim());
VlersimetBLL bll = new VlersimetBLL();
bll.GjejVlersiminMeID(vler);
cmbSelektoLojtarin.Text = vler.lojtariID.ToString();
txtVlersimi.Text = vler.Vlersimi.ToString();
panel2.Visible = true;
}
public void Edito(Vlersimet g)
{
try
{
VlersimetDAL dal = new VlersimetDAL();
dal.Update(g);
}
catch (Exception)
{
throw;
}
}
public void Regjistro(Vlersimet g)
{
try
{
VlersimetDAL dal = new VlersimetDAL();
dal.Shto(g);
}
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)
{
Vlersimet vler = new Vlersimet();
vler.StatusiID = int.Parse(txtKerko.Text.Trim());
VlersimetBLL bll = new VlersimetBLL();
bll.Fshij(vler);
// cmbSelektoLojtarin.Text = txtVlersimi.Text = "";
}
}
public int GjejVlersiminMeID(Vlersimet g)
{
try
{
VlersimetDAL dal = new VlersimetDAL();
dal.MerrVlersimeMeID(g);
int rowsAffected = g.StatusiID;
return(rowsAffected);
}
catch (Exception ex)
{
throw ex;
}
}
public int Fshij(Vlersimet g)
{
try
{
VlersimetDAL dal = new VlersimetDAL();
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 editoni", "Kujdes", MessageBoxButtons.YesNo);
if (rez == DialogResult.Yes)
{
var lojtari = cmbSelektoLojtarin.SelectedValue.ToString();
Vlersimet vlersimet = new Vlersimet();
vlersimet.StatusiID = int.Parse(txtKerko.Text.Trim());
vlersimet.lojtariID = int.Parse(lojtari);
vlersimet.Vlersimi = decimal.Parse(txtVlersimi.Text.Trim());
VlersimetBLL vlersimetBLL = new VlersimetBLL();
vlersimetBLL.Edito(vlersimet);
cmbSelektoLojtarin.Text = txtVlersimi.Text = "";
}
}
private void button1_Click(object sender, EventArgs e)
{
if (txtVlersimi.Text == " ")
{
MessageBox.Show("Plotesoni te gjitha fushat");
}
else
{
var lojtari = cmbSelektoLojtarin.SelectedValue.ToString();
Vlersimet vlersimet = new Vlersimet();
vlersimet.lojtariID = int.Parse(lojtari);
vlersimet.Vlersimi = decimal.Parse(txtVlersimi.Text);
VlersimetBLL bll = new VlersimetBLL();
bll.Regjistro(vlersimet);
cmbSelektoLojtarin.Text = txtVlersimi.Text = "";
MessageBox.Show("u regjistrua me sukses");
}
}
public void MerrVlersimeMeID(Vlersimet v)
{
SqlConnection sqlcon = new SqlConnection(_connectionString);
sqlcon.Open();
SqlDataAdapter sqlDataAdapter = new SqlDataAdapter("usp_Vlersimet_MerrVlersimetMeID", sqlcon);
sqlDataAdapter.SelectCommand.CommandType = CommandType.StoredProcedure;
sqlDataAdapter.SelectCommand.Parameters.AddWithValue("@StatusiID", v.StatusiID);
DataTable dataTable = new DataTable();
sqlDataAdapter.Fill(dataTable);
sqlDataAdapter.Dispose();
sqlcon.Close();
v.lojtariID = int.Parse(dataTable.Rows[0]["LojtariID"].ToString());
v.Vlersimi = decimal.Parse(dataTable.Rows[0]["Vleresimi"].ToString());
}
// public string _connectionString = ConfigurationManager.ConnectionStrings["Gjeneta"].ConnectionString;
public int Fshij(Vlersimet model)
{
try
{
SqlConnection connection = new SqlConnection(_connectionString);
connection.Open();
SqlCommand command = new SqlCommand("usp_Vlersimet_FshijVlersimetMeID", connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@StatusiID", model.StatusiID);
int result = command.ExecuteNonQuery();
command.Dispose();
connection.Close();
connection.Dispose();
return(result);
}
catch (Exception e)
{
return(-1);
}
}
