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 Delete(string empresaid, tb_cliente_direc BE)
{
using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid))){
using (SqlCommand cmd = new SqlCommand("gspTbClienteDirec_DELETE", cnx))
{
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@ctacte", SqlDbType.Char, 7).Value = BE.ctacte;
cmd.Parameters.Add("@direcnume", SqlDbType.Char, 3).Value = BE.direcnume;
cmd.Parameters.Add("@usuar", SqlDbType.Char, 15).Value = BE.usuar;
}
try
{
cnx.Open();
if (cmd.ExecuteNonQuery() > 0)
{
return true;
}
else
{
return false;
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
}
}
public DataSet GetAll_CODdbf(string empresaid, tb_cliente_direc BE)
{
Conex_FoxDA cone = new Conex_FoxDA();
using (OleDbConnection cnx = new OleDbConnection(cone.AdmConexion()))
{
String commandString =
"SELECT CL605IDCL,CL605NDIR FROM faccl605 WHERE CL605IDCL = ? AND CL605NDIR = ?";
using (OleDbCommand cmd = new OleDbCommand(commandString, cnx))
{
DataSet ds = new DataSet();
{
cmd.CommandType = System.Data.CommandType.Text;
cmd.Parameters.Add("@CL605IDCL ", OleDbType.Char, 4).Value = BE.ctacte;
cmd.Parameters.Add("@CL605NDIR", OleDbType.Char, 2).Value = BE.direcnume;
}
try
{
cnx.Open();
using (OleDbDataAdapter da = new OleDbDataAdapter(cmd))
{
da.Fill(ds);
}
return ds;
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
}
}
public DataSet GetAll(string empresaid, tb_cliente_direc BE)
{
using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid))){
using (SqlCommand cmd = new SqlCommand("gspTbClienteDirec_SEARCH", cnx))
{
DataSet ds = new DataSet();
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@ctacte", SqlDbType.Char, 7).Value = BE.ctacte;
cmd.Parameters.Add("@direcnume", SqlDbType.Char, 3).Value = BE.direcnume;
cmd.Parameters.Add("@direcname", SqlDbType.VarChar, 25).Value = BE.direcname;
cmd.Parameters.Add("@direcdeta", SqlDbType.VarChar, 100).Value = BE.direcdeta;
cmd.Parameters.Add("@telef", SqlDbType.VarChar, 30).Value = BE.telef;
cmd.Parameters.Add("@ubige", SqlDbType.Char, 6).Value = BE.ubige;
cmd.Parameters.Add("@status", SqlDbType.Char, 1).Value = BE.status;
cmd.Parameters.Add("@nombrelike1", SqlDbType.VarChar, 30).Value = BE.nombrelike1;
cmd.Parameters.Add("@nombrelike2", SqlDbType.VarChar, 30).Value = BE.nombrelike2;
cmd.Parameters.Add("@nombrelike3", SqlDbType.VarChar, 30).Value = BE.nombrelike3;
}
try
{
cnx.Open();
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
da.Fill(ds);
}
return ds;
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
}
}
private void Filtrar()
{
var sorted = default(SortOrder);
var xnomcolumna = string.Empty;
var xctacte = string.Empty;
xctacte = txtCtacte.Text;
if ((dgProveedor.SortedColumn != null))
{
xnomcolumna = dgProveedor.Columns[dgProveedor.SortedColumn.Index].Name;
sorted = dgProveedor.SortOrder;
}
var xpalabra1 = string.Empty;
var xpalabra2 = string.Empty;
var xpalabra3 = string.Empty;
xpalabra1 = VariablesPublicas.Palabras(txtCadenaBuscar.Text, 1);
xpalabra2 = VariablesPublicas.Palabras(txtCadenaBuscar.Text, 2);
xpalabra3 = VariablesPublicas.Palabras(txtCadenaBuscar.Text, 3);
dgProveedor.DataSource = null;
dgProveedor.AutoGenerateColumns = false;
try
{
var BL = new cliente_direcBL();
var BE = new tb_cliente_direc();
BE.ctacte = xctacte;
BE.nombrelike1 = xpalabra1;
BE.nombrelike2 = xpalabra2;
BE.nombrelike3 = xpalabra3;
dgProveedor.DataSource = BL.GetAll(VariablesPublicas.EmpresaID.ToString(), BE).Tables[0];
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
if (xnomcolumna.Trim().Length > 0)
{
if (sorted == SortOrder.Ascending)
{
dgProveedor.Sort(dgProveedor.Columns[xnomcolumna], System.ComponentModel.ListSortDirection.Ascending);
}
else
{
dgProveedor.Sort(dgProveedor.Columns[xnomcolumna], System.ComponentModel.ListSortDirection.Descending);
}
}
else
{
dgProveedor.Sort(dgProveedor.Columns["direcdeta"], System.ComponentModel.ListSortDirection.Ascending);
}
VariablesPublicas.PintaEncabezados(dgProveedor);
}
public bool Update_dbf(string empresaid, tb_cliente_direc BE)
{
return tablaDA.Update_dbf(empresaid, BE);
}
private Boolean DeleteDirecc_DBF()
{
Boolean result = false;
var BL = new cliente_direcBL();
var BE = new tb_cliente_direc();
BE.ctacte = Equivalencias.Right(txtcoddetalle.Text.Trim(), 4);
BE.direcnume = Equivalencias.Right(txt_ordenid.Text, 2);
BE.status = "9";
try
{
result = BL.Delete_dbf(VariablesPublicas.EmpresaID.ToString(), BE);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
return result;
}
public bool Insert_XML(string empresaid, tb_cliente_direc BE)
{
using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid)))
{
using (SqlCommand cmd = new SqlCommand("gspTbClienteDirec_INSERT_xml", cnx))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@ctacte", SqlDbType.Char, 7).Value = BE.ctacte;
cmd.Parameters.Add("@XML", SqlDbType.Xml).Value = BE.GetItemXML();
try
{
cnx.Open();
if (cmd.ExecuteNonQuery() > 0)
{
return true;
}
else
{
return false;
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
}
}
public bool Delete(string empresaid, tb_cliente_direc BE)
{
return tablaDA.Delete(empresaid, BE);
}
private void btn_new_Click(object sender, EventArgs e)
{
try
{
if (txtcoddetalle.Text.Length > 0)
{
BloqueoDirecc(true);
LimpiarDatosDirecc();
// Vamos Generar El nuevo Codigo de direcciones de Acuerdo a la ctacte
tb_cliente_direc BE = new tb_cliente_direc();
cliente_direcBL BL = new cliente_direcBL();
DataTable dt = new DataTable();
BE.ctacte = txtcoddetalle.Text;
dt = BL.Gen_NumDirecc(VariablesPublicas.EmpresaID.ToString(), BE).Tables[0];
if (dt.Rows.Count > 0)
{
txt_ordenid.Text = dt.Rows[0]["direcnume"].ToString();
}
ssModo = "NEW";
gridAnexos.Enabled = false;
btn_new.Enabled = false;
btn_edit.Enabled = false;
btn_delete.Enabled = false;
}
else {
MessageBox.Show("Falta Codigo de Cliente ...!!!","Mensaje");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void u_CargaAnexos()
{
var xcodcliente = txtcodigo.Text;
try
{
var BL = new cliente_direcBL();
var BE = new tb_cliente_direc();
BE.ctacte = xcodcliente;
TablaAnexos = BL.GetAll(VariablesPublicas.EmpresaID.ToString(), BE).Tables[0];
gridAnexos.AutoGenerateColumns = false;
gridAnexos.DataSource = TablaAnexos;
txtcoddetalle.Text = string.Empty;
txtRucAnexo.Text = string.Empty;
txtnomdetalle.Text = string.Empty;
if ((u_n_opsel == 0))
{
if (!(GridExaminar.CurrentRow == null))
{
txtcoddetalle.Text = GridExaminar.Rows[GridExaminar.CurrentRow.Index].Cells["ctacte"].Value.ToString();
txtRucAnexo.Text = GridExaminar.Rows[GridExaminar.CurrentRow.Index].Cells["nmruc"].Value.ToString();
txtnomdetalle.Text = GridExaminar.Rows[GridExaminar.CurrentRow.Index].Cells["ctactename"].Value.ToString();
}
}
else
{
txtcoddetalle.Text = txtcodigo.Text;
txtRucAnexo.Text = txtmnruc.Text;
txtnomdetalle.Text = txtrazonsocial.Text;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private Boolean UpdateDirecc_DBF()
{
Boolean result = false;
var BL = new cliente_direcBL();
var BE = new tb_cliente_direc();
BE.ctacte = Equivalencias.Right(txtcoddetalle.Text.Trim(), 4);
BE.direcnume = Equivalencias.Right(txt_ordenid.Text, 2);
BE.direcname = txt_denominacion.Text;
BE.direcdeta = txt_direccion.Text;
BE.telef = txt_telefono.Text;
BE.ubig1 = txt_ubigeoid.Text.ToString().Substring(0, 2);
BE.ubig2 = txt_ubigeoid.Text.ToString().Substring(2, 2);
BE.ubig3 = txt_ubigeoid.Text.ToString().Substring(4, 2);
BE.usuar = Equivalencias.Left(VariablesPublicas.Usuar.ToString().Trim(), 3);
BE.status = "1";
try
{
result = BL.Update_dbf(VariablesPublicas.EmpresaID.ToString(), BE);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
return result;
}
void UpdateDirecc()
{
try
{
var BL = new cliente_direcBL();
var BE = new tb_cliente_direc();
BE.ctacte = txtcoddetalle.Text.Trim();
BE.direcnume = txt_ordenid.Text;
BE.direcname = txt_denominacion.Text.ToUpper();
BE.direcdeta = txt_direccion.Text.ToUpper();
BE.telef = txt_telefono.Text;
BE.ubige = txt_ubigeoid.Text;
BE.usuar = VariablesPublicas.Usuar.ToUpper().Trim();
BE.status = "0";
String xxMessage = "";
if (BL.Update(VariablesPublicas.EmpresaID.ToString(), BE))
{
xxMessage = "1";
// Verificamos en el DBF Si Existe La misma direccion
if (SearchCodDbf() > 0)
{
if (UpdateDirecc_DBF())
{
xxMessage = xxMessage + " / 2";
}
}
else
{
if (InsertDirecc_DBF())
{
xxMessage = xxMessage + " / 2";
}
}
MessageBox.Show("Datos " + xxMessage + " Modificado Correctamente !!!", "Confirmación", MessageBoxButtons.OK, MessageBoxIcon.Information);
procesado = true;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private Int32 SearchCodDbf()
{
Int32 num = 0;
cliente_direcBL BL = new cliente_direcBL();
tb_cliente_direc BE = new tb_cliente_direc();
DataTable dt = new DataTable();
BE.ctacte = Equivalencias.Right(txtcoddetalle.Text.Trim(),4);
BE.direcnume = Equivalencias.Right(txt_ordenid.Text, 2);
dt = BL.GetAll_CODdbf(VariablesPublicas.EmpresaID.ToString(), BE).Tables[0];
if (dt.Rows.Count > 0)
{
num = dt.Rows.Count;
}
return num;
}
public bool Insert(string empresaid, tb_cliente_direc BE)
{
using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid))){
using (SqlCommand cmd = new SqlCommand("gspTbClienteDirec_INSERT", cnx))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@ctacte", SqlDbType.Char, 7).Value = BE.ctacte;
cmd.Parameters.Add("@direcnume", SqlDbType.Char, 3).Value = BE.direcnume;
cmd.Parameters.Add("@direcname", SqlDbType.VarChar, 25).Value = BE.direcname;
cmd.Parameters.Add("@direcdeta", SqlDbType.VarChar, 100).Value = BE.direcdeta;
cmd.Parameters.Add("@telef", SqlDbType.VarChar, 30).Value = BE.telef;
cmd.Parameters.Add("@ubige", SqlDbType.Char, 6).Value = BE.ubige;
cmd.Parameters.Add("@status", SqlDbType.Char).Value = BE.status;
cmd.Parameters.Add("@usuar", SqlDbType.Char, 15).Value = BE.usuar;
try
{
cnx.Open();
if (cmd.ExecuteNonQuery() > 0)
{
return true;
}
else
{
return false;
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
}
}
public DataSet Gen_NumDirecc(string empresaid, tb_cliente_direc BE)
{
return tablaDA.Gen_NumDirecc(empresaid, BE);
}
public DataSet GetAll_CODdbf(string empresaid, tb_cliente_direc BE)
{
return tablaDA.GetAll_CODdbf(empresaid, BE);
}
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);
}
}
}
public bool Insert_XML(string empresaid, tb_cliente_direc BE)
{
return tablaDA.Insert_XML(empresaid, BE);
}
public DataSet Gen_NumDirecc(string empresaid, tb_cliente_direc BE)
{
using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid)))
{
using (SqlCommand cmd = new SqlCommand("gspTbGenNumDirec_SEARCH", cnx))
{
DataSet ds = new DataSet();
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@ctacte", SqlDbType.Char, 7).Value = BE.ctacte;
}
try
{
cnx.Open();
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
da.Fill(ds);
}
return ds;
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
}
}
void DeleteDirecc()
{
try
{
if (txtcoddetalle.Text.Trim().Length != 7)
{
MessageBox.Show("Ingrese Código de Cliente", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (txt_ordenid.Text.Trim().Length != 3)
{
MessageBox.Show("Ingrese Código Dirección", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
else
{
var BL = new cliente_direcBL();
var BE = new tb_cliente_direc();
BE.ctacte = txtcoddetalle.Text.Trim();
BE.direcnume = txt_ordenid.Text;
BE.usuar = VariablesPublicas.Usuar.ToUpper().Trim();
String xxMessage = "";
if (BL.Delete(VariablesPublicas.EmpresaID.ToString(), BE))
{
xxMessage = "1";
if (DeleteDirecc_DBF())
{
xxMessage = xxMessage + " / 2";
}
MessageBox.Show("Datos " + xxMessage + " Eliminado Correctamente !!!", "Confirmación", MessageBoxButtons.OK, MessageBoxIcon.Information);
procesado = true;
LimpiarDatosDirecc();
BloqueoDirecc(false);
btn_new.Enabled = true;
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
