Example #1
0
        public System.Data.DataTable  GetActiveAuthorPaintingsInDataTable(AuthorPaintings authorpaintings, string MatchWith)
        {
            SqlConnection con = new SqlConnection(DBHelper.GetConnectionString());

            if (con.State == System.Data.ConnectionState.Closed)
            {
                con.Open();
            }
            string query = " Select  paintingid,authorid From tblauthorpaintings ";

            switch (MatchWith.ToLower())
            {
            case "paintingid":
                query += " where paintingid=" + authorpaintings.PaintingID + " and Is_Active='true' ";
                break;

            case "authorid":
                query += " where authorid=" + authorpaintings.AuthorID + " and Is_Active='true' ";
                break;
            }
            SqlDataAdapter da = new SqlDataAdapter(query, con);

            System.Data.DataTable tblauthorpaintings = new System.Data.DataTable();
            da.Fill(tblauthorpaintings);
            if (con.State == System.Data.ConnectionState.Open)
            {
                con.Close();
            }
            return(tblauthorpaintings);
        }
Example #2
0
        public List <AuthorPaintings> GetAuthorPaintingsInList()
        {
            SqlConnection con = new SqlConnection(DBHelper.GetConnectionString());

            if (con.State == System.Data.ConnectionState.Closed)
            {
                con.Open();
            }
            string                 query              = " Select paintingid,authorid From tblauthorpaintings";
            SqlCommand             cmd                = new SqlCommand(query, con);
            SqlDataReader          reader             = cmd.ExecuteReader();
            List <AuthorPaintings> lstauthorpaintings = new List <AuthorPaintings>();

            while (reader.Read())
            {
                AuthorPaintings authorpaintings = new AuthorPaintings();
                authorpaintings.PaintingID = Convert.ToInt32(reader["paintingid"]);
                authorpaintings.AuthorID   = Convert.ToInt32(reader["authorid"]);
                lstauthorpaintings.Add(authorpaintings);
            }
            reader.Close();
            if (con.State == System.Data.ConnectionState.Open)
            {
                con.Close();
            }
            cmd.Dispose();
            return(lstauthorpaintings);
        }
Example #3
0
        public AuthorPaintings GetAuthorPaintingsInObjectUsingID(AuthorPaintings authorpaintings)
        {
            SqlConnection con = new SqlConnection(DBHelper.GetConnectionString());

            if (con.State == System.Data.ConnectionState.Closed)
            {
                con.Open();
            }
            string        query  = " Select  paintingid,authorid From tblauthorpaintings where paintingid=" + authorpaintings.PaintingID + "";
            SqlCommand    cmd    = new SqlCommand(query, con);
            SqlDataReader reader = cmd.ExecuteReader();

            while (reader.Read())
            {
                authorpaintings.PaintingID = Convert.ToInt32(reader["paintingid"]);
                authorpaintings.AuthorID   = Convert.ToInt32(reader["authorid"]);
            }
            reader.Close();
            if (con.State == System.Data.ConnectionState.Open)
            {
                con.Close();
            }
            cmd.Dispose();
            return(authorpaintings);
        }
Example #4
0
        public bool InsertUpdate(AuthorPaintings authorpaintings)
        {
            SqlConnection con = new SqlConnection(DBHelper.GetConnectionString());

            if (con.State == System.Data.ConnectionState.Closed)
            {
                con.Open();
            }
            string     query = " select count(*) from tblAuthorPaintings where paintingid=" + authorpaintings.PaintingID + "";
            SqlCommand cmd   = new SqlCommand(query, con);
            int        c     = cmd.ExecuteScalar() == DBNull.Value?0:Convert.ToInt32(cmd.ExecuteScalar());

            if (con.State == System.Data.ConnectionState.Open)
            {
                con.Close();
            }
            cmd.Dispose();
            return(c == 0?this.Insert(authorpaintings):this.Update(authorpaintings));
        }
Example #5
0
        public bool Insert(AuthorPaintings authorpaintings)
        {
            SqlConnection con = new SqlConnection(DBHelper.GetConnectionString());

            if (con.State == System.Data.ConnectionState.Closed)
            {
                con.Open();
            }
            string     query = " insert into tblAuthorPaintings(paintingid,authorid)values(" + authorpaintings.PaintingID + "," + authorpaintings.AuthorID + ")";
            SqlCommand cmd   = new SqlCommand(query, con);

            cmd.ExecuteNonQuery();
            if (con.State == System.Data.ConnectionState.Open)
            {
                con.Close();
            }
            cmd.Dispose();
            return(true);
        }
