コード例 #1
0
        public DataSet delete(ClientEN cliente_borrado, int i)
        {
            string s;

            s = ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString();
            SqlConnection c      = new SqlConnection(s);
            DataSet       virtdb = new DataSet();

            try
            {
                SqlDataAdapter da = new SqlDataAdapter("select * from Client", c);
                da.Fill(virtdb, "client");
                DataTable t = new DataTable();
                t = virtdb.Tables["client"];

                t.Rows[i].Delete();

                SqlCommandBuilder cbuilder = new SqlCommandBuilder(da);
                da.Update(virtdb, "client");
            }
            catch (Exception ex)
            {
                ex.ToString();
                Console.WriteLine("ERROR Deleting the client");
            }
            finally
            {
                c.Close();
            }
            return(virtdb);
        }
コード例 #2
0
        //Method used in order to obtain information about a client
        public DataSet read_Client(ClientEN cl)
        {
            ClientCAD c  = new ClientCAD();
            DataSet   da = c.read(cl);

            return(da);
        }
コード例 #3
0
        //Method used in order to delete a cliente from the DB
        public DataSet delete_Client(ClientEN cl, int i)
        {
            ClientCAD c  = new ClientCAD();
            DataSet   da = c.delete(cl, i);

            return(da);
        }
コード例 #4
0
 //Copy constructor
 public OrderEN(int orderId, ClientEN client, ProductEN product, DateTime date, String address, int postalCode)
 {
     this.orderId    = orderId;
     this.client     = client;
     this.product    = product;
     this.date       = date;
     this.address    = address;
     this.postalCode = postalCode;
 }
コード例 #5
0
        public DataSet read(ClientEN cliente_leido)
        {
            string s;

            s = ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString();
            SqlConnection c      = new SqlConnection(s);
            DataSet       virtdb = new DataSet();

            try
            {
                SqlDataAdapter da = new SqlDataAdapter("select * from Client", c);
                da.Fill(virtdb, "client");
            }
            catch (Exception ex)
            {
                ex.ToString();
                Console.WriteLine("ERROR showing the client");
            }
            finally
            {
                c.Close();
            }
            return(virtdb);
        }