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();
}
