示例#1
0
        public List <DissabilityManagerDashboard> GetDissabilityManagerDashboard(ref DisabilityCumulative DisabilityCumulative, ref int yakkrcount, ref int appointment, string Agencyid, string userid)
        {
            List <DissabilityManagerDashboard> centerList = new List <DissabilityManagerDashboard>();
            List <HrCenterInfo> centerList1 = new List <HrCenterInfo>();

            try
            {
                command.Parameters.Add(new SqlParameter("@Agencyid", Agencyid));
                command.Parameters.Add(new SqlParameter("@userid", userid));
                command.Connection  = Connection;
                command.CommandType = CommandType.StoredProcedure;
                command.CommandText = "[SP_DissabilityManagerDashboard]";
                DataAdapter         = new SqlDataAdapter(command);
                _dataset            = new DataSet();
                DataAdapter.Fill(_dataset);
                if (_dataset.Tables[0] != null)
                {
                    if (_dataset.Tables[0].Rows.Count > 0)
                    {
                        foreach (DataRow dr in _dataset.Tables[0].Rows)
                        {
                            DissabilityManagerDashboard info = new DissabilityManagerDashboard();
                            info.CenterId             = EncryptDecrypt.Encrypt64(dr["center"].ToString());
                            info.Name                 = dr["centername"].ToString();
                            info.TotalChildren        = dr["totalchildren"].ToString();
                            info.DisabilityPercentage = dr["TotalDisablePercentage"].ToString();
                            info.Indicated            = dr["Indicated"].ToString();
                            info.Pending              = (Convert.ToString(dr["pending"].ToString()));   // + Convert.ToInt32(dr["WithdrawnPending"].ToString())).ToString();
                            info.Indicated            = (Convert.ToString(dr["Indicated"].ToString())); // + Convert.ToInt32(dr["WithdrawnIndicated"].ToString())).ToString();
                            info.Qualified            = dr["Qualified"].ToString();
                            info.Released             = dr["Released"].ToString();
                            info.Completed            = dr["Completed"].ToString();
                            centerList.Add(info);
                        }
                    }

                    if (_dataset.Tables[1] != null && _dataset.Tables[1].Rows.Count > 0)
                    {
                        DisabilityCumulative.TotalAcivePercent      = Convert.ToDouble(_dataset.Tables[1].Rows[0]["ActivePercent"]);
                        DisabilityCumulative.TotalActiveClient      = Convert.ToInt32(_dataset.Tables[1].Rows[0]["TotalActive"]);
                        DisabilityCumulative.TotalCumulativeClient  = Convert.ToInt32(_dataset.Tables[1].Rows[0]["TotalCumulative"]);
                        DisabilityCumulative.TotalCumulativePercent = Convert.ToDouble(_dataset.Tables[1].Rows[0]["cumulativePercent"]);
                    }
                }
                DataAdapter.Dispose();
                command.Dispose();
            }
            catch (Exception ex)
            {
                clsError.WriteException(ex);
            }
            finally
            {
                DataAdapter.Dispose();
                command.Dispose();
            }
            return(centerList);
        }
