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); } } }
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); } } }