Example #1
0
        public List <TherapistModel> getDatagridDetails()
        {
            List <TherapistModel> lstTherapist = new List <TherapistModel>();
            TherapistModel        t            = new TherapistModel();

            try
            {
                queryString = "SELECT ID, firstName as 'FIRST NAME', lastName as 'LAST NAME', wage as 'WAGE' FROM dbspa.tbltherapist" +
                              " WHERE (isDeleted = 0)";

                MySqlDataReader reader = conDB.getSelectConnection(queryString, null);

                while (reader.Read())
                {
                    t.ID1       = reader["ID"].ToString();
                    t.FirstName = reader["FIRST NAME"].ToString();
                    t.LastName  = reader["LAST NAME"].ToString();
                    t.Wage      = reader["WAGE"].ToString();
                    lstTherapist.Add(t);
                    t = new TherapistModel();
                }

                conDB.closeConnection();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }

            return(lstTherapist);
        }
        public void fillComboTherapist(System.Windows.Controls.ComboBox cmb)
        {
            try
            {
                queryString = "SELECT ID, firstName, lastName, wage, description FROM dbspa.tbltherapist WHERE (isDeleted = 0)";

                MySqlDataReader reader = conDB.getSelectConnection(queryString, null);

                while (reader.Read())
                {
                    TherapistModel tm = new TherapistModel();
                    tm.ID1         = reader["ID"].ToString();
                    tm.FirstName   = reader["firstName"].ToString();
                    tm.LastName    = reader["lastName"].ToString();
                    tm.Wage        = reader["wage"].ToString();
                    tm.Description = tm.FirstName + " " + tm.LastName;
                    cmb.Items.Add(tm);
                }

                conDB.closeConnection();
            }
            catch (Exception ex)
            {
                System.Windows.MessageBox.Show(ex.Message);
            }
        }
        private void btnCompute_Click(object sender, RoutedEventArgs e)
        {
            TherapistModel tm = dgvTherapist.SelectedItem as TherapistModel;

            if (tm != null)
            {
                TherapistSalary ts = new TherapistSalary(tm);
                ts.ShowDialog();
            }
            else
            {
                MessageBox.Show("No record selected!");
            }
        }
        private void btnEdit_Click(object sender, RoutedEventArgs e)
        {
            TherapistModel tm = dgvTherapist.SelectedItem as TherapistModel;

            if (tm != null)
            {
                tm.IfEditDetails = true;
                TherapistDetails cd = new TherapistDetails(this, tm);
                cd.ShowDialog();
            }
            else
            {
                MessageBox.Show("No record selected!");
            }
        }
        private List <TherapistModel> getAttendanceForTherapist(int ID)
        {
            TherapistModel        thera    = new TherapistModel();
            List <TherapistModel> lstThera = new List <TherapistModel>();

            try
            {
                queryString = "SELECT ID, attendanceDate, timeIn, timeOut, therapistID, minutesLate, isLate, deduction, ifhalfday, " +
                              "ifUndertime, lateDeduction, undertimeDeduction FROM dbspa.tblattendance WHERE  " +
                              "(dbspa.tblattendance.isDeleted = 0) AND (therapistID = ?) AND (attendanceDate BETWEEN ? AND ?)";
                parameters = new List <string>();

                parameters.Add(ID.ToString());

                DateTime date = DateTime.Parse(dateFrom.Text);
                parameters.Add(date.Year + "/" + date.Month + "/" + date.Day);

                date = DateTime.Parse(dateTo.Text);
                parameters.Add(date.Year + "/" + date.Month + "/" + date.Day);

                MySqlDataReader reader = conDB.getSelectConnection(queryString, parameters);

                while (reader.Read())
                {
                    thera                    = new TherapistModel();
                    thera.ID1                = reader["therapistID"].ToString();
                    thera.AttendanceDate     = DateTime.Parse(reader["attendanceDate"].ToString());
                    thera.TimeIn             = reader["timeIn"].ToString();
                    thera.TimeOut            = reader["timeOut"].ToString();
                    thera.MinutesLate        = reader["minutesLate"].ToString();
                    thera.IsLate             = Convert.ToInt32(reader["isLate"].ToString());
                    thera.Deduction          = reader["deduction"].ToString();
                    thera.Ifhalfday          = Convert.ToInt32(reader["ifhalfday"].ToString());
                    thera.ifUnderTime        = Convert.ToInt32(reader["ifUndertime"].ToString());
                    thera.lateDeduction      = reader["lateDeduction"].ToString();
                    thera.undertimeDeduction = reader["undertimeDeduction"].ToString();
                    lstThera.Add(thera);
                }

                conDB.closeConnection();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }

            return(lstThera);
        }
        private bool checkIfAlreadyLoggedIn()
        {
            bool ifLogIn = false;
            int  idThera = 0;

            try
            {
                if (cmbTherapist.SelectedItem != null)
                {
                    TherapistModel therapist = cmbTherapist.SelectedItem as TherapistModel;

                    queryString = "SELECT therapistID FROM dbspa.tblattendance WHERE therapistID = ? AND attendanceDate = ? AND isDeleted = 0";
                    parameters  = new List <string>();
                    parameters.Add(therapist.ID1);
                    DateTime date = DateTime.Parse(dteAttendance.Text);
                    parameters.Add(date.Year + "-" + date.Month + "-" + date.Day);


                    MySqlDataReader reader = conDB.getSelectConnection(queryString, parameters);

                    while (reader.Read())
                    {
                        idThera = Convert.ToInt32(reader["therapistID"].ToString());
                    }

                    conDB.closeConnection();

                    if (idThera > 0)
                    {
                        ifLogIn = true;
                    }
                }
                else
                {
                    System.Windows.MessageBox.Show("Please select Therapist!");
                }
            }
            catch (Exception ex)
            {
                System.Windows.MessageBox.Show(ex.Message);
            }

            return(ifLogIn);
        }
        private bool checkTherapistIfTheSame()
        {
            bool ifthesame = false;

            TherapistModel therapist = cmbTherapist.SelectedItem as TherapistModel;

            TherapistAttendance attM = dgvAttendance.SelectedItem as TherapistAttendance;

            if (therapist != null && attM != null)
            {
                if (therapist.ID1.Equals(attM.TherapistID))
                {
                    ifthesame = true;
                }
            }


            return(ifthesame);
        }
        private bool checkTimeIn(int strTherapistId, string recordID)
        {
            bool ifTimeIn = false;

            TherapistModel tm = new TherapistModel();

            try
            {
                queryString = "SELECT dbspa.tblattendance.ID, dbspa.tbltherapist.description AS 'THERAPIST', dbspa.tblattendance.attendanceDate AS 'DATE', " +
                              "dbspa.tblattendance.timeIn AS 'TIME IN', dbspa.tblattendance.timeOut AS 'TIME OUT' FROM (dbspa.tblattendance INNER JOIN " +
                              "dbspa.tbltherapist ON dbspa.tblattendance.therapistID = dbspa.tbltherapist.ID) WHERE (dbspa.tblattendance.isDeleted = 0) AND " +
                              "(dbspa.tbltherapist.isDeleted = 0) AND (tblAttendance.therapistID = ?) AND dbspa.tblattendance.ID = ?";

                parameters = new List <string>();
                parameters.Add(strTherapistId.ToString());
                parameters.Add(recordID);

                MySqlDataReader reader = conDB.getSelectConnection(queryString, parameters);

                while (reader.Read())
                {
                    tm.ID1    = reader["ID"].ToString();
                    tm.TimeIn = reader["TIME IN"].ToString();
                }

                if (!string.IsNullOrEmpty(tm.TimeIn))
                {
                    ifTimeIn = true;
                }
                conDB.closeConnection();
            }
            catch (Exception ex)
            {
                System.Windows.MessageBox.Show(ex.Message);
            }

            return(ifTimeIn);
        }
        private void btnDelete_Click(object sender, RoutedEventArgs e)
        {
            System.Windows.Forms.DialogResult dialogResult = System.Windows.Forms.MessageBox.Show("Are you sure you want to Delete record?", "Delete Record", System.Windows.Forms.MessageBoxButtons.YesNo);

            if (dialogResult == System.Windows.Forms.DialogResult.Yes)
            {
                TherapistModel cm = dgvTherapist.SelectedItem as TherapistModel;

                if (cm != null)
                {
                    int id = Convert.ToInt32(cm.ID1);

                    if (id != 0)
                    {
                        deleteTherapistRecord(id);
                        System.Windows.MessageBox.Show("Record deleted successfuly!");
                    }
                }
                else
                {
                    System.Windows.MessageBox.Show("No record selected!");
                }
            }
        }
