// ================================================================================================================
// Almacenar integraciones en el sistema.
// ================================================================================================================
public int saveIntegrationManual(int userId, string integrationName, int webServiceId, int databaseParametersId,
int flatFileParameterId, int integrationTypeId, int queryId,
int operationWebServiceId, List <QueryParameter> queryParameters,
string curlParameters = null)
{
Integration integration = new Integration();
integration.IntegrationDate = DateTime.Now;
integration.UserId = userId;
integration.IntegrationName = integrationName;
integration.CurlParameters = curlParameters;
integration.WebServiceId = webServiceId;
integration.OperationWebServiceId = operationWebServiceId;
integration.DatabaseParametersId = databaseParametersId;
integration.FlatFileId = integrationDB.FlatFiles.Where(param => param.Name == "Default").ToList()[0].FlatFileId;
integration.FlatFileParameterId = flatFileParameterId;
integration.IntegrationTypeId = integrationTypeId;
integration.QueryId = queryId;
integration.IntegrationCategoryId = integrationDB.IntegrationCategories.Where(param => param.Name == "Manual").ToList()[0].IntegrationCategoryId;
integration.StatusId = integrationDB.Status.Where(param => param.Name == "Enable").ToList()[0].StatusId;
integration.QueryParameters = queryParameters;
integrationDB.Integrations.Add(integration);
integrationDB.SaveChanges();
return(integration.IntegrationId);
}
// ================================================================================================================
// Almacenar datos relacionados con la gestón de usuarios en el sistema.
// ================================================================================================================
public void saveUser(string userTypeId, string name, string username, string email, string password, string[] resourcesIds)
{
User user = new User();
user.UserTypeId = Convert.ToInt32(userTypeId);
user.Name = name;
user.Username = username;
user.Email = email;
user.Password = password;
int status = usersDB.Status.Where(param => param.Name == "Enable").ToList()[0].StatusId;
user.StatusId = status;
usersDB.Users.Add(user);
usersDB.SaveChanges();
foreach (string resource in resourcesIds)
{
Permission permission = new Permission();
permission.ResourceId = Convert.ToInt32(resource);
permission.UserId = user.UserId;
usersDB.Permissions.Add(permission);
}
usersDB.SaveChanges();
}
// ================================================================================================================
// Almacenar parametros del sistema.
// ================================================================================================================
public void saveActiveDirectory(string domain, string path)
{
ActiveDirectoryParameter ad = new ActiveDirectoryParameter();
ad.ADPath = domain;
ad.ADDomain = path;
ConfigurationDB.ActiveDirectoryParameters.Add(ad);
ConfigurationDB.SaveChanges();
}