internal bool shtoArtikull(Artikull a)
{
bool isSuccess = false;
using (SqlConnection conn = Connection.GetConnection())
{
string query = @"INSERT INTO [dbo].[artikull]
(
[Id],
[Artikulli],
[Sasia_mbetur],
[Cmimi],
[Id_kategori],
[Id_njesia],
[Status],
VALUES
(
@Artikulli,
@Sasia_mbetur,
@Cmimi,
@Id_kategori,
@Id_njesia,
@Status
)";
using (SqlCommand cmd = new SqlCommand(query, conn))
{
cmd.Parameters.AddWithValue("@Artikulli", a.artikull);
cmd.Parameters.AddWithValue("@Sasia_mbetur", a.sasia);
cmd.Parameters.AddWithValue("@Cmimi", a.cmimi);
cmd.Parameters.AddWithValue("@Id_kategori", a.kategori.id);
cmd.Parameters.AddWithValue("@Id_njesia", a.njesi.id);
cmd.Parameters.AddWithValue("@Status", a.status);
conn.Open();
isSuccess = cmd.ExecuteNonQuery() > 0 ? true : false;
conn.Close();
}
}
return(isSuccess);
}
internal bool ndryshoArtikull(Artikull a)
{
bool isSuccess = false;
using (SqlConnection conn = Connection.GetConnection())
{
string query = @"UPDATE [dbo].[artikull]
SET [Cmimi] = @Cmimi,
[Id_kategori] = @Id_kategori,
[Status] = @Status
WHERE Id = @Id";
using (SqlCommand cmd = new SqlCommand(query, conn))
{
cmd.Parameters.AddWithValue("@Cmimi", a.cmimi);
cmd.Parameters.AddWithValue("@Id_kategori", a.kategori.id);
cmd.Parameters.AddWithValue("@Status", a.status);
conn.Open();
isSuccess = cmd.ExecuteNonQuery() > 0 ? true : false;
conn.Close();
}
return(isSuccess);
}
}
public FatureShitje()
{
a = new Artikull();
kokeFature = new KokeFature();
}
public Furnizimi()
{
kokeFurnizimi = new KokeFurnizimi();
a = new Artikull();
}
