internal bool shtoFature(FatureShitje fsh)
{
bool isSuccess = false;
using (SqlConnection conn = Connection.GetConnection())
{
string query = @"INSERT INTO [dbo].[fature_shitje]
(
[Id],
[Id_koke_fature],
[Id_artikull],
[Sasia],
[Cmimi]
VALUES
(
@Id_koke_fature,
@Id_artikull,
@Sasia,
@Cmimi
)";
using (SqlCommand cmd = new SqlCommand(query, conn))
{
cmd.Parameters.AddWithValue("@Id_koke_fature", fsh.kokeFature.id);
cmd.Parameters.AddWithValue("@Id_artikull", fsh.a.id);
cmd.Parameters.AddWithValue("@Sasia", fsh.sasiaShitjes);
cmd.Parameters.AddWithValue("@Cmimi", fsh.a.cmimi);
conn.Open();
isSuccess = cmd.ExecuteNonQuery() > 0 ? true : false;
conn.Close();
}
}
return(isSuccess);
}
internal bool fshiFature(FatureShitje fature)
{
bool isSuccess = false;
using (SqlConnection conn = Connection.GetConnection())
{
string q = @"DELETE FROM [dbo].[fature_shitje] WHERE [Id] = @ID ";
using (SqlCommand cmd = new SqlCommand(q, conn))
{
cmd.Parameters.AddWithValue("@ID", fature.id);
conn.Open();
isSuccess = cmd.ExecuteNonQuery() > 0 ? true : false;
conn.Close();
}
}
return(isSuccess);
}
internal bool ndryshoFature(FatureShitje fsh)
{
bool isSuccess = false;
using (SqlConnection conn = Connection.GetConnection())
{
string query = @"UPDATE [dbo].[fature_shitje]
SET [Id_koke_fature] = @Id_koke_fature,
[Id_artikull] = @Id_artikull,
[Sasia] = @Sasia
WHERE Id = @Id";
using (SqlCommand cmd = new SqlCommand(query, conn))
{
cmd.Parameters.AddWithValue("@Id_koke_fature", fsh.kokeFature.id);
cmd.Parameters.AddWithValue("@Id_artikull", fsh.a.id);
cmd.Parameters.AddWithValue("@Sasia", fsh.sasiaShitjes);
conn.Open();
isSuccess = cmd.ExecuteNonQuery() > 0 ? true : false;
conn.Close();
}
return(isSuccess);
}
}