示例#2
0
        //public Roster GetDisableDocumentsList(string agencyid, string ClientId)
        //{
        //    List<Roster> RosterList = new List<Roster>();
        //    Roster _roster = new Roster();
        //    List<ClassRoom> classList = new List<ClassRoom>();
        //    List<DisableNotes> disablenotes = new List<DisableNotes>();
        //    try
        //    {
        //        command.Parameters.Add(new SqlParameter("@agencyid", agencyid));
        //        command.Parameters.Add(new SqlParameter("@ClientId", EncryptDecrypt.Decrypt64(ClientId)));
        //        command.Connection = Connection;
        //        command.CommandType = CommandType.StoredProcedure;
        //        command.CommandText = "DisableDocumentsList";
        //        DataAdapter = new SqlDataAdapter(command);
        //        _dataset = new DataSet();
        //        DataAdapter.Fill(_dataset);
        //        if (_dataset.Tables[0] != null)
        //        {
        //            if (_dataset.Tables[0].Rows.Count > 0)
        //            {
        //                DisableNotes info = null;
        //                foreach (DataRow dr in _dataset.Tables[0].Rows)
        //                {
        //                    info = new DisableNotes();
        //                    info.noteid = dr["DisableNotesId"].ToString(); ;
        //                    info.Name = dr["Firstname"].ToString();
        //                    info.DisableDocumentName = dr["DisableDocumentName"].ToString();
        //                    info.DocumentDescription = dr["DocumentDescription"].ToString();
        //                    disablenotes.Add(info);
        //                }
        //                _roster.disablenotes = disablenotes;//Changes on 29Dec2016
        //            }
        //        }

        //    }
        //    catch (Exception ex)
        //    {
        //        clsError.WriteException(ex);
        //    }
        //    finally
        //    {
        //        if (Connection != null)
        //            Connection.Close();
        //    }
        //    return _roster;

        //}
        public DissabilityManagerDashboard BindDisableTypeByClient(string clientid)
        {
            DissabilityManagerDashboard _dissabilityManagerDashboard = new DissabilityManagerDashboard();
            List <DisablilityType>      _DisablilityType             = new List <DisablilityType>();

            try
            {
                command.Connection  = Connection;
                command.CommandType = CommandType.StoredProcedure;
                command.Parameters.AddWithValue("@ClientId", EncryptDecrypt.Decrypt64(clientid));
                command.CommandText = "[SP_DisablitiesTypeByClientId]";
                DataAdapter         = new SqlDataAdapter(command);
                _dataset            = new DataSet();
                DataAdapter.Fill(_dataset);
                if (_dataset.Tables[0] != null)
                {
                    if (_dataset.Tables[0].Rows.Count > 0)
                    {
                        DisablilityType info = null;
                        foreach (DataRow dr in _dataset.Tables[0].Rows)
                        {
                            info                = new DisablilityType();
                            info.Id             = Convert.ToInt32(dr["ID"]);
                            info.DisabilityType = dr["DisablitiesType"].ToString();
                            info.IsChecked      = Convert.ToBoolean(Convert.ToInt32(dr["ischecked"]));
                            info.PrimaryTypeId  = Convert.ToInt32(dr["PrimaryDisability"]);

                            _DisablilityType.Add(info);
                        }
                        _dissabilityManagerDashboard.disabilitytype = _DisablilityType;//Changes on 29Dec2016
                    }
                }
            }
            catch (Exception ex)
            {
                clsError.WriteException(ex);
            }
            finally
            {
                if (Connection != null)
                {
                    Connection.Close();
                }
            }
            return(_dissabilityManagerDashboard);
        }
        //public Roster GetDisableDocumentsList(string agencyid, string ClientId)
        //{
        //    List<Roster> RosterList = new List<Roster>();
        //    Roster _roster = new Roster();
        //    List<ClassRoom> classList = new List<ClassRoom>();
        //    List<DisableNotes> disablenotes = new List<DisableNotes>();
        //    try
        //    {
        //        command.Parameters.Add(new SqlParameter("@agencyid", agencyid));
        //        command.Parameters.Add(new SqlParameter("@ClientId", EncryptDecrypt.Decrypt64(ClientId)));
        //        command.Connection = Connection;
        //        command.CommandType = CommandType.StoredProcedure;
        //        command.CommandText = "DisableDocumentsList";
        //        DataAdapter = new SqlDataAdapter(command);
        //        _dataset = new DataSet();
        //        DataAdapter.Fill(_dataset);
        //        if (_dataset.Tables[0] != null)
        //        {
        //            if (_dataset.Tables[0].Rows.Count > 0)
        //            {
        //                DisableNotes info = null;
        //                foreach (DataRow dr in _dataset.Tables[0].Rows)
        //                {
        //                    info = new DisableNotes();
        //                    info.noteid = dr["DisableNotesId"].ToString(); ;
        //                    info.Name = dr["Firstname"].ToString();
        //                    info.DisableDocumentName = dr["DisableDocumentName"].ToString();
        //                    info.DocumentDescription = dr["DocumentDescription"].ToString();
        //                    disablenotes.Add(info);
        //                }
        //                _roster.disablenotes = disablenotes;//Changes on 29Dec2016
        //            }
        //        }

        //    }
        //    catch (Exception ex)
        //    {
        //        clsError.WriteException(ex);
        //    }
        //    finally
        //    {
        //        if (Connection != null)
        //            Connection.Close();
        //    }
        //    return _roster;

        //}

        public DissabilityManagerDashboard BindDisableType()
        {
            DissabilityManagerDashboard _dissabilityManagerDashboard = new DissabilityManagerDashboard();
            List <DisablilityType>      _DisablilityType             = new List <DisablilityType>();

            try
            {
                command.Connection  = Connection;
                command.CommandType = CommandType.StoredProcedure;
                command.CommandText = "[SP_DisablitiesTypeDropdownList]";
                DataAdapter         = new SqlDataAdapter(command);
                _dataset            = new DataSet();
                DataAdapter.Fill(_dataset);
                if (_dataset.Tables[0] != null)
                {
                    if (_dataset.Tables[0].Rows.Count > 0)
                    {
                        DisablilityType info = null;
                        foreach (DataRow dr in _dataset.Tables[0].Rows)
                        {
                            info                = new DisablilityType();
                            info.Id             = Convert.ToInt32(dr["ID"]);
                            info.DisabilityType = dr["DisablitiesType"].ToString();
                            //info.Notes = dr["Notes"].ToString();

                            _DisablilityType.Add(info);
                        }
                        _dissabilityManagerDashboard.disabilitytype = _DisablilityType;//Changes on 29Dec2016
                    }
                }
            }
            catch (Exception ex)
            {
                clsError.WriteException(ex);
            }
            finally
            {
                if (Connection != null)
                {
                    Connection.Close();
                }
            }
            return(_dissabilityManagerDashboard);
        }
        public DissabilityManagerDashboard getDisableDocument(string Clientid)
        {
            DissabilityManagerDashboard obj = new DissabilityManagerDashboard();

            //obj.income1 = new FamilyHousehold.calculateincome();

            try
            {
                command.Parameters.Add(new SqlParameter("@DisableNotesId", Clientid));
                command.Connection  = Connection;
                command.CommandType = CommandType.StoredProcedure;
                command.CommandText = "[getDisableDocument]";
                DataAdapter         = new SqlDataAdapter(command);
                //Due to Phone Type
                _dataset = new DataSet();
                DataAdapter.Fill(_dataset);
                if (_dataset != null && _dataset.Tables.Count > 0)
                {
                    obj.EImageByte     = (byte[])_dataset.Tables[0].Rows[0]["DisableDocument"];
                    obj.EFileExtension = _dataset.Tables[0].Rows[0]["DisableDocumentName"].ToString();
                    obj.EFileName      = _dataset.Tables[0].Rows[0]["DisableDocumentName"].ToString();
                }
                DataAdapter.Dispose();
                command.Dispose();
                return(obj);
            }
            catch (Exception ex)
            {
                clsError.WriteException(ex);
                return(obj);
            }
            finally
            {
                DataAdapter.Dispose();
                command.Dispose();
            }
        }
        public List <DissabilityManagerDashboard> GetDissabilityStaffDashboard(ref int yakkrcount, ref int appointment, string Agencyid, string userid)
        {
            List <DissabilityManagerDashboard> centerList = new List <DissabilityManagerDashboard>();
            List <HrCenterInfo> centerList1 = new List <HrCenterInfo>();

            try
            {
                command.Parameters.Add(new SqlParameter("@Agencyid", Agencyid));
                command.Parameters.Add(new SqlParameter("@userid", userid));
                command.Connection  = Connection;
                command.CommandType = CommandType.StoredProcedure;
                command.CommandText = "[SP_DissabilityStaffDashboard]";
                DataAdapter         = new SqlDataAdapter(command);
                _dataset            = new DataSet();
                DataAdapter.Fill(_dataset);
                if (_dataset.Tables[0] != null)
                {
                    if (_dataset.Tables[0].Rows.Count > 0)
                    {
                        foreach (DataRow dr in _dataset.Tables[0].Rows)
                        {
                            DissabilityManagerDashboard info = new DissabilityManagerDashboard();
                            info.CenterId             = EncryptDecrypt.Encrypt64(dr["center"].ToString());
                            info.Name                 = dr["centername"].ToString();
                            info.TotalChildren        = dr["totalchildren"].ToString();
                            info.DisabilityPercentage = dr["TotalDisablePercentage"].ToString();
                            info.Indicated            = dr["Indicated"].ToString();
                            info.Pending              = dr["pending"].ToString();
                            info.Qualified            = dr["Qualified"].ToString();
                            info.Released             = dr["Released"].ToString();
                            centerList.Add(info);
                        }
                    }
                    //if (_dataset.Tables[1].Rows.Count > 0)
                    //{
                    //    foreach (DataRow dr in _dataset.Tables[1].Rows)
                    //    {
                    //        HrCenterInfo info = new HrCenterInfo();
                    //        info.CenterId = dr["center"].ToString();
                    //        info.Name = dr["centername"].ToString();
                    //        info.Address = dr["address"].ToString();
                    //        info.Zip = dr["Zip"].ToString();
                    //        info.SeatsAvailable = dr["AvailSeats"].ToString();
                    //        centerList1.Add(info);
                    //    }
                    //    if (centerList.Count > 0 && centerList1.Count > 0)
                    //    {
                    //        centerList.FirstOrDefault().AllCentersList = centerList1;
                    //    }
                    //}
                }
                DataAdapter.Dispose();
                command.Dispose();
            }
            catch (Exception ex)
            {
                clsError.WriteException(ex);
            }
            finally
            {
                DataAdapter.Dispose();
                command.Dispose();
            }
            return(centerList);
        }