void AddParametersToCommand(EczaciEntities eczaci) { cmd.Parameters.AddWithValue("@ad", eczaci.Adi); cmd.Parameters.AddWithValue("@soyad", eczaci.Soyadi); cmd.Parameters.AddWithValue("@kAdi", eczaci.KullaniciAdi); cmd.Parameters.AddWithValue("@sifre", eczaci.Sifre); }
public int Update(EczaciEntities eczaci) { cmd = new SqlCommand("update Eczacilar SET Adi=@ad,Soyadi=@soyad,,KullaniciAdi=@kAdi,Sifre=@sifre where EczaciID=@eczaciID", conn); AddParametersToCommand(eczaci); cmd.Parameters.AddWithValue("@eczaciID", eczaci.EczaciID); return(ExecuteCommand()); }
public EczaciFrm(int eczaciID) { InitializeComponent(); _receteController = new ReceteController(); receteIlaclari = new List <ReceteIlaclariDTO>(); hastaReceteleri = new List <HastayaGoreReceteDTO>(); eczaciController = new EczaciController(); eczaci = new EczaciEntities(); eczaci = eczaciController.GetEczaci(eczaciID); labelEczaci.Text = "Eczaci " + eczaci.Adi + " " + eczaci.Soyadi; }
public EczaciEntities GetEczaciById(int eczaciID) { EczaciEntities currentEczaci = new EczaciEntities(); cmd = new SqlCommand("Select * From Eczacilar Where EczaciID = @id", conn); cmd.Parameters.AddWithValue("@id", eczaciID); conn.Open(); SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection); reader.Read(); currentEczaci.EczaciID = reader.GetInt32(0); currentEczaci.Adi = reader.GetString(1); currentEczaci.Soyadi = reader.GetString(2); currentEczaci.KullaniciAdi = reader.GetString(3); currentEczaci.Sifre = reader.GetString(4); reader.Close(); return(currentEczaci); }
public int Add(EczaciEntities eczaci) { cmd = new SqlCommand("INSERT INTO Eczacilar VALUES (@ad,@soyad,@kAdi,@sifre)", conn); AddParametersToCommand(eczaci); return(ExecuteCommand()); }
public bool Delete(EczaciEntities eczaci) { return(eczaciManagement.Delete(eczaci.EczaciID) > 0); }
public bool Update(EczaciEntities eczaci) { return(eczaciManagement.Update(eczaci) > 0); }
public bool Add(EczaciEntities eczaci) { return(eczaciManagement.Add(eczaci) > 0); }