Example #10
0
        private List <TherapistModel> getTherapistServed(int id)
        {
            List <TherapistModel> lstTM = new List <TherapistModel>();
            TherapistModel        tm    = new TherapistModel();

            queryString = "SELECT dbspa.tbltherapist.ID, dbspa.tbltherapist.firstName, dbspa.tbltherapist.lastName, dbspa.tbltherapist.wage, " +
                          "dbspa.tbltherapist.description FROM ((dbspa.tblservicemade INNER JOIN dbspa.tbltherapist ON " +
                          "dbspa.tblservicemade.therapistID = dbspa.tbltherapist.ID) INNER JOIN dbspa.tblClient ON " +
                          "dbspa.tblservicemade.clientID = dbspa.tblclient.ID) WHERE (dbspa.tblservicemade.clientID = ?) AND (dbspa.tblservicemade.dateServiced = ?)";

            parameters = new List <string>();

            parameters.Add(id.ToString());

            DateTime date = DateTime.Parse(DateTime.Now.ToShortDateString());

            parameters.Add(date.Year + "/" + date.Month + "/" + date.Day);

            MySqlDataReader reader = conDB.getSelectConnection(queryString, parameters);

            while (reader.Read())
            {
                tm.ID1         = reader["ID"].ToString();
                tm.FirstName   = reader["firstName"].ToString();
                tm.LastName    = reader["lastName"].ToString();
                tm.Wage        = reader["wage"].ToString();
                tm.Description = reader["description"].ToString();
                lstTM.Add(tm);
                tm = new TherapistModel();
            }

            conDB.closeConnection();


            return(lstTM);
        }
