Ejemplo n.º 1
0
        public JObject SaveContactToGroup(string sConnString, int userId, long groupID, string mobileNumber)
        {
            JObject responseJObj = new JObject();
            int     retVal       = 0;
            string  retMsg       = "";

            try
            {
                DataAccessLayer.V_1_5.Contacts contactsObj = new DataAccessLayer.V_1_5.Contacts(sConnString);
                retVal = contactsObj.SaveContactToGroup(userId, groupID, mobileNumber, out retMsg);
                if (retVal == 1)
                {
                    responseJObj = new JObject(new JProperty("Success", true),
                                               new JProperty("Message", "Contact Added"),
                                               new JProperty("ErrorCode", "117"));
                }
                else
                {
                    responseJObj = new JObject(new JProperty("Success", false),
                                               new JProperty("Message", "Contact Not Added"),
                                               new JProperty("ErrorCode", "117"));
                }
            }
            catch (Exception ex)
            {
                Logger.ExceptionLog("exception in SaveContactToGroup Bll " + ex.ToString());
                responseJObj = new JObject(new JProperty("Success", false),
                                           new JProperty("ErrorCode", "101"));
            }

            return(responseJObj);
        }
Ejemplo n.º 2
0
        public JObject AddWebContactList(string sConnString, int userID, string listName, int mode)
        {
            JObject responseJObj  = new JObject();
            int     returnValue   = 0;
            string  returnMessage = "";
            int     listID        = 0;

            try
            {
                DataAccessLayer.V_1_5.Contacts contactsObj = new DataAccessLayer.V_1_5.Contacts(sConnString);
                returnValue = contactsObj.AddWebContactList(userID, listName, mode, out returnMessage, out listID);
                if (returnValue == 1)
                {
                    responseJObj = new JObject(new JProperty("Success", true),
                                               new JProperty("Message", returnMessage), new JProperty("ErrorCode", "117"),
                                               new JProperty("Status", returnValue.ToString()),
                                               new JProperty("listIdOut", listID.ToString()));
                }
            }
            catch (Exception ex)
            {
                Logger.ExceptionLog("Exception in AddWebContactList Bll " + ex.ToString());
                responseJObj = new JObject(new JProperty("Success", false),
                                           new JProperty("AddWebListContacts", "WebListContact failed to Add"), new JProperty("ErrorCode", "101"));
            }
            return(responseJObj);
        }
Ejemplo n.º 3
0
        public JObject DeleteListIdNListIdContacts(string sConnString, int userID, int listId, int mode)
        {
            JObject responseJObj  = new JObject();
            int     returnValue   = 0;
            string  returnMessage = "";

            try
            {
                DataAccessLayer.V_1_5.Contacts contactsObj = new DataAccessLayer.V_1_5.Contacts(sConnString);
                returnValue = contactsObj.DeleteListIdNListIdContacts(userID, listId, mode, out returnMessage);
                if (returnValue == 1)
                {
                    responseJObj = new JObject(new JProperty("Success", true),
                                               new JProperty("Message", returnMessage), new JProperty("ErrorCode", "117"),
                                               new JProperty("Status", returnValue),
                                               new JProperty("listId", listId));
                }
            }
            catch (Exception ex)
            {
                Logger.ExceptionLog("exception in DeleteListIdNListIdContacts Bll " + ex.ToString());
                responseJObj = new JObject(new JProperty("Success", false));
            }
            return(responseJObj);
        }
Ejemplo n.º 4
0
        public JObject AddAllContactsToParticularList(string sConnString, int userId, string contactId, int mode, int listId)
        {
            JObject responseJObj = new JObject();
            int     returnValue = 0, listContactsCount = 0;
            string  returnMessage = "";

            try
            {
                DataAccessLayer.V_1_5.Contacts contactsObj = new DataAccessLayer.V_1_5.Contacts(sConnString);
                returnValue = contactsObj.AddAllContactsToParticularList(userId, listId, contactId, mode, out returnMessage, out listContactsCount);
                if (returnValue == 1)
                {
                    responseJObj = new JObject(new JProperty("Success", true),
                                               new JProperty("Message", returnMessage), new JProperty("returnValue", returnValue), new JProperty("ErrorCode", "117"),
                                               new JProperty("ListContactsCount", listContactsCount),
                                               new JProperty("Status", returnValue),
                                               new JProperty("listId", listId));
                }
                else
                {
                    responseJObj = new JObject(new JProperty("Success", false),
                                               new JProperty("Message", returnMessage), new JProperty("Status", returnValue), new JProperty("ErrorCode", "117"));
                }
            }
            catch (Exception ex)
            {
                Logger.ExceptionLog("Exception in AddAllContactsToParticularList Bll" + ex.ToString());
                responseJObj = new JObject(new JProperty("Success", false),
                                           new JProperty("ErrorCode", "101"));
            }
            return(responseJObj);
        }
Ejemplo n.º 5
0
        public JObject GetAllContactsLists(string sConnString, int userID)
        {
            JObject listsResponse    = new JObject();
            DataSet listsDataSet     = new DataSet();
            JObject listsJobj        = new JObject();
            JArray  listsJarr        = new JArray();
            JArray  deletedListsJarr = new JArray();
            string  retMessage       = "";
            string  timeStamp        = "";
            int     retVal           = 0;

            try
            {
                DataAccessLayer.V_1_5.Contacts contactsObj = new DataAccessLayer.V_1_5.Contacts(sConnString);
                listsDataSet = contactsObj.GetAllContactsList(userID, out retVal, out retMessage, out timeStamp);
                if (retVal == 1)
                {
                    if (listsDataSet.Tables[0].Rows.Count > 0)
                    {
                        foreach (DataRow _row in listsDataSet.Tables[0].Rows)
                        {
                            listsJobj = new JObject();
                            foreach (DataColumn _column in listsDataSet.Tables[0].Columns)
                            {
                                listsJobj.Add(new JProperty(_column.ColumnName, _row[_column.ColumnName]));
                            }
                            listsJarr.Add(listsJobj);
                        }
                    }
                    if (listsDataSet.Tables[1].Rows.Count > 0)
                    {
                        foreach (DataRow _row in listsDataSet.Tables[1].Rows)
                        {
                            foreach (DataColumn _column in listsDataSet.Tables[1].Columns)
                            {
                                deletedListsJarr.Add(_row["Id"]);
                            }
                        }
                    }
                    listsResponse = new JObject(new JProperty("Success", true),
                                                new JProperty("Message", "Success"), new JProperty("ErrorCode", "117"),
                                                new JProperty("TimeStamp", timeStamp),
                                                new JProperty("Lists", listsJarr),
                                                new JProperty("DeletedLists", deletedListsJarr));
                }
                else
                {
                    listsResponse = new JObject(new JProperty("Success", false), new JProperty("ErrorCode", "112"),
                                                new JProperty("Message", retMessage));
                }
            }
            catch (Exception ex)
            {
                listsResponse = new JObject(new JProperty("Success", false),
                                            new JProperty("Message", "Something Went Wrong"), new JProperty("ErrorCode", "101"));
                Logger.TraceLog("Exception In GetAllContactsLists BLL : " + ex.ToString());
            }

            return(listsResponse);
        }
Ejemplo n.º 6
0
        public JObject UploadExcelData(string sConnString, int userID, DataTable dt, DataTable excelDuplicates, int listId, int mode, string listName)
        {
            JObject responseJObj  = new JObject();
            JArray  jar           = new JArray();
            int     returnValue   = 0;
            DataSet ds            = new DataSet();
            string  returnMessage = "";
            JArray  jarDup        = new JArray();
            JObject jobjdup       = new JObject();

            try
            {
                DataAccessLayer.V_1_5.Contacts contactsObj = new DataAccessLayer.V_1_5.Contacts(sConnString);
                ds = contactsObj.UploadExcelData(userID, dt, excelDuplicates, out returnValue, out returnMessage, listId, listName, mode);
                if (returnValue == 1)
                {
                    if (ds.Tables.Count > 0)
                    {
                        if (ds.Tables[0].Rows.Count > 0)
                        {
                            jar.Add(new JObject(new JProperty("ListId", ds.Tables[0].Rows[0]["ListId"]),
                                                new JProperty("ListCount", ds.Tables[0].Rows[0]["ListCount"]),
                                                new JProperty("ListName", ds.Tables[0].Rows[0]["ListName"])));
                        }
                        if (ds.Tables.Count > 1)
                        {
                            if (ds.Tables[1].Rows.Count > 0)
                            {
                                foreach (DataRow dr in ds.Tables[1].Rows)
                                {
                                    jobjdup = new JObject();
                                    foreach (DataColumn dc in ds.Tables[1].Columns)
                                    {
                                        jobjdup.Add(new JProperty(dc.ColumnName, dr[dc.ColumnName]));
                                    }
                                    jarDup.Add(jobjdup);
                                }
                            }
                        }
                    }

                    responseJObj = new JObject(new JProperty("Success", true),
                                               new JProperty("Status", returnValue), new JProperty("ErrorCode", "117"),
                                               new JProperty("Message", returnMessage), new JProperty("Details", jar), new JProperty("Duplicates", jarDup));
                }
                else
                {
                    responseJObj = new JObject(new JProperty("Success", false),
                                               new JProperty("Status", returnValue), new JProperty("ErrorCode", "101"),
                                               new JProperty("Message", returnMessage));
                }
            }
            catch (Exception ex)
            {
                Logger.ExceptionLog("exception in UploadExcelData Bll " + ex.ToString());
                responseJObj = new JObject(new JProperty("Success", false),
                                           new JProperty("Message", "Something Went Wrong"), new JProperty("ErrorCode", "101"));
            }
            return(responseJObj);
        }
Ejemplo n.º 7
0
        public JObject DeleteWebContact(string sConnString, int userID, int contactID, int listId, int mode)
        {
            JObject responseJObj  = new JObject();
            DataSet ds            = new DataSet();
            JObject tempJobj      = new JObject();
            JArray  Jarr          = new JArray();
            int     returnValue   = 0;
            string  returnMessage = "";

            try
            {
                DataAccessLayer.V_1_5.Contacts contactsObj = new DataAccessLayer.V_1_5.Contacts(sConnString);
                ds = contactsObj.DeleteWebContact(userID, listId, contactID, mode, out returnValue, out returnMessage);
                if (returnValue == 1)
                {
                    responseJObj = new JObject(new JProperty("Success", true),
                                               new JProperty("Status", returnValue), new JProperty("ErrorCode", "117"),
                                               new JProperty("Message", returnMessage));
                }
                else
                {
                    responseJObj = new JObject(new JProperty("Success", false),
                                               new JProperty("Status", returnValue), new JProperty("ErrorCode", "101"),
                                               new JProperty("Message", "Contact deleted"));
                }
            }
            catch (Exception ex)
            {
                Logger.ExceptionLog("exception in DeleteWebContact Bll " + ex.ToString());
                responseJObj = new JObject(new JProperty("Success", false),
                                           new JProperty("Message", "Something Went Wrong"), new JProperty("ErrorCode", "101"));
            }
            return(responseJObj);
        }
Ejemplo n.º 8
0
        public JObject PhoneCallHistorySync(string sConnString, int userID, string phoneNumbers)
        {
            JObject listsResponse = new JObject();
            JObject listsJobj = new JObject();
            string  retMessage = "";
            string  timeStamp = "";
            int     retVal = 0, errorCode = 0;

            try
            {
                DataAccessLayer.V_1_5.Contacts contactsObj = new DataAccessLayer.V_1_5.Contacts(sConnString);
                retVal = contactsObj.PhoneCallHistorySync(userID, phoneNumbers, out retMessage, out errorCode);
                if (retVal == 1)
                {
                    listsResponse = new JObject(new JProperty("Success", true),
                                                new JProperty("Message", "Success"), new JProperty("ErrorCode", errorCode));
                }
                else
                {
                    listsResponse = new JObject(new JProperty("Success", false),
                                                new JProperty("Message", "Something Went Wrong"), new JProperty("ErrorCode", "101"));
                }
            }
            catch (Exception ex)
            {
                listsResponse = new JObject(new JProperty("Success", false),
                                            new JProperty("Message", "Something Went Wrong"), new JProperty("ErrorCode", "101"));
                Logger.TraceLog("Exception In PhoneCallHistorySync BLL : " + ex.ToString());
            }

            return(listsResponse);
        }
Ejemplo n.º 9
0
        public JObject ManageWebContacts(string sConnString, int userId, string name, string mobileNumber, string prefix, int contactID, int mode, int listID, string listName, string tempCropImagePath)
        {
            JObject      responseJObj  = new JObject();
            JArray       jList         = new JArray();
            MemoryStream mStream       = new MemoryStream();
            int          returnValue   = 0;
            string       returnMessage = "";
            string       imagePath     = "";
            int          contactId     = 0;

            try
            {
                DataAccessLayer.V_1_5.Contacts contactsObj = new DataAccessLayer.V_1_5.Contacts(sConnString);
                imagePath = HttpContext.Current.Server.MapPath("/ContactImages/");
                //byte[] imgCropArray = ReadFile(imagePath + tempCropImagePath);

                DataSet ds = contactsObj.ManageWebContacts(userId, name, mobileNumber, prefix, contactID, mode, listID, listName, out returnValue, out returnMessage, tempCropImagePath, out contactId);
                if (returnValue == 1)
                {
                    if (listName.Trim() != string.Empty)
                    {
                        if (ds.Tables.Count > 0)
                        {
                            if (ds.Tables[0].Rows.Count > 0)
                            {
                                jList.Add(new JObject(new JProperty("ListId", ds.Tables[0].Rows[0]["ListId"]),
                                                      new JProperty("ListCount", ds.Tables[0].Rows[0]["listCount"])));
                            }
                        }
                    }
                    responseJObj = new JObject(new JProperty("Success", true),
                                               new JProperty("ContactId", contactId),
                                               new JProperty("Status", returnValue),
                                               new JProperty("ErrorCode", "117"),
                                               new JProperty("Message", returnMessage),
                                               new JProperty("List", jList));
                }
                else
                {
                    responseJObj = new JObject(new JProperty("Success", false),
                                               new JProperty("Status", returnValue), new JProperty("ErrorCode", "142"),
                                               new JProperty("Message", "Contact Not created"));
                }
            }
            catch (Exception ex)
            {
                Logger.ExceptionLog("Exception in ManageWebContacts Bll " + ex.ToString());
                responseJObj = new JObject(new JProperty("Success", false),
                                           new JProperty("Message", "Something Went Wrong"), new JProperty("ErrorCode", "101"));
            }
            return(responseJObj);
        }
Ejemplo n.º 10
0
        public JObject AddNonMember(string sConnString, int userId, int listId, string moblie, int mode)
        {
            JObject responseJObj = new JObject();
            JArray  nameArray    = new JArray();
            JObject nameObj      = new JObject();
            int     retVal       = 0;
            string  retMsg       = "";
            DataSet ds           = new DataSet();

            try
            {
                DataAccessLayer.V_1_5.Contacts contactsObj = new DataAccessLayer.V_1_5.Contacts(sConnString);
                ds = contactsObj.AddNonMember(userId, listId, moblie, mode, out retVal, out retMsg);
                if (retVal == 1)
                {
                    if (ds.Tables.Count > 0)
                    {
                        if (ds.Tables[0].Rows.Count > 0)
                        {
                            foreach (DataRow dr in ds.Tables[0].Rows)
                            {
                                nameObj = new JObject();
                                foreach (DataColumn dc in ds.Tables[0].Columns)
                                {
                                    nameObj.Add(new JProperty(dc.ColumnName, dr[dc.ColumnName]));
                                }
                                nameArray.Add(nameObj);
                            }
                        }
                    }
                    responseJObj = new JObject(new JProperty("Success", true),
                                               new JProperty("ErrorCode", "117"), new JProperty("contactName", nameArray));
                }
                else
                {
                    responseJObj = new JObject(new JProperty("Success", false),
                                               new JProperty("ErrorCode", "117"));
                }
            }
            catch (Exception ex)
            {
                Logger.ExceptionLog("exception in addNonMember Bll " + ex.ToString());
                responseJObj = new JObject(new JProperty("Success", false),
                                           new JProperty("ErrorCode", "101"));
            }

            return(responseJObj);
        }
