예제 #1
0
 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));
     }
 }