Wednesday, 20 April 2016

MVC JSON-GET method to Display

  public ActionResult Index(string id)
        {

            JSONHelper jhelpobj = new JSONHelper();
            DataSet ds = new DataSet();
            DataTable dt = new DataTable();
            XmlDocument xmlDoc = new XmlDocument();
            UserProfile lstModel = new UserProfile();
            var jsonSResult = jhelpobj.JSONGet(AppUrls.UserAccoluntDetails_GET.ToString() + id);
            if (jsonSResult != null && jsonSResult.ToString() != "")
            {
                xmlDoc = (XmlDocument)JsonConvert.DeserializeXmlNode(jsonSResult.ToString(), "UserDetail");
                ds.ReadXml(new XmlNodeReader(xmlDoc));
                dt = ds.Tables["UserDetail"];
                if (dt != null)
                {
                    lstModel.RegistrationSK = dt.Rows[0]["RegistrationSK"].ToString();
                    lstModel.Name = dt.Rows[0]["Name"].ToString().ToString();
                    lstModel.AboutMe = dt.Rows[0]["AboutMe"].ToString().ToString();
                    lstModel.Gender = dt.Rows[0]["Gender"].ToString().ToString();                  
                    if (lstModel.Gender == "M")
                    {
                        lstModel.Gender = "Male";
                    }
                    else if (lstModel.Gender == "F")
                    {
                        lstModel.Gender = "FeMale";
                    }
                    else
                    {
                        lstModel.Gender = "TransGender";
                    }
                    lstModel.UserPicture = dt.Rows[0]["UserPicture"].ToString().ToString();
                    if (lstModel.UserPicture != "" && lstModel.UserPicture != null)
                    {
                        byte[] decode = Convert.FromBase64String(lstModel.UserPicture);
                        MemoryStream ms = new System.IO.MemoryStream(decode);
                        Image img = System.Drawing.Image.FromStream(ms);
                        if (ImageFormat.Jpeg.Equals(img.RawFormat))
                        {
                            lstModel.UserPicture = String.Format("data:image/jpg;base64,{0}", Convert.ToBase64String(decode));
                        }
                        else if (ImageFormat.Png.Equals(img.RawFormat))
                        {
                            lstModel.UserPicture = String.Format("data:image/png;base64,{0}", Convert.ToBase64String(decode));
                        }
                        else if (ImageFormat.Gif.Equals(img.RawFormat))
                        {
                            lstModel.UserPicture = String.Format("data:image/gif;base64,{0}", Convert.ToBase64String(decode));
                        }
                        else if (ImageFormat.Bmp.Equals(img.RawFormat))
                        {
                            lstModel.UserPicture = String.Format("data:image/bmp;base64,{0}", Convert.ToBase64String(decode));
                        }
                    }
                    else
                    {
                        var UserPicture = "iVBORw0KGgoAAAANSUhEUgAAAfQAAAH0CAIAAABEtEjdAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyBpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuMC1jMDYwIDYxLjEzNDc3NywgMjAxMC8wMi8xMi0xNzozMjowMCAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENTNSBXaW5kb3dzIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOjZBMkJBOTUwOTAzMzExRTVBMDBGQzJDQTU3QTY2MjRBIiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOjZBMkJBOTUxOTAzMzExRTVBMDBGQzJDQTU3QTY2MjRBIj4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6NkEyQkE5NEU5MDMzMTFFNUEwMEZDMkNBNTdBNjYyNEEiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6NkEyQkE5NEY5MDMzMTFFNUEwMEZDMkNBNTdBNjYyNEEiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4cVA4gAAAobElEQVR42uyd51obSQJFrSwkhAj2vP/b7KvMtyYooIgEe6fvUNsWSYBCd9U5P/RpvLNjqHD6VuzKf/7znx8AABAXVYoAAAC5AwAAcgcAAOQOAADIHQAAkDsAAHIHAADkDgAAyB0AAJA7AAAgdwAA5A4AAMgdAACQOwAAIHcAAEDuAACA3AEAkDsAACB3AABA7gAAgNwBAAC5AwAgdwAAQO4AAFB46hQBFJNKpRI+w5/UarVGo1Gv18Nn+JNqtap/ofon+f/7Wzw9PT3+if9ktVo9PDysnnnI0Jf1eq1/If9/D58AyB3g3RFltSplN5vNRoY9rj+0xF96vPKMnwHbOD3/zNB/wYIOpjYvjW/py+954y+XS33qf6LiALkD/KHyvK9lcGm9leEv/pMDjBW2fCpI9E7xiwzJ3Z/6k40nAZULyB3SNbv03X5G3xXSXwbzQv3M+nk8ntAjp9vtBqHL+LL8PAfTNYDcIaVml5s0DyHdiq/VaqX4FRzzPZ+TJ8R5Wz7M1PuTqgfkDtEioXc6nbOzs5OMsBb648/l05Kih5N+KT2lPGsvoc9ms+l0OhqN9EWKpwEAcoeoorp855DezJDf9VmWnP7ZRJ9/kunX1O8u44epeaFQT5AH5A7llp0nphXVT09P5bj4hP5hlu9k6Pt6vVZ+v7+/Hw6HivOyPJPygNyhfGndNpfZFWCVXr2dMeUysehVDiqWh4eHyWRi15PiAblD0ZG+pTCZXU4/Pz9XYD/ALsZylY9Xj/VdhTMajVRWsry3z7N7EpA7FJFKpSKn9/t9fXpTo8xFsbyFykdlpSy/WCzk98FgoE8magC5Q4Gc7qOk3QwFdidT2LLc5PeTkxNP10ynU2+gxPKA3OH4CfTi4sKBvVarJT6x/jWazebV1ZWei15uVYpfLpcUCyB3OE7wVNJU6pTTT09P9YnWv0y4esFnu9rt9mQyUYqfzWYUDiB3OKiMWq2Wwubl5aW+oPVdoaGPt43O5/Obm5vr62t2TAJyhwMhm0tAvV7Pmx0pkH08OzUkktObzeZ4PB6NRszSAHKHvQf2fr+vzC65UyB7xQvUsrzivPy+WCzYKwnIHXZPpVI5Pz+/uLiQbtrtNgVyGFTav3790iDpLoMpGkDusEutNxoNRfWfP39K7hTIIVFsP83QF1XEeDxmoyQgd9hRQ6nXr66uZHY2sB+Rs7Mzlf/v379vbm64YBKQO3w3NvqGXgX2brdLgRz3ESuU2avVqvL7dDpdr9cUCyB3+DSSyMnJiadiGo0GBVIE9Ij1tcmyvPzOEisgd/gc0sdZRr/f5/Kv4uBblPW41aN3OBwqwrNLEpA7fGIGQFr/9etXr9fjgFIBabVaYQlEiufSYNgcdlME8BLfVnh5ecmNAoXuvdWqKujq6kqPYW7fBJI7fDDk9/F3pUJ9pvbWpDIOsPQY9rv9lN/X6zVbJAG5wyvI5uH0KWYvS35XZfl93KPRiPkZQO7wegwks5dusOUFEv8jfgfkDpuZ/fT09OLiQppgnr2kQ67Hx8f1en1/f8/+d0Du8O/QPizNkdlLmt+9WOL5mfF4zOQ7cgfMXm2328rs5+fnnFQqNc1mU5X48PCwWq3m8znnm5Lu1xQB1Ov1y8tLzB4HfuWhKpTNkcgdUje7t7Tzzo1oUFWqQlWt+B25Q7r4GCp3PUaGKlTVGrbQQIq5jSJI98GeTbUr4qGA+PDi6mKxmGcw+U5yh4SQ2a+urrjFN2JUuX59OUWB3CGh2O5d7fT8uJ/fkrsqmoMLyB1SGbOfnJz0er1Op0O3j/sRripWRcvyVDRyh/hpNps+r0RRpICvgeNGfuQO8ac5pmKTgskZ5A6pmF1RjvNKSaHqZhYuNdgKmVwnPz8/52qwBB/qqvSHjMViQYGQ3CE2Wq2WhufNZrNSqVAa6aDqVtUrvDPzjtwhQk5OTvr9PmPzZMO7ql4NgLUW5A6xZTcFN/VtzJ6y39UAzs7OGLchd4iHRqPR7XaV3biuPVlU9WoAp6enLKcjd4inV6tLn5ycENtpCWoGeszzjEfuEAPtdlvjcX1SFNBqtWgMyB1ioFKpKLarPzMYhx/ZBJ0ag8I7M+/IHcpNvV5XWGP7I/zb56tVtQcld2ZmkDuU2+yK7YppzLZD3u9eWeVVTcgdSjwG7/V6bG2GDXymiZk65A4l7sNnZ2ecS4RXGwZPfeQOJe7D3OUNr/T8avXk5AS5I3coa+8VrJvBWy2kncGzH7lDmZDTe70er0iFt6hUKmoeaiQ8/pE7lCyXqesquVMU8BadToedVMgdSkaz2VTXrdfrbG+Ht5K7mocaCXtmkDuUqd9K7uxihg+R2TnghtyhNGZvtVospcI2+Cox/I7coRxyV3flpRywlQKy06pqMMgduUMJaLfbyB0+JXeKArlDCbqr5N5qtZA7bNNaOOmG3KEc1Ov1RqPBKBu297saDCs0yB1KENvZ3AafQg2GoR5yhxL0UlIYfCETsHcWuUNx8dkl5A6fQlr3hkiKArlDcXspyR2+kNzVbEjuyB0Kndw5vgSfJRxloiiQOxQ3uXPaEL6W3FmHR+5Q3C7KTWHwncbDhhnkDkVEyYtpU/jOsI/wjtyhiMmr2Wwy2w5fRo1Hcie8I3coXM/kml/4ZhNiqxVyhyImd2IXfLMJMe2O3KGgyZ3YBV/GW61oQsgdipjc6ZnA4A+Qe2zJHbnD95sQckfuQM8E8gEgd9gzlUqFa9zh+02IfIDcoVjUMygH+GYrIrkjdyhW5lKfJLbDd41QrSJ35A4FopZBOQBtCZB7VGmLsyew2/DOKBC5Q1E6JHIH5A7IPSo84Y7cYYdBAbkjdyiE3A1FAYwCAblHBckddih3pmWQOxQluZO2YLfNCbkjdyhEbyS5ww6TO20JuUOB/E7Ugh3KneaE3IHkDhE2J+SO3KEQvZG0BbttSxQFcoeidEjMDruRAkEBuUOh/E5vBLICIHcAeJ2nDMoBuQMAAHIHgJLkdwoBuQMAAHIHAADkDlsOohlHww6bE4WA3AEAALkDAAByBwAA5J4ozJACAHLH7wC0JeQO5emQ9EmgLQFyj603PmbQJ2EnZl+v17Ql5A6F6JDqjZI7RQHfZ52B3JE7FAJiO+w2vNOckDsUojd6WoaigJ0EBSV3ygG5A3KHCJsTyR25QyFgzh122JaYc0fuQHKHOJsT5YDcoRC9kagFu4JttcgdSO6A3AG5w56TO3IHBoKA3ONMW5QDfB+CAnIH5A5xJnfaEnKHYgUuhtLwfbNzggm5Q+HCO90Svh8RiO3IHQon99VqRTnAd1ATQu7IHYood3omfKcJPTw80ISQO9AzgXwAyB0O0jOZdocvo8ZDPkDuQOyCCJsQC6rIHYrYM4ldQHIH5B4bXEIADP4AuUcbu5hzBwZ/gNyJXQB/5AOaEHKHwvH09LRYLDjHBN+Ru5oQckfuUDi5My0D30/ulANyhyL6nevD4Gt4HySNB7lDQVllUA7w2VhAy0HuUPSRNRse4AtyZ04PuUPRk/tyuUTu8NlMoGZDckfuQHIHkjsgdzh4BEPuQHJH7hAVnpYhgsGn8NlU5I7codByVy9lQxt8Vu4kd+QOJRhfk9zhC3JnNg+5Q6FB7vCFTKABH+WA3KEEHZUUBp+K7QQC5A4lwItjzLzDNmZ/yKAokDuUgGUG4R0+RAnArYWiQO5Qju66WCxI7rBNa1FTYYcVcodyoL5Kcodt8LSMWgtyR+5QgixGd4XtW8t8PmfOHblDObqrz6kid9gyCrD8jtyhNGNtNrfBNpADkDuUDF6ZBlvKnbUZ5A4lC+/z+ZzhNryFJ2TUSBjhIXcon9wXiwVFAW/JXc1DjYTHP3KHksl9Npux2x3eQc1DjYRpGeQOJZP7IgO5w/vJHbkjdyhf110ul5VKhdKAV1Hz4I455A7lk7vDO+dT4FV4lzpyhxLjd3cwMwMb+MHPPhnkDiVOZ7PZjA3vQMNA7hBbcp/P51zoChuwwx25Q+kD2nQ6Re6wgZoEyR25Q+mTO2uq8KrcSe7IHcpKeHEHmyIg4HvleEEHcofS92RveKcnw4/nAxA875E7xIAy2nQ6ZYIVfjzvk2GmDrlDDCim3d/f05/BT/rxeMyNcsgdIunPbI2AfHJnAxVyhxhYr9dsiATjfTJMuCN3iCe8c5EI6DHPdUPIHaKCPRIQ3t/CvinkDlGhwfh4PObcSsqxfTKZqBlQFMgdokKpjcnWxJP7dDpVM6AokDvEg4+qKrixrJosqnrJnYOpyB3i7N4cVU02tvugMkWB3CFCVqvV/f09L7xP0OyqdFU9Zx2QO8SJnD7JYOY9wXqfTqc81JE7RJvgZrOZ+jmdPLV6t9x5qCN3iDbB+SoCZt6TqvTwag4qHblDzHDVTFLwulTkDgnJfTQasd85EVTRqm6uHEDuED8+qcilr4mgilZ1k9yROyQh91kGVxFEj9+Qzslk5A4J+Z3bCKLHm6NU0dQycoeEUKAbDoccWYyYxWKhKlZFUxTIHdLq+YPBgDsCI0aVy/MbuQNjdogKZt6QO6SLr5qZTCasrMZn9ul0yiYZ5A5Jj9zH4zEKiO+xPRqNmG1H7pAuGrkPh0P2vEdZrZxTQ+6QLr4Mlpn3aHh6evJsO+9KRe6QOg8PD+PxmKsio5G7qlIVyn0DyB3gx/39/Wg0YuY9AhTbVZWqUIoCuUPq+AVsynq8oSmC2O43Li2XS+bZkDvAv3veWVktO15HZW87IHf4Pw8PD3d3dwznS42qT5XIbDsgd/gjvE8mE4d3JmfKWH2O7bwgF5A7vD6uZ6NFGVmtVqo4ZtUAucObcr+5ueFkY+lQlaniuAYOkDu8jt/Ax573cuEpNTazAnKH91iv1972zm1iZamv8XisKmOqHZA7fDzGv7291Rif/F5wVEGqJlUWM2mA3OFjwuQM4b0swyzWwAG5w8f4TNPd3R3WKPgzeDgc+nVazMnABnWKAN5CkbBer7fb7UajQWkUU+6cOwPkDp/GL3yQ3KvVqj4pkEIxn89vb2/ZIQNvwbQMfOB3GUQDf0b9hULVoUq5ubnB7IDc4YsSmU6nPtTO4mpB8CIqF4QBcofv4s12nH4sVHWw9xGQO3yX5XLphTtyYhHGUuPxeDAYsIsJkDvsQCjz+VxCYfnuuHjvo998zYMWkDvsBiX3v//+ezKZUBTHQoWvKmDvI2wDWyFhW5TZlRmbzWa9Xj85OalWSQYHHTz53kdVAaUBJHfYPYPB4Pr6erlcUhSHRAWuYlfhVyoVSgNI7rBjnp6evLiq2H51ddXpdCiTAzCZTJTZeX8eIHc4RIr8p/XU681mkwLZK4vFQmb//fs3S9nwKZiWgU/z+Pgo4wyHQ0lnPp9TIPvDL8ZSUSuzc/0ykNzhEEynU+/G+/nzZ61WY31150/Q9Xp9d3enzM6bUQG5w0Ht47ur9OXq6oqbxXbLcrn0PLvMzpZ2QO5waL+Px+OHh4dKpSK/N5tN9nJ8H69a66mpzM6sF3wZhtKwm4x5fX3NXo5dlae0riJlvymQ3OHI+X0ymTxlnJ+fdzod5t+/XJLT6fQug3vBALlDIZjNZn///bfC+19//dXtdimQr5Xhf//739vbW25XBuQORUGxfbVaDQYDfbm6ujo7O2P+/VOlNxqNrq+vuZoNkDsUkcVi8fv378fHR5ld+b1araL4D7XueS3Ps7OZHZA7FDqEKn4qvHsKnjJ5h9lspuGOX6uE2QG5Q6FZZszn8/V6LcvL7/U6LW3zEaiSkdA56AvIHcqneGvr8vJSEb5Wq1EmgcfHR41vbm9v7+/v2UIKyB1K5i+ZXeZSfpfoe71eq9VqNBqJF4sKZLFYjJ7h9CkgdyhxRJ1MJv1+37toUo7wes4pqmtAMxgMHjNoIYDcYfdUKpVOp6M0vVqtlLL3sQnPh5tkseFwKLXJ8vobTzKSKurZbDadTvWpEpDf97rfsV6vt9ttfWqUwGsRkTuk5XR9KkFLAZeXl/KszC757lU6Es3d3Z3+lm63e35+fnFx0Wq1ot8rqQebZ6XCudN9p3U5vdfraYSkytVfp+L1yrZ/GBo/coeYUbc/PT2VZKVXfVdyl989G77vWWDv6ZZrlGEV4aUhb4ePspz1a0qv4/F4miHJ7tvsemCrZq+urvTph7cKebFYeLigMqfxI3eIMK2rt/vdSYp1/X5fYs3HPSH1KNzJAns9/u4bVITUI+8o1XqvpBQfwXS856CERio2+2AwOMyF7MHsGhh576kf2/qiH0MPcj259ZOsM0jxyB0iQf3co3X1dvXzlxvPpQZJQX3eVjrAj+TJCnlHlld+148nN5U9xXtool9Kn17GONh1Ap5ke3XXqR6ffqh7Z72e31w5idyhzLVbr8vp/pTTpU4J9K3zRIr26v9Sg/Tk2eF9W0l/kY87eaVRKtSnt0v6Zy6L6J3TVVze5nifccg5EBWX9G2zv7rZtJahsrXl1Rj044WfmdtskDuUzOyKw/1+X/1Zmc5vwvtQl+r5v3790r98fX0tQx1sr56cKMsoVMpN3QwvCRZ/uVVjHT2WFNVVXErrEuWBJz1Up6pi1drFxcWH81r6F1Sweszrh9SPrceqytw/Nl0GuUPRp1/kRGU0bzdUt9f37RWpf1NPBQVAfznYJYVh07ezvLcMNjMc5PXFawZHL2HrWz+kY2/4gX1i6/CPcMlamV1P8W0Kx0svQqXq5XThbZq+MYLjssgdCocSnAyoUKbe3uv1vhN79d+RL/QflHD3vSn7JQ8ZysI/npcEw1PKu3qONV3j6Rep0PtPPI90RBvK5l5BVWb/QpmoeVjuYfDhFC/Lc7oKuUMhorqU54lU6U9fWhnf/M8q3Hk7jf6D6vOH2e/xquglGv3tipZO7p6OD/Py/kOn0R3+vd5S4r89zE37i/H3I75VQ1WsAZZ3PX3zaSfLq/HoPyLRO78LD0cI8sgdDoe6os/+OKqrW6p7dzJ2G2md333U6O7uzqY7/O9rz+afLl4b9GPMMzZh3kZ4vBJGLe8PX8LkuL/4zFFQuQmXXBYkz6o69FRT1fz8+VOVvqtliZAJvOFHZleW16eDvLd4soESucMekcXCCX71Rs+fer10Hw8S/S0a+Osvvbm5KchZdi8GOlrmH3X5L0H05mXhWFXGz4/HZ4LI/Bn+p4I0AG+M2d+Cs1do1bS63a4fq7MMDZ6ONYAD5B4nFreP+XiSVL3uYNezeH7Gq7LC21qOXia27TuLAfb7htytQsfPDbmXYpbZq+V61kruetzutdJF+Cssd8d5NQCXvD551ytyh+/GKHncQrdkt9nUuHOt/Pz5U2a5vr6+vb0t/vA8zCFsMy1TitkG/SJK679+/VJLOPCuIR8+OD09VUE5yHsj/wGuygHkHg/qw41n1Ie9Xy1sFDnuT+Utksp0DnEF79glEvc2D3g5/eLiot/vH37vfz5MhF228/l8kaEUHzaGMimP3OHNXqTOo4jkA6W+uHVjhfC4Dx7JRT/V3d2dIryCG535AGUus3u/46eOLOx1GOe7J/2yQFneQV6fnrSh1pA7/INv7wtbGNVzms8U8Py9N0dLNOre6syj0Yi7BveHtH52duaLd1TshWoGP56vrPCeVGURPfh9AYPvgwtXDQNyTyuOmXDri8/cl+UtdF7X1Y+tjn17e6vO7JVJanaHzUNPeu93LJTWXx1u5pf3/YaQcMmw52poHsg9FcLci8ifyindbyH16FdQfj/iQacom8dZhu/cL9cP7xSvH1ujDR/o9U4bBXlqFrlHWtbZXka/Ak1CdNctndBfjWxeG1BS8yW3zLp+uTzdPKTFi4sLKbK8TV04y/sGaT3+vU3ex3qZrkHuUfVbT7x4mbT2TBy/nbrxX3/91e/3B4PB3d0dGe3Lgd37Ybz0Ek2mUbNXm/fRs/tnSADIvdz4oLy3M6qJ+5KAKH9NLwt7ism7JhzTaAPbzGN4Od1vU1E7iem38/WiHqH64Kt7weIZUjxyL2tadxbzDQFxvwzavVeKPz8/H4/HivD7fiNrHM9FDebUSGT2Yu6P2nkL0ThPPWK5XA6HQzWSyWRCI0HuZRpfd57xmDSRX9xHnPxOVN8/7Htx2RX30uleevFtxmoke71OoFAtxEesfXWzesr0GRbkkXvR07pPcl5eXvoN9GmWg/fpK6DJ7IPBwO8U9SuKUt4SZ7WpVfhVU2onknv047m38LMtjPPUTo518yhyh48Du3TmTeu+r5FHnS8KDxHeGS3NuXi/6dTzEuHYWrJmzw9ifGBCJaMEwJ5a5F64fusFsaurK7/jAvJ+9zSrrwjP3xJeqKt09/Tre60l3LwvDnOdZ7m6z2mG2oZKTJ+sxiP3onRgz8P4jUgUyDsjG8c0n21RhPchxlgnanxVg1+l4tNqYd8IvIoKyq/wvrm5ubu7Y4oGuR+/98rs8jsF8uFT0HPx+t7tdqX1cLmgdO9XIHlevrztIbz2L7yBWg8zO4sG8CFejfc7xfRdEV7Ng3sLkPsRCG87I7B/oRv7hnp1XV8y5SBv15f0l1IzCDb3rHp4URQ1/in8fhg9Jq+vr9U8KBDkftAQKjf1+/2LiwumUL8WcsMLkkLIlRP9wtL826id6IvYebKEnr8ayOOS8PpDavk7z36/31EtZDgcshceuR/O7L5iW0RzTPzoovQ59R/ZS5TChVPhjRDhNc1FeCx5fin/HhW/SiX6I0gHxtv/1TBU77z1Cbkfom+rzUnr5+fnmH1Pz04nX6lz9Yzze/5LuIJqT9P0nkAPc+h+/IQvG99ZJt0TPjWi+lV13N/fM/+O3Peb2S8vL8nsh8nyG3/oGZswb5OfuvH5l43Ov40LNibEw/nJ4G7PuihChi/UziHxO8E9pCv+yx2Re1lRovS750lqx8pxPlIQ9shL3/70l40/zP9PGwYPeMEzfJqN/yn/59TCUepdnU71+Pv3b978hdx3T7fbVQvzqywpjaOQX4Z9n7zo82yYPe9uirfI9e73UqlCb29vp9MpZYLcd4bPVvz8+ZPZmLLowDPm78/MkMRLRLPZ/PXr13q95qJg5L7LUeH5+fnV1RWZvURyR9+R4ZV25feHh4fhcKhPygS5f5dut6vIENlbFADKyOnpqTfLyu+UxnvPQorgwwDodyl0Oh0yIEARuqTfgaNPuiTJ/es0m03fG8OBQ4CCoM6oLukTD9wPTHL/Uulk19UqufuSEAoEoCDh3e/58tsCKBDk/ukG1Ol0fHUMZgcoWvDqdruJv8oKuX+dXq+n1sN5JYACUqvVlL3Ozs4oCuT+uXbjt1zyIjSAwo6t1T3VSbkuH7l/AjUaZfZ2u01RABS/q3LhD3LfFs+202IAii/3y8tLzqAg961oNBqnp6dqLoz1AAqOZ1AF94Ig94/N7lk8igKgREPtXq/H3gfk/h7tdps35wGUC3VYdVsWyZD7e/hwBBEAoESow/qwIUWB3F/Bx9663S7bHwFKJrJqVbHdM+90XuT+ysO/1+t1Oh3e0whQOtRtPfPOPgjkvonaRL/f18Of2yoAyhje1XnVhZlTRe6baEB3cnLChiqAktJsNhXe6cLI/f9UKhWbnQUZgAgimsI7M+/I/V+5q0GcnZ0xWwdQatSFfRUwckfu/6LRHLPtAHHInUOIyP1fNIhTa+Dif4DSGy3bE8k9kcj9XxqNBrPtANH4Xd2ZZVXk/o/ZWWEHiAlvm0l8TyRy/+cyGe4bAIgJ30aQ+FUzyP2f+6DVDkjuAMgducdDpVJRC2ApFSAmarWaOrVyG3JP+gmvzI7ZAeLze7PZTHm6NWmpyemcSgWIFXXtlAflSctdmb3dbrOUChDruDzlDp663LvdLskdINbknvIbPJKWe61W04OdfTIAsSb3VquV7FHV1JM7+2QAIk5vKV/ina7X/FI9YjtA3AGOaZnEfu1qVeM11Tr3ggLE3dPld3X2BAfoicpd47VOp6Mq53WpABGjDu5LIpF7Qs9zVTn7ZACiR91cnT3BZdXUkzvTMgAR46U1kntayT3lPVIA6ZDshshqsvXdaDSI7QCJhPcEz6mmKHe/qIXt7QDpdPkEw1xyglMFe+srsR0gqfCemt/TW2TIZttZSgVISu7q8u12G7nzDAcAej1y5xkOAIXv9amN11NcVGTOHSA1uTcykur16W0PYqsMQHpy9273pDp+co6rZ9DcARLs+0kdZUpL7o7tHEwFSBC/Mjud8J6W3BMcmgFAyHZJvVI1Lc15KRW5AySIl1WRO3IHgKio1WoauKfz8rVqarXL8SWAZJN7UmuqzLkDQBqyy64eIblHK3dVLXIHSFPuzLlHW7WpbXQFgDzq/pJAIhOzycmd9g2QLNJ6LQO5R1WpGpER2wEI74nsqkjmsBYvTQWA5w2RKSy8VdOpUZZSAcAqSCHnpSK7ZN+ADgAbck/kfdkJTcsw5w4A6QziE0ru3AcJAJ5zJ7nHNhZD7gCJk84gPi25c6sMAHJPZPktrd0ytGwAILlH9azmbCoA5NNe9Guq8cs9tRv6AWCb8B79OdUE9gPx3lQAeJHco98QmYrcSe4AEEjh1Q5JyJ1pGQAguccpd6ZlACCf3JF7DHJnWgYAkHuEcucFTACQh2mZeJI7l/0CQFJaSCW505oBYCO8s8+99FVIbAeAl2aIO/bFfgCX2A4ASSa/mOWuMZfXxLkMEgBe+sEnYGL1Q+Ry9yZI5A4AL4n7hpn4kzvTMgDwqh887Y7cGXYBQGx+iPgdPiR3AEgUH29E7mV9MrOgCgBvhT/m3EnuABBhco942jZm8Tm5c4IJAF71g2+YIbmXtfJoxADwTnhH7uWjlkHzBYA3DVitxmqJmOXOJkgA+FDusS7LVeOuM+QOAB8O8aNcmYtT7mGfDHIHgA9dEeXMTMzJPfr7mgHg+3L34lx8rohW7iR3ANgmBTYaDZJ7yeoMuQPAlskduZemwkjuALClK5iWKRNxX+YJALuVO8m9THJnQRUAPpQ70zLlkzv3QQLAh3L3Wx+Qe3l+MbZCAsB2yZ1DTGWqMD2KuQ8SALYZ5Ue5Phet3LkyDAC2H+iT3EvzKCa2A8D2co8vDkYrd2bbAWB7uce3phqh3CNeIQGA/UkjskQY40wTFw8AwCelEV8ijDO5q5KQOwCQ3KOCiwcA4AtyJ7mT3AEAuSP3w/9K2Zw7C6oAsL00kHs56onkDgCfTe7MuVNPABCbNBwKkTsjLACILREi93LIneQOACkP95E7AKQOC6o8hAEg2uSO3HkIAwByR+5HqifaKwCkPNyPdp877RUAtofkjtwBIELiO/kYmwQrGbRUAPiCPZA7j18AYNCP3EnuAFAGeyB3kjsARCj3mOyB3AEASO48ewEAuSN3kjsAIHfkjtwBALkj9zfkzgkmAPia3FlQLXT10EYBgOROcgcAQO5lkDttFAC+JnemZUjuAEByR+48ewGAaIjcv1k9yB0ASO7slgEAiFAgTE8DAPzL09MTcqduACA2eyB3qgcASO7InboBAOyB3EnuAHAUezw+PiL3grJardbrNc0UAD6LzC6BIPeCslgsYqoeADhkNFwul8i9oKhuSO4A8DW5Kx0i94LykBHTxBkAHABJQ+pgWqboj19VEsuqALAl0oWkEdmgP0K5z2az4XCoqqLJAsCWI/7BYDCdTpF70eWueopp7gwA9op0IWlIHci90KxWq/v7ez2EWVkFgA+RKCYZTMvgdwCIxxXSunQR3xbqOOX++Pg4Go2ur68jG2cBwG6Zz+cSxXg8jm+LXT3WOlssFre3t/V6vVqtNhoNfeGqdwAwT09PPrJ0d3cnUUR58rEecf2pwm5ubmT5s7Ozi4sLKZ42DQA/stOOg8FA4/v4ptqTkLsezhpzSe4+ttrr9eT3ZrNJhAdINrDLBg8PD9K6Avv9/X3Ev2w9herUw1k1Oh6P+/3++fl5q9WilQMkG9iHw6GcEP1RmHoKNbrO8M0ECvLtdlt+V4TXZ0zvwwWAlzw+Pnr4rs/ZbKa0LrOncENJPZ06lt8V3lWv9Xq92+2enp6enZ2dnJzoH+kAAFGyWq0k9NFoZKfrH9O5eCo5r6lq9Qz3w1yV7Vl4RXjFeYm+VqvRHwDKHuMk9LDepvG6vutLapeBJxpaVxm+SqJarW4E+UoOugpAwXnKsRHVU74glhmJf7K8LK8Hu1qDgvxJRqfTUZZH7gClkPssh6K6c3riV38j93/HccJ3jcnvMruyvBTfarV8DMqfrL4CFCSQ+ZV4/pzP53L6NIPrYJH7m/heGrUVqbxWq8nvsvzp6akn5SkfgKOjHCahu5/qu8OZjU/hIPf3hnhuK/7H6TO2vLO87zNg9RXgYGNrv4THb8Kz0/3Ja3mQ+9dd7zV3fXeQ73Q6CvKel8fvAAcYTHsy3Ve9Oqr/eF5HpXyQ+7f87jbktyxK9BoSeg9lPUNfGhncbQDw/e7m/YthXdQ3fIUdjRQRct8Xy4zwj94jLxTkFef1RXHeimczJcD24ckzomF1dJ7BK9WQ+9HwINHLO07xPhUVwO8A75h9kcPJyWnd8+wUEXI/Jm6LIWJI8V569WZ5uV5ZvlqtyvL5T8oNUvP44+Nj/tPzLY7qXiDF5si90ChxeFA5Ho+9O94z8jK+RO9ry7hcHhLMQN7CKKH7qJF4/BNKCbkXPaHkN1MaKd4p3hdSmtqfUHQQU8TJs3zGcy9SPCpH7vEY3wtEXmWV6y16T+D4kzgPceCdLV4O9d0evq0vv3ZKKSH3eOS+0aDDbGPYTOmDUaKeA+NDwT2+yhHenRD2L/o9aBQUck8L94f8nzjRewInP0cf1mBZiYWjx5Qfz6uj+Tl0hxUndEoJucMm6hjqITK+8vtkMgkpPpyZCienSPRwlITurYpO5fk9i+xcRO6wbaLPH99Qcg+vBgzrsZ7J8f/64/nMFDfRw5cjeR5HDbdGz65srIgyb47cYTeJXp1KfczXVRoZ3NE+XH4QPnl3IHwWz5WHiXJvVXQk9yRMHsyO3GGXfn9rNtM2936b4Hdh+3tzTv6RQGGmHM83HG13h7tcwnvkHdgpMeQOx8TxSj0zTMhY60H0YTKHDZc0lXDK32NBC92K//Hn5AzFhdzh+HHs1a7ofZZhATb/mT885UTvLxRmHIO88PKK/EkiT7PkP1/u1wLkDqVJau69+dmYcMFZWJgNu3H0BcWXWuv5y3LzC6H+k3wgoLiQO0SS7sP3MK+aD+8bWd4nqsJn+BNK8uh406Ev3spvQ9zI6fl/JJ4jd0gx1L9EEs9vqw+h3rM63oqTP1T18hO+8wx+6zM/qRJ2s4SN5xwEBeQOH2fDsJ05v80mfPdq7cZNCSHp4/cvmz2fxPNn+r3mmd/lsrHphXOhgNxhKyyLd8Jg2GIfFmzzxg/Pg1f58eeRq+hjeP7CrFfxFIqnVuzxsOAZNpvTJgG5w4Hsb++8lLX/JD9xvzGJH/4wzO/HOgAKG1fCpVr5KfL89x+vnRFlVyIgdzhCLN1GOt5xn/d4/h/zuzA3wv5G8H/1+bHX+P+WZ1/9k3CfbX7CJL8fMXwJK5+WOw0JkDuU9RngdB+OO74qYv9h7TXCRQsvp/43CP8p/2v6qz/0vnXsfzl/qv7xDYK7fern5aYU/+OPN/Ya5v+QPA7IHWJQ/IdSCxbOp3L/+xa3RbyxDT/814Kjw+f70f5lDLe7/X8P8+Avr1XZID/3Er4gbkDuAP+3bXglG6UB8E04iwgAgNwBAAC5AwAAcgcAAOQOAADIHQAAuQMAAHIHAADkDgAAyB0AAJA7AABypwgAAJA7AAAgdwAAQO4AAIDcAQAAuQMAIHcAAEDuAACA3AEAALkDAMCn+J8AAwCfrCyAgDFOtQAAAABJRU5ErkJggg==";
                        byte[] decode = Convert.FromBase64String(UserPicture);
                        MemoryStream ms = new System.IO.MemoryStream(decode);
                        Image img = System.Drawing.Image.FromStream(ms);
                        lstModel.UserPicture = String.Format("data:image/bmp;base64,{0}", Convert.ToBase64String(decode));
                    }
                }
                //UserAddress
                dt = ds.Tables["UserAddress"];
                if (dt != null)
                {                  
                    lstModel.City = dt.Rows[0]["CityDesc"].ToString();
                    lstModel.State = dt.Rows[0]["StateDesc"].ToString();                  
                }
                //UserType
                dt = ds.Tables["UserTypeList"];
                if (dt != null)
                {
                    for (int i = 0; i < dt.Rows.Count; i++)
                    {
                        lstModel.UserType += dt.Rows[i]["UserTypeDesc"].ToString() + ",";
                    }
                    lstModel.UserType = lstModel.UserType.TrimEnd(',');
                }
                //UserLanguage
                dt = ds.Tables["UserLanguageList"];
                if (dt != null)
                {
                    string Lang = "";
                    for (int i = 0; i < dt.Rows.Count; i++)
                    {
                        Lang += dt.Rows[i]["LanguageDesc"].ToString() + ",";
                    }
                    lstModel.Language = Lang.TrimEnd(',');
                }
            }
            return View(lstModel);
        }

No comments: