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