private List <SubItemEntity> ConvertToSubListEntity(ICollection <SubItemEntityModel> subItems)
{
var entities = new List <SubItemEntity>();
foreach (var item in subItems)
{
var x = new SubItemEntity();
{
x.Id = item.Id;
x.IsFieldEnabled = item.IsFieldEnabled;
x.IsFieldEnabledAsBool = item.IsFieldEnabledAsBool;
x.IsNumericFieldEnabled = item.IsNumericFieldEnabled;
x.IsScanEnabled = item.IsScanEnabled;
x.KeepFieldValue = item.KeepFieldValue;
x.KeyboardInput = item.KeyboardInput;
x.Length = item.Length;
x.MenuItemId = item.MenuItemId;
x.Name = item.Name;
x.NumericFieldEnabled = item.NumericFieldEnabled;
x.Offset = item.Offset;
x.ScanEnabled = item.ScanEnabled;
x.StartWith = item.StartWith;
x.Type = item.Type;
x.ValueLength = item.ValueLength;
entities.Add(x);
}
}
return(entities);
}
public SubItemEntity Update(SubItemEntity subItem, int userId)
{
base.Initialize();
base.OpenConnection();
try
{
using (var cmd = new SqlCommand("spr_upd_subitem", connection))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@id_subitem", subItem.Id);
cmd.Parameters.AddWithValue("@nom_subitem", subItem.Name);
cmd.Parameters.AddWithValue("@des_descr", subItem.Description);
//cmd.Parameters.AddWithValue("@dat_criac", subItem.CreationDate);
cmd.Parameters.AddWithValue("@dat_atual", subItem.LastUpdate);
//cmd.Parameters.AddWithValue("@ind_ativa", subItem.IsActive);
cmd.Parameters.AddWithValue("@cod_usu", userId);
cmd.ExecuteNonQuery();
return(subItem);
}
}
catch (Exception ex)
{
throw;
}
finally
{
base.CloseConnection();
}
}
public SubItemSummaryRead ToSubItemRead(SubItemEntity entity)
{
return(new SubItemSummaryRead
{
Id = entity.Id,
Name = entity.Name,
Description = entity.Description
});
}
public SubItemEntity Create(int itemId, SubItemEntity subItem, int userId)
{
var item = _itemService.GetById(itemId);
if (item.Desdobramento == false)
{
throw new Exception("atomic.item");
}
if (item == null)
{
throw new Exception("invelida.id");
}
return(_subItemService.Create(itemId, subItem, userId));
}
public SubItemEntity Create(int itemId, SubItemEntity subItem, int userId)
{
base.Initialize();
base.OpenConnection();
try
{
using (var cmd = new SqlCommand("spr_ins_subitem", connection))
{
using (SqlTransaction tr = connection.BeginTransaction())
{
cmd.Transaction = tr;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@id_item", itemId);
cmd.Parameters.AddWithValue("@nom_subitem", subItem.Name);
cmd.Parameters.AddWithValue("@des_descr", subItem.Description);
cmd.Parameters.AddWithValue("@dat_criac", subItem.CreationDate);
cmd.Parameters.AddWithValue("@dat_atual", subItem.LastUpdate);
cmd.Parameters.AddWithValue("@ind_ativa", subItem.IsActive);
cmd.Parameters.AddWithValue("@cod_usu", userId);
var subItemId = (int)cmd.ExecuteScalar();
this.CreateRelation(itemId, subItemId, cmd);
tr.Commit();
subItem.Id = subItemId;
return(subItem);
}
}
}
catch (Exception ex)
{
throw;
}
finally
{
base.CloseConnection();
}
}
public IEnumerable <SubItemEntity> GetByCompanyAndItemId(int itemId, int companyId)
{
try
{
var collection = new List <SubItemEntity>();
base.Initialize();
this.OpenConnection();
using (var cmd = new SqlCommand("spr_ler_empre_subitem", connection))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@id_item", itemId);
cmd.Parameters.AddWithValue("@id_empresa", companyId);
var dataReader = cmd.ExecuteReader();
while (dataReader.Read())
{
var id = dataReader["id"].ToInt32();
var name = dataReader["nom_subitem"].ToString();
var description = dataReader["des_descr"].ToString();
var creationDate = dataReader["dat_criac"].ToDateTime();
var lastUpdate = dataReader["dat_atual"].ToDateTime();
var isActive = dataReader["ind_ativa"].ToBoolean();
var subItem = new SubItemEntity(id, name, description, isActive, creationDate, lastUpdate);
collection.Add(subItem);
}
}
return(collection);
}
catch (Exception ex)
{
throw;
}
finally
{
base.CloseConnection();
}
}
private RegistrationItemEntity SaveRegistrationsOffline()
{
var subItemsOffline = ((ListView)SubItemsListView).ItemsSource;
var registrationOffline = new RegistrationItemEntity {
MenuItemId = _parentMenuItem.Id, RegistrationValues = new List <RegistrationValueItemEntity>()
};
foreach (var item in subItemsOffline)
{
SubItemEntity subItemEntity = (SubItemEntity)item;
var mainPageDetailViewModel = new MainPageDetailViewModelOffline(subItemEntity);
var registrationValue = new RegistrationValueItemEntity();
registrationValue.SubItemId = subItemEntity.Id;
registrationValue.Value = subItemEntity.FieldValue;
registrationValue.SubItemName = subItemEntity.Name;
registrationOffline.RegistrationValues.Add(registrationValue);
}
App.LocalDatabase.SaveRegistrationItem(registrationOffline);
return(registrationOffline);
}
public SubItemEntity GetById(int id)
{
try
{
base.Initialize();
this.OpenConnection();
using (var cmd = new SqlCommand("spr_ler_subitem", connection))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@id_subitem", id);
var dataReader = cmd.ExecuteReader();
while (dataReader.Read())
{
var idSubItem = dataReader["id"].ToInt32();
var name = dataReader["nom_subitem"].ToString();
var description = dataReader["des_descr"].ToString();
var creationDate = dataReader["dat_criac"].ToDateTime();
var lastUpdate = dataReader["dat_atual"].ToDateTime();
var isActive = dataReader["ind_ativa"].ToBoolean();
var subItem = new SubItemEntity(idSubItem, name, description, isActive, creationDate, lastUpdate);
return(subItem);
}
}
return(null);
}
catch (Exception ex)
{
throw;
}
finally
{
base.CloseConnection();
}
}
public SubItemEntity Update(SubItemEntity subItem, int userId)
{
return(_subItemService.Update(subItem, userId));
}
public SubItemEntity Update(SubItemEntity subItem, int userId)
{
return(_repository.Update(subItem, userId));
}
public SubItemEntity Create(int itemId, SubItemEntity subItem, int username)
{
return(_repository.Create(itemId, subItem, username));
}
public SubItemId(SubItemEntity e)
{
Id = e.Id;
}
public SubItemEntity ToEntity()
{
var entity = new SubItemEntity(Id, Name, Description, true, DateTime.Now, DateTime.Now);
return(entity);
}
