public static bool RedeemTicket(Int32 GymAccountId, Int32 GymId, string Barcode)
{
using (ConnectorBase conn = ConnectorBase.NewInstance())
{
Barcode = CleanupBarcode(Barcode);
Query qry = Query.New <GymTicket>()
.Update(GymTicket.Columns.Status, GymTicketStatus.Redeemed)
.Update(GymTicket.Columns.RedeemDate, DateTime.UtcNow)
.Where(GymTicket.TableSchema.SchemaName, GymTicket.Columns.Barcode, dg.Sql.WhereComparision.EqualsTo, Barcode)
.AND(GymTicket.TableSchema.SchemaName, GymTicket.Columns.Status, dg.Sql.WhereComparision.EqualsTo, GymTicketStatus.Available);
if (GymAccountId > 0)
{
qry.Join(JoinType.InnerJoin, Gym.TableSchema, Gym.TableSchema.SchemaName,
new JoinColumnPair(GymTicket.TableSchema, GymTicket.Columns.GymId, Gym.Columns.GymId))
.AND(Gym.TableSchema.SchemaName, Gym.Columns.GymAccountId, dg.Sql.WhereComparision.EqualsTo, GymAccountId);
}
if (GymId > 0)
{
qry.AND(GymTicket.TableSchema.SchemaName, GymTicket.Columns.GymId, dg.Sql.WhereComparision.EqualsTo, GymId);
}
bool result = qry.Execute(conn) == 1;
try
{
Int64 AppUserId = 0;
using (DataReaderBase reader =
Query.New <GymTicket>()
.Select(GymTicket.Columns.GymId)
.AddSelect(GymTicket.Columns.AppUserId)
.Where(GymTicket.Columns.Barcode, Barcode)
.LimitRows(1)
.ExecuteReader(conn))
{
if (reader.Read())
{
GymId = reader.GetInt32(0);
AppUserId = reader.GetInt64(1);
}
}
if (AppUserId > 0)
{
Int64 GymCheckinId;
GymCheckinController.CheckinPointsAction[] PointsGenerated;
GymCheckinController.Checkin(conn, AppUserId, GymId, Barcode, null, out GymCheckinId, out PointsGenerated);
}
}
catch { }
return(result);
}
}
public static Int32 PermissionIdByKey(string permission)
{
Query qry = new Query(Permission.TableSchema)
.Select(Permission.Columns.PermissionId)
.Where(Permission.Columns.Key, permission);
using (DataReaderBase reader = qry.ExecuteReader())
{
while (reader.Read())
{
return(reader.GetInt32(0));
}
}
return(0);
}
protected void Page_Init(object sender, EventArgs e)
{
Pair[] items = HttpContext.Current.Items[HTTPCONTEXT_ITEMS_KEY] as Pair[];
if (items == null)
{
Query qry = new Query(EmailTemplate.TableSchema)
.Select(EmailTemplate.Columns.EmailTemplateId)
.AddSelect(EmailTemplate.Columns.Name);
using (DataReaderBase reader = qry.ExecuteReader())
{
List <Pair> list = new List <Pair>();
while (reader.Read())
{
list.Add(new Pair(reader.GetInt32(0), reader.GetStringOrEmpty(1)));
}
HttpContext.Current.Items[HTTPCONTEXT_ITEMS_KEY] = items = list.ToArray();
}
}
string[] AvailableLanguages = AppConfig.GetString(@"AvailableLanguages", @"").Split(','), langParts;
foreach (string lang in AvailableLanguages)
{
langParts = lang.Split(':');
HtmlTableRow row = new HtmlTableRow();
HtmlTableCell cell1 = new HtmlTableCell();
HtmlTableCell cell2 = new HtmlTableCell();
DropDownList ddl = new DropDownList();
cell1.InnerText = langParts[1] + @" (" + langParts[0] + @")";
ddl.Items.Add(new ListItem(GlobalStrings.GetText(@"NoneForDropDowns"), "0"));
foreach (Pair p in items)
{
ddl.Items.Add(new ListItem(p.Second.ToString(), p.First.ToString()));
}
cell2.Controls.Add(ddl);
row.Cells.Add(cell1);
row.Cells.Add(cell2);
tblOptions.Rows.Add(row);
mapDdls[langParts[0]] = ddl;
}
}