Example #1
0
        public DealerCustomerBLL GetDeaCustIFromName(string name)
        {
            DealerCustomerBLL dc  = new DealerCustomerBLL();
            SqlConnection     con = new SqlConnection(this.connect.connection);
            DataTable         dt  = new DataTable();

            try
            {
                string sql = "SELECT [id]" +
                             ",[type]" +
                             ",[name]" +
                             ",[email]" +
                             ",[contact]" +
                             ",[address]" +
                             ",[addeddate]" +
                             ",[addedby]" +
                             "FROM[dbo].[tbldeacust]" +
                             "WHERE name " + name;
            }

            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
            }
            finally
            {
                con.Close();
            }
            return(dc);
        }
Example #2
0
        public bool Delete(DealerCustomerBLL bd)
        {
            SqlConnection con       = new SqlConnection(this.connect.connection);
            bool          isSuccess = false;

            try
            {
                string     sql = "DELETE FROM tbldeacust WHERE id=@id";
                SqlCommand cmd = new SqlCommand(sql, con);
                cmd.Parameters.AddWithValue("@id", bd.ID);
                con.Open();
                int rows = cmd.ExecuteNonQuery();
                if (rows > 0)
                {
                    isSuccess = true;
                }
                else
                {
                    isSuccess = false;
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
            }
            finally
            {
                con.Close();
            }


            return(isSuccess);
        }
Example #3
0
        public bool Insert(DealerCustomerBLL bi)
        {
            bool          isSuccess = false;
            SqlConnection con       = new SqlConnection(this.connect.connection);

            try
            {
                string sql = "INSERT INTO [dbo].[tbldeacust]" +
                             "([type]" +
                             ",[name]" +
                             ",[email]" +
                             ",[contact]" +
                             ",[address]" +
                             ",[addeddate]" +
                             ",[addedby])" +
                             "VALUES" +
                             "(@type," +
                             "@name," +
                             "@email," +
                             "@contact," +
                             "@address," +
                             "@addeddate," +
                             "@addedby)";
                SqlCommand cmd = new SqlCommand(sql, con);
                cmd.Parameters.AddWithValue("@type", bi.Type);
                cmd.Parameters.AddWithValue("@name", bi.Name);
                cmd.Parameters.AddWithValue("@email", bi.Email);
                cmd.Parameters.AddWithValue("@contact", bi.Contact);
                cmd.Parameters.AddWithValue("@address", bi.Address);
                cmd.Parameters.AddWithValue("@addeddate", bi.AddedDate);
                cmd.Parameters.AddWithValue("@addedby", bi.AddedBy);
                con.Open();
                int rows = cmd.ExecuteNonQuery();
                if (rows > 0)
                {
                    isSuccess = true;
                }
                else
                {
                    isSuccess = false;
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
            }
            finally {
                con.Close();
            }
            return(isSuccess);
        }
Example #4
0
        public bool Update(DealerCustomerBLL bu)
        {
            SqlConnection con       = new SqlConnection(this.connect.connection);
            bool          isSuccess = false;

            try
            {
                string sql = "UPDATE [dbo].[tbldeacust]" +
                             "SET[type] = @type," +
                             "[name] = @name," +
                             "[email] = @email," +
                             "[contact] = @contact," +
                             "[address] = @address," +
                             "[addeddate] = @addeddate," +
                             "[addedby] = @addedby," +
                             "WHERE id = @id";
                SqlCommand cmd = new SqlCommand(sql, con);
                cmd.Parameters.AddWithValue("@type", bu.Type);
                cmd.Parameters.AddWithValue("@name", bu.Name);
                cmd.Parameters.AddWithValue("@email", bu.Email);
                cmd.Parameters.AddWithValue("@contact", bu.Contact);
                cmd.Parameters.AddWithValue("@address", bu.Address);
                cmd.Parameters.AddWithValue("@addeddate", bu.AddedDate);
                cmd.Parameters.AddWithValue("@addedby", bu.AddedBy);
                con.Open();
                int rows = cmd.ExecuteNonQuery();
                if (rows > 0)
                {
                    isSuccess = true;
                }
                else
                {
                    isSuccess = false;
                }
            }

            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
            }
            finally
            {
                con.Close();
            }
            return(isSuccess);
        }
        public bool Update(DealerCustomerBLL dc)
        {
            bool isSuccess = false;

            SqlConnection conn = new SqlConnection(myconnstring);

            try
            {
                String     sql = "UPDATE table_dealer_customer SET type=@type, name=@name, email=@email, contact=@contact, address=@address, added_date=@added_date, added_by=@added_by WHERE id = @id";
                SqlCommand cmd = new SqlCommand(sql, conn);

                cmd.Parameters.AddWithValue("@type", dc.type);
                cmd.Parameters.AddWithValue("@name", dc.name);
                cmd.Parameters.AddWithValue("@email", dc.email);
                cmd.Parameters.AddWithValue("@contact", dc.contact);
                cmd.Parameters.AddWithValue("@address", dc.address);
                cmd.Parameters.AddWithValue("@added_date", dc.added_date);
                cmd.Parameters.AddWithValue("@added_by", dc.added_by);
                cmd.Parameters.AddWithValue("@id", dc.id);

                conn.Open();

                int rows = cmd.ExecuteNonQuery();

                if (rows > 0)
                {
                    isSuccess = true;
                }
                else
                {
                    isSuccess = false;
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
            finally
            {
                conn.Close();
            }

            return(isSuccess);
        }
        public bool Insert(DealerCustomerBLL dc)
        {
            bool isSuccess = false;

            SqlConnection conn = new SqlConnection(myconnstring);

            try
            {
                String     sql = "INSERT INTO table_dealer_customer (type, name, email, contact, address, added_date, added_by) VALUES (@type, @name, @email, @contact, @address, @added_date, @added_by)";
                SqlCommand cmd = new SqlCommand(sql, conn);

                cmd.Parameters.AddWithValue("@type", dc.type);
                cmd.Parameters.AddWithValue("@name", dc.name);
                cmd.Parameters.AddWithValue("@email", dc.email);
                cmd.Parameters.AddWithValue("@contact", dc.contact);
                cmd.Parameters.AddWithValue("@address", dc.address);
                cmd.Parameters.AddWithValue("@added_date", dc.added_date);
                cmd.Parameters.AddWithValue("@added_by", dc.added_by);

                conn.Open();

                int rows = cmd.ExecuteNonQuery();

                if (rows > 0)
                {
                    isSuccess = true;
                }
                else
                {
                    isSuccess = false;
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
            finally
            {
                conn.Close();
            }

            return(isSuccess);
        }
Example #7
0
        public DealerCustomerBLL SearchDealerCustomerForTransaction(string keywords)
        {
            DealerCustomerBLL dc  = new DealerCustomerBLL();
            SqlConnection     con = new SqlConnection(this.connect.connection);

            DataTable dt = new DataTable();

            try
            {
                string sql = "SELECT [id]" +
                             ",[type]" +
                             ",[name]" +
                             ",[email]" +
                             ",[contact]" +
                             ",[address]" +
                             ",[addeddate]" +
                             ",[addedby]" +
                             "FROM[dbo].[tbldeacust]" +
                             "WHERE id LIKE '%" + keywords + "%' OR name LIKE '%" + keywords + "%'";
                SqlDataAdapter da = new SqlDataAdapter(sql, con);
                con.Open();
                da.Fill(dt);
                if (dt.Rows.Count > 0)
                {
                    dc.Name    = dt.Rows[0]["name"].ToString();
                    dc.Email   = dt.Rows[0]["email"].ToString();
                    dc.Contact = dt.Rows[0]["contact"].ToString();
                    dc.Address = dt.Rows[0]["address"].ToString();
                }
            }
            catch (Exception ex) {
                MessageBox.Show(ex.ToString());
            }
            finally {
                con.Close();
            }

            return(dc);
        }
        public bool Delete(DealerCustomerBLL dc)
        {
            bool isSuccess = false;

            SqlConnection conn = new SqlConnection(myconnstring);

            try
            {
                string sql = "DELETE FROM table_dealer_customer WHERE id = @id";

                SqlCommand cmd = new SqlCommand(sql, conn);

                cmd.Parameters.AddWithValue("@id", dc.id);

                conn.Open();

                int rows = cmd.ExecuteNonQuery();

                if (rows > 0)
                {
                    isSuccess = true;
                }
                else
                {
                    isSuccess = false;
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
            finally
            {
                conn.Close();
            }

            return(isSuccess);
        }