public int Add(User entity)
{
var queryString = String.Format("INSERT INTO {0} (Name) VALUES ('{1}');",
c_usersDatabaseName,
entity.Name);
DataBaseHelper.ExecuteCommand(queryString);
return(m_userMapper.GetLastCreatedId(queryString));
}
public int Add(Catalog entity)
{
var queryString = String.Format("INSERT INTO {0} (Name) VALUES ('{1}');",
c_catalogsDatabaseName,
entity.Name
);
return(m_catalogMapper.GetLastCreatedId(queryString));
}
public int Add(Order entity)
{
var queryString = String.Format("INSERT INTO {0} (UserId) VALUES ({1});",
c_ordersDatabaseName,
entity.UserId
);
return(m_orderMapper.GetLastCreatedId(queryString));
}
public int Add(Product entity)
{
var queryString = "";
if (entity.CatalogId == 0)
{
queryString = String.Format("INSERT INTO {0} (Name, Description) VALUES ('{1}', '{2}'); SELECT IDENT_CURRENT('{0}') AS Id;",
c_productsDatabaseName,
entity.Name,
entity.Description
);
}
else
{
queryString = String.Format("INSERT INTO {0} (Name, Description, CatalogId) VALUES ('{1}', '{2}', {3}); SELECT IDENT_CURRENT('{0}') AS Id;",
c_productsDatabaseName,
entity.Name,
entity.Description,
entity.CatalogId);
}
return(m_productMapper.GetLastCreatedId(queryString));
}
