public static Lib_Primavera.Model.Artigo GetArtigo(string codArtigo)
{
ErpBS objMotor = new ErpBS();
Model.Artigo myArtigo = new Model.Artigo();
if (PriEngine.InitializeCompany(ConfigurationConstants.NAME_COMPANY, ConfigurationConstants.USERNAME, ConfigurationConstants.PASSWORD) == true)
{
if (PriEngine.Engine.Comercial.Artigos.Existe(codArtigo) == true)
{
StdBELista objArtigo = PriEngine.Engine.Consulta("SELECT ARTIGO.Artigo AS Artigo, ARTIGO.Descricao AS Descricao, PVP1, Iva, FAMILIAS.Descricao AS Familia, STKActual, ANEXOS.Id AS Id, ANEXOS.FicheiroOrig AS FicheiroOrig, ANEXOS.Descricao AS AnexosDesc "
+ "FROM ARTIGO, ARTIGOMOEDA, FAMILIAS, ANEXOS "
+ "WHERE ARTIGO.Artigo = '" + codArtigo + "' AND ARTIGO.Artigo = ARTIGOMOEDA.Artigo AND FAMILIAS.Familia = ARTIGO.Familia AND ANEXOS.Chave = ARTIGO.Artigo");
myArtigo.CodArtigo = objArtigo.Valor("Artigo");
myArtigo.Descricao = objArtigo.Valor("Descricao");
myArtigo.Preco = objArtigo.Valor("PVP1");
myArtigo.IVA = objArtigo.Valor("Iva");
myArtigo.StkAtual = objArtigo.Valor("STKActual");
myArtigo.Familia = objArtigo.Valor("Familia");
myArtigo.Imagem = objArtigo.Valor("Id") + '.' + objArtigo.Valor("FicheiroOrig").Split('.')[1];
myArtigo.DescricaoImg = objArtigo.Valor("AnexosDesc");
return(myArtigo);
}
else
{
return(null);
}
}
else
{
return(null);
}
}
public static List <Artigo> ListaArtigosbyTipo(int id)
{
List <Artigo> artigos = new List <Artigo>();
if (PriEngine.InitializeCompany(ElectroSinf.Properties.Settings.Default.Company.Trim(), ElectroSinf.Properties.Settings.Default.User.Trim(), ElectroSinf.Properties.Settings.Default.Password.Trim()) == true)
{
StdBELista lst = PriEngine.Engine.Consulta("SELECT Artigo.Artigo,STKActual,Descricao,IVA,PVP1 FROM Artigo JOIN ArtigoMoeda ON Artigo.Artigo=ArtigoMoeda.Artigo WHERE CDU_Tipo=" + id);
Artigo art;
while (!lst.NoFim())
{
art = new Artigo();
art.CodArtigo = lst.Valor("Artigo");
art.DescArtigo = lst.Valor("Descricao");
art.Stock = Convert.ToDouble(lst.Valor("STKActual"));
art.Preco = Math.Round(lst.Valor("PVP1") * (1 + Convert.ToDouble(lst.Valor("IVA")) / 100.0), 2);
artigos.Add(art);
lst.Seguinte();
}
return(artigos);
}
else
{
return(null);
}
}
public static List <Absence> GetAbsences(DateTime initialDate, DateTime finalDate) // Returns a List of all absences of all employees
{
// Create an empty list of absences:
List <Absence> absences = new List <Absence>();
if (!InitializeCompany())
{
return(absences);
}
// Get Data from Absence of the employee with ID=employeeId
StdBELista list = PriEngine.Engine.Consulta(
"SELECT CadastroFaltas.Funcionario AS CadastroFaltasFuncionario, CadastroFaltas.Data AS CadastroFaltasData, Funcionarios.Nome AS FuncionariosNome " +
"FROM CadastroFaltas " +
"INNER JOIN Funcionarios ON CadastroFaltas.Funcionario = Funcionarios.Codigo " +
"WHERE CadastroFaltas.Data >= '" + initialDate.ToString("yyyyMMdd") + "' AND CadastroFaltas.Data <= '" + finalDate.ToString("yyyyMMdd") + "' " +
"ORDER BY CadastroFaltas.Data"
);
while (!list.NoFim())
{
Absence absence = new Absence();
absence.EmployeeId = list.Valor("CadastroFaltasFuncionario");
absence.EmployeeName = list.Valor("FuncionariosNome");
absence.Date = list.Valor("CadastroFaltasData");
// Add absence to the list:
absences.Add(absence);
// Next item:
list.Seguinte();
}
return(absences);
}
public static Lib_Primavera.Model.TipoTarefa GetTipoTarefa(string cod)
{
StdBELista objList = new StdBELista();
Model.TipoTarefa act = new Model.TipoTarefa();
if (PriEngine.InitializeCompany(FirstREST.Properties.Settings.Default.Company.Trim(), FirstREST.Properties.Settings.Default.User.Trim(), FirstREST.Properties.Settings.Default.Password.Trim()) == true)
{
objList = PriEngine.Engine.Consulta(
"SELECT TiposTarefa.ID AS ID, TiposTarefa.Descricao AS Descricao FROM TiposTarefa WHERE ID ='" + cod + "'");
if (objList.NumLinhas().Equals(0))
{
return(null);
}
else
{
act = new Model.TipoTarefa();
act.ID = objList.Valor("ID");
act.Descricao = objList.Valor("Descricao");
return(act);
}
}
else
{
return(null);
}
}
/// <summary>
/// Get the list of companies.
/// </summary>
/// <returns>A dictionary containing [string CompanyCode, string CompanyDescription]</returns>
public static Dictionary <string, string> GetGroupCompanies(ERPContext oERPContext)
{
Dictionary <string, string> Result = new Dictionary <string, string>();
StringBuilder sqlQry = new StringBuilder();
sqlQry.AppendLine("select e.Codigo, e.IDNome as Descricao, ce.Descricao as Categoria ");
sqlQry.AppendLine("from {0}..empresas e ");
sqlQry.AppendLine(" inner join {0}..categoriasempresas ce on e.categoria=ce.categoria ");
sqlQry.AppendLine(" inner join {0}..empresas ea on ea.Categoria = ce.Categoria ");
sqlQry.AppendFormat("where ea.codigo = '{0}' and e.TipoExercicio <> 'CONSO'", oERPContext.BSO.Contexto.CodEmp);
string sqlQRYRun = string.Format(sqlQry.ToString(), Properties.Settings.Default.PRIEMPRE_DBNAME);
StdBELista compList = oERPContext.BSO.Consulta(sqlQRYRun.ToString());
if (!compList.Vazia())
{
while (!compList.NoFim())
{
Result.Add(compList.Valor("Codigo"), compList.Valor("Descricao"));
compList.Seguinte();
}
}
return(Result);
}
public static Lib_Primavera.Model.Rota GetRota(string codrota)
{
StdBELista objList = new StdBELista();
Model.Rota rota = new Model.Rota();
if (PriEngine.InitializeCompany(FirstREST.Properties.Settings.Default.Company.Trim(), FirstREST.Properties.Settings.Default.User.Trim(), FirstREST.Properties.Settings.Default.Password.Trim()) == true)
{
objList = PriEngine.Engine.Consulta(
"SELECT * FROM STP_Rotas STP_Rotas.id = '" + codrota + "'");
if (PriEngine.Engine.CRM.Actividades.Existe(codrota) == false)
{
return(null);
}
else
{
rota = new Model.Rota();
rota.ID = objList.Valor("ID");
rota.Rot = objList.Valor("Rota");
rota.Descricao = objList.Valor("Descricao");
rota.ZonaID = objList.Valor("Zona");
return(rota);
}
}
else
{
return(null);
}
}
public ActionResult Login(UserCheckOut objUser)
{
//StdBELista objList = PriEngine.Engine.Consulta("SELECT Descricao from FAMILIAS WHERE Familia LIKE 'COMP'");
StdBELista objList = PriEngine.Engine.Consulta("SELECT UserId from USERPROFILE WHERE UserName LIKE 'Jaquim' AND Password LIKE 'teste'");
System.Diagnostics.Debug.WriteLine("1 " + objList.Valor("UserId"));
if (ModelState.IsValid)
{
System.Diagnostics.Debug.WriteLine("2 " + objList.Valor("UserId"));
// System.Diagnostics.Debug.WriteLine("USER ID das " + objList.Valor("Descricao"));
// System.Diagnostics.Debug.WriteLine("USER ID "+objList.Valor("UserId"));
if (objList.Valor("UserId") != null)
{
/*UserCheckOut tempUser = Lib_Primavera.PriIntegration.GetUserProf(objUser.UserCod);
* Session["UserID"] = tempUser.UserCod.ToString();
* Session["UserName"] = tempUser.UserName.ToString();
* return RedirectToAction("UserDashBoard");*/
}
}
return(View(objUser));
}
// GET api/<controller>
public ActionResult Index(string id)
{
StdBELista objList = PriEngine.Engine.Consulta("SELECT Descricao, STKActual, PCMEDIO, Familia FROM ARTIGO WHERE Artigo LIKE '" + id + "'");
Artigo art = new Artigo {
CodArtigo = id, DescArtigo = objList.Valor("Descricao"), STKAtual = objList.Valor("STKActual"), Familia = objList.Valor("Familia"), Price = objList.Valor("PCMEDIO")
};
return(View(art));
}
private static EntityReference GenerateReference(StdBELista queryObject)
{
return(new EntityReference
{
Tipo = EntityType.Lead.ToDescriptionString(),
Identificador = TypeParser.String(queryObject.Valor("Entidade")),
Descricao = TypeParser.String(queryObject.Valor("Nome"))
});
}
private static Address GetAddress(StdBELista warehouseInfo)
{
return(new Address
{
Pais = TypeParser.String(warehouseInfo.Valor("Pais")),
Morada = TypeParser.String(warehouseInfo.Valor("Morada")),
CodigoPostal = TypeParser.String(warehouseInfo.Valor("Cp")),
Distrito = TypeParser.String(warehouseInfo.Valor("Distrito")),
Localidade = TypeParser.String(warehouseInfo.Valor("Localidade"))
});
}
public void lista_utilizador_permissoes(string user)
{
init();
StdBELista upList = _admBs.Consulta("SELECT * FROM Permissoes WHERE Utilizador='" + user + "'");
upList.Inicio();
while (!upList.NoFim())
{
Console.WriteLine("Permissao: ");
Console.WriteLine(" Perfil: " + upList.Valor("Perfil"));
Console.WriteLine(" Empresa: " + upList.Valor("Empresa"));
upList.Seguinte();
}
return;
}
private static ProductListing GenerateListing(StdBELista productInfo)
{
var productId = TypeParser.String(productInfo.Valor("Artigo"));
var productUnit = TypeParser.String(productInfo.Valor("UnidadeVenda"));
return(new ProductListing()
{
Unidade = productUnit,
Identificador = productId,
PrecoMedio = FindLowest(productId, productUnit),
Stock = TypeParser.Double(productInfo.Valor("Stock")),
IVA = TypeParser.Double(productInfo.Valor("Iva")),
Descricao = TypeParser.String(productInfo.Valor("Descricao"))
});
}
public static GenderCounter GetGenderCount(DateTime initialDate, DateTime finalDate)
{
if (!InitializeCompany())
{
return(new GenderCounter(-1, -1, DateTime.MinValue, DateTime.MinValue));
}
StdBELista list = PriEngine.Engine.Consulta(
"SELECT Sexo " +
"FROM Funcionarios " +
"WHERE DataAdmissao <= '" + finalDate.ToString("yyyyMMdd") + "' " +
" AND (DataDemissao >= '" + initialDate.ToString("yyyyMMdd") + "' OR DataDemissao IS NULL) "
);
int males = 0;
int females = 0;
while (!list.NoFim())
{
if (list.Valor("Sexo") == "1")
{
females++;
}
else
{
males++;
}
list.Seguinte();
}
return(new GenderCounter(males, females, initialDate, finalDate));
} // Returns <male,female> format
public ScriptResponse Execute(ContextDataObject context, string query)
{
ErpBS bsERP = new ErpBS();
if (!context.Parameters.ContainsKey("TipoPlataforma"))
{
throw new Exception("TipoPlataforma inválido");
}
EnumTipoPlataforma tipoPlataforma;
if (!Enum.TryParse <EnumTipoPlataforma>((string)context.Parameters["TipoPlataforma"], out tipoPlataforma))
{
throw new Exception("TipoPlataforma inválido");
}
try
{
bsERP.AbreEmpresaTrabalho(tipoPlataforma, context.Company, context.Username, context.Password);
}
catch (Exception e)
{
throw new Exception("Erro a abrir a empresa no ERP: " + e.Message);
}
StdBELista queryResults = bsERP.Consulta(query);
int numLinhas = queryResults.NumLinhas();
int numColunas = queryResults.NumColunas();
string[] headers = new string[numColunas];
for (short i = 0; i < numColunas; i++)
{
headers[i] = queryResults.Nome(i);
}
object[,] data = new object[numLinhas, numColunas];
for (short i = 0; i < numLinhas; i++)
{
for (short j = 0; j < numColunas; j++)
{
var nome = headers[j];
data[i, j] = queryResults.Valor(nome);
}
queryResults.Seguinte();
}
QueryResult response = new QueryResult()
{
Headers = headers,
Data = data
};
bsERP.FechaEmpresaTrabalho();
return(new ScriptResponse
{
Object = response
});
}
public void lista_perfis()
{
init();
StdBELista pList = _admBs.Consulta("SELECT * FROM perfis");
pList.Inicio();
while (!pList.NoFim())
{
Console.WriteLine("Perfil: " + pList.Valor("Codigo"));
Console.WriteLine(" Codigo: " + pList.Valor("Codigo"));
Console.WriteLine(" Nome: " + pList.Valor("Nome"));
pList.Seguinte();
}
return;
}
public void info()
{
init();
ErpBS motor = new ErpBS();
bool _false = false;
Console.WriteLine("License: " + !motor.Licenca.VersaoDemo);
Console.WriteLine("Language: " + _admBs.Params.get_Idioma());
Console.WriteLine("Seguranca Activa: " + _admBs.Params.get_SegurancaActiva());
Console.WriteLine("Seguranca Pro Emp Activa: " + _admBs.Params.get_SegurancaPorEmpActiva());
Console.WriteLine("Modo Seguranca: " + _admBs.Params.get_SegurancaActiva());
//Console.WriteLine("N Postos: " + adm.Utilizadores.listPostos.ListaPostos(ref _false).NumItens);
string backupsdir = Backupsdir;
if (backupsdir == null)
{
backupsdir = _admBs.SQLServer.DirectoriaBackup();
}
Console.WriteLine("DirectoriaBackup: " + backupsdir);
StdBELista uList = _admBs.Consulta("SELECT * FROM utilizadores");
Console.WriteLine("N Utilizadores: " + uList.NumLinhas());
uList.Inicio();
while (!uList.NoFim())
{
Console.WriteLine(" Utilizador: " + uList.Valor("Codigo") + ", " + uList.Valor("Nome"));
uList.Seguinte();
}
StdBELista eList = _admBs.Consulta("SELECT * FROM empresas");
Console.WriteLine("N Empresas: " + eList.NumLinhas());
eList.Inicio();
while (!eList.NoFim())
{
Console.WriteLine(" Empresa: " + eList.Valor("Codigo") + ", " + eList.Valor("IDNome"));
eList.Seguinte();
}
return;
}
public static List <Artigo> getRelacionados(string id, int tipo, double pvp1)
{
List <Artigo> relacionados = new List <Artigo>();
double precoMax = pvp1 * 1.25;
string precoString = precoMax.ToString();
precoString = precoString.Replace(",", ".");
StdBELista lst = new StdBELista();
lst = PriEngine.Engine.Consulta("IF(SELECT COUNT(DISTINCT Artigo) Total FROM LinhasDoc WHERE Data >= DATEADD(month,-3,GETDATE()) AND Artigo IN (SELECT Artigo FROM Artigo WHERE CDU_Tipo=" + tipo + ") AND LinhasDoc.PrecUnit <= " + precoString + ") >$4"
+ "BEGIN "
+ " SELECT Art.Artigo, Descricao, PVP1, IVA, Total "
+ " FROM "
+ " (SELECT Artigo.Artigo, Descricao, PVP1, IVA "
+ " FROM Artigo "
+ " JOIN ArtigoMoeda ON Artigo.Artigo=ArtigoMoeda.Artigo"
+ " WHERE CDU_Tipo="+ tipo + " AND PVP1 <= " + precoString + " AND Artigo.Artigo!='" + id + "' ) AS Art "
+ " JOIN (SELECT TOP 5 Artigo, COUNT(*) Total "
+ " FROM LinhasDoc "
+ " WHERE Data >= DATEADD(month,-3,GETDATE())"
+ " GROUP BY Artigo "
+ " HAVING COUNT(*) > 1"
+ " ORDER BY COUNT(*) DESC) AS Linhas ON Art.Artigo = Linhas.Artigo "
+ "END "
+ "ELSE "
+ "SELECT Artigo.Artigo, Descricao, PVP1, IVA "
+ "FROM Artigo JOIN ArtigoMoeda ON Artigo.Artigo=ArtigoMoeda.Artigo "
+ "WHERE CDU_Tipo=" + tipo + " AND Artigo.Artigo!='" + id + "' "
+ "ORDER BY NEWID() "
+ "SET ROWCOUNT 5");
Artigo art;
while (!lst.NoFim())
{
art = new Artigo();
art.CodArtigo = lst.Valor("artigo");
art.DescArtigo = lst.Valor("descricao");
art.Preco = Math.Round(lst.Valor("PVP1") * (1 + Convert.ToDouble(lst.Valor("IVA")) / 100.0), 2);
relacionados.Add(art);
lst.Seguinte();
}
return(relacionados);
}
private static List <Pending> GetPendingDocuments(DateTime initialDate, DateTime finalDate, bool receivables)
{
List <Pending> output = new List <Pending>();
if (!InitializeCompany())
{
return(output);
}
StdBELista pendingDocumentsQuery = PriEngine.Engine.Consulta(
"SELECT ValorPendente, Moeda, TipoDoc, Entidade, TipoEntidade, Estado, DataVenc, DataDoc " +
"FROM Pendentes " +
"WHERE TipoEntidade = " + (receivables ? "'C'" : "'F'") +
" AND DataDoc >= '" + initialDate.ToString("yyyyMMdd") + "' AND DataDoc <= '" + finalDate.ToString("yyyyMMdd") + "' " +
"ORDER BY DataDoc"
);
while (!pendingDocumentsQuery.NoFim())
{
Pending pendingDocument = new Pending();
pendingDocument.PendingValue = new Money(pendingDocumentsQuery.Valor("ValorPendente"), pendingDocumentsQuery.Valor("Moeda"));
pendingDocument.DocumentDate = pendingDocumentsQuery.Valor("DataDoc");
pendingDocument.DocumentType = pendingDocumentsQuery.Valor("TipoDoc");
pendingDocument.DueDate = pendingDocumentsQuery.Valor("DataVenc");
pendingDocument.Entity = pendingDocumentsQuery.Valor("Entidade");
pendingDocument.EntityType = pendingDocumentsQuery.Valor("TipoEntidade");
pendingDocument.State = pendingDocumentsQuery.Valor("Estado");
output.Add(pendingDocument);
pendingDocumentsQuery.Seguinte();
}
return(output);
}
internal static List <Armazem_stock> getStock_armazem(string CodArtigo)
{
List <Armazem_stock> stock_armazem = new List <Armazem_stock>();
StdBELista lst = new StdBELista();
lst = PriEngine.Engine.Consulta("SELECT ArtigoArmazem.Armazem,ArtigoArmazem.StkActual,Armazens.Descricao,Armazens.Morada,Armazens.Localidade,Armazens.Cp,Armazens.CpLocalidade FROM ArtigoArmazem JOIN Armazens ON ArtigoArmazem.Armazem = Armazens.Armazem WHERE Artigo ='" + CodArtigo + "'");
Armazem_stock arm_stc;
while (!lst.NoFim())
{
arm_stc = new Armazem_stock();
arm_stc.Armazem_id = lst.Valor("Armazem");
arm_stc.Stock_qtdd = lst.Valor("StkActual");
arm_stc.Descricao = lst.Valor("Descricao");
arm_stc.Morada = lst.Valor("Morada");
arm_stc.Localidade = lst.Valor("Localidade");
arm_stc.Cp = lst.Valor("Cp");
arm_stc.CpLocalidade = lst.Valor("CpLocalidade");
stock_armazem.Add(arm_stc);
lst.Seguinte();
}
return(stock_armazem);
}
//
// GET: /CategoryPage/
public ActionResult Category(string id)
{
StdBELista objList = PriEngine.Engine.Consulta("SELECT Descricao from FAMILIAS WHERE Familia LIKE '" + id + "'");
Familias fam = new Familias {
Familia = id, Descricao = objList.Valor("Descricao")
};
return(View(fam));
}
public static List <Artigo> toArtigoList(StdBELista objList)
{
List <Model.Artigo> listArtigos = new List <Model.Artigo>();
while (!objList.NoFim())
{
listArtigos.Add(new Model.Artigo
{
CodArtigo = objList.Valor("Artigo"),
DescArtigo = objList.Valor("Descricao"),
Stock = Convert.ToDouble(objList.Valor("STKActual")),
Marca = objList.Valor("Marca"),
Preco = Math.Round((Convert.ToDouble(objList.Valor("PVP1")) * (1 + Convert.ToDouble(objList.Valor("IVA")) / 100.0)), 2)
});
objList.Seguinte();
}
return(listArtigos);
}
public static Lib_Primavera.Model.RespostaErro login(Model.Cliente cli)
{
Lib_Primavera.Model.RespostaErro erro = new Model.RespostaErro();
try
{
if (PriEngine.InitializeCompany(ElectroSinf.Properties.Settings.Default.Company.Trim(), ElectroSinf.Properties.Settings.Default.User.Trim(), ElectroSinf.Properties.Settings.Default.Password.Trim()) == true)
{
StdBELista cliente = PriEngine.Engine.Consulta("SELECT Cliente,CDU_Password from Clientes where CDU_Email='" + cli.Email + "';");
if (cliente.Vazia())
{
erro.Erro = -1;
erro.Descricao = "Email Errado";
}
else
{
string inserida = PriEngine.Platform.Criptografia.Encripta(cli.Password, 50);
if (inserida == cliente.Valor("CDU_Password"))
{
erro.Erro = 0;
erro.Descricao = cliente.Valor("Cliente");
}
else
{
erro.Erro = -1;
erro.Descricao = "Password Errada";
}
}
return(erro);
}
else
{
erro.Erro = 1;
erro.Descricao = "Erro ao abrir empresa";
return(erro);
}
}
catch (Exception ex)
{
erro.Erro = 1;
erro.Descricao = ex.Message;
return(erro);
}
}
private bool EditCabec(int number)
{
bool result = false;
string sql = PSO.Sql.FormatSQL("SELECT * FROM TDU_CabecAnomalias WHERE CDU_Numero = @1@", number);
StdBELista list = BSO.Consulta(sql);
if (list != null)
{
if (list.NumLinhas() == 1)
{
result = true;
numericUpDownNumber.Value = list.Valor("CDU_Numero");
dateTimePickerDate.Value = list.Valor("CDU_Data");
}
}
return(result);
}
private static LeadListing GenerateListing(StdBELista queryObject)
{
return(new LeadListing()
{
Identificador = TypeParser.String(queryObject.Valor("Entidade")),
Nome = TypeParser.String(queryObject.Valor("Nome")),
Email = TypeParser.String(queryObject.Valor("Email")),
Activo = TypeParser.Boolean(queryObject.Valor("Activo")),
TipoTerceiro = TypeParser.String(queryObject.Valor("TipoTerceiro")),
DataCriacao = TypeParser.Date(queryObject.Valor("DataCriacao")),
DataModificacao = TypeParser.Date(queryObject.Valor("DataUltAct")),
Telefone = TypeParser.String(queryObject.Valor("Telemovel"))
});
}
public static List <OvertimeHours> GetOvertimeHours(DateTime initialDate, DateTime finalDate)
{
// Create an empty list of absences:
List <OvertimeHours> overtimeHours = new List <OvertimeHours>();
if (!InitializeCompany())
{
return(overtimeHours);
}
// Get Data from Absence of the employee with ID=employeeId BD
StdBELista list = PriEngine.Engine.Consulta(
"SELECT CadastroHExtras.Funcionario, CadastroHExtras.Data, CadastroHExtras.Tempo, Funcionarios.Nome AS FuncionariosNome " +
"FROM CadastroHExtras " +
"INNER JOIN Funcionarios " +
"ON CadastroHExtras.Funcionario = Funcionarios.Codigo " +
"WHERE CadastroHExtras.Data >= '" + initialDate.ToString("yyyyMMdd") + "' AND CadastroHExtras.Data <= '" + finalDate.ToString("yyyyMMdd") + "' " +
"ORDER BY CadastroHExtras.Data "
);
// Get Data from Absence of the employee with ID=employeeId Not BD
//StdBELista list = PriEngine.Engine.RecursosHumanos.CadastroHorasExtra.LstCadastroHorasExtra();
// TODO edit
while (!list.NoFim())
{
OvertimeHours overtimeHoursObj = new OvertimeHours();
overtimeHoursObj.EmployeeId = list.Valor("Funcionario");
overtimeHoursObj.EmployeeName = list.Valor("FuncionariosNome");
overtimeHoursObj.Date = list.Valor("Data");
overtimeHoursObj.Time = list.Valor("Tempo").ToString();
// Add absence to the list:
overtimeHours.Add(overtimeHoursObj);
// Next item:
list.Seguinte();
}
return(overtimeHours);
}
public void lista_utilizador_aplicacoes(string user)
{
init();
StdBELista uaList = _admBs.Consulta("SELECT * FROM UtilizadoresAplicacoes WHERE Utilizador='" + user + "'");
uaList.Inicio();
while (!uaList.NoFim())
{
Console.WriteLine("Aplicacao: " + uaList.Valor("Apl"));
uaList.Seguinte();
}
return;
}
// Human Resources related:
public static List <Employee> GetEmployees(DateTime initialDate, DateTime finalDate)
{
// Create an empty list of employees:
List <Employee> employees = new List <Employee>();
if (!InitializeCompany())
{
return(employees);
}
StdBELista list = PriEngine.Engine.Consulta(
"SELECT IdGDOC, Nome, Sexo, Vencimento, TipoMoeda, DataAdmissao, DataDemissao " +
"FROM Funcionarios " +
"WHERE DataAdmissao <= '" + finalDate.ToString("yyyyMMdd") + "' " +
" AND (DataDemissao >= '" + initialDate.ToString("yyyyMMdd") + "' OR DataDemissao IS NULL) " +
"ORDER BY DataAdmissao"
);
while (!list.NoFim())
{
Employee employee = new Employee();
// Set values
employee.ID = list.Valor("IdGDOC");
employee.Name = list.Valor("Nome");
employee.Gender = list.Valor("Sexo") == "0" ? Employee.GenderType.Female : Employee.GenderType.Male;
employee.Salary = new Money(list.Valor("Vencimento"), "Unspecified"); // No currency value
employee.HiredOn = ParseDate(list, "DataAdmissao");
employee.FiredOn = ParseDate(list, "DataDemissao");
// Add employee to the list:
employees.Add(employee);
// Next item:
list.Seguinte();
}
return(employees);
}
public static RespostaErro CreateProposta(Oportunidade oportunidade)
{
Lib_Primavera.Model.RespostaErro erro = new Model.RespostaErro();
StdBELista props = PriEngine.Engine.Consulta(@"SELECT Count(*) AS N FROM PropostasOPV
WHERE IdOportunidade = '" + oportunidade.ID + "' ;");
int n = props.Valor("N");
//maximo 4 propostas
if (n >= 4)
{
erro.Erro = 1;
erro.Descricao = "The maximum of proposals is four.";
return(erro);
}
CrmBEPropostaOPV prop = new CrmBEPropostaOPV();
try
{
if (PriEngine.InitializeCompany(FirstREST.Properties.Settings.Default.Company.Trim(), FirstREST.Properties.Settings.Default.User.Trim(), FirstREST.Properties.Settings.Default.Password.Trim()) == true)
{
prop.set_IdOportunidade(oportunidade.ID);
prop.set_IdCabecOrigem(oportunidade.ID);
short x = (short)n;
x++;
prop.set_NumProposta(x);
prop.set_Valor(0);
//var opp = PriEngine.Engine.CRM.OportunidadesVenda.EditaID(oportunidade.ID);
PriEngine.Engine.CRM.PropostasOPV.Actualiza(prop);
erro.Erro = 0;
erro.Descricao = "Sucesso";
return(erro);
}
else
{
erro.Erro = 1;
erro.Descricao = "Erro ao abrir empresa";
return(erro);
}
}
catch (Exception ex)
{
erro.Erro = 1;
erro.Descricao = ex.Message;
return(erro);
}
}
} // Returns <male,female> format
public static List <EmployeeMovement> GetEmployeesMovements(DateTime initialDate, DateTime finalDate)
{
// Create an empty list of employee movements:
List <EmployeeMovement> employeeMovements = new List <EmployeeMovement>();
if (!InitializeCompany())
{
return(employeeMovements);
}
// Get Data of movements:
StdBELista list = PriEngine.Engine.Consulta(
"SELECT TotalDeRemuneracoes, TotalEncargosEntPat, Funcionario, DataMov, NumProc " +
"FROM MovimentosFuncionarios " +
"WHERE MovimentosFuncionarios.DataMov >= '" + initialDate.ToString("yyyyMMdd") + "' AND MovimentosFuncionarios.DataMov <= '" + finalDate.ToString("yyyyMMdd") + "' " +
"ORDER BY MovimentosFuncionarios.DataMov "
);
while (!list.NoFim())
{
EmployeeMovement employeeMovement = new EmployeeMovement();
employeeMovement.EmployeeId = list.Valor("Funcionario");
employeeMovement.MovementDate = list.Valor("DataMov");
employeeMovement.ProcessNo = list.Valor("NumProc");
employeeMovement.EmployeePayment = list.Valor("TotalDeRemuneracoes");
employeeMovement.EstateCharges = list.Valor("TotalEncargosEntPat");
// Add absence to the list:
employeeMovements.Add(employeeMovement);
// Next item:
list.Seguinte();
}
return(employeeMovements);
}
private static ActivityListing GenerateListing(StdBELista queryResult)
{
return(new ActivityListing
{
Tipo = TypeReference(queryResult),
DataFim = TypeParser.Date(queryResult.Valor("DataFim")),
Resumo = TypeParser.String(queryResult.Valor("Resumo")),
Estado = TypeParser.Integer(queryResult.Valor("Estado")),
Identificador = TypeParser.String(queryResult.Valor("Id")),
DataInicio = TypeParser.Date(queryResult.Valor("DataInicio")),
Prioridade = TypeParser.Integer(queryResult.Valor("Prioridade")),
DataModificacao = TypeParser.Date(queryResult.Valor("DataUltAct"))
});
}
private static Factura parseFacturaObj(StdBELista obj)
{
Factura factura = new Factura();
factura.entidade = obj.Valor("Entidade");
factura.tipoDocumento = obj.Valor("Tipodoc");
factura.numDocumento = obj.Valor("NumDoc");
//Console.WriteLine("objecto: " + obj.Valor("DataDoc"));
if (obj.Valor("DataDoc") != null)
factura.dataDocumento = obj.Valor("DataDoc");
if (obj.Valor("DataVenc") != null)
factura.dataVencimento = obj.Valor("DataVenc");
// if (obj.Valor("DataLiq") != null)
// factura.dataLiquidacao = obj.Valor("DataLiq");
factura.valorTotal = obj.Valor("ValorTotal");
// if (obj.Valor("ValorDesconto") != null)
// factura.valorDesconto = obj.Valor("ValorDesconto");
factura.modoPagamento = obj.Valor("ModoPag");
factura.condPagamento = obj.Valor("CondPag");
factura.moeda = obj.Valor("Moeda");
factura.totalIva = obj.Valor("TotalIva");
return factura;
}
private static DateTime ParseDate(StdBELista list, String key)
{
var value = list.Valor(key);
Type type = value.GetType();
if (type != typeof (DateTime))
{
if(type != typeof(String))
return DateTime.MinValue;
DateTime output;
if(!DateTime.TryParse(value, out output))
return DateTime.MinValue;
return output;
}
return value;
}
public static void processLine(StdBELista balanceSheetQuery, ClassLine line)
{
line.conta = balanceSheetQuery.Valor("Conta");
line.moeda = balanceSheetQuery.Valor("Moeda");
//line.values.Add(d);
line.values.Add((double)balanceSheetQuery.Valor("Mes00CR"));
line.values.Add((double)balanceSheetQuery.Valor("Mes01CR"));
line.values.Add((double)balanceSheetQuery.Valor("Mes02CR"));
line.values.Add((double)balanceSheetQuery.Valor("Mes03CR"));
line.values.Add((double)balanceSheetQuery.Valor("Mes04CR"));
line.values.Add((double)balanceSheetQuery.Valor("Mes05CR"));
line.values.Add((double)balanceSheetQuery.Valor("Mes06CR"));
line.values.Add((double)balanceSheetQuery.Valor("Mes07CR"));
line.values.Add((double)balanceSheetQuery.Valor("Mes08CR"));
line.values.Add((double)balanceSheetQuery.Valor("Mes09CR"));
line.values.Add((double)balanceSheetQuery.Valor("Mes10CR"));
line.values.Add((double)balanceSheetQuery.Valor("Mes11CR"));
line.values.Add((double)balanceSheetQuery.Valor("Mes12CR"));
line.values.Add((double)balanceSheetQuery.Valor("Mes13CR"));
line.values.Add((double)balanceSheetQuery.Valor("Mes14CR"));
line.values.Add((double)balanceSheetQuery.Valor("Mes15CR"));
line.values.Add((double)balanceSheetQuery.Valor("Mes00DB"));
line.values.Add((double)balanceSheetQuery.Valor("Mes01DB"));
line.values.Add((double)balanceSheetQuery.Valor("Mes02DB"));
line.values.Add((double)balanceSheetQuery.Valor("Mes03DB"));
line.values.Add((double)balanceSheetQuery.Valor("Mes04DB"));
line.values.Add((double)balanceSheetQuery.Valor("Mes05DB"));
line.values.Add((double)balanceSheetQuery.Valor("Mes06DB"));
line.values.Add((double)balanceSheetQuery.Valor("Mes07DB"));
line.values.Add((double)balanceSheetQuery.Valor("Mes08DB"));
line.values.Add((double)balanceSheetQuery.Valor("Mes09DB"));
line.values.Add((double)balanceSheetQuery.Valor("Mes10DB"));
line.values.Add((double)balanceSheetQuery.Valor("Mes11DB"));
line.values.Add((double)balanceSheetQuery.Valor("Mes12DB"));
line.values.Add((double)balanceSheetQuery.Valor("Mes13DB"));
line.values.Add((double)balanceSheetQuery.Valor("Mes14DB"));
line.values.Add((double)balanceSheetQuery.Valor("Mes15DB"));
line.values.Add((double)balanceSheetQuery.Valor("Mes01OR"));
line.values.Add((double)balanceSheetQuery.Valor("Mes02OR"));
line.values.Add((double)balanceSheetQuery.Valor("Mes03OR"));
line.values.Add((double)balanceSheetQuery.Valor("Mes04OR"));
line.values.Add((double)balanceSheetQuery.Valor("Mes05OR"));
line.values.Add((double)balanceSheetQuery.Valor("Mes06OR"));
line.values.Add((double)balanceSheetQuery.Valor("Mes07OR"));
line.values.Add((double)balanceSheetQuery.Valor("Mes08OR"));
line.values.Add((double)balanceSheetQuery.Valor("Mes09OR"));
line.values.Add((double)balanceSheetQuery.Valor("Mes10OR"));
line.values.Add((double)balanceSheetQuery.Valor("Mes11OR"));
line.values.Add((double)balanceSheetQuery.Valor("Mes12OR"));
line.tipoLancamento = balanceSheetQuery.Valor("TipoLancamento");
line.naturezaOR = balanceSheetQuery.Valor("NaturezaOR");
}
