public void modifiko(ShoferiDetyrim shofer) { using (SqlConnection conn = new SqlConnection(connectionString)) { SqlCommand cmd = new SqlCommand("update Shoferet set Detyrimi = " + (shofer.detyrimi - shofer.dorezuar).ToString() + " where Id_shoferi = @Id", conn); cmd.Parameters.Add("@Id", System.Data.SqlDbType.BigInt); cmd.Parameters["@Id"].Value = shofer.id; conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); } }
public List <ShoferiDetyrim> Shoferet(Int64 idKlienti) { //gjen listen e shofereve qe i perkasin agjensise List <ShoferiDetyrim> shof = new List <ShoferiDetyrim>(); using (SqlConnection conn = new SqlConnection(connectionString)) { SqlCommand cmd = new SqlCommand("SELECT Id_shoferi,EmriShoferi,MbiemriShoferi,Detyrimi FROM Shoferet where Id_klienti = " + idKlienti + " And Shoferet.Aktiv = 'True" + "'", conn); conn.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { ShoferiDetyrim s = new ShoferiDetyrim(); s.id = Convert.ToInt64(reader["Id_shoferi"].ToString()); s.detyrimi = Convert.ToDecimal(reader["Detyrimi"].ToString()); s.emri = reader["EmriShoferi"].ToString() + " " + reader["MbiemriShoferi"].ToString(); shof.Add(s); } return(shof); } }