Ejemplo n.º 11
0
        public JObject WebContactsList(string sConnString, int userID, int mode, int listId, int source, int pageIndex, string alphabetSort, string searchValue)
        {
            JObject responseJObj    = new JObject();
            DataSet ds              = new DataSet();
            JObject contactJobj     = new JObject();
            JObject listJobj        = new JObject();
            JObject contactListJobj = new JObject();
            JArray  Jarr            = new JArray();
            JArray  JarrList        = new JArray();
            JArray  JarrContactList = new JArray();
            int     returnValue     = 0;
            string  returnMessage   = "";
            int     pageCount       = 0;

            try
            {
                DataAccessLayer.V_1_5.Contacts contactsObj = new DataAccessLayer.V_1_5.Contacts(sConnString);
                ds = contactsObj.WebContactsList(userID, mode, listId, source, pageIndex, alphabetSort, searchValue, out returnValue, out returnMessage, out pageCount);
                if (ds.Tables[0].Rows.Count > 0)
                {
                    foreach (DataRow _row in ds.Tables[0].Rows)
                    {
                        contactJobj = new JObject();
                        foreach (DataColumn _column in ds.Tables[0].Columns)
                        {
                            contactJobj.Add(new JProperty(_column.ColumnName, _row[_column.ColumnName]));
                        }
                        Jarr.Add(contactJobj);
                    }
                }
                if (mode == 1)
                {
                    if (ds.Tables[1].Rows.Count > 0)
                    {
                        foreach (DataRow _row in ds.Tables[1].Rows)
                        {
                            listJobj = new JObject();
                            foreach (DataColumn _column in ds.Tables[1].Columns)
                            {
                                listJobj.Add(new JProperty(_column.ColumnName, _row[_column.ColumnName]));
                            }
                            JarrList.Add(listJobj);
                        }
                    }
                    //if (Ds.Tables[3].Rows.Count > 0)
                    //{

                    //    foreach (DataRow _row in Ds.Tables[3].Rows)
                    //    {
                    //        contactListJobj = new JObject();
                    //        foreach (DataColumn _column in Ds.Tables[3].Columns)
                    //        {
                    //            contactListJobj.Add(new JProperty(_column.ColumnName, _row[_column.ColumnName]));
                    //        }
                    //        JarrContactList.Add(contactListJobj);
                    //    }

                    //}
                }
                responseJObj = new JObject(new JProperty("Success", true),
                                           new JProperty("Message", returnMessage),
                                           new JProperty("Status", returnValue),
                                           new JProperty("contactsData", Jarr),
                                           new JProperty("contactListDetails", JarrList),
                                           new JProperty("contactListData", JarrContactList));
            }
            catch (Exception ex)
            {
                Logger.ExceptionLog("exception in WebContactsList Bll " + ex.ToString());
                responseJObj = new JObject(new JProperty("success", false),
                                           new JProperty("message", "No contatcs found"));
            }
            return(responseJObj);
        }
Ejemplo n.º 12
0
        public JObject GetMobilContactsDetailsSort(string sConnString, int userId, int source, string alphabet, int mode, int pageIndex, int listId, HttpContext context)
        {
            JObject jResponse     = new JObject();
            JArray  jArray        = new JArray();
            JArray  jarSubcontcts = new JArray();

            try
            {
                int     retValue = 0, contactsCount = 0;
                string  retMessage  = "";
                int     pageCount   = 1;
                DataSet allContacts = new DataSet();
                DataAccessLayer.V_1_5.Contacts contactsObj = new DataAccessLayer.V_1_5.Contacts(sConnString);
                allContacts = contactsObj.GetMobileContactDetailsSort(userId, source, mode, alphabet, pageIndex, listId, out retValue, out retMessage, out pageCount, out contactsCount);
                if (retValue == 1)
                {
                    if (allContacts != null)
                    {
                        if (allContacts.Tables.Count != 0)
                        {
                            if (allContacts.Tables[0].Rows.Count != 0)
                            {
                                for (int rowCount = 0; rowCount < allContacts.Tables[0].Rows.Count; rowCount++)
                                {
                                    if (source == 1)
                                    {
                                        DataRow[] result = null;

                                        if (allContacts.Tables.Count > 1)
                                        {
                                            result = null;
                                            if (allContacts.Tables[1].Rows.Count != 0)
                                            {
                                                result = allContacts.Tables[1].Select("ContactID =" + allContacts.Tables[0].Rows[rowCount]["ID"] + " ");
                                                int COUNT = result.Count();
                                                jarSubcontcts = new JArray();
                                                foreach (DataRow drSubContacts in result)
                                                {
                                                    jarSubcontcts.Add(new JObject(new JProperty("subContactId", drSubContacts["contactId"]),
                                                                                  new JProperty("contactType", drSubContacts["contactType"]),
                                                                                  new JProperty("contactNumber", drSubContacts["Number"]),
                                                                                  new JProperty("userId", drSubContacts["UserId"])));
                                                }
                                            }
                                        }
                                    }

                                    jArray.Add(new JObject(new JProperty("id", allContacts.Tables[0].Rows[rowCount]["Id"]),
                                                           new JProperty("name", allContacts.Tables[0].Rows[rowCount]["Name"]),
                                                           new JProperty("mobileNumber", allContacts.Tables[0].Rows[rowCount]["MobileNumber"]),
                                                           new JProperty("imagePath", allContacts.Tables[0].Rows[rowCount]["ImagePath"]),
                                                           new JProperty("source", allContacts.Tables[0].Rows[rowCount]["Source"]),
                                                           new JProperty("Prefix", allContacts.Tables[0].Rows[rowCount]["Prefix"]),
                                                           new JProperty("ContactId", allContacts.Tables[0].Rows[rowCount]["ContactId"]),
                                                           new JProperty("subContactDeatils", jarSubcontcts)));
                                }



                                jResponse = new JObject(new JProperty("Success", true),
                                                        new JProperty("Message", retMessage),
                                                        new JProperty("Status", retValue), new JProperty("ErrorCode", "117"),
                                                        new JProperty("ContactsCount", contactsCount),
                                                        new JProperty("pageCount", pageCount),
                                                        new JProperty("contactDetails", jArray));


                                return(jResponse);
                            }
                            else
                            {
                                jResponse = new JObject(new JProperty("Success", false),
                                                        new JProperty("Message", "No Data Found"),
                                                        new JProperty("ErrorCode", "139"),
                                                        new JProperty("ContactsCount", contactsCount),
                                                        new JProperty("Status", 0));


                                return(jResponse);
                            }
                        }
                    }
                }
                else
                {
                    jResponse = new JObject(new JProperty("Success", false),
                                            new JProperty("Message", retMessage), new JProperty("ErrorCode", "101"));
                    return(jResponse);
                }
            }
            catch (Exception ex)
            {
                jResponse = new JObject(new JProperty("Success", false),
                                        new JProperty("Message", ex.ToString()), new JProperty("ErrorCode", "101"));
                //new JProperty("Message", ex.StackTrace));
                Logger.ExceptionLog("Exception in GetMobilContactsDetailsSort BLL" + ex.StackTrace);
            }

            return(jResponse);
        }
