public List <ProductLevel> ListInv(CDBUtil dbUtil, MySqlConnection conn, bool isStockCountConfig)
{
string sql = "";
sql = " SELECT * FROM ProductLevel WHERE Deleted = 0 ";
MySqlDataReader reader;
reader = dbUtil.sqlRetrive(sql, conn);
List <ProductLevel> invList = new List <ProductLevel>();
while (reader.Read())
{
ProductLevel invInfo = new ProductLevel();
if (reader["ProductLevelID"] != DBNull.Value)
{
invInfo.ProductLevelId = reader.GetInt32("ProductLevelID");
}
if (reader["ProductLevelCode"] != DBNull.Value)
{
invInfo.ProductLevelCode = reader.GetString("ProductLevelCode");
}
if (reader["ProductLevelName"] != DBNull.Value)
{
invInfo.ProductLevelName = reader.GetString("ProductLevelName");
}
invList.Add(invInfo);
}
reader.Close();
return(invList);
}
public ProductLevel GetProductLevel(MySqlConnection conn, int dbShopId)
{
ProductLevel productLevel = new ProductLevel();
MySqlCommand cmd = new MySqlCommand("select distinct inventoryid,inventoryname from inventoryview where inventoryid=" + dbShopId, conn);
MySqlDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
productLevel.ProductLevelId = reader.GetInt32("InventoryID");
productLevel.ProductLevelName = reader.GetString("InventoryName");
}
reader.Close();
return(productLevel);
}
public List <ProductLevel> ListInv(CDBUtil dbUtil, MySqlConnection conn, int staffRoleId)
{
bool isHQ = false;
string sql = "";
// Check shop is hq
sql = " SELECT * FROM property WHERE HeadOrBranch=1";
MySqlDataReader reader = dbUtil.sqlRetrive(sql, conn);
if (reader.Read())
{
isHQ = true;
}
else
{
isHQ = false;
}
reader.Close();
sql = "";
if (isHQ)
{
sql = " SELECT * FROM ProductLevel WHERE Deleted = 0 AND IsInv=1 ";
}
else
{
sql = " SELECT * FROM ProductLevel WHERE Deleted = 0 AND IsInv=1 AND ProductLevelID <> 1 ";
}
System.Data.DataTable dtResult = dbUtil.List("SELECT * FROM staffroleviewinventory WHERE StaffRoleID=" + staffRoleId, conn);
if (dtResult.Rows.Count > 0)
{
sql += " AND ProductLevelID IN ( ";
for (int i = 0; i <= dtResult.Rows.Count - 1; i++)
{
sql += dtResult.Rows[i]["ProductLevelID"].ToString();
if (i < dtResult.Rows.Count - 1)
{
sql += " , ";
}
}
sql += " ) ";
}
reader = dbUtil.sqlRetrive(sql, conn);
List <ProductLevel> invList = new List <ProductLevel>();
while (reader.Read())
{
ProductLevel invInfo = new ProductLevel();
if (reader["ProductLevelID"] != DBNull.Value)
{
invInfo.ProductLevelId = reader.GetInt32("ProductLevelID");
}
if (reader["ProductLevelCode"] != DBNull.Value)
{
invInfo.ProductLevelCode = reader.GetString("ProductLevelCode");
}
if (reader["ProductLevelName"] != DBNull.Value)
{
invInfo.ProductLevelName = reader.GetString("ProductLevelName");
}
invList.Add(invInfo);
}
reader.Close();
return(invList);
}