private void CheckNoGlobalOrExternal(DataDivision node)
{
if (node == null)
{
return; // no DATA DIVISION
}
foreach (var section in node.Children()) // "storage" sections
{
foreach (var child in section.Children)
{
var data = child.CodeElement as DataDescriptionEntry;
if (data == null)
{
continue;
}
if (data.IsGlobal) // TCRFUN_DECLARATION_NO_GLOBAL
{
DiagnosticUtils.AddError(data, "Illegal GLOBAL clause in function data item.");
}
if (data.IsExternal) // TCRFUN_DECLARATION_NO_EXTERNAL
{
DiagnosticUtils.AddError(data, "Illegal EXTERNAL clause in function data item.");
}
}
}
}
public int GetDivisionEdit(DataDivision datadivision)
{
try
{
//DataDivision division = new DataDivision();
using (SqlConnection con = new SqlConnection(connectionString))
{
SqlCommand cmd = new SqlCommand("Facturacion.spu_COMP_InsCambiosClientes", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@sClienteRFC", SqlDbType.NVarChar).Value = datadivision.Rfc.ToString().Trim();
cmd.Parameters.AddWithValue("@sClienteNew", SqlDbType.Char).Value = datadivision.Cliente.ToString().Trim();
cmd.Parameters.AddWithValue("@DivisionNew", SqlDbType.Char).Value = datadivision.Division.ToString().Trim();
cmd.Parameters.AddWithValue("@sUsuario", SqlDbType.Char).Value = datadivision.Usuario.ToString().Trim();
con.Open();
//cmd.ExecuteNonQuery();
//con.Close();
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
datadivision.Idcambio = Convert.ToInt32(rdr["idCambio"]);
}
foreach (FacturasRFC item in datadivision.Selectedrows)
{
SqlCommand command = new SqlCommand("Facturacion.spu_COMP_cambiosCliente", con);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@idCambio", SqlDbType.Int).Value = datadivision.Idcambio;
command.Parameters.AddWithValue("@filial", SqlDbType.Char).Value = datadivision.Filial.ToString().Trim();
command.Parameters.AddWithValue("@suc", SqlDbType.Char).Value = datadivision.Sucursal.ToString().Trim();
command.Parameters.AddWithValue("@division", SqlDbType.Char).Value = datadivision.Division.ToString().Trim();
command.Parameters.AddWithValue("@cliente", SqlDbType.Char).Value = datadivision.Cliente.ToString().Trim();
command.Parameters.AddWithValue("@cteAnterior", SqlDbType.Char).Value = item.Cliente.ToString().Trim();
command.Parameters.AddWithValue("@Factura", SqlDbType.Char).Value = item.Factura.ToString().Trim();
command.Parameters.AddWithValue("@Usuario", SqlDbType.Char).Value = datadivision.Usuario.ToString().Trim();
command.ExecuteNonQuery();
}
con.Close();
}
return(1);
}
catch (Exception)
{
throw;
}
}
private void CheckNoGlobalOrExternal(DataDivision node)
{
if (node == null) return; // no DATA DIVISION
foreach(var section in node.Children()) { // "storage" sections
foreach(var child in section.Children()) {
var data = child.CodeElement as DataDescriptionEntry;
if (data == null) continue;
if (data.IsGlobal) // TCRFUN_DECLARATION_NO_GLOBAL
DiagnosticUtils.AddError(data, "Illegal GLOBAL clause in function data item.");
if (data.IsExternal) // TCRFUN_DECLARATION_NO_EXTERNAL
DiagnosticUtils.AddError(data, "Illegal EXTERNAL clause in function data item.");
}
}
}
public int Editar([FromBody] DataDivision datadivision)
{
return(objfacturas.GetDivisionEdit(datadivision));
}
public virtual bool Visit(DataDivision dataDivision)
{
return(true);
}
