public static bool Save(Models.AdHoc adHoc) { try { using (var ctx = new PlayDataContext { ObjectTrackingEnabled = true }) { adHoc.CreateDate = System.DateTime.Now; ctx.AdHocs.InsertOnSubmit(adHoc); ctx.SubmitChanges(); return true; } } catch { return false; } }
public static int MarkAsPaid(int playOrderId) { try { using (var ctx = new PlayDataContext { ObjectTrackingEnabled = true }) { var playOrder = ctx.PlayOrders.FirstOrDefault(x => x.PlayOrderId == playOrderId); playOrder.Paid = true; playOrder.ModifyDate = System.DateTime.Now; ctx.SubmitChanges(); return playOrderId; } } catch { return -1; } }
public static bool Delete(string secret, int playOrderId) { if (secret.ToLower() != "oblivion") { return false; } try { using (var ctx = new PlayDataContext { ObjectTrackingEnabled = true }) { var playOrder = ctx.PlayOrders.FirstOrDefault(x => x.PlayOrderId == playOrderId); ctx.PlayOrders.DeleteOnSubmit(playOrder); ctx.SubmitChanges(); return true; } } catch { return false; } }
public static bool Save(string msg) { try { using (var ctx = new PlayDataContext { ObjectTrackingEnabled = true }) { var log = new Models.Log { CreateDate = System.DateTime.Now, LogType = "Error", Message = msg }; ctx.Logs.InsertOnSubmit(log); ctx.SubmitChanges(); return true; } } catch { return false; } }
public static int Save(Models.PlayOrder playOrder) { try { using (var ctx = new PlayDataContext { ObjectTrackingEnabled = true }) { playOrder.CreateDate = System.DateTime.Now; playOrder.Paid = false; ctx.PlayOrders.InsertOnSubmit(playOrder); ctx.SubmitChanges(); return playOrder.PlayOrderId; } } catch { return -1; } }