public void shto(Shoferi shof) { using (SqlConnection conn = new SqlConnection(connectionString)) { SqlCommand cmd = new SqlCommand("insert into Shoferet (UserId,EmriShoferi,MbiemriShoferi,Password,Aktiv,Id_dispecher,Detyrimi,Id_klienti) values (@perd,@emri,@mbiemri,@pass,@aktiv,@iddispecher,@detyrimi,@idklienti)", conn); cmd.Parameters.Add("@perd", System.Data.SqlDbType.VarChar); cmd.Parameters["@perd"].Value = shof.perdoruesi; cmd.Parameters.Add("@emri", System.Data.SqlDbType.VarChar); cmd.Parameters["@emri"].Value = shof.emri; cmd.Parameters.Add("@mbiemri", System.Data.SqlDbType.VarChar); cmd.Parameters["@mbiemri"].Value = shof.mbiemri; cmd.Parameters.Add("@pass", System.Data.SqlDbType.VarChar); cmd.Parameters["@pass"].Value = shof.password; cmd.Parameters.Add("@aktiv", System.Data.SqlDbType.Bit); cmd.Parameters["@aktiv"].Value = true; cmd.Parameters.Add("@iddispecher", System.Data.SqlDbType.BigInt); cmd.Parameters["@iddispecher"].Value = shof.IdDispecher; cmd.Parameters.Add("@detyrimi", System.Data.SqlDbType.Decimal); cmd.Parameters["@detyrimi"].Value = 0; cmd.Parameters.Add("@idklienti", System.Data.SqlDbType.BigInt); cmd.Parameters["@idklienti"].Value = shof.IdKlienti; conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); } }
public void modifiko(Shoferi shofer) { using (SqlConnection conn = new SqlConnection(connectionString)) { SqlCommand cmd = new SqlCommand("update Shoferet set UserId = '" + shofer.perdoruesi + "', EmriShoferi = '" + shofer.emri + "', MbiemriShoferi = '" + shofer.mbiemri + "', Password = '******', Aktiv = '" + shofer.aktiv + "',Detyrimi = " + shofer.Detyrimi + ", Id_dispecher = " + shofer.IdDispecher + ", Id_klienti = " + shofer.IdKlienti + " 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 <Shoferi> Shoferet(Int64 idKlienti) { //gjen listen e shofereve qe i perkasin agjensise List <Shoferi> shof = new List <Shoferi>(); using (SqlConnection conn = new SqlConnection(connectionString)) { SqlCommand cmd = new SqlCommand("SELECT Id_shoferi,EmriShoferi,MbiemriShoferi FROM Shoferet where Id_klienti = " + idKlienti + " And Shoferet.Aktiv = 'True" + "'", conn); conn.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { Shoferi s = new Shoferi(); s.id = Convert.ToInt64(reader["Id_shoferi"].ToString()); s.emri = reader["EmriShoferi"].ToString() + " " + reader["MbiemriShoferi"].ToString(); shof.Add(s); } return(shof); } }