public bool Delete_dbf(string empresaid, tb_cliente_direc BE)
        {
            Conex_Fox2DA cone = new Conex_Fox2DA();
            using (OleDbConnection cnx = new OleDbConnection(cone.AdmConexion()))
            {
                String commandString =
                "UPDATE faccl605  SET  " +
                                 " CL605STAT = ? " +
                " WHERE CL605IDCL  = ?  AND CL605NDIR = ? ";

                OleDbCommand cmd = new OleDbCommand(commandString, cnx);
                cmd.Parameters.Add("@CL605STAT", OleDbType.Integer).Value = BE.status;
                cmd.Parameters.Add("@CL605IDCL", OleDbType.Char, 4).Value = BE.ctacte;
                cmd.Parameters.Add("@CL605NDIR", OleDbType.Char, 2).Value = BE.direcnume;
                cnx.Open();
                try
                {
                    if (cmd.ExecuteNonQuery() > 0)
                    {
                        return true;
                    }
                    else
                    {
                        return false;
                    }
                }
                catch (Exception ex)
                {
                    throw new Exception(ex.Message);
                }
            }
        }
Ejemplo n.º 2
0
        public bool Update_dbf(string empresaid, tb_cliente BE)
        {
            Conex_Fox2DA cone = new Conex_Fox2DA();
            using (OleDbConnection cnx = new OleDbConnection(cone.AdmConexion()))
            {
                String commandString =
                "UPDATE faccl600  SET  " +
                                 " CL600STAT = ? ,"+
                                 " CL600NAME = ? ,"+
                                 " CL600NRUC = ? ," +
                                 " CL600TABL = ? ," +
                                 " CL600TPCL = ? ," +
                                 " CL600SERV = ? ," +
                                 " CL600APCP = ? ," +
                                 " CL600CALM = ? ," +
                                 " CL600CATE = ? ," +
                                 " CL600REPR = ? ," +
                                 " CL600DOID = ? ," +
                                 " CL600USID = ? ," +
                                 " CL600FEAC = ? ," +
                                 " CL600IDSC = ? ," +
                                 " CL600TAPI = ? ," +
                                 " CL600DIRE = ? ," +
                                 " CTACTE = ? " +
                " WHERE CL600IDCL  = ? ";

                OleDbCommand cmd = new OleDbCommand(commandString, cnx);
                cmd.Parameters.Add("@CL600STAT", OleDbType.Integer).Value = BE.status;
                cmd.Parameters.Add("@CL600NAME", OleDbType.VarChar, 60).Value = BE.ctactename;
                cmd.Parameters.Add("@CL600NRUC", OleDbType.VarChar, 11).Value = BE.nmruc;
                cmd.Parameters.Add("@CL600TABL", OleDbType.Integer).Value = "0".ToString();
                cmd.Parameters.Add("@CL600TPCL", OleDbType.Char, 1).Value = "P".ToString();
                cmd.Parameters.Add("@CL600SERV", OleDbType.VarChar, 30).Value = "03".ToString();
                cmd.Parameters.Add("@CL600APCP", OleDbType.Char, 2).Value = "05".ToString();
                cmd.Parameters.Add("@CL600CALM", OleDbType.Char, 2).Value = "".ToString();
                cmd.Parameters.Add("@CL600CATE", OleDbType.Char, 1).Value = "M".ToString();
                cmd.Parameters.Add("@CL600REPR", OleDbType.VarChar, 25).Value = BE.replegalname;
                cmd.Parameters.Add("@CL600DOID", OleDbType.VarChar, 8).Value = BE.replegaldni;
                cmd.Parameters.Add("@CL600USID", OleDbType.Char, 3).Value = BE.usuar;
                cmd.Parameters.Add("@CL600FEAC", OleDbType.Date).Value = DateTime.Today.ToShortDateString();
                cmd.Parameters.Add("@CL600IDSC", OleDbType.Char, 2).Value = "".ToString();
                cmd.Parameters.Add("@CL600TAPI", OleDbType.Boolean).Value = false;
                cmd.Parameters.Add("@CL600DIRE", OleDbType.VarChar, 100).Value = BE.direc;
                cmd.Parameters.Add("@CTACTE", OleDbType.VarChar, 7).Value = BE.ctacte;
                cmd.Parameters.Add("@CL600IDCL", OleDbType.Char, 4).Value = BE.ctacte;

                cnx.Open();
                try
                {
                    if (cmd.ExecuteNonQuery() > 0)
                    {
                        return true;
                    }
                    else
                    {
                        return false;
                    }
                }
                catch (Exception ex)
                {
                    throw new Exception(ex.Message);
                }
            }
        }
        public bool Update_dbf(string empresaid, tb_cliente_direc BE)
        {
            Conex_Fox2DA cone = new Conex_Fox2DA();
            using (OleDbConnection cnx = new OleDbConnection(cone.AdmConexion()))
            {
                String commandString =
                "UPDATE faccl605  SET  " +
                                 " CL605STAT = ? ," +
                                 " CL605DIRE = ? ," +
                                 " CL605TELF = ? ," +
                                 " CL605CTTO = ? ," +
                                 " CL605CTDA = ? ," +
                                 " CL605NFAX = ? ," +
                                 " CL605DEPA = ? ," +
                                 " CL605PROV = ? ," +
                                 " CL605DIST = ? ," +
                                 " CL605SITU = ? ," +
                                 " CL605USID = ? ," +
                                 " CL605FEAC = ? " +
                " WHERE CL605IDCL  = ?  AND CL605NDIR = ? ";

                OleDbCommand cmd = new OleDbCommand(commandString, cnx);
                cmd.Parameters.Add("@CL605STAT", OleDbType.Integer).Value = BE.status;
                cmd.Parameters.Add("@CL605DIRE", OleDbType.VarChar, 100).Value = BE.direcdeta;
                cmd.Parameters.Add("@CL605TELF", OleDbType.Char, 11).Value = BE.telef;
                cmd.Parameters.Add("@CL605CTTO", OleDbType.VarChar, 30).Value = BE.direcname;
                cmd.Parameters.Add("@CL605CTDA", OleDbType.Char, 2).Value = "".ToString();
                cmd.Parameters.Add("@CL605NFAX", OleDbType.Char, 11).Value = "".ToString();
                cmd.Parameters.Add("@CL605DEPA", OleDbType.Char, 2).Value = BE.ubig1;
                cmd.Parameters.Add("@CL605PROV", OleDbType.Char, 2).Value = BE.ubig2;
                cmd.Parameters.Add("@CL605DIST", OleDbType.Char, 3).Value = BE.ubig3;
                cmd.Parameters.Add("@CL605SITU", OleDbType.Boolean).Value = false;
                cmd.Parameters.Add("@CL605USID", OleDbType.Char, 3).Value = BE.usuar;
                cmd.Parameters.Add("@CL605FEAC", OleDbType.Date).Value = DateTime.Today.ToShortDateString();
                cmd.Parameters.Add("@CL605IDCL", OleDbType.Char, 4).Value = BE.ctacte;
                cmd.Parameters.Add("@CL605NDIR", OleDbType.Char, 2).Value = BE.direcnume;

                cnx.Open();
                try
                {
                    if (cmd.ExecuteNonQuery() > 0)
                    {
                        return true;
                    }
                    else
                    {
                        return false;
                    }
                }
                catch (Exception ex)
                {
                    throw new Exception(ex.Message);
                }
            }
        }