public void History_write(string user_id, string _page, string _state) { db_e db = new db_e(); string user_name = UserData.user_get(user_id, "user_name"); string department_id = UserData.user_get(user_id, "department_id"); string department_name = UserData.user_get(user_id, "department_name"); string company_id = UserData.user_get(user_id, "company_id"); string company_name = UserData.user_get(user_id, "company_name"); string auth = UserData.user_get(user_id, "auth"); var _insert = new history { user_id = user_id, company_id = company_id, department_id = department_id, user_ip = "", pre_page = "", connect_agent = company_name, connect_host = auth, connect_path = user_name, memo = department_name, connect_date = DateTime.Now, state = _state, page = _page }; db.history.Add(_insert); db.SaveChanges(); // 실제로 저장 }
public ActionResult hotel_action(hotel_ask doc) { string msg = "호텔 단체 요금 견적이 접수되었습니다."; doc.write_date = DateTime.Now; doc.state = "접수"; db2.hotel_ask.Add(doc); db2.SaveChanges(); // 실제로 저장 return (Content("<html><script>alert('" + msg + "'); window.top.location.href ='/Shop/producthotel_ko';</script></html>")); }
public ActionResult code_nationality_action(code_nationality doc, string mode_type, string idx) { string msg = ""; if (string.IsNullOrEmpty(idx)) { #region 저장 doc.write_date = DateTime.Now; doc.writer_id = User.Identity.Name; doc.index_order = 9; doc.use_yn = "Y"; db.code_nationality.Add(doc); db.SaveChanges(); // 실제로 저장 msg = Util.msg.msg_insert; #endregion } else { if (mode_type == "D") { #region 삭제 code_nationality doc_del = db.code_nationality.Single(x => x.code_id == idx); db.code_nationality.Remove(doc_del); db.SaveChanges(); msg = Util.msg.msg_del; #endregion } else { #region 수정 doc.writer_id = User.Identity.Name; doc.write_date = DateTime.Now; doc.index_order = 9; doc.use_yn = "Y"; db.Entry(doc).State = EntityState.Modified; db.SaveChanges(); msg = Util.msg.msg_edit; #endregion } } return(Redirect("/code/code_nationality_list")); }
public ActionResult BoardView(int idx, int?cate) { if (idx == 0) { //0번 게시글은 임시글로써, DB에 존재하지 않는 글임 return(NotFound()); } //권한 시작============================================================================================== BoardAuth(idx, cate); //권한 끝================================================================================================ BoardList data = db.BoardList.Find(idx); #region 일 가져오기 //파일 가져오기===================================================================================================================== var _list = (from a in db.BoardFile where a.Md_id == data.fileId && a.use_yn != "N" select a).OrderByDescending(p => p.id).ToList(); ViewBag.이미지리스트 = _list; ViewBag.이미지리스트카운트 = _list.Count(); //파일 끝============================================================================================================================ #endregion #region 조회수 증가 data.hit = data.hit + 1;; db.SaveChanges(); // 실제로 저장 #endregion #region 읽은 사용자 저장 int _readCount = (from a in db.BoardRread where a.board_idx == idx && a.user_id == User.Identity.Name select a.idx).Count(); if (_readCount == 0) { var _insert = new BoardRread { user_id = User.Identity.Name, user_name = (from a in db.user where a.user_id == User.Identity.Name select a.user_name).FirstOrDefault(), read_date = DateTime.Now, board_idx = idx }; db.BoardRread.Add(_insert); db.SaveChanges(); // 실제로 저장 } var _read = (from a in db.BoardRread where a.board_idx == idx select a).ToList(); ViewBag.읽은사람 = _read; #endregion #region 코멘트 가져오기 IQueryable <BoardComment> _listComent = Enumerable.Empty <BoardComment>().AsQueryable(); _listComent = db.BoardComment.Where(p => p.BD_idx == idx && p.use_yn == "Y").OrderByDescending(o => o.idx); ViewBag.댓글 = _listComent; ViewBag.댓글수 = _listComent.Count(); #endregion return(View(data)); }
public async Task <IActionResult> person_set_action(person doc, int?idx, string mode_type, List <IFormFile> ImageFile) { string file_id = ""; #region 기본 사용자 정보 string user_id = User.Identity.Name; int department_idx = Convert.ToInt32(UserData.user_get(user_id, "department_idx")); int company_idx = Convert.ToInt32(UserData.user_get(user_id, "company_idx")); int auth = Convert.ToInt32(UserData.user_get(user_id, "auth")); #endregion string msg = ""; if (doc.use_yn == "on") { doc.use_yn = "Y"; } else { doc.use_yn = "N"; } if (idx == null) { #region 저장 msg = "입력"; file_id = user_id + DateTime.Now.ToShortDateString() + DateTime.Now.Hour.ToString() + DateTime.Now.Minute.ToString() + DateTime.Now.Second.ToString() + DateTime.Now.Millisecond.ToString(); doc.write_date = DateTime.Now; doc.fileId = file_id; db.person.Add(doc); db.SaveChanges(); // 실제로 저장 msg = Util.msg.msg_insert; #endregion } else { if (mode_type == "D") { #region 삭제 person _update = (from a in db.person where a.idx == idx select a).Single(); _update.use_yn = "N"; db.SaveChanges(); // 실제로 저장 #endregion } else { #region 수정 msg = "수정"; file_id = doc.fileId; if (string.IsNullOrEmpty(file_id)) { file_id = user_id + DateTime.Now.ToShortDateString() + DateTime.Now.Hour.ToString() + DateTime.Now.Minute.ToString() + DateTime.Now.Second.ToString() + DateTime.Now.Millisecond.ToString(); doc.fileId = file_id; } doc.edit_date = DateTime.Now; db.Entry(doc).State = EntityState.Modified; //idx 제외 업데이트================================= db.Entry(doc).Property("write_date").IsModified = false; db.Entry(doc).Property("work_end_date").IsModified = false; //================================================== db.SaveChanges(); msg = Util.msg.msg_edit; #endregion } } #region 일 올리기 var builder = new ConfigurationBuilder().SetBasePath(Directory.GetCurrentDirectory()).AddJsonFile("appsettings.json"); Configuration = builder.Build(); string Models_photo = Configuration["user_app:file_list_url"]; string company_id = UserData.user_get(user_id, "company_id"); int s = 1; foreach (var formFile in ImageFile) { double file_size = formFile.Length; if (file_size < _fileSizeLimit) { var formFileContent = await FileHelpers .ProcessFormFile <IFormFile>( formFile, ModelState, _permittedExtensions, _fileSizeLimit); #region 변수 // 변수 ========================================================================================================================= string only = user_id + DateTime.Today.ToShortDateString().Replace("-", "") + DateTime.Now.Hour.ToString() + DateTime.Now.Minute.ToString() + DateTime.Now.Second.ToString() + DateTime.Now.Millisecond.ToString(); // var trustedFileNameForFileStorage = Path.GetRandomFileName(); //랜덤이름 string file_ex = ""; // 확장자 try { file_ex = Path.GetFileName(formFile.FileName).Split('.').Last(); } catch { } var _fileName = only + "." + file_ex; // 신규 파일 이름 var _local_path = _targetFilePath + company_id + "/"; // 신규 파일 경로 var filePath = Path.Combine(_local_path, _fileName); // 전체 경로 string desiredThumbPath = _local_path + "s/"; // 작은 이미지 전체 경로 string ore_fileName = Path.GetFileName(formFile.FileName); #endregion //경로에 폴더가 없으면 만들어준다.============================================= var dInfo = new DirectoryInfo(_local_path); var dInfo_s = new DirectoryInfo(desiredThumbPath); if (!dInfo.Exists) { dInfo.Create(); } if (!dInfo_s.Exists) { dInfo_s.Create(); } //================================================================================= using (var fileStream = System.IO.File.Create(filePath)) { await fileStream.WriteAsync(formFileContent); } if (get_word.img_check(file_ex) == "img") { // 세로 기준 ResizeImage(desiredThumbPath, formFile, _fileName, 300, 0); } var _insert = new Md_Image() { Md_id = file_id, ImagePath = Models_photo + company_id + "/" + _fileName, fileName = ore_fileName, use_yn = "Y", file_ex = file_ex, file_size = file_size, r_date = DateTime.Now, write_id = User.Identity.Name, sImagePath = Models_photo + company_id + "/s/" + _fileName, }; db.Md_Image.Add(_insert); db.SaveChanges(); } s++; } #endregion return(Redirect("/person/person_set_list")); }
public ActionResult m_photo_list_mainset() { string returnUrl = "/board/m_photo_list?cate=7"; string m_id = Request["m_id"] ?? ""; int idx = Convert.ToInt32(Request["idx"]); if (!string.IsNullOrEmpty(m_id)) { var _update = (from a in db.BoardFile where a.machine_id == m_id select a).ToList(); foreach (var item in _update) { if (item.BF_idx == idx) { item.main_img = "Y"; } else { item.main_img = "N"; } db.SaveChanges(); // 실제로 저장 } } return(Content("<script>alert('Set as representative image');location.href='/board/m_photo_list?search_type=" + m_id + "';</script>")); }
public async Task <IActionResult> userinfo_action(user doc) { #region 사용자 정보 수정 user _update = (from a in db.user where a.user_id == User.Identity.Name select a).Single(); _update.user_tel = doc.user_tel; // _update.user_password = doc.user_password; _update.edit_date = DateTime.Now; _update.main_bg_color = doc.main_bg_color; _update.language = doc.language; _update.user_email = doc.user_email; db.SaveChanges(); // 실제로 저장 #endregion //================================================================== UserData UserData = new UserData(); UserData.History_write(User.Identity.Name, "/sys/user_info", "수정"); //=================================================================== return(Redirect("/sys/user_info")); }