public admin_shop get_shop(string sShopId)
{
StringBuilder sb = new StringBuilder();
admin_shop shop = new admin_shop();
string sSql =
"select s.id, s.parent_name, s.name, s.shop_external_id, c.value_1 percent, accept_terminal_enrollment, enrollment_sms_text " +
"from shop s, shop_coupon sc, coupon c, coupon_type ct " +
"where " +
"s.id = " + sShopId + " and " +
"sc.shop_id = s.id and " +
"c.id = sc.coupon_id and " +
"c.coupon_type_id=ct.id and " +
"ct.name='enrollment_loyalty_discount'";
GLOBAL_SQL_CONN conn = new GLOBAL_SQL_CONN(this);
try
{
GLOBAL_SQL_COMMAND command = new GLOBAL_SQL_COMMAND(sSql, conn);
GLOBAL_SQL_READER reader = new GLOBAL_SQL_READER(command);
if (reader.Read())
{
shop.iId = (int)reader.c("id");
shop.sParentName = (string)reader.c("parent_name");
shop.sName = (string)reader.c("name");
shop.sMerchantId = (string)reader.c("shop_external_id");
shop.sSmsText = (string)reader.c("enrollment_sms_text");
shop.iLoyaltyPercent = (int)reader.c("percent");
shop.bAcceptTerminalEnrollment = (bool)reader.c("accept_terminal_enrollment");
} else
shop = null;
} catch (Exception e)
{
shop = null;
} finally
{
conn.Close();
}
if (shop == null)
return get_shop_heading_only(sShopId);
return shop;
}
private admin_shop get_shop_heading_only(string sShopId)
{
StringBuilder sb = new StringBuilder();
admin_shop shop = new admin_shop();
string sSql =
"select s.id, s.parent_name,s.shop_external_id, s.name, accept_terminal_enrollment, enrollment_sms_text " +
"from shop s, shop_coupon sc, coupon c, coupon_type ct " +
"where " +
"s.id = " + sShopId;
GLOBAL_SQL_CONN conn = new GLOBAL_SQL_CONN(this);
try
{
GLOBAL_SQL_COMMAND command = new GLOBAL_SQL_COMMAND(sSql, conn);
GLOBAL_SQL_READER reader = new GLOBAL_SQL_READER(command);
if (reader.Read())
{
shop.iId = (int)reader.c("id");
shop.sParentName = (string)reader.c("parent_name");
shop.sMerchantId = (string)reader.c("shop_external_id");
shop.sSmsText = (string)reader.c("enrollment_sms_text");
shop.bAcceptTerminalEnrollment = (bool)reader.c("accept_terminal_enrollment");
shop.sName = (string)reader.c("name");
}
} catch (Exception e)
{
shop = null;
} finally
{
conn.Close();
}
return shop;
}
public List<admin_shop> get_all_shops(string sChainId, bool bEnrollmentAcceptedInTerminal)
{
StringBuilder sb = new StringBuilder();
List<admin_shop> shopList = new List<admin_shop>();
string sSql =
"select id, name,shop_external_id, accept_terminal_enrollment from shop " +
"where parent_shop='" + sChainId + "' and accept_terminal_enrollment=" + bEnrollmentAcceptedInTerminal.ToString() + " order by name";
GLOBAL_SQL_CONN conn = new GLOBAL_SQL_CONN(this);
try
{
GLOBAL_SQL_COMMAND command = new GLOBAL_SQL_COMMAND(sSql, conn);
GLOBAL_SQL_READER reader = new GLOBAL_SQL_READER(command);
while (reader.Read())
{
admin_shop shop = new admin_shop();
shop.iId = (int)reader.c("id");
shop.sName = (string)reader.c("name");
shop.sMerchantId = (string)reader.c("shop_external_id");
shop.bAcceptTerminalEnrollment = (bool)reader.c("accept_terminal_enrollment");
shopList.Add(shop);
}
} catch (Exception e)
{
shopList = null;
} finally
{
conn.Close();
}
return shopList;
}
