Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public void SacuvajAsisUBazu()
- {
- using (SqlConnection conn = new SqlConnection(Data.CONNECTION_STRING))
- {
- conn.Open();
- SqlCommand command = conn.CreateCommand();
- command.CommandText = @"insert into Asistent(Ime, KorisnickoIme, Prezime, TipZaposlenog,Lozinka,Email,Profesor, Active) values
- (@Ime, @KorisnickoIme,@Prezime, @TipZaposlenog, @Lozinka, @Email, @Profesor, @Active)";
- command.Parameters.Add(new SqlParameter("Ime", this.Ime));
- command.Parameters.Add(new SqlParameter("KorisnickoIme", this.KorisnickoIme));
- command.Parameters.Add(new SqlParameter("Prezime", this.Prezime));
- command.Parameters.Add(new SqlParameter("TipZaposlenog", this.TipZaposlenog));
- command.Parameters.Add(new SqlParameter("Lozinka", this.Lozinka));
- command.Parameters.Add(new SqlParameter("Email", this.Email));
- command.Parameters.Add(new SqlParameter("Profesor", this.Prof.KorisnickoIme));
- command.Parameters.Add(new SqlParameter("Active", this.Active));
- command.ExecuteScalar();
- }
- }
- public void UpdateAsis()
- {
- using (SqlConnection conn = new SqlConnection(Data.CONNECTION_STRING))
- {
- conn.Open();
- SqlCommand command = conn.CreateCommand();
- command.CommandText = @"update Asistent set Ime =@Ime, Prezime =@Prezime,Lozinka =@Lozinka, Email =@Email, Profesor =@Profesor, Active =@Active
- where KorisnickoIme = @KorisnickoIme";
- command.Parameters.Add(new SqlParameter("Ime", this.Ime));
- command.Parameters.Add(new SqlParameter("Prezime", this.Prezime));
- command.Parameters.Add(new SqlParameter("Lozinka", this.Lozinka));
- command.Parameters.Add(new SqlParameter("Email", this.Email));
- command.Parameters.Add(new SqlParameter("Active", this.Active));
- command.Parameters.Add(new SqlParameter("Profesor", this.Prof.KorisnickoIme));
- command.Parameters.Add(new SqlParameter("KorisnickoIme", this.KorisnickoIme));
- command.ExecuteNonQuery();
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement