//public class ClassName
        //{
        //    public int strnum { get; set; }
        //}

        public IEnumerable <DomainEntity.StoreEntity> GetAllStore(DomainEntity.StoreEntity entity)
        {
            try
            {
                var storeList = new List <DomainEntity.StoreEntity>();
                using (StoreContext)
                {
                    if (StoreDBOPEN(Function.getStoreConnectionString(entity.login_entity), StoreContext))
                    {
                        string strgetStoreID = "SELECT MM770RSC.TBLFLD.TBLVAL FROM MM770RSC.TBLFLD WHERE MM770RSC.TBLFLD.TBLNAM = 'WMSRA' AND MM770RSC.TBLFLD.TBLVAL != '' ";
                        var    StoreCommand  = new OdbcCommand(strgetStoreID, StoreContext);
                        var    STRReader     = StoreCommand.ExecuteReader();

                        List <int> strnum = new List <int>();

                        while (STRReader.Read())
                        {
                            strnum.Add((int)STRReader.GetInt32(0));
                        }
                        string strNumString = string.Join(",", strnum);
                        STRReader.Close();
                        StoreCommand.Dispose();


                        using (JDAContext)
                        {
                            if (DBOPEN(Function.getConnectionString(entity.login_entity), JDAContext))
                            {
                                string querystring = "SELECT " + entity.login_entity.dBname + ".TBLSTR.STRNUM, "
                                                     + entity.login_entity.dBname + ".TBLSTR.REGNUM, "
                                                     + entity.login_entity.dBname + ".TBLSTR.STRDST, "
                                                     + entity.login_entity.dBname + ".TBLSTR.STRNAM, "
                                                     + entity.login_entity.dBname + ".TBLSTR.STMNGR, "
                                                     + entity.login_entity.dBname + ".TBLSTR.STRWHS "
                                                     + "FROM " + entity.login_entity.dBname + ".TBLSTR WHERE " + entity.login_entity.dBname + ".TBLSTR.STRNUM in(" + strNumString + ") ";
                                //+ "FETCH FIRST 50 ROWS ONLY";

                                var JDACommand = new OdbcCommand(querystring, JDAContext);
                                JDACommand.CommandTimeout = 0;
                                var JDAReader = JDACommand.ExecuteReader();
                                while (JDAReader.Read())
                                {
                                    var storeDetails = new DomainEntity.StoreEntity();
                                    storeDetails.store       = JDAReader.GetInt32(JDAReader.GetOrdinal("STRNUM"));
                                    storeDetails.region      = JDAReader.GetInt32(JDAReader.GetOrdinal("REGNUM"));
                                    storeDetails.district    = JDAReader.GetInt32(JDAReader.GetOrdinal("STRDST"));
                                    storeDetails.description = JDAReader.GetString(JDAReader.GetOrdinal("STRNAM"));
                                    storeDetails.manager     = JDAReader.GetString(JDAReader.GetOrdinal("STMNGR"));
                                    storeDetails.warehouse   = JDAReader.GetString(JDAReader.GetOrdinal("STRWHS"));
                                    storeList.Add(storeDetails);
                                }
                                JDAReader.Close();
                                JDACommand.Dispose();
                            }
                        }
                    }
                }
                return(storeList);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                JDAContext.Close();
                StoreContext.Close();
            }
        }
 public void Update(DomainEntity.StoreEntity entity)
 {
     throw new NotImplementedException();
 }