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