private void btnPolySave_Click(object sender, EventArgs e)
{
int data = 0;
bool _excep = false;
using (var uow = (AdoNetUnitOfWork)UnitOfWorkFactory.Create(UnitOfWorkFactory.ConnectionType.SQL, Connection.connectionString))
{
PolyclinicRepository pRepos = new PolyclinicRepository(uow);
try
{
Polyclinic polyclinic = new Polyclinic()
{
Name = txtPolyclinicName.Text,
Address = txtPolyclinicAddress.Text
};
data = pRepos.AddPolyclinic(polyclinic);
uow.SaveChanges();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
_excep = true;
}
if (_excep == false && data == 1)
{
MessageBox.Show("The operation is successfull...");
}
}
}
public int AddPolyclinic(Polyclinic polyclinic)
{
IDbCommand cmd = _unitOfWork.CreateCommand();
cmd.CommandText = "INSERT INTO Polyclinic(name,address) VALUES (@name,@address)";
cmd.Parameters.Add(new SqlParameter("@name", polyclinic.Name));
cmd.Parameters.Add(new SqlParameter("@address", polyclinic.Address));
int data = cmd.ExecuteNonQuery();
return(data);
}
public List <Polyclinic> FindPolyclinicL(string polyclinicName)
{
IDbCommand command = _unitOfWork.CreateCommand();
polyclinicName = "%" + polyclinicName + "%";
command.CommandText = "SELECT * FROM Polyclinic WHERE name LIKE @name";
command.Parameters.Add(new SqlParameter("@name", polyclinicName));
IDataReader dataReader = command.ExecuteReader();
List <Polyclinic> polyclinics = new List <Polyclinic>();
while (dataReader.Read())
{
Polyclinic polyclinic = new Polyclinic()
{
ID = dataReader.GetInt32(0),
Name = dataReader.GetString(1),
};
polyclinics.Add(polyclinic);
}
dataReader.Close();
return(polyclinics);
}
public List <Polyclinic> GetAllPolyclinicsL()
{
IDbCommand command = _unitOfWork.CreateCommand();
command.CommandText = "SELECT id AS 'Polyclinic No',name AS 'Polyclinic Name',address AS 'Polyclinic Adress' FROM Polyclinic";
IDataReader dataReader = command.ExecuteReader();
List <Polyclinic> polyclinics = new List <Polyclinic>();
while (dataReader.Read())
{
Polyclinic polyclinic = new Polyclinic()
{
ID = dataReader.GetInt32(0),
Name = dataReader.GetString(1),
Address = dataReader.GetString(2)
};
polyclinics.Add(polyclinic);
}
dataReader.Close();
return(polyclinics);
}