public async Task <IActionResult> Create(TbSlide tbSlide, IFormFile SlideImage) { if (ModelState.IsValid) { if (SlideImage.Length > 0) { var fileName = ContentDispositionHeaderValue.Parse(SlideImage.ContentDisposition).FileName.Trim('"'); string ImageName = Guid.NewGuid().ToString() + Path.GetExtension(SlideImage.FileName); var path = Path.Combine(Directory.GetCurrentDirectory(), $"wwwroot\\Uploadimages\\{ImageName}"); var pathView = $"\\Uploadimages\\{ImageName}"; using (var stream = new FileStream(path, FileMode.Create)) { await SlideImage.CopyToAsync(stream); } tbSlide.SlideImage = pathView; //tbSlide.CamnangNgaytao = DateTime.Now; } _context.Add(tbSlide); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(tbSlide)); }
public async Task <IActionResult> Create([Bind("DoitacId,DoitacTen,DoitacMota,DoitacHinhanh")] TbDoiTac tbDoiTac) { if (ModelState.IsValid) { _context.Add(tbDoiTac); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(tbDoiTac)); }
public async Task <IActionResult> Create([Bind("SukienId,SukienNgaygio,SukienDiachi,SukienMota")] TbSuKien tbSuKien) { if (ModelState.IsValid) { _context.Add(tbSuKien); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(tbSuKien)); }
public async Task <IActionResult> Create([Bind("LienheId,LienheCoso,LienheTencose,LienheDiachi,LienheDienthoai,LienheEmail,LienheLinkfb,LienheLinktw,LienheLinkin,LienheLinkgmap")] TbLienHe tbLienHe) { if (ModelState.IsValid) { _context.Add(tbLienHe); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(tbLienHe)); }
public async Task <IActionResult> Create([Bind("LoaicamnangId,LoaicamnangTieude")] TbLoaiCamNang tbLoaiCamNang) { if (ModelState.IsValid) { _context.Add(tbLoaiCamNang); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(tbLoaiCamNang)); }
public async Task <IActionResult> Create(TbCamNang tbCamNang, IFormFile CamnangHinhanh) { if (ModelState.IsValid) { if (CamnangHinhanh != null) { var fileName = ContentDispositionHeaderValue.Parse(CamnangHinhanh.ContentDisposition).FileName.Trim('"'); string ImageName = Guid.NewGuid().ToString() + Path.GetExtension(CamnangHinhanh.FileName); var path = Path.Combine(Directory.GetCurrentDirectory(), $"wwwroot\\Uploadimages\\{ImageName}"); var pathView = $"\\Uploadimages\\{ImageName}"; using (var stream = new FileStream(path, FileMode.Create)) { await CamnangHinhanh.CopyToAsync(stream); } tbCamNang.CamnangHinhanh = pathView; tbCamNang.CamnangNgaytao = DateTime.Now; } _context.Add(tbCamNang); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } IList <CamNang> studentList = new List <CamNang>(); var student = (from tb in _context.TbCamNang join lcn in _context.TbLoaiCamNang on tb.LoaicamnangId equals lcn.LoaicamnangId select new { tb.CamnangId, tb.CamnangTieude, tb.CamnangMota, tb.CamnangNoidung, tb.CamnangHinhanh, tb.LoaicamnangId, lcn.LoaicamnangTieude, }).ToList(); foreach (var i in student) { studentList.Add(new CamNang() { CamnangId = i.CamnangId, CamnangTieude = i.CamnangTieude, CamnangMota = i.CamnangMota, CamnangHinhanh = i.CamnangHinhanh, CamnangNoidung = i.CamnangNoidung, LoaicamnangId = i.LoaicamnangId, LoaicamnangTieude = i.LoaicamnangTieude }); } ViewData["students"] = studentList; return(View()); //return View(tbCamNang); }
public async Task <IActionResult> Create([Bind("Mssg_ID,Title,Text,Sender_ID,Receiver_ID,Team_Code,Co_Receiver_ID,Co_Recvr_Approved,Receiver_Approved,Date,Target_Date,start_work_hour,end_work_hour")] Requests_Site_Post requests) { //current user has sender id if (HttpContext.Session.GetInt32("ID") == int.Parse(requests.Sender_ID)) { Requests new_req = new Requests(); new_req.Mssg_ID = requests.Mssg_ID; new_req.Title = requests.Title; new_req.Text = requests.Text; new_req.Sender_ID = int.Parse(requests.Sender_ID); new_req.Team_Code = requests.Team_Code; new_req.Co_Receiver_ID = int.Parse(requests.Co_Receiver_ID); new_req.Co_Recvr_Approved = false; new_req.Date = DateTime.Now; DateTime datevalue; //check if string has date time format if (DateTime.TryParse(requests.Target_Date, out datevalue) && DateTime.TryParse(requests.start_work_hour, out datevalue) && DateTime.TryParse(requests.end_work_hour, out datevalue)) { //start is after end if (DateTime.Parse(requests.start_work_hour) >= DateTime.Parse(requests.end_work_hour)) { return(Redirect(Request.Headers["Referer"].ToString())); } new_req.Target_Date = requests.Target_Date; new_req.start_work_hour = requests.start_work_hour; new_req.end_work_hour = requests.end_work_hour; } else { return(Redirect(Request.Headers["Referer"].ToString())); } if (ModelState.IsValid) { _context.Add(new_req); await _context.SaveChangesAsync(); return(Redirect(Request.Headers["Referer"].ToString())); } //return to previous page/ return(Redirect(Request.Headers["Referer"].ToString())); } else { return(Redirect(Request.Headers["Referer"].ToString())); } }
public async Task <ActionResult> OnPostSendRequestAsync(IFormFile Binary, [StringLength(13, ErrorMessage = "تعداد ارقام صحیح نیست", MinimumLength = 11)][RegularExpression(@"^(\+98|0)?9\d{9}$", ErrorMessage = "تلفن همراه نامعتبر است")] string PhoneNumber, string FullName, string LetterSubject, string LetterDisp, string CompanyName) { try { if (Binary == null) { TempData["nofile"] = "فایل انتخاب نشده است"; return(Page()); } if (!ModelState.IsValid) { ViewData["OnTab"] = "rquest-type"; return(Page()); } if (PhoneNumber == null) { TempData["noPhone"] = "تلفن همراه را وارد کنید "; return(Page()); } TblBinarys tblBinarys = new TblBinarys(); var res = await Services.Upload(Binary); if (res != null) { tblBinarys.Binary = res; tblBinarys.Subject = LetterSubject; tblBinarys.Description = "ثبت از سایت"; tblBinarys.FileFormat = Path.GetExtension(Binary.FileName).Replace(".", ""); _context.TblBinarys.Add(tblBinarys); _context.SaveChanges(); } TblLetters NewLetter = new TblLetters { BinaryIds = tblBinarys.BinaryId.ToString(), CreateDate = DateTime.Now, SignDateTime = DateTime.Now, Comment = FullName + " " + PhoneNumber + " " + CompanyName + " " + LetterDisp, LetterDate = Services.ToShamsi(DateTime.Now.Date), Sender = 7820, SenderName = "سيستم مکاتبات اعضاء", Reciver = 6519, ReciverName = "عباسعلی اسلامی - رييس اتحاديه اتحاديه صادرکنندگان فراورده های نفت، گاز و پتروشيمی ايران", SubjectId = 829, SubjectName = "سيستم مکاتبات سايت", Subjects = LetterSubject, Peyvast = "دارد 1 برگ", LetterNum = "", DocumentType = "نامه", Arjaiat = "عادی", SendType = "اپلیکشن", LetterType = 0, RelateLetterId = 0, RelateLetterType = "وارده" }; _context.Add(NewLetter); _context.SaveChanges(); var id = NewLetter.LetterId; TblRefrences refrence = new TblRefrences { LetterId = id, ToUser = 57, Status = 0, FromUser = Services.UserMemberId, ReferAbout = "نامه ثبتی از سایت", Periority = "عادی" }; Services.InsertReference(_context, refrence); ViewData["OnTab"] = "rquest-type"; Registered = true; TempData["Success"] = Services.EncryptString(NewLetter.LetterId.ToString()); TempData["Date"] = NewLetter.LetterDate.ToString(); return(Page()); } catch (Exception ex) { TempData["nofile"] = ex.Message; return(Page()); } }
public JsonResult EnrollInClass(long locationID, long classID, long roomLayoutID, int seatNumber, int reservationStatus) { // 1 - Enrolled // 2 - Cancelled // 3 - Maintenance // 4 - LateCancelled // 9 - WaitListed User loggedInuser = db_context.Users.AsNoTracking().Where(x => x.Email == HttpContext.User.Identity.Name || x.UserName == HttpContext.User.Identity.Name).ToList().First(); Location l = db_context.Locations.AsNoTracking().Single(x => x.LocationID == locationID); if (db_context.Reservations.Where(x => x.ClassID == classID && x.UserID == loggedInuser.UserID).Count() > 0) { var result = new { StatusCode = "Error", Message = "You're already enrolled" }; return(Json(result)); } else { if (roomLayoutID == 0) { Reservation r = new Reservation(); r.UserID = loggedInuser.UserID; r.RoomLayoutID = roomLayoutID; r.ClassID = classID; r.ReservationDate = DateTime.UtcNow.ToTimeZoneTime(l.TimeZone); r.SeatNumber = db_context.Reservations.AsNoTracking().Where(x => x.ClassID == classID && x.RoomLayoutID == roomLayoutID).Count() + 1; r.ReservationStatus = 1; r.SignedIn = 0; db_context.Add(r); db_context.SaveChanges(); var result = new { StatusCode = "Success", Message = "Successfully enrolled in the class" }; return(Json(result)); } else { if (db_context.Reservations.Where(x => x.ClassID == classID && x.RoomLayoutID == roomLayoutID && x.SeatNumber == seatNumber).Count() > 0) { var result = new { StatusCode = "Error", Message = "Someone already reserved that seat" }; return(Json(result)); } else { Reservation r = new Reservation(); r.UserID = loggedInuser.UserID; r.RoomLayoutID = roomLayoutID; r.ClassID = classID; r.ReservationDate = DateTime.UtcNow.ToTimeZoneTime(l.TimeZone); r.SeatNumber = seatNumber; r.ReservationStatus = 1; r.SignedIn = 0; db_context.Add(r); db_context.SaveChanges(); var result = new { StatusCode = "Success", Message = "Successfully enrolled in the class" }; return(Json(result)); } } } }
public async Task <ActionResult> OnPostSendRequestAsync(IFormFile Binary, [StringLength(13, ErrorMessage = "تعداد ارقام صحیح نیست", MinimumLength = 11)][RegularExpression(@"^(\+98|0)?9\d{9}$", ErrorMessage = "تلفن همراه نامعتبر است")] string PhoneNumber) { try { if (Binary == null) { TempData["nofile"] = "فایل انتخاب نشده است"; ViewData["OnTab"] = "rquest-type"; return(Page()); } if (!ModelState.IsValid) { ViewData["OnTab"] = "rquest-type"; return(Page()); } if (PhoneNumber == null) { TempData["noPhone"] = "تلفن همراه را وارد کنید "; ViewData["OnTab"] = "rquest-type"; return(Page()); } if (!await Services.RequestCheck(dB_Context, PhoneNumber)) { TblBinarys tblBinarys = new TblBinarys(); var res = await Services.Upload(Binary); if (res != null) { tblBinarys.Binary = res; tblBinarys.Subject = "درخواست از سایت"; tblBinarys.Description = "ثبت از سایت"; tblBinarys.FileFormat = Path.GetExtension(Binary.FileName).Replace(".", ""); dB_Context.TblBinarys.Add(tblBinarys); dB_Context.SaveChanges(); } TblLetters NewLetter = new TblLetters { BinaryIds = tblBinarys.BinaryId.ToString(), CreateDate = DateTime.Now, SignDateTime = DateTime.Now, Comment = PhoneNumber, LetterDate = Services.ToShamsi(DateTime.Now.Date), Sender = 15377, Reciver = 6519, SubjectId = 828, Subjects = "درخواست عضويت در اتحاديه (سايت)", Peyvast = "دارد 1 برگ", LetterNum = "", DocumentType = "نامه", Arjaiat = "عادی", SendType = "اپلیکشن", SubjectName = "", SenderName = "متقاضي عضويت در اتحاديه", ReciverName = "عباسعلي اسلامي - رييس اتحاديه اتحاديه صادرکنندگان فراورده هاي نفت، گاز و پتروشيمي ايران", LetterType = 0, RelateLetterId = 0, RelateLetterType = "وارده" }; dB_Context.Add(NewLetter); dB_Context.SaveChanges(); var id = NewLetter.LetterId; TblRefrences refrence = new TblRefrences { LetterId = id, ToUser = 57, Status = 0, FromUser = Services.UserMemberId, ReferAbout = "درخواست از سایت", Periority = "عادی" }; Services.InsertReference(dB_Context, refrence); ViewData["OnTab"] = "rquest-type"; ViewData["Success"] = "درخواست شما ثبت گردید| شماره درخواست الکترونیکی شما:" + NewLetter.LetterId.ToString() + ""; Registered = true; return(Page()); } else { ViewData["OnTab"] = "rquest-type"; ViewData["Error"] = "شما درخواست عضویت را قبلا ثبت کردید. اگر نام کاربری و کلمه عبور دریافت نکردید لطفا به اتحادیه مراجعه فرمایید."; Registered = true; return(Page()); } } catch (Exception ex) { TempData["nofile"] = ex; ViewData["OnTab"] = "rquest-type"; return(Page()); } }
public JsonResult BookingOperation() { string OperationID = HttpContext.Request.Form["operationID"]; long ClassID = long.Parse(HttpContext.Request.Form["classID"]); long RoomID = long.Parse(HttpContext.Request.Form["roomID"]); long locationID = long.Parse(HttpContext.Request.Form["locationID"]); Location location = db_context.Locations.AsNoTracking().Single(x => x.LocationID == locationID); var result = new { StatusCode = "", Message = "" }; switch (OperationID) { case "1": { long userID = long.Parse(HttpContext.Request.Form["userID"]); int SpotNumber = int.Parse(HttpContext.Request.Form["spotNumber"]); if (userID == 0) { result = new { StatusCode = "Error", Message = "Please Select a Member" }; return(Json(result)); } else { if (db_context.Reservations.AsNoTracking().Where(x => x.SeatNumber == SpotNumber && x.RoomLayoutID == RoomID && x.ReservationStatus == 1).Count() > 0) { result = new { StatusCode = "Error", Message = "Seat already reserved" }; return(Json(result)); } if (db_context.Reservations.AsNoTracking().Where(x => x.ClassID == ClassID && x.RoomLayoutID == RoomID && x.UserID == userID && x.ReservationStatus == 1).Count() > 0) { result = new { StatusCode = "Error", Message = "Member already enrolled" }; return(Json(result)); } else { Reservation r = new Reservation(); r.UserID = userID; r.RoomLayoutID = RoomID; r.ClassID = ClassID; r.ReservationDate = DateTime.UtcNow.ToTimeZoneTime(location.TimeZone); r.SeatNumber = SpotNumber; r.ReservationStatus = 1; r.SignedIn = 0; db_context.Add(r); db_context.SaveChanges(); result = new { StatusCode = "Success", Message = "Seat booked successfully" }; return(Json(result)); } } } case "2": //Cancel Reservation { int SpotNumber = int.Parse(HttpContext.Request.Form["spotNumber"]); long reservationID = long.Parse(HttpContext.Request.Form["reservationID"]); Reservation r = db_context.Reservations.AsNoTracking().SingleOrDefault(x => x.ReservationID == reservationID && x.ClassID == ClassID && x.RoomLayoutID == RoomID); r.ReservationStatus = 2; db_context.Update(r); db_context.SaveChanges(); Reservation waitlistEntry = db_context.Reservations.AsNoTracking().Where(x => x.ClassID == ClassID && x.RoomLayoutID == RoomID && x.ReservationStatus == 9).OrderBy(x => x.ReservationDate).FirstOrDefault(); List <Reservation> Reservations = db_context.Reservations.AsNoTracking().Where(x => x.ClassID == ClassID && x.RoomLayoutID == RoomID).ToList(); if (waitlistEntry != null) { if (RoomID != 0) { RoomLayout roomLayout = db_context.RoomLayouts.AsNoTracking().SingleOrDefault(x => x.RoomLayoutID == RoomID); dynamic layout = System.Json.JsonObject.Parse(roomLayout.SeatMatrix); foreach (var entry in layout) { if (entry.JsonType == System.Json.JsonType.Object) { if (entry["S"] == "C") { if (Reservations.Where(x => x.SeatNumber == int.Parse(entry["SN"])).Count() == 0) { waitlistEntry.SeatNumber = int.Parse(entry["SN"]); waitlistEntry.ReservationStatus = 1; db_context.Update(waitlistEntry); db_context.SaveChanges(); break; } } } } } } result = new { StatusCode = "Success", Message = "Successfully cancelled the reservation" }; return(Json(result)); } case "20": //Put Spot Under Maintenance { string SpotNumber = HttpContext.Request.Form["spotNumber"]; Reservation r = new Reservation(); r.UserID = 0; r.RoomLayoutID = RoomID; r.ClassID = ClassID; r.ReservationDate = DateTime.UtcNow.ToTimeZoneTime(location.TimeZone); r.SeatNumber = int.Parse(SpotNumber); r.ReservationStatus = 3; r.SignedIn = 0; db_context.Add(r); db_context.SaveChanges(); result = new { StatusCode = "Success", Message = "Seat flagged as Under Maintenance" }; return(Json(result)); } default: { break; } } return(Json(true)); }