private void BtnCreate_Click(object sender, EventArgs e)
{
cmbPackets.Items.Clear();
dgrPackets.DataSource = "";
string name = txtNewName.Text;
decimal price = numPacket.Value;
string time = txtServiceDuration.Text;
if (name == "" || price == 0 || time == "")
{
MessageBox.Show("Please input all fields", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
Packet newPacket = new Packet();
newPacket.PacketName = name;
newPacket.PacketPrice = (decimal)price;
newPacket.PacketTime = time;
_context.Packets.Add(newPacket);
_context.SaveChanges();
FillCmbPacket();
FillDataGriwPackets();
txtNewName.Text = txtServiceDuration.Text = "";
numPacket.Value = 0;
}
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"));
}
private void Button1_Click(object sender, EventArgs e)
{
string name = cmbPackets.SelectedItem.ToString();
foreach (string nameServices in listServices.CheckedItems)
{
int idservice = _context.Services.First(s => s.ServiceNames == nameServices).Id;
int id = _context.Packets.FirstOrDefault(p => p.PacketName == name).Id;
PacketToServy packetToServy = new PacketToServy();
packetToServy.PacketsId = id;
packetToServy.ServiceId = idservice;
_context.PacketToServies.Add(packetToServy);
}
//string nameservice = listServices.SelectedItems.ToString();
_context.SaveChanges();
FillDataGrid();
}
private void BtnCreate_Click(object sender, EventArgs e)
{
Outcome outcome = _context.Outcomes.Add(new Outcome()
{
Tools = Convert.ToInt64(txtTools.Text),
Cleaning = Convert.ToInt64(txtClean.Text),
WhichService = _context.Services.FirstOrDefault(s => s.ServiceNames == cmbServices.Text).Id,
Mont = DateTime.Now
});
_context.SaveChanges();
FillOutcimes();
}
public ActionResult Index(tMember member)
{
FitnessEntities db = new FitnessEntities();
db.tMember.Add(member);
db.SaveChanges();
return(View());
}
private void BtnAdd_Click(object sender, EventArgs e)
{
dgrRegister.DataSource = "";
string name = txtClientName.Text;
string surname = txtSurname.Text;
string cardId = txtCardId.Text;
if (name == "" || surname == "" || cardId == "")
{
MessageBox.Show("Please input all fields", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
Register newClient = new Register();
newClient.ClientName = name;
newClient.ClientSurname = surname;
_context.Registers.Add(newClient);
_context.SaveChanges();
int id = _context.Registers.FirstOrDefault(n => n.ClientName == name && n.ClientSurname == surname).Id;
Card newCard = new Card();
newCard.ClientId = id;
if (_context.Cards.Any(c => c.CardNumber == cardId))
{
MessageBox.Show("CardNumber must be unique", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (cardId.Length < 5)
{
MessageBox.Show("CardNumber must be greater than 5 or equal 5", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
newCard.CardNumber = cardId;
_context.Cards.Add(newCard);
_context.SaveChanges();
FillDataGrid();
}
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 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("匯入成功");
}
private void Button1_Click(object sender, EventArgs e)
{
Card selectedRegister = _context.Cards.Find(selectedRegisterId);
CardToPacketService newCps = _context.CardToPacketServices.Add(new CardToPacketService()
{
CardId = selectedRegister.Id,
PacketsssId = _context.Packets.FirstOrDefault(c => c.PacketName == cmbPacket.Text).Id,
ServicesssId = null,
});
Incoming newIncoming = new Incoming();
newIncoming.RegisterId = _context.Registers.First(r => r.ClientName == txtClientName.Text).Id;
newIncoming.ClientIncomes = (long)_context.Packets.FirstOrDefault(p => p.PacketName == cmbPacket.Text).PacketPrice;
newIncoming.IncomeMonth = DateTime.Now;
_context.Incomings.Add(newIncoming);
_context.SaveChanges();
FillDataOrders();
txtNumber.Text = txtSurname.Text = txtClientName.Text = "";
}
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));
}
private void BtnCreate_Click(object sender, EventArgs e)
{
cmbServices.Items.Clear();
string name = txtNewName.Text;
string price = txtPrice.Text;
string duration = txtServiceDuration.Text;
if (name == "" || price == "" || duration == "")
{
MessageBox.Show("Please, input all fields", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
Service newService = new Service();
newService.ServiceNames = name;
newService.ServicePrice = price;
newService.ServiceDuration = duration;
_context.Services.Add(newService);
_context.SaveChanges();
FillCmbServices();
FillDataGrid();
txtNewName.Text = txtPrice.Text = txtServiceDuration.Text = "";
}
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();
}
}
}
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 string UpdatetBookings(string datestr, string sdate, string edate, string gymId, string tposition, string smdate, string emdate, string eventid, string coachid, string memberid)
{
int _coachid = int.Parse(coachid);
if (string.IsNullOrWhiteSpace(eventid))
{
//新增到資料庫
DateTime StartTime = Convert.ToDateTime(datestr + " " + sdate + ":" + smdate);
DateTime Endtime = Convert.ToDateTime(datestr + " " + edate + ":" + emdate);
//判斷跟教練排休時間有沒有衝到
bool conflictCoachTime = (from p in db.tCoachRest
where p.fCoachId == _coachid &&
(
(p.fStartTime <= StartTime && p.fEndTime >= Endtime) ||
(p.fStartTime <= Endtime && p.fEndTime >= Endtime))
select p).Any();
if (conflictCoachTime)
{
return("與教練排休時間衝突!");
}
//原寫死需修改
tOrder t = new tOrder();
int _fid = (from p in db.tOrder select p.fid).FirstOrDefault();
int _fOrder = (from p in db.tOrder select p.forderid).FirstOrDefault();
if (_fid == 0)
{
_fid = 1;
}
else
{
_fid = (from p in db.tOrder select p.fid).Max() + 1;
}
if (_fOrder == 0)
{
_fOrder = 1;
}
else
{
_fOrder = (from p in db.tOrder select p.forderid).Max() + 1;
}
t.fid = _fid;
t.forderid = _fOrder;
t.fMemberId = int.Parse(memberid);
t.fCoachID = Convert.ToInt32(coachid);
t.fGynId = Convert.ToInt32(gymId);
t.fLessonId = _fOrder;
t.fSuccessed = 0;
t.fStartTime = StartTime;
t.fEndTime = Endtime;
t.fApplyTime = DateTime.Now;
t.fOrderlike = -1;
if (sdate == "23")
{
t.fEndTime = t.fEndTime.AddDays(1);
}
t.fTrainingName = tposition;
db.tOrder.Add(t);
db.SaveChanges();
}
else
{
//修改資料庫
int _eventid = int.Parse(eventid);
tOrder t = (from p in db.tOrder where p.forderid == _eventid select p).FirstOrDefault();
DateTime StartTime = Convert.ToDateTime(t.fStartTime.ToString("yyyy/MM/dd") + " " + sdate + ":" + smdate);
DateTime Endtime = Convert.ToDateTime(t.fEndTime.ToString("yyyy/MM/dd") + " " + edate + ":" + emdate);
if (t != null)
{
t.fMemberId = int.Parse(memberid);
t.fCoachID = _coachid;
t.fGynId = Convert.ToInt32(gymId);
t.fSuccessed = 0;
t.fStartTime = StartTime;
t.fEndTime = Endtime;
t.fApplyTime = DateTime.Now;
t.fLessonId = t.forderid;
if (sdate == "23")
{
t.fEndTime = t.fEndTime.AddDays(1);
}
t.fTrainingName = tposition;
db.Entry(t).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
return("");
}