Example #6
0
        public bool Update(AuthorPaintings authorpaintings)
        {
            SqlConnection con = new SqlConnection(DBHelper.GetConnectionString());

            if (con.State == System.Data.ConnectionState.Closed)
            {
                con.Open();
            }
            string     query = " update  tblAuthorPaintings set authorid=" + authorpaintings.AuthorID + " where paintingid=" + authorpaintings.PaintingID + "";
            SqlCommand cmd   = new SqlCommand(query, con);

            cmd.ExecuteNonQuery();
            if (con.State == System.Data.ConnectionState.Open)
            {
                con.Close();
            }
            cmd.Dispose();

            return(true);
        }
Example #7
0
        public List <AuthorPaintings> GetAuthorPaintingsInList(AuthorPaintings authorpaintings, string MatchWith)
        {
            string query = " Select paintingid,authorid From tblauthorpaintings "; switch (MatchWith.ToLower())
            {
            case "paintingid":
                query += " where paintingid=" + authorpaintings.PaintingID + "";
                break;

            case "authorid":
                query += " where authorid=" + authorpaintings.AuthorID + "";
                break;
            }
            SqlConnection con = new SqlConnection(DBHelper.GetConnectionString());

            if (con.State == System.Data.ConnectionState.Closed)
            {
                con.Open();
            }
            SqlCommand             cmd                = new SqlCommand(query, con);
            SqlDataReader          reader             = cmd.ExecuteReader();
            List <AuthorPaintings> lstauthorpaintings = new List <AuthorPaintings>();

            while (reader.Read())
            {
                authorpaintings            = new AuthorPaintings();
                authorpaintings.PaintingID = Convert.ToInt32(reader["paintingid"]);
                authorpaintings.AuthorID   = Convert.ToInt32(reader["authorid"]);
                lstauthorpaintings.Add(authorpaintings);
            }
            reader.Close();
            if (con.State == System.Data.ConnectionState.Open)
            {
                con.Close();
            }
            cmd.Dispose();
            return(lstauthorpaintings);
        }
Example #8
0
 public System.Data.DataTable  GetAuthorPaintingsInDataTable(AuthorPaintings authorpaintings, string MatchWith)
 {
     return(new DAL.AuthorPaintingsDAL().GetAuthorPaintingsInDataTable(authorpaintings, MatchWith));
 }
Example #9
0
///<summary>
///This Method will Get record of AuthorPaintings  From your database in a Single Object of Class AuthorPaintings.
///Return Object if record Found other wise will throw an Execption of Type SQLExecption or return false in any other Problem
///Your are using Beta Version of Rapid Development (by Raees Ul Islam 0345-7294449
///</summary>
///</param name=AuthorPaintings>This is an Object of your Class AuthorPaintings</param>
        public AuthorPaintings GetAuthorPaintingsInObjectUsingID(AuthorPaintings authorpaintings)
        {
            return(new DAL.AuthorPaintingsDAL().GetAuthorPaintingsInObjectUsingID(authorpaintings));
        }
Example #10
0
///<summary>
///This Method will Delete and record of AuthorPaintings  in your database.
///Return true when data will Delete to your Data base other wise will throw an Execption of Type SQLExecption or return false in any other Problem
///Your are using Beta Version of Rapid Development (by Raees Ul Islam 0345-7294449
///</summary>
///</param name=AuthorPaintings>This is an Object of your Class AuthorPaintings</param>
        public bool Delete(AuthorPaintings authorpaintings)
        {
            return(new DAL.AuthorPaintingsDAL().Delete(authorpaintings));
        }
Example #11
0
///<summary>
///This Method will Update and record of AuthorPaintings  in your database.
///Return true when data will update to your Data base other wise will throw an Execption of Type SQLExecption or return false in any other Problem
///Your are using Beta Version of Rapid Development (by Raees Ul Islam 0345-7294449
///</summary>
///</param name=AuthorPaintings>This is an Object of your Class AuthorPaintings</param>
        public bool Update(AuthorPaintings authorpaintings)
        {
            return(new DAL.AuthorPaintingsDAL().Update(authorpaintings));
        }
Example #12
0
///<summary>
///This Method will insert and record of AuthorPaintings  in your database.
///Return true when data will insert to your Data base other wise will throw an Execption of Type SQLExecption or return false in any other Problem
///Your are using Beta Version of Rapid Development (by Raees Ul Islam 0345-7294449
///</summary>
///</param name=AuthorPaintings>This is an Object of your Class AuthorPaintings</param>
        public bool Insert(AuthorPaintings authorpaintings)
        {
            return(new DAL.AuthorPaintingsDAL().Insert(authorpaintings));
        }
Example #13
0
 public List <AuthorPaintings> GetAuthorPaintingsInList(AuthorPaintings authorpaintings, string MatchWith)
 {
     return(new DAL.AuthorPaintingsDAL().GetAuthorPaintingsInList(authorpaintings, MatchWith));
 }