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();
}
}
