public DataSet GetAll2(string empresaid, tb_t1_caja BE)
{
using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid)))
{
using (SqlCommand cmd = new SqlCommand("gspTbT1Tarjeta_SEARCH2", cnx))
{
DataSet ds = new DataSet();
{
cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.Add("@tarjetaid", SqlDbType.Int).Value = BE.tarjetaid;
//cmd.Parameters.Add("@tarjetaname", SqlDbType.VarChar, 50).Value = BE.tarjetaname;
//cmd.Parameters.Add("@filtro", SqlDbType.Char, 1).Value = BE.filtro;
}
try
{
cnx.Open();
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
da.Fill(ds);
}
return ds;
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
}
}
public bool Delete(string empresaid, tb_t1_caja BE)
{
using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid)))
{
using (SqlCommand cmd = new SqlCommand("gspTbT1Tarjeta_DELETE", cnx))
{
{
cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.Add("@tarjetaid", SqlDbType.Int).Value = BE.tarjetaid;
}
try
{
cnx.Open();
if (cmd.ExecuteNonQuery() > 0)
{
return true;
}
else
{
return false;
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
}
}
public DataSet DetalleActual(string empresaid, tb_t1_caja BE)
{
using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid)))
{
using (SqlCommand cmd = new SqlCommand("gspTbT1Cajadet_SEARCH_ACT", cnx))
{
DataSet ds = new DataSet();
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@moduloid", SqlDbType.Char, 4).Value = BE.moduloid;
cmd.Parameters.Add("@local", SqlDbType.Char, 3).Value = BE.local;
cmd.Parameters.Add("@fecha", SqlDbType.DateTime).Value = BE.fecha;
cmd.Parameters.Add("@filtro", SqlDbType.Char, 1).Value = BE.filtro;
}
try
{
cnx.Open();
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
da.Fill(ds);
}
return ds;
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
}
}
private DataTable liquidacioncaja()
{
var dt = new DataTable();
try
{
var BL = new tb_t1_cajaBL();
var BE = new tb_t1_caja();
BE.moduloid = moduloid.Trim();
BE.local = local;
BE.fecha = Convert.ToDateTime(fechafin);
BE.filtro = "1";
dt = BL.DetalleActual(VariablesPublicas.EmpresaID.ToString(), BE).Tables[0];
if (dt != null)
{
return dt;
}
else
{
return dt;
}
}
catch (Exception ex)
{
throw ex;
}
}
private void Modificar()
{
if (Valido())
{
try
{
var BE = new tb_t1_caja();
var BL = new tb_t1_cajaBL();
BE.moduloid = modulo.ToString();
BE.local = local.ToString();
BE.fecha = Convert.ToDateTime(fecha.Text);
BE.tcambio = Convert.ToDecimal(txttcambio.Text);
BE.adminid = idadmin.Text.ToString();
BE.cajeroid = idcajero.Text.ToString();
BE.apertura1 = Convert.ToDecimal(dgb_liquidacion.GetRowCellValue(1, "importe1").ToString().Trim());
BE.apertura2 = Convert.ToDecimal(dgb_liquidacion.GetRowCellValue(1, "importe2").ToString().Trim());
BE.cierre1 = Convert.ToDecimal(saldomn.Text);
BE.cierre2 = Convert.ToDecimal(saldome.Text);
BE.cerrado = chkcerrado.Checked;
BE.usuar = VariablesPublicas.Usuar.Trim();
if (TablaLiquidacion_modal != null)
{
TablaLiquidacion_modal.Clear();
}
for (var i = 0; i < dgb_liquidacion.RowCount; i++)
{
row = TablaLiquidacion_modal.NewRow();
row["moduloid"] = modulo.ToString();
row["local"] = local.ToString();
row["fecha"] = Convert.ToDateTime(fecha.Text);
row["conceptoid"] = dgb_liquidacion.GetRowCellValue(i, "conceptoid").ToString().Trim();
row["glosa"] = dgb_liquidacion.GetRowCellValue(i, "glosa").ToString().Trim();
row["cajaaccionid"] = dgb_liquidacion.GetRowCellValue(i, "cajaaccionid").ToString().Trim();
row["importe1"] = dgb_liquidacion.GetRowCellValue(i, "importe1").ToString().Trim();
row["importe2"] = dgb_liquidacion.GetRowCellValue(i, "importe2").ToString().Trim();
row["usuar"] = VariablesPublicas.Usuar.Trim();
TablaLiquidacion_modal.Rows.Add(row);
}
StringWriter sw = new StringWriter();
TablaLiquidacion_modal.WriteXml(sw);
string result = sw.ToString();
if (BL.Update(EmpresaID, BE, TablaLiquidacion_modal))
{
MessageBox.Show("Datos Modificados Correctamente !!!", "Información", MessageBoxButtons.OK, MessageBoxIcon.Information);
bloquear(false);
btnNew.Enabled = true;
btnPrint.Enabled = true;
btnInicio.Enabled = true;
btnAnterior.Enabled = true;
btnSiguiente.Enabled = true;
btnUltimo.Enabled = true;
btnExit.Enabled = true;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
private void form_cargar_datos(String posicion)
{
try
{
limpiar();
var BL = new tb_t1_cajaBL();
var BE = new tb_t1_caja();
var dt = new DataTable();
if (fecha.Text.Trim().Length == 0)
{
if (posicion.Trim().Length > 0)
{
MessageBox.Show("Indicar Una Fecha !!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
return;
}
BE.moduloid = modulo.ToString().Trim();
BE.local = local.Trim();
BE.fecha = Convert.ToDateTime(fecha.Text);
BE.posicion = posicion.Trim();
dt = BL.GetAll_paginacion(EmpresaID, BE).Tables[0];
if (dt.Rows.Count > 0)
{
limpiar();
ssModo = "EDIT";
loc_id.Text = dt.Rows[0]["local"].ToString().Trim();
ValidaLocal(loc_id.Text);
idadmin.Text = dt.Rows[0]["adminid"].ToString().Trim();
ValidaPersona(idadmin.Text);
idcajero.Text = dt.Rows[0]["cajeroid"].ToString().Trim();
ValidaPerson2(idcajero.Text);
txttcambio.Text = dt.Rows[0]["tcambio"].ToString().Trim();
fecha.EditValue = Convert.ToDateTime(dt.Rows[0]["fecha"].ToString());
fecha_TextChanged(fecha.Text, new EventArgs());
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void fecha_TextChanged(object sender, EventArgs e)
{
get_tipocambio(fecha.Text);
try
{
var BE = new tb_t1_caja();
var BL = new tb_t1_cajaBL();
BE.moduloid = modulo.ToString();
BE.local = local.ToString();
BE.fecha = Convert.ToDateTime(fecha.Text);
BE.filtro = "1";
if (TablaLiquidacion != null)
{
TablaLiquidacion.Clear();
}
TablaLiquidacion = BL.DetalleActual(EmpresaID, BE).Tables[0];
if (TablaLiquidacion.Rows.Count > 0)
{
MDI_dgb_liquidacion.DataSource = TablaLiquidacion;
}
else
{
MDI_dgb_liquidacion.DataSource = _CargarDetalle();
}
bloquear(true);
MDI_dgb_liquidacion.Enabled = false;
btnSave.Enabled = false;
_CargarVentas(Convert.ToDateTime(fecha.Text));
ConsultaDatos();
_CalcularTotales("importe1");
_CalcularTotales("importe2");
}
catch (Exception ex)
{
throw ex;
}
}
private void ConsultaDatos()
{
var BE = new tb_t1_caja();
var BL = new tb_t1_cajaBL();
var dt = new DataTable();
BE.moduloid = modulo;
BE.local = local;
BE.fecha = Convert.ToDateTime(fecha.Text);
dt = BL.GetAllCab(EmpresaID, BE).Tables[0];
if (dt.Rows.Count > 0)
{
loc_id.Text = dt.Rows[0]["local"].ToString().Trim();
ValidaLocal(loc_id.Text);
idadmin.Text = dt.Rows[0]["adminid"].ToString().Trim();
ValidaPersona(idadmin.Text);
idcajero.Text = dt.Rows[0]["cajeroid"].ToString().Trim();
ValidaPerson2(idcajero.Text);
chkcerrado.Checked = Convert.ToBoolean(dt.Rows[0]["cerrado"].ToString() == "True" ? 1 : 0);
btnNew.Enabled = false;
btnEdit.Enabled = !Convert.ToBoolean(dt.Rows[0]["cerrado"].ToString() == "True" ? 1 : 0);
idadmin.Enabled = false;
idcajero.Enabled = false;
txttcambio.Enabled = false;
}
else
{
bloquear(false);
}
fecha.Enabled = true;
}
public bool UpdateApertura(string empresaid, tb_t1_caja BE)
{
using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid)))
{
using (SqlCommand cmd = new SqlCommand("gspTbT1Caja_UPDATE_apertura", cnx))
{
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@moduloid", SqlDbType.Char, 4).Value = BE.moduloid;
cmd.Parameters.Add("@local", SqlDbType.Char, 3).Value = BE.local;
cmd.Parameters.Add("@fecha", SqlDbType.DateTime).Value = BE.fecha;
cmd.Parameters.Add("@apertura1", SqlDbType.Decimal).Value = BE.apertura1;
cmd.Parameters.Add("@apertura2", SqlDbType.Decimal).Value = BE.apertura2;
cmd.Parameters.Add("@cerrado", SqlDbType.Bit).Value = BE.cerrado;
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 bool Insert(string empresaid, tb_t1_caja BE, DataTable DatDetalle)
{
using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid)))
{
using (SqlCommand cmd = new SqlCommand("gspTbT1Caja_INSERT", cnx))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@moduloid", SqlDbType.Char,4).Value = BE.moduloid;
cmd.Parameters.Add("@local", SqlDbType.Char,3).Value = BE.local;
cmd.Parameters.Add("@fecha", SqlDbType.DateTime).Value = BE.fecha;
cmd.Parameters.Add("@tcambio", SqlDbType.Decimal).Value = BE.tcambio;
cmd.Parameters.Add("@adminid", SqlDbType.Char,4).Value = BE.adminid;
cmd.Parameters.Add("@cajeroid", SqlDbType.Char,4).Value = BE.cajeroid;
cmd.Parameters.Add("@apertura1", SqlDbType.Decimal).Value = BE.apertura1;
cmd.Parameters.Add("@apertura2", SqlDbType.Decimal).Value = BE.apertura2;
cmd.Parameters.Add("@cierre1", SqlDbType.Decimal).Value = BE.cierre1;
cmd.Parameters.Add("@cierre2", SqlDbType.Decimal).Value = BE.cierre2;
cmd.Parameters.Add("@cerrado", SqlDbType.Bit).Value = BE.cerrado;
cmd.Parameters.Add("@usuar", SqlDbType.Char,15).Value = BE.usuar;
// Detalle
cmd.Parameters.AddWithValue("@DetalleImp", DatDetalle);
try
{
cnx.Open();
if (cmd.ExecuteNonQuery() > 0)
{
return true;
}
else
{
return false;
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
}
}
private bool cajacerrada()
{
bool lSigo = false;
try
{
var BE = new tb_t1_caja();
var BL = new tb_t1_cajaBL();
DataTable dt = new DataTable();
BE.moduloid = modulo.ToString();
BE.local = local.ToString();
BE.fecha = Convert.ToDateTime(fechdoc.Text);
dt = BL.GetAllCab(VariablesPublicas.EmpresaID, BE).Tables[0];
if (dt.Rows.Count>0)
{
lSigo = Convert.ToBoolean(dt.Rows[0]["cerrado"].ToString());
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
return lSigo;
}
private void btn_aperturar_Click(object sender, EventArgs e)
{
try
{
var BE = new tb_t1_caja();
var BL = new tb_t1_cajaBL();
BE.moduloid = modulo.ToString();
BE.local = local.ToString();
BE.fecha = Convert.ToDateTime(fecha.Text);
BE.tcambio = Convert.ToDecimal(txttcambio.Text);
//BE.adminid = idadmin.Text.ToString();
//BE.cajeroid = idcajero.Text.ToString();
BE.apertura1 = monedan.Text.Trim() == "" ? 0 : Convert.ToDecimal(monedan.Text);
BE.apertura2 = monedae.Text.Trim() == "" ? 0 : Convert.ToDecimal(monedae.Text);
BE.cierre1 = 0;
BE.cierre2 = 0;
//BE.cerrado = chkcerrado.Checked;
BE.usuar = VariablesPublicas.Usuar.Trim();
if (TablaLiquidacion_modal != null)
{
TablaLiquidacion_modal.Clear();
}
for (var i = 0; i < TablaLiquidacion.Rows.Count; i++)
{
row = TablaLiquidacion_modal.NewRow();
row["moduloid"] = modulo.ToString();
row["local"] = local.ToString();
row["fecha"] = Convert.ToDateTime(fecha.Text);
row["conceptoid"] = TablaLiquidacion.Rows[i]["conceptoid"].ToString().Trim();
row["glosa"] = TablaLiquidacion.Rows[i]["glosa"].ToString().Trim();
row["cajaaccionid"] = TablaLiquidacion.Rows[i]["cajaaccionid"].ToString().Trim();
row["importe1"] = TablaLiquidacion.Rows[i]["importe1"].ToString().Trim();
row["importe2"] = TablaLiquidacion.Rows[i]["importe2"].ToString().Trim();
row["fecre"] = DateTime.Today;
row["feact"] = DateTime.Today;
row["usuar"] = VariablesPublicas.Usuar.Trim();
TablaLiquidacion_modal.Rows.Add(row);
}
TablaLiquidacion_modal.Rows[0]["importe1"] = monedan.Text.Trim() == "" ? 0 : Convert.ToDecimal(monedan.Text);
TablaLiquidacion_modal.Rows[0]["importe2"] = monedae.Text.Trim() == "" ? 0 : Convert.ToDecimal(monedae.Text);
TablaLiquidacion_modal.Rows[1]["importe1"] = monedan.Text.Trim() == "" ? 0 : Convert.ToDecimal(monedan.Text);
TablaLiquidacion_modal.Rows[1]["importe2"] = monedae.Text.Trim() == "" ? 0 : Convert.ToDecimal(monedae.Text);
if (BL.Insert(EmpresaID, BE, TablaLiquidacion_modal))
{
MessageBox.Show("Datos Grabados Correctamente !!!", "Información", MessageBoxButtons.OK, MessageBoxIcon.Information);
bloquear(false);
btn_nuevo.Enabled = true;
//btn_grabar.Enabled = true;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void get_cajas()
{
try
{
var BE = new tb_t1_caja();
var BL = new tb_t1_cajaBL();
BE.moduloid = modulo.ToString();
BE.local = local.ToString();
gridControl1.DataSource = BL.GetAllCab(VariablesPublicas.EmpresaID, BE).Tables[0];
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void fecha_DateTimeChanged(object sender, EventArgs e)
{
get_tipocambio(fecha.Text);
try
{
var BE = new tb_t1_caja();
var BL = new tb_t1_cajaBL();
BE.moduloid = modulo.ToString();
BE.local = local.ToString();
BE.fecha = Convert.ToDateTime(fecha.Text);
BE.filtro = "1";
if (TablaLiquidacion != null)
{
TablaLiquidacion.Clear();
}
TablaLiquidacion = _CargarDetalle();
//if (TablaLiquidacion.Rows.Count > 0)
//{
// gridControl1.DataSource = TablaLiquidacion;
//}
//else
//{
// gridControl1.DataSource = _CargarDetalle();
//}
bloquear(true);
//MDI_dgb_liquidacion.Enabled = false;
//btnSave.Enabled = false;
_CargarVentas(Convert.ToDateTime(fecha.Text));
//ConsultaDatos();
//_CalcularTotales("importe1");
//_CalcularTotales("importe2");
}
catch (Exception ex)
{
throw ex;
}
}
private void btn_modificar_Click(object sender, EventArgs e)
{
try
{
var BE = new tb_t1_caja();
var BL = new tb_t1_cajaBL();
BE.moduloid = modulo.ToString();
BE.local = local.ToString();
BE.fecha = Convert.ToDateTime(fecha.Text);
BE.apertura1 = Convert.ToDecimal(monedan.Text);
BE.cerrado = chkcerrado.Checked;
BE.usuar = VariablesPublicas.Usuar.Trim();
if (BL.UpdateApertura(EmpresaID, BE))
{
MessageBox.Show("Datos Grabados Correctamente, ojo tiene que editar y grabar nuevamente la liquidación de caja de esta fecha !!!", "Información", MessageBoxButtons.OK, MessageBoxIcon.Information);
bloquear(false);
btn_nuevo.Enabled = true;
//btn_grabar.Enabled = true;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
