public DataSet ExecuteDataset(BLLDoctorClaim objBLLDoctorClaim)
{
using (SqlConnection ConnectionString = new SqlConnection(Configuration.ConnectionStringsMaster))
{
SqlParameter[] _parameters =
{
new SqlParameter("@Sptype", objBLLDoctorClaim.SpType),
new SqlParameter("@Token", objBLLDoctorClaim.Token),
new SqlParameter("@ClaimClient", objBLLDoctorClaim.ClientId),
new SqlParameter("@PolicyNumber", objBLLDoctorClaim.PolicyNumber),
new SqlParameter("@PatientName", objBLLDoctorClaim.PatientName),
new SqlParameter("@MemberCode", objBLLDoctorClaim.MemberCode),
new SqlParameter("@PatientAge", objBLLDoctorClaim.PatientAge),
new SqlParameter("@PatientGen", objBLLDoctorClaim.PatientGender),
new SqlParameter("@PatientAddress", objBLLDoctorClaim.PatientAddress),
new SqlParameter("@PatientMobile", objBLLDoctorClaim.PatientMobile),
new SqlParameter("@DoctorId", objBLLDoctorClaim.DoctorId),
new SqlParameter("@DoctorName", objBLLDoctorClaim.DoctorName),
new SqlParameter("@PatientPic", objBLLDoctorClaim.PatientPic),
new SqlParameter("@Document", objBLLDoctorClaim.Document),
new SqlParameter("@DCDocument", objBLLDoctorClaim.Document),
new SqlParameter("@DocumentUrL", objBLLDoctorClaim.DC_DocumentUrl),
new SqlParameter("@DocumentName", objBLLDoctorClaim.DC_DocumentName),
new SqlParameter("@PharmacyDocument", objBLLDoctorClaim.PharmacyDocument),
new SqlParameter("@IP", objBLLDoctorClaim.IP),
new SqlParameter("@DC_Diagnosis", objBLLDoctorClaim.DC_Diagnosis),
new SqlParameter("@DC_ClaimedAmount", objBLLDoctorClaim.DC_ClaimedAmount),
new SqlParameter("@AppointmentDate", objBLLDoctorClaim.AppointmentDate)
};
return(SqlHelper.ExecuteDataset(ConnectionString, CommandType.StoredProcedure, "PROC_DoctorClaim", _parameters));
}
}