public InternalStackHolder InternalStackholderDetails(Int64 Id)
        {
            InternalStackHolder obj   = new InternalStackHolder();
            CommonHelper        objCH = new CommonHelper();
            DataSet             ds    = objISH.GetInternalStackHoldersDetails(Id);

            if (ds != null && ds.Tables.Count > 0)
            {
                int tblIndx = -1;
                tblIndx++;
                if (ds.Tables.Count > tblIndx && ds.Tables[tblIndx] != null && ds.Tables[tblIndx].Rows.Count > 0)
                {
                    obj.InternalStakeholdersId = Convert.ToInt64(ds.Tables[tblIndx].Rows[0]["InternalStakeholdersId"]);
                    obj.Name        = Convert.ToString(ds.Tables[tblIndx].Rows[0]["Name"]);
                    obj.Status      = Convert.ToInt16(ds.Tables[tblIndx].Rows[0]["IsActive"]);
                    obj.Emailid     = Convert.ToString(ds.Tables[tblIndx].Rows[0]["Emailid"]);
                    obj.OrgName     = Convert.ToString(ds.Tables[tblIndx].Rows[0]["OrgName"]);
                    obj.Designation = Convert.ToString(ds.Tables[tblIndx].Rows[0]["Designation"]);
                }
            }
            return(obj);
        }
        public PageLoad_InternalStackHolderList InternalStackholdersList()
        {
            CommonHelper objCH = new CommonHelper();
            PageLoad_InternalStackHolderList obj = new PageLoad_InternalStackHolderList();
            DataSet ds = objISH.GetInternalStackHoldersList();

            if (ds != null && ds.Tables.Count > 0)
            {
                int tblIndx = -1;
                tblIndx++;
                if (ds.Tables.Count > tblIndx && ds.Tables[tblIndx] != null && ds.Tables[tblIndx].Rows.Count > 0)
                {
                    List <InternalStackHolder> InternalStackHolderList = new List <InternalStackHolder>();
                    InternalStackHolder        objIS = new InternalStackHolder();
                    foreach (DataRow dr in ds.Tables[tblIndx].Rows)
                    {
                        objIS                        = new InternalStackHolder();
                        objIS.ItemNumber             = Convert.ToInt64(dr["ItemNumber"]);
                        objIS.InternalStakeholdersId = Convert.ToInt64(dr["InternalStakeholdersId"]);
                        objIS.Name                   = Convert.ToString(dr["Name"]);
                        objIS.Status                 = Convert.ToInt16(dr["IsActive"]);
                        objIS.IsInUse                = Convert.ToBoolean(dr["IsInUse"]);
                        objIS.OrgName                = Convert.ToString(dr["OrgName"]);
                        objIS.Designation            = Convert.ToString(dr["Designation"]);
                        objIS.Emailid                = Convert.ToString(dr["Emailid"]);
                        InternalStackHolderList.Add(objIS);
                    }
                    obj.InternalStackHolderList = InternalStackHolderList;
                }
                tblIndx++;
                if (ds.Tables.Count > tblIndx && ds.Tables[tblIndx] != null && ds.Tables[tblIndx].Rows.Count > 0)
                {
                    obj.TotalCount = Convert.ToInt64(ds.Tables[tblIndx].Rows[0]["TotalCount"]);
                }
            }
            return(obj);
        }