public List <Stat> GetStats() { List <Stat> statystyki_list = new List <Stat>(); try { ewidencjaContext ew = new ewidencjaContext(); var ts = ew.TblStats.Select(a => new { a.Id, a.VisitHostIp, a.DateVisited, a.Page }); foreach (var entry in ts) { Stat s = new Stat(); s.id = entry.Id; s.visit_host_ip = entry.VisitHostIp; s.date_visited = Convert.ToDateTime(entry.DateVisited); s.page = entry.Page; statystyki_list.Add(s); } }catch (Exception ex) { System.Diagnostics.Trace.WriteLine(ex.ToString()); } return(statystyki_list); }
public void InsertIPIntoDB(string ip, string page) { try { ewidencjaContext ew = new ewidencjaContext(); DateTime curr = DateTime.Now; TblStats ts = new TblStats(); ts.DateVisited = curr; ts.VisitHostIp = ip; ts.Page = page; ew.TblStats.Add(ts); ew.SaveChanges(); } catch (Exception ex) { System.Diagnostics.Trace.WriteLine(ex.ToString()); } }
public string InsertIntoDBCurrences(List <Currency> curr) { if (curr.Count > 0) { //checking if date exists in table try { string mnt = "", day = ""; if (DateTime.Now.Month == 1) { mnt = "01"; } else if (DateTime.Now.Month == 2) { mnt = "02"; } else if (DateTime.Now.Month == 3) { mnt = "03"; } else if (DateTime.Now.Month == 4) { mnt = "04"; } else if (DateTime.Now.Month == 5) { mnt = "05"; } else if (DateTime.Now.Month == 6) { mnt = "06"; } else if (DateTime.Now.Month == 7) { mnt = "07"; } else if (DateTime.Now.Month == 8) { mnt = "08"; } else if (DateTime.Now.Month == 9) { mnt = "09"; } else { mnt = DateTime.Now.Month.ToString(); } if (DateTime.Now.Day == 1) { day = "01"; } else if (DateTime.Now.Day == 2) { day = "02"; } else if (DateTime.Now.Day == 3) { day = "03"; } else if (DateTime.Now.Day == 4) { day = "04"; } else if (DateTime.Now.Day == 5) { day = "05"; } else if (DateTime.Now.Day == 6) { day = "06"; } else if (DateTime.Now.Day == 7) { day = "07"; } else if (DateTime.Now.Day == 8) { day = "08"; } else if (DateTime.Now.Day == 9) { day = "09"; } else { day = DateTime.Now.Day.ToString(); } DateTime current_date = DateTime.Now; DateTime exists = DateTime.MinValue; DateTime exist_d = DateTime.MinValue; ewidencjaContext ew = new ewidencjaContext(); DateTime cd = Convert.ToDateTime(current_date); var tbw = ew.TblWaluty.Where(a => a.InsDate == cd).Select(x => new { x.InsDate }).FirstOrDefault(); exists = tbw.InsDate.Value; if (exists != current_date) { string usd_value = "", jpy_value = "", bgn_value = "", czk_value = "", dkk_value = "", gbp_value = "", huf_value = "", pln_value = "", ron_value = "", sek_value = "", chf_value = "", isk_value = "", nok_value = "", hrk_value = "", rub_value = "0", try_value = "0", aud_value = "0", brl_value = "0", cad_value = "0", cny_value = "0", hkd_value = "0", idr_value = "0", ils_value = "0", inr_value = "0", krw_value = "0", mxn_value = "0", myr_value = "0", nzd_value = "0", php_value = "0", sgd_value = "0", thb_value = "0", zar_value = "0"; foreach (var cur in curr) { if (cur.Cur == "USD") { usd_value = cur.DayValue; } if (cur.Cur == "JPY") { jpy_value = cur.DayValue; } if (cur.Cur == "BGN") { bgn_value = cur.DayValue; } if (cur.Cur == "CZK") { czk_value = cur.DayValue; } if (cur.Cur == "DKK") { dkk_value = cur.DayValue; } if (cur.Cur == "GBP") { gbp_value = cur.DayValue; } if (cur.Cur == "HUF") { huf_value = cur.DayValue; } if (cur.Cur == "PLN") { pln_value = cur.DayValue; } if (cur.Cur == "RON") { ron_value = cur.DayValue; } if (cur.Cur == "SEK") { sek_value = cur.DayValue; } if (cur.Cur == "CHF") { chf_value = cur.DayValue; } if (cur.Cur == "ISK") { isk_value = cur.DayValue; } if (cur.Cur == "NOK") { nok_value = cur.DayValue; } if (cur.Cur == "HRK") { hrk_value = cur.DayValue; } if (cur.Cur == "RUB") { rub_value = cur.DayValue; } if (cur.Cur == "TRY") { try_value = cur.DayValue; } if (cur.Cur == "AUD") { aud_value = cur.DayValue; } if (cur.Cur == "BRL") { brl_value = cur.DayValue; } if (cur.Cur == "CAD") { cad_value = cur.DayValue; } if (cur.Cur == "CNY") { cny_value = cur.DayValue; } if (cur.Cur == "HKD") { hkd_value = cur.DayValue; } if (cur.Cur == "ILS") { ils_value = cur.DayValue; } if (cur.Cur == "INR") { inr_value = cur.DayValue; } if (cur.Cur == "KRW") { krw_value = cur.DayValue; } if (cur.Cur == "MXN") { mxn_value = cur.DayValue; } if (cur.Cur == "MYR") { myr_value = cur.DayValue; } if (cur.Cur == "NZD") { nzd_value = cur.DayValue; } if (cur.Cur == "PHP") { php_value = cur.DayValue; } if (cur.Cur == "SGD") { sgd_value = cur.DayValue; } if (cur.Cur == "THB") { thb_value = cur.DayValue; } if (cur.Cur == "ZAR") { zar_value = cur.DayValue; } } TblWaluty tw = new TblWaluty(); tw.InsDate = current_date; tw.UsdValue = Convert.ToDecimal(usd_value); tw.JpyValue = Convert.ToDecimal(jpy_value); tw.BgnValue = Convert.ToDecimal(bgn_value); tw.CzkValue = Convert.ToDecimal(czk_value); tw.DkkValue = Convert.ToDecimal(dkk_value); tw.GbpValue = Convert.ToDecimal(gbp_value); tw.HufValue = Convert.ToDecimal(huf_value); tw.PlnValue = Convert.ToDecimal(pln_value); tw.RonValue = Convert.ToDecimal(ron_value); tw.SekValue = Convert.ToDecimal(sek_value); tw.ChfValue = Convert.ToDecimal(chf_value); tw.IskValue = Convert.ToDecimal(isk_value); tw.NokValue = Convert.ToDecimal(nok_value); tw.HrkValue = Convert.ToDecimal(hrk_value); tw.RubValue = Convert.ToDecimal(rub_value); tw.TryValue = Convert.ToDecimal(try_value); tw.AudValue = Convert.ToDecimal(aud_value); tw.BrlValue = Convert.ToDecimal(brl_value); tw.CadValue = Convert.ToDecimal(cad_value); tw.CnyValue = Convert.ToDecimal(cny_value); tw.HkdValue = Convert.ToDecimal(hkd_value); tw.IdrValue = Convert.ToDecimal(idr_value); tw.IlsValue = Convert.ToDecimal(ils_value); tw.InrValue = Convert.ToDecimal(inr_value); tw.KrwValue = Convert.ToDecimal(krw_value); tw.MxnValue = Convert.ToDecimal(mxn_value); tw.MyrValue = Convert.ToDecimal(myr_value); tw.NzdValue = Convert.ToDecimal(nzd_value); tw.PhpValue = Convert.ToDecimal(php_value); tw.SgdValue = Convert.ToDecimal(sgd_value); tw.ThbValue = Convert.ToDecimal(thb_value); tw.ZarValue = Convert.ToDecimal(zar_value); ew.TblWaluty.Add(tw); ew.SaveChanges(); } else if (exists == current_date) { //update if date exists in column table string usd_value = "", jpy_value = "", bgn_value = "", czk_value = "", dkk_value = "", gbp_value = "", huf_value = "", pln_value = "", ron_value = "", sek_value = "", chf_value = "", isk_value = "", nok_value = "", hrk_value = "", rub_value = "0", try_value = "0", aud_value = "0", brl_value = "0", cad_value = "0", cny_value = "0", hkd_value = "0", idr_value = "0", ils_value = "0", inr_value = "0", krw_value = "0", mxn_value = "0", myr_value = "0", nzd_value = "0", php_value = "0", sgd_value = "0", thb_value = "0", zar_value = "0"; AssignationValuesCurrencies(ref curr, ref usd_value, ref jpy_value, ref bgn_value, ref czk_value, ref dkk_value, ref gbp_value, ref huf_value, ref pln_value, ref ron_value, ref sek_value, ref chf_value, ref isk_value, ref nok_value, ref hrk_value, ref rub_value, ref try_value, ref aud_value, ref brl_value, ref cad_value, ref cny_value, ref hkd_value, ref idr_value, ref ils_value, ref inr_value, ref krw_value, ref mxn_value, ref myr_value, ref nzd_value, ref php_value, ref sgd_value, ref thb_value, ref zar_value); var entity = ew.TblWaluty.FirstOrDefault(item => item.InsDate == exists); entity.UsdValue = Convert.ToDecimal(usd_value); entity.JpyValue = Convert.ToDecimal(jpy_value); entity.BgnValue = Convert.ToDecimal(bgn_value); entity.CzkValue = Convert.ToDecimal(czk_value); ew.TblWaluty.Update(entity); ew.SaveChanges(); } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); } } return("OK"); }