public void Delete(int Id, out string Message, out System.Drawing.Color Color)
{
Object.Doctor doctor = new Object.Doctor();
doctor.Id = Id;
int ResultNumber = crud.Delete(doctor);
message.Delete(ResultNumber, out Message, out Color);
}
public void Update(int Id, string FirstName, string FamilyName, string Phonenumber
, out string Message, out System.Drawing.Color Color)
{
Object.Doctor doctor = new Object.Doctor();
doctor.Id = Id;
doctor.FirstName = FirstName;
doctor.FamilyName = FamilyName;
doctor.PhoneNumber = Phonenumber;
int ResultNumber = crud.Update(doctor);
message.Update(ResultNumber, out Message, out Color);
}
public void Create(string doctorFirstName, string doctorFamilyName, string doctorPhoneNumber
, out string Message, out System.Drawing.Color Color)
{
Object.Doctor doctor = new Object.Doctor();
doctor.FirstName = doctorFirstName;
doctor.FamilyName = doctorFamilyName;
doctor.PhoneNumber = doctorPhoneNumber;
int ResultNumber = crud.Create(doctor);
message.Create(ResultNumber, out Message, out Color);
}
public int Delete(Object.Doctor doctor)
{
using (SqlConnection con = new SqlConnection(SharedMethods.getConnectionString()))
{
SqlCommand cmd = new SqlCommand("Delete From tblDoctor Where Id = @Id", con);
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@Id", doctor.Id);
con.Open();
return((int)cmd.ExecuteNonQuery());
}
}
public int Create(Object.Doctor doctor)
{
using (SqlConnection con = new SqlConnection(SharedMethods.getConnectionString()))
{
SqlCommand cmd = new SqlCommand("spAddDoctor_tblDoctor", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@FirstName", doctor.FirstName);
cmd.Parameters.AddWithValue("@FamilyName", doctor.FamilyName);
cmd.Parameters.AddWithValue("@PhoneNumber", doctor.PhoneNumber);
SqlParameter Result = new SqlParameter("@ResultNumber", DbType.Int32);
Result.Direction = ParameterDirection.Output;
cmd.Parameters.Add(Result);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
return((int)Result.Value);
}
}
