public HttpResponseMessage Login(Attendants login) { ModelState.Remove("PasswordSalt"); ModelState.Remove("Name"); ModelState.Remove("Salary"); ModelState.Remove("Account"); ModelState.Remove("Service"); ModelState.Remove("File"); ModelState.Remove("ServiceTime"); ModelState.Remove("Experience"); ModelState.Remove("Status"); if (ModelState.IsValid) { using (db) { Attendants memberAccount = db.Attendants.FirstOrDefault(x => x.Email == login.Email); if (memberAccount == null) { return(Request.CreateResponse(HttpStatusCode.OK, new { message = "無此帳號" })); } else { string psw = Utility.GenerateHashWithSalt(login.Password, memberAccount.PasswordSalt); Attendants memeber = db.Attendants.FirstOrDefault(x => x.Email == memberAccount.Email && x.Password == psw); if (memeber == null) { return(Request.CreateResponse(HttpStatusCode.OK, new { message = "密碼錯誤" })); } else { string newToken = new Token().GenerateToken(memeber.Id, login.Email, "a"); return(Request.CreateResponse(HttpStatusCode.OK, new { message = "登入成功", memeber.Id, login.Email, memeber.Photo, memeber.File, token = newToken })); } } } } else { return(Request.CreateResponse(HttpStatusCode.OK, new { message = "帳密格式不符" })); } }
/// <summary> /// Try to add a new buyer into this room /// </summary> /// <param name="buyer">The new attendant and potential buyer</param> /// <returns></returns> public bool TryEnterAsAttendant(Buyer buyer) { var fiscal = new RoomCanReceiveAttendantValidation(); var result = fiscal.Valid(this); if (!result.IsValid) { ValidationErrors = result.Errors; return(false); } Attendants.Add(buyer); return(true); }
public HttpResponseMessage AttendantRegister(MemberView password) { Attendants attendants = db.Attendants.Find(password.Id); if (password.Password.Length < 6) { return(Request.CreateResponse(HttpStatusCode.OK, new { result = "密碼長度不符" })); } attendants.PasswordSalt = Utility.CreateSalt(); attendants.Password = Utility.GenerateHashWithSalt(password.Password, attendants.PasswordSalt); db.Entry(attendants).State = EntityState.Modified; db.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK, new { result = "密碼修改成功" })); }
public void addAttendants(Attendants a) { string query = "INSERT INTO ScrumAttendants (eventID, userID) VALUES (@eventID, @userID)"; SqlConnection con = dbc.GetConnection(); SqlCommand cmd = new SqlCommand(query, con); cmd.Parameters.AddWithValue("@eventID", a.eventID); cmd.Parameters.AddWithValue("@userID", a.userID); try { cmd.ExecuteNonQuery(); } catch (SqlException e) { Console.WriteLine(e.Message); } }
public HttpResponseMessage PostOrders(Orders orders) { ModelState.Remove("Status"); DateTime startDate = (DateTime)orders.StartDate; DateTime endDate = (DateTime)orders.EndDate.AddDays(1); TimeSpan tsDate = endDate - startDate; Attendants attendants = db.Attendants.Find(orders.AttendantId); if (!ModelState.IsValid) { return(Request.CreateResponse(HttpStatusCode.OK, ModelState)); } orders.Total = Convert.ToInt32(tsDate.Days) * attendants.Salary; orders.InitDate = DateTime.Now; orders.Status = OrderType.等待照服員確認訂單; db.Orders.Add(orders); db.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK, new { result = "訂單成立" })); }
//[JwtAuthFilter] public IHttpActionResult AttendantDetails(int Id) { //string token = Request.Headers.Authorization.Parameter; //Token jwtAuthUtil = new Token(); //TokenPayload tokenPayload= jwtAuthUtil.GetToken(token); //if (tokenPayload.Identity!="a"|| tokenPayload.ID != Id ) //{ // return Ok(new // { // message = "非法操作" // }); //} List <Cities> cities = db.Cities.ToList(); List <Locations> locationses = db.Locations.ToList(); Attendants attendant = db.Attendants.Include(x => x.Locationses).Where(x => x.Id == Id).FirstOrDefault(); if (attendant.Locationses.Count == 0) { return(Ok(new { attendant, city = "未選擇城市", location = "未指定地區", cities, })); } else { return(Ok(new { attendant, cities, })); } }
public IHttpActionResult QuizReply(QuestionAnswer questionAnswer) { if (string.IsNullOrWhiteSpace(questionAnswer.Answer)) { return(Ok(new { message = "回覆沒填喔" })); } Question question = db.Questions.FirstOrDefault(x => x.Id == questionAnswer.QuestionId); Attendants attendant = db.Attendants.FirstOrDefault(x => x.Id == question.AttendantId); questionAnswer.Attendant = attendant.Name; questionAnswer.ReplyTime = DateTime.Now; db.QuestionAnswers.Add(questionAnswer); db.SaveChanges(); return(Ok(new { message = "已回覆" })); }
public IHttpActionResult NewAttendantDetails() { var formdata = HttpContext.Current.Request; int AttendantID = Convert.ToInt32(formdata["Id"]); Attendants attendant = db.Attendants.Include(x => x.Locationses).Where(x => x.Id == AttendantID).FirstOrDefault(); if (!formdata["Location"].IsNullOrWhiteSpace()) { string[] formlocation = formdata["Location"].Split(','); int[] formlocationInt = new int[formlocation.Length]; for (int i = 0; i < formlocation.Length; i++) { formlocationInt[i] = Convert.ToInt32(formlocation[i]); } var NewLocationses = db.Locations.Where(x => formlocationInt.Contains(x.Id)).ToList();//搜尋 同SQL IN attendant.Locationses = NewLocationses; } else { return(Ok(new { message = "未選擇地區" })); } if (formdata.Files["Photo"] != null) { string photo = ""; string fileExtension = Path.GetExtension(formdata.Files["Photo"].FileName).ToLower(); string[] Extension = { ".jpeg", ".jpg", ".png", ".gif", }; bool photoOK = false; for (int i = 0; i < Extension.Length; i++) { if (fileExtension == Extension[i]) { photoOK = true; break; } } if (photoOK) { if (attendant.Photo != null) { string oldpath = Path.Combine(HostingEnvironment.ApplicationPhysicalPath + "Uploads", attendant.Photo); File.Delete(oldpath); } photo = AttendantID + "_p_" + DateTime.Now.ToString("yyyyMMddHHmm") + fileExtension; string path = Path.Combine(HostingEnvironment.ApplicationPhysicalPath + "Uploads", photo); formdata.Files["Photo"].SaveAs(path); attendant.Photo = photo; } else { return(Ok(new { message = "相片檔案格式不符" })); } } else { if (attendant.Photo == null) { return(Ok(new { message = "未上傳照片" })); } } if (formdata.Files["File"] != null) { string file = ""; string fileExtension = Path.GetExtension(formdata.Files["File"].FileName).ToLower(); string[] Extension = { ".jpeg", ".jpg", ".pdf" }; bool fileOK = false; for (int i = 0; i < Extension.Length; i++) { if (fileExtension == Extension[i]) { fileOK = true; break; } } if (fileOK) { if (attendant.File != null) { string oldpath = Path.Combine(HostingEnvironment.ApplicationPhysicalPath + "Uploads", attendant.File); File.Delete(oldpath); } file = AttendantID + "_f_" + DateTime.Now.ToString("yyyyMMddHHmm") + fileExtension; string path = Path.Combine(HostingEnvironment.ApplicationPhysicalPath + "Uploads", file); formdata.Files["File"].SaveAs(path); attendant.File = file; } else { return(Ok(new { message = "證照檔案格式不符" })); } } else { if (attendant.File == null) { return(Ok(new { message = "未上傳證照" })); } } if (formdata["Name"] != null) { attendant.Name = formdata["Name"]; } else { return(Ok(new { message = "未填姓名" })); } if (formdata["Salary"] != null) { attendant.Salary = Convert.ToInt32(formdata["Salary"]); } else { return(Ok(new { message = "未填薪水" })); } if (formdata["Account"] != null) { attendant.Account = formdata["Account"]; } else { return(Ok(new { message = "未填戶頭" })); } if (formdata["Service"] != null) { attendant.Service = formdata["Service"]; } else { return(Ok(new { message = "未選擇能提供的服務項目" })); } if (formdata["ServiceTime"] != null) { int serviceTime = Convert.ToInt32(formdata["ServiceTime"]); attendant.ServiceTime = (ServiceTime)serviceTime; } else { return(Ok(new { message = "未選擇服務時段" })); } if (formdata["Experience"] != null) { attendant.Experience = formdata["Experience"]; } else { return(Ok(new { message = "未填寫履歷" })); } int status = Convert.ToInt32(formdata["Status"]); attendant.Status = (Whether)status; attendant.EditDate = DateTime.Now; db.SaveChanges(); return(Ok(new { message = "更新資料成功" })); }
// POST api/UserAttendance public void Post([FromBody] Attendants a) { dbatt.addAttendants(a); }