public void RemoveMailing(int mailingId)
{
ProcedureCall removeMailing = new ProcedureCall("pr_removeMailing", sqlConnection);
removeMailing.parameters.Add(new ProcedureParam("@mailingId", SqlDbType.Int, 4, mailingId));
removeMailing.Execute(false);
}
public void RemoveAssociate(int associateId)
{
ProcedureCall removeAssociate = new ProcedureCall("pr_removeAssociate", sqlConnection);
removeAssociate.parameters.Add(new ProcedureParam("@associateId", SqlDbType.Int, 4, associateId));
removeAssociate.Execute(false);
}
public static Object[] Retrieve(String procedureName, SqlConnection sqlConnection, Type objectType)
{
// Convenções:
// A procedure deve retornar registros compatíveis com objectType
// objectType deve possuir campos com os atributos [ItemId] e [ItemName]
// Estes campos devem ser publicos e de instancia (não estáticos)
ProcedureCall procedureCall = new ProcedureCall(procedureName, sqlConnection);
procedureCall.parameters.Add(new ProcedureParam("@tenantId", SqlDbType.Int, 4, 4));
procedureCall.Execute(true);
List <Object> returnList = procedureCall.ExtractFromResultset(objectType);
ItemScaffolding itemScaffolding = new ItemScaffolding();
itemScaffolding.FindItemFields(objectType);
Object[] itemArray = new Object[returnList.Count + 1];
itemArray[0] = Activator.CreateInstance(objectType);
itemScaffolding.SetItemId(itemArray[0], 0);
itemScaffolding.SetItemName(itemArray[0], "");
int ndx = 1;
foreach (Object obj in returnList)
{
itemArray[ndx] = Activator.CreateInstance(objectType);
itemScaffolding.SetItemId(itemArray[ndx], itemScaffolding.GetItemId(obj));
itemScaffolding.SetItemName(itemArray[ndx], itemScaffolding.GetItemName(obj));
ndx++;
}
return(itemArray);
}
public void SetPrintingDevice(PrintingDevice printingDevice)
{
ProcedureCall storePrintingDevice = new ProcedureCall("pr_storePrintingDevice", sqlConnection);
storePrintingDevice.parameters.Add(new ProcedureParam("@tenantId", SqlDbType.Int, 4, printingDevice.tenantId));
storePrintingDevice.parameters.Add(new ProcedureParam("@ipAddress", SqlDbType.VarChar, 100, printingDevice.ipAddress));
storePrintingDevice.parameters.Add(new ProcedureParam("@description", SqlDbType.VarChar, 100, printingDevice.description));
storePrintingDevice.parameters.Add(new ProcedureParam("@serialNumber", SqlDbType.VarChar, 100, printingDevice.serialNumber));
storePrintingDevice.parameters.Add(new ProcedureParam("@counter", SqlDbType.Int, 4, printingDevice.counter));
storePrintingDevice.Execute(true);
int?deviceId = storePrintingDevice.ExtractFromResultset();
if (deviceId != null)
{
List <Object> counterHistory = GetCounterHistory(deviceId.Value);
if (counterHistory.Count > 0)
{
// Verifica se o contador é repetido, considera uma diferença de 50 páginas ao comparar
DateTime today = DateTime.Now;
PageCounter lastCounter = (PageCounter)counterHistory[0];
Decimal diff = Math.Abs(printingDevice.counter - lastCounter.counter);
if ((lastCounter.date.Day != today.Day) || (diff > 50))
{
SetPageCounter(deviceId.Value, printingDevice.counter);
}
}
else
{
// Nenhum contador prévio, insere primeira ocorrência
SetPageCounter(deviceId.Value, printingDevice.counter);
}
}
}
public void RemovePrintingDevice(int id)
{
ProcedureCall removePrintingDevice = new ProcedureCall("pr_removePrintingDevice", sqlConnection);
removePrintingDevice.parameters.Add(new ProcedureParam("@id", SqlDbType.Int, 4, id));
removePrintingDevice.Execute(false);
}
public void RemoveSmtpServer(int smtpServerId)
{
ProcedureCall removeSmtpServer = new ProcedureCall("pr_removeSmtpServer", sqlConnection);
removeSmtpServer.parameters.Add(new ProcedureParam("@smtpServerId", SqlDbType.Int, 4, smtpServerId));
removeSmtpServer.Execute(false);
}
public void RemoveCostCenterTree(int tenantId)
{
ProcedureCall removeCostCenters = new ProcedureCall("pr_removeCostCenter", sqlConnection);
removeCostCenters.parameters.Add(new ProcedureParam("@tenantId", SqlDbType.Int, 4, tenantId));
removeCostCenters.Execute(false);
}
public void RemoveTenant(int tenantId)
{
ProcedureCall removeTenant = new ProcedureCall("pr_removeTenant", sqlConnection);
removeTenant.parameters.Add(new ProcedureParam("@tenantId", SqlDbType.Int, 4, tenantId));
removeTenant.Execute(false);
}
public void RemoveCostCenter(int costCenterId)
{
ProcedureCall removeCostCenter = new ProcedureCall("pr_removeCostCenter", sqlConnection);
removeCostCenter.parameters.Add(new ProcedureParam("@costCenterId", SqlDbType.Int, 4, costCenterId));
removeCostCenter.Execute(false);
}
public void RemoveLogin(int loginId)
{
ProcedureCall removeLogin = new ProcedureCall("pr_removeLogin", sqlConnection);
removeLogin.parameters.Add(new ProcedureParam("@loginId", SqlDbType.Int, 4, loginId));
removeLogin.Execute(false);
}
public void RemoveAllAssociates(int costCenterId)
{
ProcedureCall removeAssociates = new ProcedureCall("pr_removeAssociate", sqlConnection);
removeAssociates.parameters.Add(new ProcedureParam("@costCenterId", SqlDbType.Int, 4, costCenterId));
removeAssociates.Execute(false);
}
public void SetPageCounter(int deviceId, int counter)
{
ProcedureCall storePageCounter = new ProcedureCall("pr_storePageCounter", sqlConnection);
storePageCounter.parameters.Add(new ProcedureParam("@deviceId", SqlDbType.Int, 4, deviceId));
storePageCounter.parameters.Add(new ProcedureParam("@counter", SqlDbType.Int, 4, counter));
storePageCounter.Execute(false);
}
public void SetAssociate(CostCenterAssociate associate)
{
ProcedureCall storeAssociate = new ProcedureCall("pr_storeAssociate", sqlConnection);
storeAssociate.parameters.Add(new ProcedureParam("@tenantId", SqlDbType.Int, 4, associate.tenantId));
storeAssociate.parameters.Add(new ProcedureParam("@costCenterId", SqlDbType.Int, 4, associate.costCenterId));
storeAssociate.parameters.Add(new ProcedureParam("@userId", SqlDbType.Int, 4, associate.userId));
storeAssociate.Execute(false);
}
public void SetLogin(AdministratorLogin login)
{
ProcedureCall storeLogin = new ProcedureCall("pr_storeAdministratorLogin", sqlConnection);
storeLogin.parameters.Add(new ProcedureParam("@loginId", SqlDbType.Int, 4, login.id));
storeLogin.parameters.Add(new ProcedureParam("@username", SqlDbType.VarChar, 100, login.username));
storeLogin.parameters.Add(new ProcedureParam("@password", SqlDbType.VarChar, 100, login.password));
storeLogin.Execute(false);
}
public void SetCostCenter(CostCenter costCenter)
{
ProcedureCall storeCostCenter = new ProcedureCall("pr_storeCostCenter", sqlConnection);
storeCostCenter.parameters.Add(new ProcedureParam("costCenterId", SqlDbType.Int, 4, costCenter.id));
storeCostCenter.parameters.Add(new ProcedureParam("@tenantId", SqlDbType.Int, 4, costCenter.tenantId));
storeCostCenter.parameters.Add(new ProcedureParam("@name", SqlDbType.VarChar, 100, costCenter.name));
storeCostCenter.parameters.Add(new ProcedureParam("@parentId", SqlDbType.Int, 4, costCenter.parentId));
storeCostCenter.Execute(false);
}
public void SetParam(ApplicationParam param)
{
ProcedureCall updateAccountingParam = new ProcedureCall("pr_storeAccountingParam", sqlConnection);
updateAccountingParam.parameters.Add(new ProcedureParam("@paramId", SqlDbType.Int, 4, param.id));
updateAccountingParam.parameters.Add(new ProcedureParam("@name", SqlDbType.VarChar, 100, param.name));
updateAccountingParam.parameters.Add(new ProcedureParam("@value", SqlDbType.VarChar, 255, param.value));
updateAccountingParam.parameters.Add(new ProcedureParam("@ownerTask", SqlDbType.VarChar, 100, param.ownerTask));
updateAccountingParam.Execute(false);
}
public int?SetTenant(Tenant tenant)
{
ProcedureCall storeTenant = new ProcedureCall("pr_storeTenant", sqlConnection);
storeTenant.parameters.Add(new ProcedureParam("@tenantId", SqlDbType.Int, 4, tenant.id));
storeTenant.parameters.Add(new ProcedureParam("name", SqlDbType.VarChar, 100, tenant.name));
storeTenant.parameters.Add(new ProcedureParam("@alias", SqlDbType.VarChar, 100, tenant.alias));
storeTenant.Execute(true);
return(storeTenant.ExtractFromResultset()); // retorna o id da empresa
}
public List <Object> GetAllTenants()
{
List <Object> tenantList;
ProcedureCall retrieveTenants = new ProcedureCall("pr_retrieveTenant", sqlConnection);
retrieveTenants.Execute(true);
tenantList = retrieveTenants.ExtractFromResultset(typeof(Tenant));
return(tenantList);
}
public List <Object> GetAllLogins()
{
List <Object> administratorLogins;
ProcedureCall retrieveLogin = new ProcedureCall("pr_retrieveAdministratorLogin", sqlConnection);
retrieveLogin.Execute(true);
administratorLogins = retrieveLogin.ExtractFromResultset(typeof(AdministratorLogin));
return(administratorLogins);
}
public void SetLicense(License license)
{
ProcedureCall storeLicense = new ProcedureCall("pr_storeLicense", sqlConnection);
storeLicense.parameters.Add(new ProcedureParam("@licenseId", SqlDbType.Int, 4, license.id));
storeLicense.parameters.Add(new ProcedureParam("@tenantId", SqlDbType.Int, 4, license.tenantId));
storeLicense.parameters.Add(new ProcedureParam("@installationKey", SqlDbType.VarChar, 255, license.installationKey));
storeLicense.parameters.Add(new ProcedureParam("@installationDate", SqlDbType.DateTime, 8, license.installationDate));
storeLicense.parameters.Add(new ProcedureParam("@computerName", SqlDbType.VarChar, 100, license.computerName));
storeLicense.Execute(false);
}
public void SetTenantPreference(Preference preference)
{
ProcedureCall storeTenantPreference = new ProcedureCall("pr_storeTenantPreference", sqlConnection);
storeTenantPreference.parameters.Add(new ProcedureParam("@tenantId", SqlDbType.Int, 4, preference.tenantId));
storeTenantPreference.parameters.Add(new ProcedureParam("@preferenceId", SqlDbType.Int, 4, preference.id));
storeTenantPreference.parameters.Add(new ProcedureParam("@name", SqlDbType.VarChar, 100, preference.name));
storeTenantPreference.parameters.Add(new ProcedureParam("@value", SqlDbType.VarChar, 255, preference.value));
storeTenantPreference.parameters.Add(new ProcedureParam("@type", SqlDbType.VarChar, 80, preference.type));
storeTenantPreference.Execute(false);
}
public List <Object> GetAllParams()
{
List <Object> accountingParams;
ProcedureCall retrieveAccountingParams = new ProcedureCall("pr_retrieveAccountingParams", sqlConnection);
retrieveAccountingParams.Execute(true);
accountingParams = retrieveAccountingParams.ExtractFromResultset(typeof(ApplicationParam));
return(accountingParams);
}
public List <Object> GetAllLogins(int tenantId)
{
List <Object> logins;
ProcedureCall retrieveLogins = new ProcedureCall("pr_retrieveLogin", sqlConnection);
retrieveLogins.parameters.Add(new ProcedureParam("@tenantId", SqlDbType.Int, 4, tenantId));
retrieveLogins.Execute(true);
logins = retrieveLogins.ExtractFromResultset(typeof(Login));
return(logins);
}
public List <Object> GetAllAssociates(int tenantId)
{
List <Object> associateList;
ProcedureCall retrieveAssociates = new ProcedureCall("pr_retrieveAssociates", sqlConnection);
retrieveAssociates.parameters.Add(new ProcedureParam("@tenantId", SqlDbType.Int, 4, tenantId));
retrieveAssociates.Execute(true);
associateList = retrieveAssociates.ExtractFromResultset(typeof(CostCenterAssociate));
return(associateList);
}
public List <Object> GetAllSmtpServers(int tenantId)
{
List <Object> smtpServers;
ProcedureCall retrieveSmtpServers = new ProcedureCall("pr_retrieveSmtpServer", sqlConnection);
retrieveSmtpServers.parameters.Add(new ProcedureParam("@tenantId", SqlDbType.Int, 4, tenantId));
retrieveSmtpServers.Execute(true);
smtpServers = retrieveSmtpServers.ExtractFromResultset(typeof(SmtpServer));
return(smtpServers);
}
public List <Object> GetAllPrintingDevices(int tenantId)
{
List <Object> deviceList;
ProcedureCall retrievePrintingDevices = new ProcedureCall("pr_retrievePrintingDevice", sqlConnection);
retrievePrintingDevices.parameters.Add(new ProcedureParam("@tenantId", SqlDbType.Int, 4, tenantId));
retrievePrintingDevices.Execute(true);
deviceList = retrievePrintingDevices.ExtractFromResultset(typeof(PrintingDevice));
return(deviceList);
}
public List <Object> GetAllUsers(int tenantId)
{
List <Object> userList;
ProcedureCall retrieveUsers = new ProcedureCall("pr_retrieveUser", sqlConnection);
retrieveUsers.parameters.Add(new ProcedureParam("@tenantId", SqlDbType.Int, 4, tenantId));
retrieveUsers.Execute(true);
userList = retrieveUsers.ExtractFromResultset(typeof(User));
return(userList);
}
public List <Object> GetAllTenantPreferences(int tenantId)
{
List <Object> tenantPreferences;
ProcedureCall retrieveTenantPreferences = new ProcedureCall("pr_retrieveTenantPreference", sqlConnection);
retrieveTenantPreferences.parameters.Add(new ProcedureParam("@tenantId", SqlDbType.Int, 4, tenantId));
retrieveTenantPreferences.Execute(true);
tenantPreferences = retrieveTenantPreferences.ExtractFromResultset(typeof(Preference));
return(tenantPreferences);
}
public List <Object> GetCounterHistory(int deviceId)
{
List <Object> counterHistory;
ProcedureCall retrievePageCounters = new ProcedureCall("pr_retrievePageCounter", sqlConnection);
retrievePageCounters.parameters.Add(new ProcedureParam("@deviceId", SqlDbType.Int, 4, deviceId));
retrievePageCounters.Execute(true);
counterHistory = retrievePageCounters.ExtractFromResultset(typeof(PageCounter));
return(counterHistory);
}
public List <Object> GetAllMailings(int tenantId)
{
List <Object> mailingList;
ProcedureCall retrieveMailings = new ProcedureCall("pr_retrieveMailing", sqlConnection);
retrieveMailings.parameters.Add(new ProcedureParam("@tenantId", SqlDbType.Int, 4, tenantId));
retrieveMailings.Execute(true);
mailingList = retrieveMailings.ExtractFromResultset(typeof(Mailing));
return(mailingList);
}