public static void Update(string uuid, EntitySensitiveInformation sensitiveInformation)
{
string columnsAndValues = BuilderColumnsValuesSensitiveInformation
.GetValuesAndColumnsToUpdate(sensitiveInformation);
SqlCommandUpdateByUuid.Execute(tableName, uuid, columnsAndValues.ToString());
}
internal static string GetValuesAndColumnsToUpdate(EntitySensitiveInformation sensitiveInformation)
{
StringBuilder columnsAndValues = new StringBuilder();
columnsAndValues.Append($"{columnsNames["type"]}='{sensitiveInformation.type}',");
columnsAndValues.Append($"{columnsNames["informationName"]}='{sensitiveInformation.informationName}',");
columnsAndValues.Append($"{columnsNames["containerName"]}='{sensitiveInformation.containerName}',");
columnsAndValues.Append($"{columnsNames["notes"]}='{sensitiveInformation.notes}',");
columnsAndValues.Append($"{columnsNames["username"]}='{sensitiveInformation.username}',");
columnsAndValues.Append($"{columnsNames["password"]}='{sensitiveInformation.password}',");
columnsAndValues.Append($"{columnsNames["urlsList"]}='{sensitiveInformation.urlsList}',");
columnsAndValues.Append($"{columnsNames["cardName"]}='{sensitiveInformation.cardName}',");
columnsAndValues.Append($"{columnsNames["cardEntity"]}='{sensitiveInformation.cardEntity}',");
columnsAndValues.Append($"{columnsNames["cardNumber"]}='{sensitiveInformation.cardNumber}',");
columnsAndValues.Append($"{columnsNames["cardExpirationDate"]}='{sensitiveInformation.cardExpirationDate}',");
columnsAndValues.Append($"{columnsNames["cardSecurityNumber"]}='{sensitiveInformation.cardSecurityNumber}',");
columnsAndValues.Append($"{columnsNames["contactName"]}='{sensitiveInformation.contactName}',");
columnsAndValues.Append($"{columnsNames["contactLastname"]}='{sensitiveInformation.contactLastname}',");
columnsAndValues.Append($"{columnsNames["businessName"]}='{sensitiveInformation.businessName}',");
columnsAndValues.Append($"{columnsNames["emailsList"]}='{sensitiveInformation.emailsList}',");
columnsAndValues.Append($"{columnsNames["phoneNumbersList"]}='{sensitiveInformation.phoneNumbersList}',");
columnsAndValues.Append($"{columnsNames["addressesList"]}='{sensitiveInformation.addressesList}',");
columnsAndValues.Append($"{columnsNames["postalCode"]}='{sensitiveInformation.postalCode}',");
columnsAndValues.Append($"{columnsNames["country"]}='{sensitiveInformation.country}',");
columnsAndValues.Append($"{columnsNames["state"]}='{sensitiveInformation.state}',");
columnsAndValues.Append($"{columnsNames["birthday"]}='{sensitiveInformation.birthday}',");
columnsAndValues.Append($"{columnsNames["tagsList"]}='{sensitiveInformation.tagsList}',");
columnsAndValues.Append($"{columnsNames["favorite"]}='{sensitiveInformation.favorite}',");
columnsAndValues.Append($"{columnsNames["contentKey"]}='{sensitiveInformation.contentKey}'");
return(columnsAndValues.ToString());
}
internal static string GetValuesToCreate(EntitySensitiveInformation sensitiveInformation)
{
StringBuilder values = new StringBuilder();
values.Append($"'{ sensitiveInformation.type }',");
values.Append($"'{ sensitiveInformation.informationName }',");
values.Append($"'{ sensitiveInformation.containerName }',");
values.Append($"'{ sensitiveInformation.notes }',");
values.Append($"'{ sensitiveInformation.username }',");
values.Append($"'{ sensitiveInformation.password }',");
values.Append($"'{ sensitiveInformation.urlsList }',");
values.Append($"'{ sensitiveInformation.cardName }',");
values.Append($"'{ sensitiveInformation.cardEntity }',");
values.Append($"'{ sensitiveInformation.cardNumber }',");
values.Append($"'{ sensitiveInformation.cardExpirationDate }',");
values.Append($"'{ sensitiveInformation.cardSecurityNumber }',");
values.Append($"'{ sensitiveInformation.contactName }',");
values.Append($"'{ sensitiveInformation.contactLastname }',");
values.Append($"'{ sensitiveInformation.businessName }',");
values.Append($"'{ sensitiveInformation.emailsList }',");
values.Append($"'{ sensitiveInformation.phoneNumbersList }',");
values.Append($"'{ sensitiveInformation.addressesList }',");
values.Append($"'{ sensitiveInformation.postalCode }',");
values.Append($"'{ sensitiveInformation.country }',");
values.Append($"'{ sensitiveInformation.state }',");
values.Append($"'{ sensitiveInformation.birthday }',");
values.Append($"'{ sensitiveInformation.tagsList }',");
values.Append($"'{ sensitiveInformation.favorite }',");
values.Append($"'{ sensitiveInformation.contentKey }'");
return(values.ToString());
}
public static void Create(EntitySensitiveInformation sensitiveInformation)
{
string columns = BuilderColumnsValuesSensitiveInformation
.GetColumnsToCreate();
string values = BuilderColumnsValuesSensitiveInformation
.GetValuesToCreate(sensitiveInformation);
SqlCommandInsert.Execute(tableName, columns.ToString(), values.ToString());
}
public static SensitiveInformation GetModel(EntitySensitiveInformation entitySI)
{
SensitiveInformation modelSI = new SensitiveInformation();
modelSI.id = entitySI.id;
modelSI.uuid = entitySI.uuid.ToString();
modelSI.type = ConvertStringToEnum <EnumSIType> .Convert(entitySI.type);
modelSI.informationName = entitySI.informationName;
modelSI.containerName = entitySI.containerName;
modelSI.notes = entitySI.notes;
modelSI.username = entitySI.username;
modelSI.password = entitySI.password;
modelSI.cardName = entitySI.cardName;
modelSI.cardEntity = entitySI.cardEntity;
modelSI.cardNumber = entitySI.cardNumber;
modelSI.cardExpirationDate = entitySI.cardExpirationDate;
modelSI.cardSecurityNumber = entitySI.cardSecurityNumber;
modelSI.contactName = entitySI.contactName;
modelSI.contactLastname = entitySI.contactLastname;
modelSI.businessName = entitySI.businessName;
modelSI.postalCode = entitySI.postalCode;
modelSI.country = entitySI.country;
modelSI.state = entitySI.state;
modelSI.birthday = entitySI.birthday;
modelSI.favorite = entitySI.favorite;
modelSI.contentKey = entitySI.contentKey;
modelSI.tagsList = ConvertStringToList <string> .Convert(entitySI.tagsList);
modelSI.addressesList = ConvertStringToList <string> .Convert(entitySI.addressesList);
modelSI.phoneNumbersList = ConvertStringToList <string> .Convert(entitySI.phoneNumbersList);
modelSI.emailsList = ConvertStringToList <string> .Convert(entitySI.emailsList);
modelSI.urlsList = ConvertStringToList <string> .Convert(entitySI.urlsList);
return(modelSI);
}
public static EntitySensitiveInformation GetEntity(SensitiveInformation modelSI)
{
EntitySensitiveInformation entitySI = new EntitySensitiveInformation();
entitySI.type = modelSI.type.ToString();
entitySI.informationName = modelSI.informationName;
entitySI.containerName = modelSI.containerName;
entitySI.notes = modelSI.notes;
entitySI.username = modelSI.username;
entitySI.password = modelSI.password;
entitySI.cardName = modelSI.cardName;
entitySI.cardEntity = modelSI.cardEntity;
entitySI.cardNumber = modelSI.cardNumber;
entitySI.cardExpirationDate = modelSI.cardExpirationDate;
entitySI.cardSecurityNumber = modelSI.cardSecurityNumber;
entitySI.contactName = modelSI.contactName;
entitySI.contactLastname = modelSI.contactLastname;
entitySI.businessName = modelSI.businessName;
entitySI.postalCode = modelSI.postalCode;
entitySI.country = modelSI.country;
entitySI.state = modelSI.state;
entitySI.birthday = modelSI.birthday;
entitySI.favorite = modelSI.favorite;
entitySI.contentKey = modelSI.contentKey;
entitySI.tagsList = ConvertListToString <string> .Convert(modelSI.tagsList);
entitySI.addressesList = ConvertListToString <string> .Convert(modelSI.addressesList);
entitySI.phoneNumbersList = ConvertListToString <string> .Convert(modelSI.phoneNumbersList);
entitySI.emailsList = ConvertListToString <string> .Convert(modelSI.emailsList);
entitySI.urlsList = ConvertListToString <string> .Convert(modelSI.urlsList);
return(entitySI);
}
public void Update(string uuid, SensitiveInformation modelSI)
{
EntitySensitiveInformation entitySI = MappingDomainEntityToEntity.GetEntity(modelSI);
CrudManagerSensitiveInformation.Update(uuid, entitySI);
}
public void Create(SensitiveInformation modelSI)
{
EntitySensitiveInformation entitySI = MappingDomainEntityToEntity.GetEntity(modelSI);
CrudManagerSensitiveInformation.Create(entitySI);
}
public static void Update(int id, ModelSensitiveInformation modelSI)
{
EntitySensitiveInformation entitySI = MappingModelToEntity.GetEntity(modelSI);
CrudManagerSensitiveInformation.Update(id, entitySI);
}
public static void Create(ModelSensitiveInformation modelSI)
{
EntitySensitiveInformation entitySI = MappingModelToEntity.GetEntity(modelSI);
CrudManagerSensitiveInformation.Create(entitySI);
}
