public static UInt32 NextPositionProductCatalog(UInt32 Category)
{
DataClassesPrestashop DBPs
= new DataClassesPrestashop(new MySqlConnection(Properties.Settings.Default.PRESTASHOPConnectionString));
if (DBPs.PsCategoryProduct.Count(Obj => Obj.IDCategory == Category) > 0)
{
return DBPs.PsCategoryProduct.Where(Obj => Obj.IDCategory == Category).ToList().Max(cp => cp.Position) + 1;
}
else
return 1;
}
public static UInt32 NextPosition()
{
DataClassesPrestashop DBPs = new DataClassesPrestashop(new MySqlConnection(Properties.Settings.Default.PRESTASHOPConnectionString));
if (DBPs.PsCustomerFeature.Count() > 0)
{
return(DBPs.PsCustomerFeature.ToList().Max(cp => cp.Position) + 1);
}
else
{
return(1);
}
}
public ushort NextPosition()
{
DataClassesPrestashop DBPs = new DataClassesPrestashop(new MySqlConnection(Properties.Settings.Default.PRESTASHOPConnectionString));
if (DBPs.PsAttribute.Count() > 0)
{
return((ushort)(DBPs.PsAttribute.ToList().Max(ag => ag.Position) + 1));
}
else
{
return(1);
}
}
public static ushort NextPositionProductImage(UInt32 Product)
{
DataClassesPrestashop DBPs
= new DataClassesPrestashop(new MySqlConnection(Properties.Settings.Default.PRESTASHOPConnectionString));
if (DBPs.PsImage.Count(im => im.IDProduct == Product) > 0)
{
return((ushort)(DBPs.PsImage.Where(im => im.IDProduct == Product).ToList().Max(cp => cp.Position) + 1));
}
else
{
return(1);
}
}
