public static IList <FieldCodeModel> GetFieldCodeList(int?IntID, int selectionType, int FieldClassId, string SearchBy, string SearchString, Guid?CompanyId, int ItemsPerPage, int RequestPage, int CurrentPageNo)
        {
            ArrayList paramList = new ArrayList();
            string    resultString;
            IList <FieldCodeModel> objFieldCodeModel = null;
            FieldCodeModel         obj = new FieldCodeModel();

            obj.SearchString  = SearchString;
            obj.RequestType   = selectionType;
            obj.IntID         = IntID;
            obj.CompanyId     = CompanyId;
            obj.ItemsPerPage  = ItemsPerPage;
            obj.RequestPageNo = RequestPage;
            obj.FieldClassId  = FieldClassId;
            paramList.Add(obj);
            using (var client = new HttpClient())
            {
                Uri baseAddress = new Uri(System.Configuration.ConfigurationManager.AppSettings["UriPath"]);
                client.BaseAddress = baseAddress;
                resultString       = client.PostAsJsonAsync("api/FieldCode/FieldCode_List", paramList)
                                     .Result
                                     .Content.ReadAsStringAsync().Result;
            }

            objFieldCodeModel = (IList <FieldCodeModel>)Newtonsoft.Json.JsonConvert.DeserializeObject(resultString, typeof(IList <FieldCodeModel>));
            return(objFieldCodeModel);
        }
        public IList <FieldCodeModel> FieldCode_List(ArrayList paramList)
        {
            FieldCodeModel         apiObject     = new FieldCodeModel();
            string                 strResult     = "";
            IList <FieldCodeModel> apiObjectList = null;

            apiObject = Newtonsoft.Json.JsonConvert.DeserializeObject <FieldCodeModel>(paramList[0].ToString());
            /// =============
            apiObjectList = fnFieldCode_List(apiObject, ref strResult);
            return(apiObjectList);
        }
        public FieldCodeModel FieldCode_InsertUpdate(ArrayList paramList)
        {
            string         strResult     = "";
            string         strReturnCode = "000";
            string         strReturnMsg  = "UnDefined";
            FieldCodeModel apiObject     = new FieldCodeModel();

            apiObject = Newtonsoft.Json.JsonConvert.DeserializeObject <FieldCodeModel>(paramList[0].ToString());
            string crCnString = UtilityLib.GetConnectionString();

            int FieldCodeInfo = DAL_FieldCode.FieldCode_InsertUpdate(crCnString, apiObject.FieldCodeId, apiObject.FieldClassId, apiObject.FieldCodeName,
                                                                     apiObject.FieldCodeAlias, apiObject.FieldCodeOrder, apiObject.CompanyId);

            if (FieldCodeInfo == 0)
            {
                apiObject.ReturnCode    = FieldCodeInfo;
                apiObject.ReturnMessage = "Success";
            }
            else if (FieldCodeInfo == 1)
            {
                apiObject.ReturnCode    = FieldCodeInfo;
                apiObject.ReturnMessage = "Field Code already exists";
            }
            else if (FieldCodeInfo == 101)
            {
                apiObject.ReturnCode    = FieldCodeInfo;
                apiObject.ReturnMessage = "Field Code updated successfully";
            }
            else if (FieldCodeInfo == 2)
            {
                apiObject.ReturnCode    = FieldCodeInfo;
                apiObject.ReturnMessage = "record is already updated by someone else";
            }
            else
            {
                apiObject.ReturnCode    = FieldCodeInfo;
                apiObject.ReturnMessage = "Fail-Record Not Inserted";
            }
            strResult = strReturnCode + "|" + strReturnMsg;
            return(apiObject);
        }
        private IList <FieldCodeModel> fnFieldCode_List(FieldCodeModel apiObject, ref string strResult)
        {
            string strReturnCode = "000";
            string strReturnMsg  = "UnDefined";
            string crCnString    = UtilityLib.GetConnectionString();
            IList <FieldCodeModel> objFieldCodeModelList = new List <FieldCodeModel>();

            DataSet usersInfoDS = DAL_FieldCode.FieldCode_List(crCnString, apiObject.RequestType, apiObject.SearchBy, apiObject.SearchString,
                                                               apiObject.IntID, apiObject.FieldClassId, apiObject.CompanyId, apiObject.ItemsPerPage, apiObject.RequestPageNo, apiObject.CurrentPageNo);

            DataTable usersInfoDT = usersInfoDS.Tables[0];

            if (usersInfoDT != null && usersInfoDT.Rows.Count > 0)
            {
                strReturnCode = "001";
                strReturnMsg  = "Success";
                foreach (DataRow dr in usersInfoDT.Rows)
                {
                    apiObject                = new FieldCodeModel();
                    apiObject.FieldCodeId    = UtilityLib.FormatNumber(dr["FieldCodeId"].ToString());
                    apiObject.FieldClassId   = UtilityLib.FormatNumber(dr["FieldClassId"].ToString());
                    apiObject.FieldClassName = (string)dr["FieldClassName"];
                    apiObject.FieldCodeName  = (string)dr["FieldCodeName"];
                    apiObject.FieldCodeAlias = (string)dr["FieldCodeAlias"];
                    apiObject.FieldCodeOrder = (string)dr["FieldCodeOrder"];
                    apiObject.CompanyId      = (Guid)(dr["CompanyId"]);
                    objFieldCodeModelList.Add(apiObject);
                }
            }
            else
            {
                strReturnCode = "002";
                strReturnMsg  = "Fail-Record Not Found";
            }
            strResult = strReturnCode + "|" + strReturnMsg;
            return(objFieldCodeModelList);
        }