public Login() { InitializeComponent(); _context = new FitnessEntities(); //txtUsername.Text = (GetHash("elcinhtml")); }
// GET: Fitness public ActionResult Index() { int i = 0; FitnessEntities db = new FitnessEntities(); var q = (from items in db.tOrder join itemscoach in db.tCoach on items.fCoachID equals itemscoach.fCoachID where items.fOrderlike == 1 group items by items.fCoachID into g orderby g.Sum(m => m.fOrderlike) descending select g); List <string> img = new List <string>(); foreach (var w in q) { foreach (var w1 in w) { var x = (from y in db.tCoach where y.fCoachID == w1.fCoachID select y.fCoachimg).ToArray(); var a = x[0]; img.Add(a); } if (i >= 3) { break; } i++; } var t = img.Distinct(); ViewBag.coachimg = t.ToList(); return(View()); }
public ActionResult CheckMember() { FitnessEntities db = new FitnessEntities(); if (Session[CDictionary.user_using_id] != null) { int userid = (int)Session[CDictionary.user_using_id]; string nums = HttpContext.Request.QueryString["fMember_Num"]; var bumbs = (from i in db.tMember where i.fMemberId == userid select i).First(); if (bumbs != null) { if (bumbs.fMember_Num == nums) { bumbs.fMember_Num = null; if (DateTime.Now < bumbs.fMember_time) { ViewBag.message = "驗證成功"; bumbs.fMember_approced = "y"; db.SaveChanges(); return(View("CheckMember")); } db.SaveChanges(); } } } ViewBag.message = "驗證成功"; return(View("CheckMember")); }
protected void Page_Load(object sender, EventArgs e) { lblBrowser.Text = String.Format("{0} - {1} {2}", Request.Browser.Type, Request.Browser.Version, Request.Browser.Platform); using (var entities = new FitnessEntities()) { using (var connection = entities.Connection) { if (connection.State != ConnectionState.Open) { connection.Open(); } lblDatabaseServer.Text = String.Format("{0} on {1} ({2})", entities.Connection.Database, entities.Connection.DataSource, entities.Connection.ServerVersion); } } bulBranch.DataSource = BranchService.GetActiveBranches(User.Identity.Name); bulBranch.DataTextField = "Name"; bulBranch.DataBind(); bulAllowedBranch.DataSource = BranchService.GetAllowedBranches(User.Identity.Name); bulAllowedBranch.DataTextField = "Name"; bulAllowedBranch.DataBind(); hypAlerts.Visible = !String.IsNullOrEmpty(Request["FromAlert"]); if (!Page.IsPostBack) { RadScheduler1.SelectedDate = DateTime.Today; BindData(); } }
public ActionResult Index(tMember member) { FitnessEntities db = new FitnessEntities(); db.tMember.Add(member); db.SaveChanges(); return(View()); }
public ActionResult Signup(tCoach coach) { FitnessEntities db = new FitnessEntities(); coach.fCoachimg = "https://cdn4.iconfinder.com/data/icons/small-n-flat/24/user-group-512.png"; db.tCoach.Add(coach); db.SaveChanges(); return(View()); }
public ActionResult Editmember() { int a = Convert.ToInt32(Session[CDictionary.user_using_id]); FitnessEntities db = new FitnessEntities(); var q = (from p in db.tMember where p.fMemberId == a select p).First(); return(View(q)); }
public BillingProvider(FitnessEntities context, IPrincipal principal, ILogger logger, AutoNumberProvider autoNumberProvider, InvoiceProvider invoiceProvider) : base(context, principal) { this.logger = logger; this.autoNumberProvider = autoNumberProvider; this.invoiceProvider = invoiceProvider; }
public string nogetcomment(int forderid) { FitnessEntities db = new FitnessEntities(); var q = from p in db.tOrder where p.forderid == forderid select p; q.First().fOrderlike = 0; db.SaveChanges(); return("匯入成功"); }
public string GetValue(string key) { string result; using (var ctx = new FitnessEntities()) { var config = ctx.Configurations.SingleOrDefault(configuration => configuration.Key == key); result = config == null ? String.Empty : config.Value; } return(result); }
public string defaultPage() { //Models.期末專題_Test資料庫Entities temp = new Models.期末專題_Test資料庫Entities(); FitnessEntities temp = new FitnessEntities(); var x = from i in temp.tStudio select new { i.fCorpName, i.fCounty, i.fDistrict, i.cfImage, i.fLatitude, i.fLongitude, i.fAddress }; string json = JsonConvert.SerializeObject(x); return(json); }
public string AddGetGymNameArray(List <string> values) { FitnessEntities db = new FitnessEntities(); if (values != null) { if (values.Count > 2) { string flag = ""; List <string> a = new List <string>(); for (int i = 0; i < values.Count - 2; i++) { if (values[i + 2] != null) { a.Add(values[i + 2]); } } foreach (string foodName in a) { var q = (from p in db.tFoodList where p.fFoodName == foodName select p).FirstOrDefault(); tRecord tl = new tRecord(); tl.fId = q.fId; tl.fRecordFoodCalories = q.fFoodCalories; tl.fRecordFoodFat = q.fFoodFat; tl.fRecordFoodName = q.fFoodName; tl.fRecordFoodProtein = q.fFoodProtein; tl.fRecordCarbohydrate = q.fFoodCarbohydrate; int x = values.Count(); tl.fRecordDate = DateTime.Parse(values[0]); tl.fTimeId = Int32.Parse(values[1]); tl.fMemberId = Convert.ToInt32(Session[CDictionary.user_using_id]); db.tRecord.Add(tl); db.SaveChanges(); } if (flag != "") { return(flag); } else { return("新增成功"); } } } return("新增失敗"); }
public ActionResult Signup(tMember items) { FitnessEntities db = new FitnessEntities(); items.fMember_time = DateTime.Now + TimeSpan.FromMinutes(10); string number = randnum(); items.fMember_Num = number; CSendEmail.sendemail(new string[] { items.fMemberEmail }, CSendEmail.getnum(number)); items.fMemberPicture = "https://cdn4.iconfinder.com/data/icons/small-n-flat/24/user-group-512.png"; db.tMember.Add(items); db.SaveChanges(); return(RedirectToAction("../Fitness/Index")); }
public ActionResult Login(string account, string password) { FitnessEntities db = new FitnessEntities(); if (string.IsNullOrWhiteSpace(account) || string.IsNullOrWhiteSpace(password)) { return(RedirectToAction("Index", "Fitness")); } if (Session[CDictionary.account] != null && Session[CDictionary.password] != null) { account = Session[CDictionary.account].ToString(); password = Session[CDictionary.password].ToString(); } else { Session[CDictionary.account] = account; Session[CDictionary.password] = password; } string result = ""; var q = from items in db.tMember where items.fMemberEmail == account && items.fMemberPassword == password select items; var q1 = from items in db.tCoach where items.fCoachMail == account && items.fCoachPassword == password select items; if (q.Count() > 0) { ViewBag.message = q.First().fMemberName + "登入成功"; Session[CDictionary.user_using_id] = q.First().fMemberId; q.First().fMember_time = DateTime.Now; db.SaveChanges(); result = "/Login"; } else if (q1.Count() > 0) { ViewBag.message = q1.First().fCoachName + "登入成功"; Session[CDictionary.user_using_id] = q1.First().fCoachID; ViewBag.img = q1.First().fCoachimg; result = "/CoachLogin"; } else { result = "登入失敗"; } return(RedirectToAction(result)); }
public void SetValue(string key, string value) { using (var ctx = new FitnessEntities()) { var configuration = ctx.Configurations.SingleOrDefault(config => config.Key == key); if (configuration != null) { configuration.Key = key; configuration.Value = value; configuration.ChangedWhen = DateTime.Now; configuration.ChangedWho = userName; ctx.SaveChanges(); } } }
public JsonResult GetAutoComplete(string fname) { FitnessEntities db = new FitnessEntities(); bool data = true; if (string.IsNullOrWhiteSpace(fname) == false) { data = false; } var p = from q in db.tFoodList where q.fFoodName.StartsWith(fname) || data select new { label = q.fId, value = q.fFoodName }; return(Json(p, JsonRequestBehavior.AllowGet)); }
public ActionResult CoachLogin() { if (Session[CDictionary.user_using_id] == null) { return(RedirectToAction("Index", "Fitness")); } Ctdatatable ct = new Ctdatatable(); int a = Convert.ToInt32(Session[CDictionary.user_using_id]); FitnessEntities db = new FitnessEntities(); var q = (from items in db.tCoach where items.fCoachID == a select items).First(); ViewBag.CoachID = a; return(View(q)); }
// GET: Coach public ActionResult ViewCoach() { FitnessEntities db = new FitnessEntities(); var q = from items in db.tCoach where items.fCoachSuccess == 1 select items; ViewBag.Login = ""; if (Session[CDictionary.user_using_id] == null) { ViewBag.Login = "******"; } else { ViewBag.Login = "******"; } return(View(q.ToList())); }
public ActionResult Login() { if (Session[CDictionary.user_using_id] == null) { return(RedirectToAction("Index", "Fitness")); } int a = Convert.ToInt32(Session[CDictionary.user_using_id]); FitnessEntities db = new FitnessEntities(); Ctdatatable ct = new Ctdatatable(); var q = (from itemsmember in db.tMember where itemsmember.fMemberId == a select itemsmember).First(); var q1 = from itemsorder in db.tOrder where itemsorder.fMemberId == a select itemsorder; //q2 =======這段不要啟用,會影響到飲食紀錄時間 //var q2 = from membertime in db.tTime // join memberrecord in db.tRecord // on membertime.fTimeId equals memberrecord.fTimeId // where memberrecord.fMemberId == a // select membertime; var q3 = from membertime in db.tTime join memberrecord in db.tRecord on membertime.fTimeId equals memberrecord.fTimeId where memberrecord.fMemberId == a select memberrecord; var q4 = from aa in db.tTime select aa; var q5 = (from itemsorder in db.tOrder join itemscoach in db.tCoach on itemsorder.fCoachID equals itemscoach.fCoachID where itemsorder.fMemberId == a && itemsorder.fEndTime < q.fMember_time && itemsorder.fOrderlike == -1 select itemscoach).FirstOrDefault(); ct.Cmember = q; ct.Corder = q1; ct.Ctime = q4; ct.Crecord = q3; ct.Ccoach = q5; return(View(ct)); }
public ActionResult FoodCaloriesYesterday() { FitnessEntities db = new FitnessEntities(); int a = Convert.ToInt32(Session[CDictionary.user_using_id]); var td = DateTime.Today.AddDays(-1); var data = (from c in db.tRecord where c.fRecordDate.Value == td && c.fMemberId == a group c by new { a = c.fRecordDate.Value, b = c.fTimeId.Value } into g //group c by c.fListDate into g select new { name = g.Key.a.ToString(), gro = g.Key.b, count = g.Sum(w => w.fRecordFoodCalories) }).ToList(); return(Json(data, JsonRequestBehavior.AllowGet)); }
public ActionResult FoodDietCaloriesLastWeek() { FitnessEntities db = new FitnessEntities(); int a = Convert.ToInt32(Session[CDictionary.user_using_id]); var t1 = DateTime.Now.AddDays(Convert.ToDouble((0 - Convert.ToInt16(DateTime.Now.DayOfWeek)) - 7)); var t2 = DateTime.Now.AddDays(Convert.ToDouble((6 - Convert.ToInt16(DateTime.Now.DayOfWeek)) - 7)); var t3 = DateTime.Today.AddDays(-4); var data = (from c in db.tRecord where c.fRecordDate.Value >= t1 && c.fRecordDate.Value <= t2 && c.fMemberId == a group c by new { a = c.fRecordDate.Value, b = c.fTimeId.Value } into g //group c by c.fListDate into g select new { name = g.Key.a.ToString(), gro = g.Key.b, count = g.Sum(w => w.fRecordFoodCalories) }).ToList(); return(Json(data, JsonRequestBehavior.AllowGet)); }
static void Main(string[] args) { var context = new FitnessEntities(); Header h = new Header(); h.Name = "Header A"; Detail d = new Detail(); d.Description = "Detail A"; d.Header = h; context.Add(d); context.Add(h); context.SaveChanges(); //Microsoft.VisualBasic.Financial.Pmt() }
public ActionResult Editmember(Ctdatatable member) { //string photoName = Guid.NewGuid().ToString(); //photoName += Path.GetExtension(member.Cmember.image.FileName); //member.Cmember.image.SaveAs(Server.MapPath("../Images/" + photoName)); //member.Cmember.fMemberPicture = "../Images/" + photoName; FitnessEntities db = new FitnessEntities(); var q = from items in db.tMember where items.fMemberId == member.Cmember.fMemberId select items; q.First().fMemberName = member.Cmember.fMemberName; q.First().fMemberGender = member.Cmember.fMemberGender; q.First().fMemberPhone = member.Cmember.fMemberPhone; q.First().MemberAddress = member.Cmember.MemberAddress; q.First().fMemberEmail = member.Cmember.fMemberEmail; q.First().fMemberPassword = member.Cmember.fMemberPassword; q.First().fMemberPicture = member.Cmember.fMemberPicture; db.SaveChanges(); return(RedirectToAction("Login")); }
public static void DoLog(Common.Action act, string UIDorTELL, int Result, string Exception) { try { Com.Log mLog = new Com.Log() { ActionType = (int)act, Time = DateTime.UtcNow, UIDorTELLNUMBER = UIDorTELL, Result = Result, Exception = Exception }; using (FitnessEntities ent = new FitnessEntities()) { ent.Logs.Add(mLog); ent.SaveChanges(); } } catch (Exception e) { Console.WriteLine("Error On Log: " + e.Message); } }
public JsonResult GetDessert(string fDateDs) { //Debug.WriteLine("後段test"); FitnessEntities db = new FitnessEntities(); int a = Convert.ToInt32(Session[CDictionary.user_using_id]); //DateTime key = Convert.ToDateTime("2020/10/8").Date; bool data = true; if (string.IsNullOrWhiteSpace(fDateDs) == false) { data = false; } DateTime key = Convert.ToDateTime(fDateDs).Date; var p = from q in db.tRecord where q.fRecordDate == key && q.fTimeId == 4 && q.fMemberId == a select new { foodname = q.fRecordFoodName, foodprotein = q.fRecordFoodProtein, foodfat = q.fRecordFoodFat, foodcarbohydrate = q.fRecordCarbohydrate }; //string p = "re"; return(Json(p, JsonRequestBehavior.AllowGet)); }
// GET: Canlendar行事曆首頁 public ActionResult Booking(string coachid = "7") { if (Session[CDictionary.user_using_id] == null) { return(RedirectToAction("ViewCoach", "Coach")); } int a = Convert.ToInt32(Session[CDictionary.user_using_id]); FitnessEntities db = new FitnessEntities(); Ctdatatable ct = new Ctdatatable(); var q = (from itemsmember in db.tMember where itemsmember.fMemberId == a select itemsmember).First(); var q1 = from itemsorder in db.tOrder where itemsorder.fMemberId == a select itemsorder; var q2 = from membertime in db.tTime join memberrecord in db.tRecord on membertime.fTimeId equals memberrecord.fTimeId where memberrecord.fMemberId == a select membertime; var q3 = from membertime in db.tTime join memberrecord in db.tRecord on membertime.fTimeId equals memberrecord.fTimeId where memberrecord.fMemberId == a select memberrecord; //var q4 = from aa in db.tTime // select aa; ct.Cmember = q; ct.Corder = q1; ct.Ctime = q2; ct.Crecord = q3; ViewBag.CoachID = coachid; ViewBag.MemberID = Session[CDictionary.user_using_id].ToString(); return(View(ct)); }
public Form1() { InitializeComponent(); _context = new FitnessEntities(); }
public CreditCardTypeProvider(FitnessEntities context, IPrincipal principal) : base(context, principal) { }
public UserForm(User user) { InitializeComponent(); _loggedUser = user; _context = new FitnessEntities(); }
public ServiceForm() { InitializeComponent(); _context = new FitnessEntities(); }