Exemple #1
0
        public static string GetRow(string RowId)
        {
            if (HttpContext.Current.Session["UserName"] == null)
            {
                return("Error: You are not logged-in.");
            }

            DBClass db = new DBClass("Muntazm");

            db.Con.Open();
            db.Com.CommandText = "SELECT [CurCode],[CurDesc] FROM [Currencies] WHERE [CurCode] ='" + RowId + "'";
            SqlDataReader        dr          = db.Com.ExecuteReader();
            JavaScriptSerializer serailizer  = new JavaScriptSerializer();
            SurchResult          SurchResult = new SurchResult();

            if (dr.HasRows)
            {
                while (dr.Read())
                {
                    SurchResult.SurCode        = dr[0].ToString();
                    SurchResult.SurDescription = dr[1].ToString();
                    //curriencies.DecimalDescription = dr[2].ToString();
                    //curriencies.Status = dr[3].ToString();
                }
            }

            if (dr.IsClosed == false)
            {
                dr.Close();
            }

            db.Con.Close();
            db = null;
            return(serailizer.Serialize(SurchResult));
        }
        public static string GetRow(string RowId)
        {
            if (HttpContext.Current.Session["UserName"] == null)
            {
                return "Error: You are not logged-in.";
            }

            DBClass db = new DBClass("Muntazm");
            db.Con.Open();
            db.Com.CommandText = "SELECT [CurCode],[CurDesc] FROM [Currencies] WHERE [CurCode] ='"+ RowId +"'";
            SqlDataReader dr = db.Com.ExecuteReader();
            JavaScriptSerializer serailizer = new JavaScriptSerializer();
            SurchResult SurchResult = new SurchResult();
            if (dr.HasRows)
            {
                while (dr.Read())
                {
                    SurchResult.SurCode = dr[0].ToString();
                    SurchResult.SurDescription = dr[1].ToString();
                    //curriencies.DecimalDescription = dr[2].ToString();
                    //curriencies.Status = dr[3].ToString();

                }
            }

            if (dr.IsClosed == false)
                dr.Close();

            db.Con.Close();
            db = null;
            return serailizer.Serialize(SurchResult);
        }