Example #11
0
        public IActionResult AddNewTherapist([FromBody] AddNewTherapistRequestDto requestDto)
        {
            if (requestDto.ClassifyGuids.Count() <= 0)
            {
                return(Failed(ErrorCode.Empty, "所属大类未选择"));
            }

            if (requestDto.Tag?.Count() <= 0)
            {
                return(Failed(ErrorCode.Empty, "擅长需填写"));
            }

            if (string.Join("", requestDto.Tag).Length > 300)
            {
                return(Failed(ErrorCode.Empty, "擅长超过最大长度限制"));
            }

            if (requestDto.MerchantProjectGuidList.Count() <= 0)
            {
                return(Failed(ErrorCode.Empty, "服务项目未选择"));
            }

            if (!string.IsNullOrEmpty(requestDto.Introduction))
            {
                if (requestDto.Introduction.Length > 500)
                {
                    return(Failed(ErrorCode.Empty, "个人简介超过最大长度限制"));
                }
            }

            var therapistBiz = new TherapistBiz();

            var IsTherapistPhoneExist = therapistBiz.IsTherapistPhoneExist(requestDto.TherapistPhone);

            if (IsTherapistPhoneExist)
            {
                return(Failed(ErrorCode.UserData, "该手机号已注册!"));
            }

            var therapistGuid = Guid.NewGuid().ToString("N");

            var tModel = new TherapistModel()
            {
                TherapistGuid     = therapistGuid,
                TherapistName     = requestDto.TherapistName,
                JobTitle          = requestDto.JobTitle,
                MerchantGuid      = UserID,
                PortraitGuid      = requestDto.PortraitGuid,
                TherapistPhone    = requestDto.TherapistPhone,
                TherapistPassword = CryptoHelper.AddSalt(therapistGuid, requestDto.TherapistPassword),
                Introduction      = requestDto.Introduction,
                Tag             = JsonConvert.SerializeObject(requestDto.Tag),
                CreatedBy       = UserID,
                CreationDate    = DateTime.Now,
                LastUpdatedBy   = UserID,
                LastUpdatedDate = DateTime.Now
            };

            var tpModelList = requestDto.MerchantProjectGuidList.Distinct().Select(d => new TherapistProjectModel()
            {
                TherapistProjectGuid = Guid.NewGuid().ToString("N"),
                TherapistGuid        = tModel.TherapistGuid,
                ProjectGuid          = d,
                CreatedBy            = UserID,
                CreationDate         = DateTime.Now,
                LastUpdatedBy        = UserID,
                LastUpdatedDate      = DateTime.Now,
                Enable = true
            }).ToList();

            var classifyModels = requestDto.ClassifyGuids.Distinct().Select(d => new MerchantTherapistClassifyModel()
            {
                TherapistClassifyGuid = Guid.NewGuid().ToString("N"),
                TherapistGuid         = tModel.TherapistGuid,
                ClassifyGuid          = d,
                CreatedBy             = UserID,
                CreationDate          = DateTime.Now,
                LastUpdatedBy         = UserID,
                LastUpdatedDate       = DateTime.Now,
                Enable  = true,
                OrgGuid = ""
            }).ToList();

            var response = therapistBiz.AddNewTherapist(tModel, tpModelList, classifyModels);

            return(Success(response));
        }
Example #12
0
 public ReportForm(TherapistModel tm, List <TherapistModel> lstTM)
 {
     therapist    = tm;
     lstTherapist = lstTM;
     InitializeComponent();
 }
        private void btnTimeOut_Click(object sender, RoutedEventArgs e)
        {
            try
            {
                if (!string.IsNullOrEmpty(dteAttendance.Text))
                {
                    if (checkTherapistIfTheSame())
                    {
                        if (cmbTherapist.SelectedItem != null)
                        {
                            TherapistModel therapist = cmbTherapist.SelectedItem as TherapistModel;

                            string recordID = "";

                            TherapistAttendance attM = dgvAttendance.SelectedItem as TherapistAttendance;

                            if (attM != null)
                            {
                                recordID = attM.ID;
                            }


                            if (checkTimeIn(Convert.ToInt32(therapist.ID1), attM.ID))
                            {
                                DateTime loggedOutTime;
                                string   strLogOut = Properties.Settings.Default.logOutTime;
                                if (chkManualOut.IsChecked == true)
                                {
                                    loggedOutTime = DateTime.Parse(dteAttendance.Text + " " + dateTimeOut.Text);
                                }
                                else
                                {
                                    loggedOutTime = DateTime.Parse(dteAttendance.Text + " " + time.Content);
                                }

                                DateTime LogOut = DateTime.Parse(dteAttendance.Text + " " + strLogOut);
                                if (loggedOutTime.Date.Equals(LogOut.Date))
                                {
                                    loggedOutTime = loggedOutTime.AddDays(-1);
                                }
                                int x          = loggedOutTime.CompareTo(LogOut);
                                int deductions = 0;
                                //bool ifUndertime = false;
                                int numIfUndertime = 0;
                                if (x < 0)
                                {
                                    deductions = Properties.Settings.Default.undertime;
                                    //ifUndertime = true;
                                    numIfUndertime = 1;
                                }

                                queryString = "UPDATE dbspa.tblattendance SET timeOut = ?, ifUndertime = ? , undertimeDeduction = ? WHERE therapistID = ? AND ID = ?";
                                parameters  = new List <string>();
                                if (chkManualOut.IsChecked == true)
                                {
                                    parameters.Add(dateTimeOut.Text);
                                }
                                else
                                {
                                    parameters.Add(time.Content.ToString());
                                }

                                parameters.Add(numIfUndertime.ToString());
                                parameters.Add(deductions.ToString());
                                parameters.Add(therapist.ID1);
                                parameters.Add(recordID);

                                conDB.AddRecordToDatabase(queryString, parameters);
                                conDB.closeConnection();
                                //getAttendanceRecords();
                                System.Windows.MessageBox.Show("Time out for " + therapist.Description + " recorded successfully!");
                                conDB.writeLogFile("TIME OUT: " + therapist.Deduction);
                            }
                            else
                            {
                                System.Windows.MessageBox.Show("No Time In record found!");
                            }
                        }
                        else
                        {
                            System.Windows.MessageBox.Show("Please select Therapist!");
                        }
                    }
                    else
                    {
                        System.Windows.MessageBox.Show("Selected therapist not equal to selected record!");
                    }
                }
                else
                {
                    System.Windows.MessageBox.Show("Please provide date for attendance!");
                }
            }


            catch (Exception ex)
            {
                Console.WriteLine(ex.Message);
            }
            finally
            {
                getAttendanceRecords();
            }
        }
        private void updateLogInViaManual()
        {
            if (cmbTherapist.SelectedItem != null)
            {
                TherapistModel therapist = cmbTherapist.SelectedItem as TherapistModel;
                string         recordID  = "";

                try
                {
                    string   strLogInTime = Properties.Settings.Default.LogInTime;
                    string   strHalfday   = Properties.Settings.Default.haldayTime;
                    DateTime loggedTime;
                    DateTime dateNow = DateTime.Parse(dteAttendance.Text);
                    if (chkManualIn.IsChecked == true)
                    {
                        loggedTime = DateTime.Parse(dateNow.ToShortDateString() + " " + dateTimeIn.Text);
                    }
                    else
                    {
                        loggedTime = DateTime.Parse(dateNow.ToShortDateString() + " " + time.Content);
                    }

                    DateTime logInTime = DateTime.Parse(dateNow.ToShortDateString() + " " + strLogInTime);

                    DateTime halfDay = DateTime.Parse(dateNow.ToShortDateString() + " " + strHalfday);

                    int x = loggedTime.CompareTo(logInTime);
                    int y = loggedTime.CompareTo(halfDay);

                    int deductions    = 0;
                    int lateDeduction = 0;
                    int numIfLate     = 0;
                    int numIfHalfDay  = 0;
                    int minutes       = 0;

                    //CHECK IF LOG IN TIME IS HALFDAY
                    if (y >= 0)
                    {
                        //ifHalfDay = true;
                        numIfHalfDay = 1;
                        if ((DateTime.Now.DayOfWeek == DayOfWeek.Saturday) ||
                            (DateTime.Now.DayOfWeek == DayOfWeek.Sunday))
                        {
                            //GET HALDAY DEDUCTION
                            deductions = Properties.Settings.Default.halfdayDeduction;
                        }
                        else
                        {
                            deductions = Properties.Settings.Default.halfdayDeduction;
                        }
                    }
                    else
                    {
                        //CHECK IF LOG IN TIME IS ON OR BEFORE OR AFTER SET LOG IN TIME
                        //-1 BEFORE 1PM
                        //0 - 1PM
                        //1 - after 1PM
                        if (x > 0)
                        {
                            TimeSpan span = loggedTime.Subtract(logInTime);

                            minutes = span.Minutes;

                            if (minutes < 0)
                            {
                                minutes = 0;
                            }
                            else
                            {
                                //ifLate = true;
                                numIfLate = 1;
                            }

                            lateDeduction = checkMinutesToDeduct(minutes);
                        }
                    }

                    parameters = new List <string>();
                    if (checkIfAlreadyLoggedIn())
                    {
                        System.Windows.Forms.DialogResult dialogResult = System.Windows.Forms.MessageBox.Show("THERAPIST: " + therapist.Description + " already has a Time In! " +
                                                                                                              "Update existing Time In record?", "Attendace", System.Windows.Forms.MessageBoxButtons.YesNo);

                        if (dialogResult == System.Windows.Forms.DialogResult.Yes)
                        {
                            TherapistAttendance attM = dgvAttendance.SelectedItem as TherapistAttendance;
                            if (attM != null)
                            {
                                recordID = attM.ID;
                            }

                            queryString = "UPDATE dbspa.tblattendance SET attendanceDate = ?, timeIn = ?, minutesLate = ?, isLate =?, " +
                                          " deduction = ?, ifhalfday = ?, lateDeduction = ? WHERE therapistID = ? AND dbspa.tblattendance.attendanceDate = ?";

                            DateTime date = DateTime.Parse(dteAttendance.Text);
                            parameters.Add(date.Year + "/" + date.Month + "/" + date.Day);
                            parameters.Add(dateTimeIn.Text);
                            parameters.Add(minutes.ToString());
                            parameters.Add(numIfLate.ToString());
                            parameters.Add(deductions.ToString());
                            parameters.Add(numIfHalfDay.ToString());
                            parameters.Add(lateDeduction.ToString());
                            parameters.Add(therapist.ID1);
                            parameters.Add(date.Year + "/" + date.Month + "/" + date.Day);

                            conDB.AddRecordToDatabase(queryString, parameters);
                            System.Windows.MessageBox.Show("Time in for " + therapist.Description + " recorded successfully!");
                            conDB.writeLogFile("TIME IN:(MANUAL) UPDATE EXISTING RECORD FOR: " + therapist.Deduction);
                        }
                        else
                        {
                        }
                    }
                    else
                    {
                        queryString = "INSERT INTO dbspa.tblattendance (attendanceDate, timeIn, therapistID, isDeleted, minutesLate, isLate, deduction, " +
                                      "ifhalfday, lateDeduction, undertimeDeduction, ifUndertime) VALUES(?,?,?,?,?,?,?,?,?,?,?)";
                        parameters = new List <string>();
                        DateTime date = DateTime.Parse(dteAttendance.Text);
                        parameters.Add(date.Year + "/" + date.Month + "/" + date.Day);

                        parameters.Add(dateTimeIn.Text);

                        parameters.Add(therapist.ID1);
                        parameters.Add(0.ToString());
                        parameters.Add(minutes.ToString());
                        parameters.Add(numIfLate.ToString());
                        parameters.Add(deductions.ToString());
                        parameters.Add(numIfHalfDay.ToString());
                        parameters.Add(lateDeduction.ToString());
                        parameters.Add(0.ToString());
                        parameters.Add(0.ToString());

                        conDB.AddRecordToDatabase(queryString, parameters);
                        System.Windows.MessageBox.Show("Time in for " + therapist.Description + " recorded successfully!");
                        conDB.writeLogFile("TIME IN:(MANUAL) SAVE NEW RECORD FOR " + therapist.Deduction);
                    }



                    conDB.closeConnection();
                }
                catch (Exception ex)
                {
                    System.Windows.MessageBox.Show(ex.Message);
                }
                finally
                {
                    getAttendanceRecords();
                }
            }
            else
            {
                System.Windows.MessageBox.Show("Please select Therapist!");
            }
        }
