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