public void modifiko(Dispecher dis) { using (SqlConnection conn = new SqlConnection(connectionString)) { SqlCommand cmd = new SqlCommand("update Dispecher set PerdoruesiDispecheri = '" + dis.perdoruesi + "', EmriDispecheri = '" + dis.emri + "', PasswordDispecheri = '" + dis.password + "' where Id_dispecheri = @Id", conn); cmd.Parameters.Add("@Id", System.Data.SqlDbType.BigInt); cmd.Parameters["@Id"].Value = dis.id; conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); } }
public void shto(Dispecher dis) { using (SqlConnection conn = new SqlConnection(connectionString)) { SqlCommand cmd = new SqlCommand("insert into Dispecher (PerdoruesiDispecheri,EmriDispecheri,PasswordDispecheri) values (@perd,@emri,@pass)", conn); cmd.Parameters.Add("@perd", System.Data.SqlDbType.VarChar); cmd.Parameters["@perd"].Value = dis.perdoruesi; cmd.Parameters.Add("@emri", System.Data.SqlDbType.VarChar); cmd.Parameters["@emri"].Value = dis.emri; cmd.Parameters.Add("@pass", System.Data.SqlDbType.VarChar); cmd.Parameters["@pass"].Value = dis.password; conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); } }