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