Example #15
0
 public TherapistDetails(Therapist t, TherapistModel tm)
 {
     tModel    = tm;
     therapist = t;
     InitializeComponent();
 }
 public TherapistSalary(TherapistModel tm)
 {
     therapist = tm;
     InitializeComponent();
 }
 public IHttpActionResult SendConfirmationEmail(TherapistModel therapistModel)
 {
     return(Ok());
 }
 public IHttpActionResult Post(TherapistModel therapistModel)
 {
     return(Ok());
 }
Example #19
0
        private void printClientForm()
        {
            try
            {
                reportViewer.ProcessingMode = ProcessingMode.Local;
                LocalReport localReport = reportViewer.LocalReport;

                localReport.ReportPath = "Reports/ClientReport.rdlc";
                reportViewer.RefreshReport();

                //Create the list of parameters that will be passed to the report
                List <ReportParameter> paramList = new List <ReportParameter>();

                ReportParameter param = new ReportParameter("name");
                param.Values.Add(clientModel.FirstName + " " + clientModel.LastName);
                paramList.Add(param);

                param = new ReportParameter("date");
                DateTime date = DateTime.Parse(clientModel.DateServiced);
                param.Values.Add(date.ToShortDateString());
                paramList.Add(param);

                param = new ReportParameter("serialNumber");
                param.Values.Add(clientModel.SerialNumber);
                paramList.Add(param);

                param = new ReportParameter("cod");
                param.Values.Add(clientModel.Cod);
                paramList.Add(param);

                param = new ReportParameter("address");
                param.Values.Add(clientModel.Address);
                paramList.Add(param);

                param = new ReportParameter("serviceMode");
                param.Values.Add(clientModel.ServiceMode);
                paramList.Add(param);

                param = new ReportParameter("timeIn");
                param.Values.Add(clientModel.TimeIn);
                paramList.Add(param);

                param = new ReportParameter("timeOut");
                if (string.IsNullOrEmpty(clientModel.TimeOut))
                {
                    param.Values.Add(" ");
                }
                else
                {
                    param.Values.Add(clientModel.TimeOut);
                }

                paramList.Add(param);


                double   total     = 0.0;
                double   prodTotal = 0.0;
                string[] strArr;
                string[] priceArr;

                if (clientModel.LstServiceTypeModel.Count < 1)
                {
                    strArr      = new string[1];
                    priceArr    = new string[1];
                    priceArr[0] = "\r" + "0.0" + "\n";
                    strArr[0]   = "\r" + "None" + "\n";
                }
                else
                {
                    strArr   = new string[clientModel.LstServiceTypeModel.Count];
                    priceArr = new string[clientModel.LstServiceTypeModel.Count];

                    for (int i = 0; i < clientModel.LstServiceTypeModel.Count; i++)
                    {
                        ServiceTypeModel stm = clientModel.LstServiceTypeModel[i];
                        double           x   = 0.0;
                        x           = x + Convert.ToDouble(stm.Price);
                        total      += x;
                        priceArr[i] = "\r" + stm.Price + "\n";
                        strArr[i]   = "\r" + stm.ServiceType + "\n";
                    }
                }

                string[] strThera = new string[1];
                if (clientModel.LstTherapistModel.Count < 1)
                {
                    strThera[0] = "\r" + "-" + "\n";
                }
                else
                {
                    strThera = new string[clientModel.LstTherapistModel.Count];
                    for (int i = 0; i < clientModel.LstTherapistModel.Count; i++)
                    {
                        TherapistModel tm = clientModel.LstTherapistModel[i];
                        strThera[i] = "\r" + tm.ToString() + "\n";
                    }
                }


                string[] strProducts     = new string[1];
                string[] strProductPrice = new string[1];

                if (clientModel.lstProductsBought.Count < 1)
                {
                    strProducts[0]     = "\r" + "None" + "\n";
                    strProductPrice[0] = "\r" + "0.0" + "\n";
                }
                else
                {
                    strProducts     = new string[clientModel.lstProductsBought.Count];
                    strProductPrice = new string[clientModel.lstProductsBought.Count];
                    for (int x = 0; x < clientModel.lstProductsBought.Count; x++)
                    {
                        ProductBoughtModel prodBought = clientModel.lstProductsBought[x];
                        double             pp         = Convert.ToDouble(String.Format("{0:0.00}", prodBought.ProductPrice));
                        strProducts[x]     = "\r" + prodBought.ProductName + "\n";
                        strProductPrice[x] = "\r" + prodBought.ProductPrice + "\n";
                        prodTotal          = prodTotal + pp;
                    }
                }


                total = total + prodTotal;

                param = new ReportParameter("total");
                param.Values.Add(total.ToString());
                paramList.Add(param);

                //MULTI LEVEL PARAMS
                ReportParameter multiValueParam = new ReportParameter("serviceType");
                multiValueParam.Values.AddRange(strArr);
                paramList.Add(multiValueParam);

                multiValueParam = new ReportParameter("amounts");
                multiValueParam.Values.AddRange(priceArr);
                paramList.Add(multiValueParam);

                multiValueParam = new ReportParameter("therapist");
                multiValueParam.Values.AddRange(strThera);
                paramList.Add(multiValueParam);

                multiValueParam = new ReportParameter("products");
                multiValueParam.Values.AddRange(strProducts);
                paramList.Add(multiValueParam);

                multiValueParam = new ReportParameter("productprice");
                multiValueParam.Values.AddRange(strProductPrice);
                paramList.Add(multiValueParam);
                //ADD PARAMETERS

                //Set the ReportViewers parameters to the list of ReportParameters we just created

                this.reportViewer.LocalReport.SetParameters(paramList.ToArray());

                // Refresh the report
                reportViewer.RefreshReport();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }

            this.reportViewer.RefreshReport();
            this.reportViewer.RefreshReport();
        }