public bool Insert(UsuarioTemporal usuarioTemporal)
{
var sql = "insert into usuarios_correo (nombre,apellido,correo_electronico,correo_copia,asunto,titulo,mensaje,estado) VALUES(@nombre, @apellido, @correo_electronico,@correo_copia, @asunto,@titulo, @mensaje,@estado)";
var parametros = new List <Parametro> {
new Parametro("@nombre", usuarioTemporal.Nombre),
new Parametro("@apellido", usuarioTemporal.Apellido),
new Parametro("@correo_electronico", usuarioTemporal.CorreoElectronico),
new Parametro("@correo_copia", usuarioTemporal.CCopy),
new Parametro("@asunto", usuarioTemporal.Asunto),
new Parametro("@titulo", usuarioTemporal.Titulo),
new Parametro("@mensaje", usuarioTemporal.Cuerpo),
new Parametro("@estado", Convert.ToInt16(usuarioTemporal.EstadoEnvio))
};
try
{
var resl = manejador.Execute(sql, parametros, CommandType.Text);
return((resl == 0) ? false : true);
}
catch (Exception)
{
return(false);
}
}
public Boolean Update(Usuario user)
{
var sql = "UPDATE users SET number_id = @number_id,name=@name,user_name=@user_name,user_type=@user_type,lastname_p=@lastname_p,lastname_m=@lastname_m,phone_number=@phone_number," +
"mail=@mail,notes=@notes,password=@password,updated_by=@updated_by,active=@active WHERE user_id = @user_id;";
List <Parametro> lst = new List <Parametro> ();
lst.Add(new Parametro("@user_id", user.UsuarioId));
lst.Add(new Parametro("@number_id", user.MyCedula));
lst.Add(new Parametro("@name", user.MyNombre));
lst.Add(new Parametro("@user_name", user.UserName));
lst.Add(new Parametro("@user_type", (int)user.TipoUsuario));
lst.Add(new Parametro("@lastname_p", user.MyApellidoPaterno));
lst.Add(new Parametro("@lastname_m", user.MyApellidoMaterno));
lst.Add(new Parametro("@phone_number", user.MyTelefono));
lst.Add(new Parametro("@mail", user.MyMail));
lst.Add(new Parametro("@notes", user.MyNotas));
lst.Add(new Parametro("@password", user.MyClave));
lst.Add(new Parametro("@updated_by", user.UpdatedBy));
lst.Add(new Parametro("@active", Convert.ToInt16(user.MyActivo)));
try {
return((manejador.Execute(sql, lst, CommandType.Text) == 0) ? true : false);
} catch (Exception) {
throw new Exception($"No se ejecuto el query: {nameof(Update)}");
}
}
public void Delete(double accountingEntryId)
{
var sql = "UPDATE accounting_entries SET active = FALSE " +
"WHERE accounting_entry_id = @accounting_entry_id LIMIT 1";
try
{
//int totalActulizados;
var cnt = manejador.Execute(sql, new List <Parametro> {
new Parametro("@accounting_entry_id", accountingEntryId)
}, CommandType.Text);
}
catch (Exception ex)
{
///log.write(ex);
throw new Exception($"No se pudo ejecutar el metodo {nameof(Delete)}");
}
}
public bool InsertCompany(List <Compañia> compañias, Usuario asignacion, Usuario usuario)
{
int contador = compañias.Count;
foreach (var compani in compañias)
{
///agregar el ignore
var sql = "INSERT INTO companies_permission (user_id,company_id,updated_by) VALUES (@user_id,@company_id,@updated_by) " +
"ON DUPLICATE KEY UPDATE updated_by = @updated_by , updated_at = NOW(), active = 1";
var parametros = new List <Parametro> {
new Parametro("@user_id", asignacion.UsuarioId),
new Parametro("@company_id", compani.Codigo),
new Parametro("@updated_by", usuario.UsuarioId)
};
contador = (manejador.Execute(sql, parametros, CommandType.Text) == 1) ? contador - 1 : contador;
}
return((contador == 0) ? true : false);
}
public Compañia Insert(Compañia company, string copiarMaestroCuenta, Usuario user)
{
var sql = "INSERT INTO companies(company_id,type_id,number_id,name,money_type,op1,op2,address,website,mail,phone_number1,phone_number2,notes,user_id)" +
"VALUES(@company_id,@type_id,@number_id,@name,@money_type,@op1,@op2,@address,@website,@mail,@phone_number1,@phone_number2,@notes,@user_id);";
List <Parametro> lst = new List <Parametro>();
company.Codigo = NuevoCodigo();
lst.Add(new Parametro("@company_id", company.Codigo));
lst.Add(new Parametro("@type_id", (int)company.TipoId));
lst.Add(new Parametro("@number_id", company.NumeroCedula));
lst.Add(new Parametro("@name", company.Nombre));
lst.Add(new Parametro("@money_type", (int)company.TipoMoneda));
lst.Add(new Parametro("@address", company.Direccion));
lst.Add(new Parametro("@website", company.Web));
lst.Add(new Parametro("@mail", company.Correo));
lst.Add(new Parametro("@phone_number1", company.Telefono[0]));
lst.Add(new Parametro("@phone_number2", company.Telefono[1]));
lst.Add(new Parametro("@notes", company.Observaciones));
lst.Add(new Parametro("@user_id", user.UsuarioId));
lst.Add(new Parametro("@op1", ((company is PersonaJuridica) ? ((PersonaJuridica)company).MyIDRepresentanteLegal : ((PersonaFisica)company).MyApellidoPaterno)));
lst.Add(new Parametro("@op2", ((company is PersonaJuridica) ? ((PersonaJuridica)company).MyRepresentanteLegal : ((PersonaFisica)company).MyApellidoMaterno)));
try
{
if (manejador.Execute(sql, lst, CommandType.Text) != 0)
{
CrearMaestroCuenta(copiarMaestroCuenta, user, company);
return(company);
}
else
{
throw new Exception("No se pudo insertar la compañia");
}
}
catch (Exception)
{
throw;
}
}
public void Update(Transaccion tr, long userid)
{
var sql = "UPDATE transactions_accounting " +
"SET account_id = @account_id, " +
"reference = @reference, " +
"detail = @detail, " +
"balance = @balance," +
"balance_type = @balance_type, " +
"money_type = @money_type, " +
"money_chance = @money_chance, " +
"bill_date = @bill_date," +
"updated_by = @updated_by " +
"WHERE transaction_accounting_id = @transaction_accounting_id";
List <Parametro> lst = new List <Parametro> {
new Parametro("@account_id", tr.CuentaDeAsiento.Id),
new Parametro("@reference", tr.Referencia),
new Parametro("@detail", tr.Detalle),
new Parametro("@balance", tr.Monto),
new Parametro("@balance_type", (int)tr.ComportamientoCuenta),
new Parametro("@money_type", (int)tr.TipoCambio),
new Parametro("@money_chance", tr.MontoTipoCambio),
new Parametro("@bill_date", tr.FechaFactura),
new Parametro("@updated_by", userid),
new Parametro("@transaction_accounting_id", tr.Id)
};
try {
var affectedRows = manejador.Execute(sql, lst, CommandType.Text);
if (affectedRows == 0)
{
throw new Exception("No se actualizo ningun registro");
}
} catch (Exception ex) {
throw ex;
}
}
private void InsertName(string name)
{
manejador.Execute(SqlStringInsertName, new Parametro("@name", name));
}