Ejemplo n.º 13
0
        public JObject WebContactsList(string sConnString, int userID, int listId, int pageIndex)
        {
            JObject responseJObj = new JObject();
            DataSet ds = new DataSet();
            JObject contactJobj = new JObject();
            JObject listJobj = new JObject();
            JObject contactListJobj = new JObject();
            JArray  Jarr = new JArray();
            JArray  JarrList = new JArray();
            JArray  JarrContactList = new JArray();
            int     returnValue = 0;
            string  returnMessage = "";
            int     pageCount = 0, allContactsCount = 0;

            try
            {
                DataAccessLayer.V_1_5.Contacts contactsObj = new DataAccessLayer.V_1_5.Contacts(sConnString);
                ds = contactsObj.WebContactsList(userID, listId, pageIndex, out returnValue, out returnMessage, out pageCount, out allContactsCount);
                if (returnValue == 1)
                {
                    if (ds.Tables[0].Rows.Count > 0)
                    {
                        foreach (DataRow _row in ds.Tables[0].Rows)
                        {
                            contactJobj = new JObject();
                            foreach (DataColumn _column in ds.Tables[0].Columns)
                            {
                                contactJobj.Add(new JProperty(_column.ColumnName, _row[_column.ColumnName]));
                            }
                            Jarr.Add(contactJobj);
                        }
                    }
                    if (ds.Tables[1].Rows.Count > 0)
                    {
                        foreach (DataRow _row in ds.Tables[1].Rows)
                        {
                            listJobj = new JObject();
                            foreach (DataColumn _column in ds.Tables[1].Columns)
                            {
                                listJobj.Add(new JProperty(_column.ColumnName, _row[_column.ColumnName]));
                            }
                            JarrList.Add(listJobj);
                        }
                    }
                    if (ds.Tables[3].Rows.Count > 0)
                    {
                        foreach (DataRow _row in ds.Tables[3].Rows)
                        {
                            contactListJobj = new JObject();
                            foreach (DataColumn _column in ds.Tables[3].Columns)
                            {
                                contactListJobj.Add(new JProperty(_column.ColumnName, _row[_column.ColumnName]));
                            }
                            JarrContactList.Add(contactListJobj);
                        }
                    }
                    responseJObj = new JObject(new JProperty("Success", true),
                                               new JProperty("Message", returnMessage), new JProperty("ErrorCode", "117"),
                                               new JProperty("Status", returnValue),
                                               new JProperty("AllContactsCount", allContactsCount),
                                               new JProperty("pageCount", pageCount),
                                               new JProperty("Items", Jarr),
                                               new JProperty("ContactList", JarrList),
                                               new JProperty("Data", JarrContactList));
                }
            }
            catch (Exception ex)
            {
                Logger.ExceptionLog("exception in WebContactsList Bll " + ex.ToString());
                responseJObj = new JObject(new JProperty("Success", false),
                                           new JProperty("Message", "No contatcs found"), new JProperty("ErrorCode", "101"));
            }
            return(responseJObj);
        }