public static bool UpdateGaBaseData(int type, DateTime st, DateTime et) { bool flag = false; try { offlineBbhomeDataContext ctx = new offlineBbhomeDataContext(); flag = ctx.GA_Logs.Any(c => c.Type == type && c.GAStartDate == st && c.GAEndDate == et && c.Status == false); if (flag) { flag = false; GA_Log log = null; log = ctx.GA_Logs.FirstOrDefault(c => c.Type == type && c.GAStartDate == st && c.GAEndDate == et && c.Status == false); if (log != null) { log.Status = true; ctx.SubmitChanges(); flag = true; } } } catch (Exception ex) { return(false); } return(flag); }
public static bool InserGaBaseData(int type, DateTime st, DateTime et, bool f) { bool flag = false; try { offlineBbhomeDataContext ctx = new offlineBbhomeDataContext(); ctx.GA_Logs.InsertOnSubmit( new GA_Log() { Type = type, GAStartDate = st, GAEndDate = et, Status = flag } ); ctx.SubmitChanges(); flag = true; } catch (Exception ex) { return false; } return flag; }
public static bool InserGaBaseData(int type, DateTime st, DateTime et, bool f) { bool flag = false; try { offlineBbhomeDataContext ctx = new offlineBbhomeDataContext(); ctx.GA_Logs.InsertOnSubmit( new GA_Log() { Type = type, GAStartDate = st, GAEndDate = et, Status = flag } ); ctx.SubmitChanges(); flag = true; } catch (Exception ex) { return(false); } return(flag); }
public static int getUserInfo(string guid, string usrid) { string memssage = ""; int uid = Converter.ParseInt(usrid, -1); if (uid < 0) { offlineBbhomeDataContext octx = new offlineBbhomeDataContext(); if (octx.Ga_guidUserIDs.Any(c => c.guid == guid)) { uid = octx.Ga_guidUserIDs.FirstOrDefault(c => c.guid == guid).uid; } } return(uid); }
public static bool insert_piwik_log_reffer(List <string> refferList) { using (offlineBbhomeDataContext ctx = new offlineBbhomeDataContext()) { try { var query = refferList.Where(c => !ctx.piwik_log_reffers.Any(p => p.refferurl == c)).ToList(); List <piwik_log_reffer> addreffers = new List <piwik_log_reffer>(); query.ForEach( c => { string tstr = c.ToString(); string durl = tstr; if (!string.IsNullOrEmpty(tstr) && tstr != "http://about:blank") { durl = GetNewString(tstr, null, true); } addreffers.Add( new piwik_log_reffer() { refferurl = c.ToString(), refergbk = durl } ) ; }); ctx.piwik_log_reffers.InsertAllOnSubmit(addreffers); ctx.SubmitChanges(); } catch { return(false); } return(true); } }
public static bool insert_piwiklog(List <UserVisitInfo> usrlist, out string msg) { bool flag = false; msg = ""; try { List <Piwik_log> eventList = new List <Piwik_log>(); foreach (UserVisitInfo e in usrlist) { eventList.Add(new Piwik_log() { guid = e.Guid, action = e.Action ?? "", lastVisitTime = DateTime.Parse(e.LastVisitTime ?? "1990-1-1"), spenttime = Converter.ParseInt(e.Spent, 0), pagetitle = e.PageTitle ?? "", url = e.Url, userid = Converter.ParseInt(e.Userid, -1), refferurl = e.Referurl, event_action = e.Event_action, visitIp = e.VisitIp, location = e.Location, locationsina = e.Locationsina }); } offlineBbhomeDataContext ctx = new offlineBbhomeDataContext(); ctx.Piwik_logs.InsertAllOnSubmit(eventList); ctx.SubmitChanges(); flag = true; } catch (Exception ex) { msg = ex.ToString(); return(false); } return(flag); }
public static bool ExistGaData(int type, DateTime st, DateTime et) { bool flag = false; try { offlineBbhomeDataContext ctx = new offlineBbhomeDataContext(); flag = ctx.GA_Logs.Any(c => c.Type == type && c.GAStartDate == st && c.GAEndDate == et); if (!flag) { InserGaBaseData(type, st, et, false); } } catch (Exception ex) { return false; } return flag; }
public static bool insert_piwikCsAction(List <Piwik_CustomerAction> usrlist, out string msg) { bool flag = false; msg = ""; try { offlineBbhomeDataContext ctx = new offlineBbhomeDataContext(); ctx.Piwik_CustomerActions.InsertAllOnSubmit(usrlist); ctx.SubmitChanges(); flag = true; } catch (Exception ex) { msg = ex.Message; return(false); } return(flag); }
public static bool ExistGaData(int type, DateTime st, DateTime et) { bool flag = false; try { offlineBbhomeDataContext ctx = new offlineBbhomeDataContext(); flag = ctx.GA_Logs.Any(c => c.Type == type && c.GAStartDate == st && c.GAEndDate == et); if (!flag) { InserGaBaseData(type, st, et, false); } } catch (Exception ex) { return(false); } return(flag); }
public static bool insert_piwiklog(List<UserVisitInfo> usrlist,out string msg) { bool flag = false; msg = ""; try { List<Piwik_log> eventList = new List<Piwik_log>(); foreach (UserVisitInfo e in usrlist) { eventList.Add(new Piwik_log() { guid=e.Guid, action=e.Action??"", lastVisitTime=DateTime.Parse(e.LastVisitTime??"1990-1-1"), spenttime=Converter.ParseInt(e.Spent,0), pagetitle=e.PageTitle??"", url=e.Url, userid=Converter.ParseInt(e.Userid,-1), refferurl=e.Referurl, }); } offlineBbhomeDataContext ctx = new offlineBbhomeDataContext(); ctx.Piwik_logs.InsertAllOnSubmit(eventList); ctx.SubmitChanges(); flag = true; } catch (Exception ex) { msg = ex.Message; return false; } return flag; }
public static int getUserInfo(string guid, string usrid) { string memssage = ""; int uid = Converter.ParseInt(usrid, -1); if (uid < 0) { offlineBbhomeDataContext octx = new offlineBbhomeDataContext(); if (octx.Ga_guidUserIDs.Any(c => c.guid == guid)) { uid = octx.Ga_guidUserIDs.FirstOrDefault(c => c.guid == guid).uid; } } return uid; }
public static bool UpdateGaBaseData(int type, DateTime st, DateTime et) { bool flag = false; try { offlineBbhomeDataContext ctx = new offlineBbhomeDataContext(); flag = ctx.GA_Logs.Any(c => c.Type == type && c.GAStartDate == st && c.GAEndDate == et && c.Status == false); if (flag) { flag = false; GA_Log log = null; log = ctx.GA_Logs.FirstOrDefault(c => c.Type == type && c.GAStartDate == st && c.GAEndDate == et && c.Status == false); if (log != null) { log.Status = true; ctx.SubmitChanges(); flag = true; } } } catch (Exception ex) { return false; } return flag; }
public static bool insert_piwik_log_reffer(List<string> refferList) { using (offlineBbhomeDataContext ctx = new offlineBbhomeDataContext()) { try { var query = refferList.Where(c => !ctx.piwik_log_reffers.Any(p => p.refferurl == c)).ToList(); List<piwik_log_reffer> addreffers = new List<piwik_log_reffer>(); query.ForEach( c => { string tstr = c.ToString(); string durl = tstr; if (!string.IsNullOrEmpty(tstr) && tstr != "http://about:blank") durl = GetNewString(tstr, null, true); addreffers.Add( new piwik_log_reffer() { refferurl = c.ToString(), refergbk=durl } ) ; }); ctx.piwik_log_reffers.InsertAllOnSubmit(addreffers); ctx.SubmitChanges(); } catch { return false; } return true; } }
public static bool insert_piwikCsAction(List<Piwik_CustomerAction> usrlist, out string msg) { bool flag = false; msg = ""; try { offlineBbhomeDataContext ctx = new offlineBbhomeDataContext(); ctx.Piwik_CustomerActions.InsertAllOnSubmit(usrlist); ctx.SubmitChanges(); flag = true; } catch (Exception ex) { msg = ex.Message; return false; } return flag; }