public static Templates GetOne(int IdTemplate)
{
SqlCommand cb = new SqlCommand("GetTemplates");
DataAccess db = new DataAccess();
cb.Parameters.AddWithValue("@IdTemplate", IdTemplate);
return DbSet<Templates>.RowToT(db.GetTable(cb).Rows[0]);
}
public static EntityFields GetOne(int Id)
{
SqlCommand cb = new SqlCommand("GetEntityFields");
DataAccess db = new DataAccess();
cb.Parameters.AddWithValue("@Id", Id);
return GenericCodeFirst.DbSet<EntityFields>.RowToT(db.GetTable(cb).Rows[0]);
}
public static List<EntityFields> GetAll(int Id)
{
DataAccess db = new DataAccess();
SqlCommand cb = new SqlCommand("GetAllEntityFields");
cb.Parameters.AddWithValue("@Id", Id);
return GenericCodeFirst.DbSet<EntityFields>.TableToListT(db.GetTable(cb));
}
public static DataType GetOne(int Id)
{
SqlCommand cb = new SqlCommand("GetDataType");
DataAccess db = new DataAccess();
cb.Parameters.AddWithValue("@Id", Id);
return DbSet<DataType>.RowToT(db.GetTable(cb).Rows[0]);
}
public static Entity GetOneByName(string name)
{
SqlCommand cb = new SqlCommand("GetEntityByName");
DataAccess db = new DataAccess();
cb.Parameters.AddWithValue("@name", name);
return GenericCodeFirst.DbSet<Entity>.RowToT(db.GetTable(cb).Rows[0]);
}
public static bool Exist(string name)
{
SqlCommand cb = new SqlCommand("GetEntityByName");
DataAccess db = new DataAccess();
cb.Parameters.AddWithValue("@name", name);
if (db.GetTable(cb).Rows.Count >= 1)
return true;
else
return false;
}
public static List<Templates> GetAll()
{
DataAccess db = new DataAccess();
SqlCommand cb = new SqlCommand("GetAllTemplates");
return DbSet<Templates>.TableToListT(db.GetTable(cb));
}
public static List<DataType> GetAll()
{
DataAccess db = new DataAccess();
SqlCommand cb = new SqlCommand("GetAllDataType");
return DbSet<DataType>.TableToListT(db.GetTable(cb));
}
public static List<Entity> GetAll()
{
DataAccess db = new DataAccess();
SqlCommand cb = new SqlCommand("GetAllEntity");
return GenericCodeFirst.DbSet<Entity>.TableToListT(db.GetTable(cb));
}