public int SaveOutdoorPatient(Model.OutdoorPatient aOutdoorPatient)
        {
            Query = "INSERT INTO tblOP (OPID,TreatmentType,PatientName,ServiceDate,Address,Gender,Age,Phone,Mobile,Nationality," +
                    "Doctor,Fees,BloodGroup,GurdianName,ContactPerson,RefferedBy)VALUES(@OPID,@TreatmentType,@PatientName,@ServiceDate,@Address,@Gender,@Age,@Phone,@Mobile,@Nationality,@Doctor,@Fees,@BloodGroup,@GurdianName,@ContactPerson,@RefferedBy)";
            Command = new SqlCommand(Query, Connection);
            Command.Parameters.AddWithValue("@OPID", aOutdoorPatient.Opid ?? "");
            Command.Parameters.AddWithValue("@TreatmentType", aOutdoorPatient.TreatementType ?? "");
            Command.Parameters.AddWithValue("@PatientName", aOutdoorPatient.PatientName ?? "");
            Command.Parameters.AddWithValue("@ServiceDate", aOutdoorPatient.ServiceDate);
            Command.Parameters.AddWithValue("@Address", aOutdoorPatient.Address ?? "");
            Command.Parameters.AddWithValue("@Gender", aOutdoorPatient.Gender ?? "");
            Command.Parameters.AddWithValue("@Age", aOutdoorPatient.Age);
            Command.Parameters.AddWithValue("@Phone", aOutdoorPatient.Phone ?? "");
            Command.Parameters.AddWithValue("@Mobile", aOutdoorPatient.Mobile ?? "");
            Command.Parameters.AddWithValue("@Nationality", aOutdoorPatient.Nationality ?? "");
            Command.Parameters.AddWithValue("@Doctor", aOutdoorPatient.Doctor ?? "");
            Command.Parameters.AddWithValue("@Fees", aOutdoorPatient.Fees ?? "");
            Command.Parameters.AddWithValue("@BloodGroup", aOutdoorPatient.BloodGroup ?? "");
            Command.Parameters.AddWithValue("@GurdianName", aOutdoorPatient.GurdianName ?? "");
            Command.Parameters.AddWithValue("@ContactPerson", aOutdoorPatient.ContactPerson ?? "");
            Command.Parameters.AddWithValue("@RefferedBy", aOutdoorPatient.RefferedBy ?? "");
            int rowAffect = Command.ExecuteNonQuery();

            return(rowAffect);
        }
        public int UpdateOutdoorPatient(Model.OutdoorPatient aOutdoorPatient)
        {
            Query =
                "UPDATE tblOP SET TreatmentType=@TreatmentType,PatientName=@PatientName,ServiceDate=@ServiceDate,Address=@Address,Gender=@Gender,Age=@Age,Phone=@Phone,Mobile=@Mobile,Nationality=@Nationality," +
                "Doctor=@Doctor,Fees=@Fees,BloodGroup=@BloodGroup,GurdianName=@GurdianName,ContactPerson=@ContactPerson,RefferedBy=@RefferedBy WHERE OPID='" + aOutdoorPatient.Opid + "'";
            Command = new SqlCommand(Query, Connection);
            Command.Parameters.AddWithValue("@TreatmentType", aOutdoorPatient.TreatementType ?? "");
            Command.Parameters.AddWithValue("@PatientName", aOutdoorPatient.PatientName ?? "");
            Command.Parameters.AddWithValue("@ServiceDate", aOutdoorPatient.ServiceDate);
            Command.Parameters.AddWithValue("@Address", aOutdoorPatient.Address ?? "");
            Command.Parameters.AddWithValue("@Gender", aOutdoorPatient.Gender ?? "");
            Command.Parameters.AddWithValue("@Age", aOutdoorPatient.Age);
            Command.Parameters.AddWithValue("@Phone", aOutdoorPatient.Phone ?? "");
            Command.Parameters.AddWithValue("@Mobile", aOutdoorPatient.Mobile ?? "");
            Command.Parameters.AddWithValue("@Nationality", aOutdoorPatient.Nationality ?? "");
            Command.Parameters.AddWithValue("@Doctor", aOutdoorPatient.Doctor ?? "");
            Command.Parameters.AddWithValue("@Fees", aOutdoorPatient.Fees ?? "");
            Command.Parameters.AddWithValue("@BloodGroup", aOutdoorPatient.BloodGroup ?? "");
            Command.Parameters.AddWithValue("@GurdianName", aOutdoorPatient.GurdianName ?? "");
            Command.Parameters.AddWithValue("@ContactPerson", aOutdoorPatient.ContactPerson ?? "");
            Command.Parameters.AddWithValue("@RefferedBy", aOutdoorPatient.RefferedBy ?? "");
            int rowAffect = Command.ExecuteNonQuery();

            return(rowAffect);
        }
        public int DeleteOutdoorPatient(Model.OutdoorPatient aOutdoorPatient)
        {
            Query   = "DELETE FROM tblop WHERE OPID='" + aOutdoorPatient.Opid + "'";
            Command = new SqlCommand(Query, Connection);
            int rowAffect = Command.ExecuteNonQuery();

            return(rowAffect);
        }
        public DataTable IsExist_Update(Model.OutdoorPatient aOutdoorPatient)
        {
            Query               = "SELECT OPID FROM tblop WHERE OPID <> '" + aOutdoorPatient.Opid + "'";
            Command             = new SqlCommand(Query, Connection);
            Command.CommandType = CommandType.Text;
            Reader              = Command.ExecuteReader();
            DataTable dataTable = new DataTable();

            dataTable.Load(Reader); return(dataTable);
        }