Ejemplo n.º 1
0
        public ActionResult Create([Bind(Include = "ID,Title,Body,Date,Type,ContentType")] Tutorial tutorial, HttpPostedFileBase upload)
        {
            string userid      = User.Identity.GetUserId();
            var    currentuser = db.Users.SingleOrDefault(u => u.Id == userid);

            if (ModelState.IsValid)
            {
                if (upload != null && upload.ContentLength > 0)
                {
                    var pic = new FileMain
                    {
                        FileName    = System.IO.Path.GetFileName(upload.FileName),
                        FileType    = FileType.Pic,
                        ContentType = upload.ContentType
                    };
                    using (var reader = new System.IO.BinaryReader(upload.InputStream))
                    {
                        pic.Content = reader.ReadBytes(upload.ContentLength);
                    }
                    tutorial.FileMains = new List <FileMain> {
                        pic
                    };
                }

                tutorial.User = currentuser;
                tutorial.Date = DateTime.Now;

                db.Tutorials.Add(tutorial);
                db.SaveChanges();
                return(RedirectToAction("Index"));
            }

            return(View(tutorial));
        }
        //Loading
        public ActionResult Loading()
        {
            var      code = Session["key"];
            FileMain file = db.FileMains.SingleOrDefault(n => n.file_key == code.ToString());

            return(View(db.FileMains.Find(file.file_id)));
        }
        public ActionResult GetNewFileIdforMoveToProcess(string FileNo)
        {
            //RBACUser rUser = new RBACUser(Session["UserName"].ToString());
            //if (!rUser.HasPermission("Group_Edit"))
            //{
            //    return Json("D", JsonRequestBehavior.AllowGet);
            //}

            try
            {
                FileMain FileMainAdd = new FileMain();
                var      data        = _fileMainService.All().ToList().FirstOrDefault(x => x.FileNo == FileNo);
                var      MainID      = _fileMainService.All().ToList().Where(x => x.FileNo == FileNo).Select(x => x.MainID).FirstOrDefault();
                string   sql         = string.Format(" Select fd.AttachFileName as FileName from FileDetail as fd where MainID= '" + MainID + "' " +
                                                     " union select AttachFileName from FileTransDetail where FileTransID in " +
                                                     "(select FileTransID from FileTransMain where MainID = '" + MainID + "')");
                List <ProcessActionVM> VchrList;
                using (ERPConfigurationContext dbContext = new ERPConfigurationContext())
                {
                    VchrList = dbContext.Database.SqlQuery <ProcessActionVM>(sql).ToList();
                }
                // ViewBag.Items = VchrList;
                if (data != null)
                {
                    FileMainAdd = data;
                }

                return(Json(new { FileMainAdd, VchrList }, JsonRequestBehavior.AllowGet));
            }
            catch (Exception)
            {
                return(Json("0", JsonRequestBehavior.AllowGet));
            }
        }
        public ActionResult PostSubmit(HttpPostedFileBase fileread, FileMain fileMain)
        {
            if (fileread == null)
            {
                TempData["check"] = "Vui lòng bỏ văn bản vào để tiến hành";
                return(Redirect("/"));
            }
            else
            {
                var code = Guid.NewGuid().ToString();

                var fileimg = Path.GetFileName(fileread.FileName);
                var pa      = Path.Combine(Server.MapPath("~/IMG/Img"), code + fileimg);

                fileread.SaveAs(pa);

                fileMain.file_key        = code;
                fileMain.file_status     = 1;
                fileMain.file_datecreate = DateTime.Now;
                fileMain.file_img        = code + fileread.FileName;


                var dao    = new FilesDAO();
                var status = dao.create(fileMain);
                switch (status)
                {
                case 1:
                    Session["key"] = code;


                    FileMain f       = db.FileMains.SingleOrDefault(n => n.file_key == code);
                    History  history = new History
                    {
                        file_id        = f.file_id,
                        his_title      = "đã tạo báo cáo",
                        his_datecreate = DateTime.Now,
                        his_status     = 1
                    };
                    db.Historys.Add(history);
                    db.SaveChanges();


                    History history2 = new History
                    {
                        file_id        = f.file_id,
                        his_title      = "đang tiến hành đọc",
                        his_datecreate = DateTime.Now,
                        his_status     = 1
                    };
                    db.Historys.Add(history2);
                    db.SaveChanges();

                    return(RedirectToAction("Loading"));

                default:
                    return(Redirect("/"));
                }
            }
        }
Ejemplo n.º 5
0
 public int create(FileMain fileMain)
 {
     try
     {
         db.FileMains.Add(fileMain);
         db.SaveChanges();
         return(1);
     }
     catch (Exception)
     {
         return(2);
     }
 }
Ejemplo n.º 6
0
        //public ActionResult Edit([Bind(Include = "ID,Title,Body,Date,Type,ContentType")] Tutorial tutorial, HttpPostedFileBase upload)
        public ActionResult Edit(Tutorial model, HttpPostedFileBase upload, int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            Tutorial tutorial = db.Tutorials.Find(id);

            if (tutorial == null)
            {
                return(HttpNotFound());
            }

            if (ModelState.IsValid)
            {
                //int tutorialid = tutorial.ID;
                //var tutorialToUpdate = db.Tutorials.SingleOrDefault(u => u.ID == tutorialid);

                if (upload != null && upload.ContentLength > 0)
                {
                    if (tutorial.FileMains.Any(f => f.FileType == FileType.Pic))
                    {
                        db.FileMains.Remove(tutorial.FileMains.First(f => f.FileType == FileType.Pic));
                    }
                    var pic = new FileMain
                    {
                        FileName    = System.IO.Path.GetFileName(upload.FileName),
                        FileType    = FileType.Pic,
                        ContentType = upload.ContentType
                    };
                    using (var reader = new System.IO.BinaryReader(upload.InputStream))
                    {
                        pic.Content = reader.ReadBytes(upload.ContentLength);
                    }
                    tutorial.FileMains = new List <FileMain> {
                        pic
                    };
                }

                tutorial.Title       = model.Title;
                tutorial.Body        = model.Body;
                tutorial.Type        = model.Type;
                tutorial.ContentType = model.ContentType;
                tutorial.Date        = DateTime.Now;

                db.Entry(tutorial).State = EntityState.Modified;
                db.SaveChanges();
                return(RedirectToAction("Index"));
            }
            return(View(tutorial));
        }
        //Hàm lưu item
        public JsonResult CreateItem(string[] price, string[] confidence, int[] x0, int[] y0, int[] x1, int[] y1, object[] target, string[] itemcode)
        {
            var      code = Session["key"];
            FileMain file = db.FileMains.SingleOrDefault(n => n.file_key == code.ToString());

            Image img = Image.FromFile(Request.MapPath("~/IMG/img/" + file.file_img));


            for (var i = 0; i < price.Length - 1; i++)
            {
                var codekey = Guid.NewGuid().ToString();
                var pa      = Path.Combine(Server.MapPath("~/IMG/Img"), codekey + ".png");
                SaveResizeImage(file.file_img, pa, x0[i], y0[i], x1[i], y1[i]);
                ItemMain itemMain = new ItemMain
                {
                    item_mvo        = price[i],
                    item_pro        = float.Parse(confidence[i]),
                    item_datecreate = DateTime.Now,
                    file_id         = file.file_id,
                    item_x0         = x0[i],
                    item_y0         = y0[i],
                    item_x1         = x1[i],
                    item_y1         = y1[i],
                    table_id        = 1,
                    item_watched    = false,
                    notSee          = false,
                    item_mvi        = price[i],
                    item_img        = codekey + ".png",
                    item_target     = (string)target[i],
                    item_codeitem   = itemcode[i],
                    file_key        = file.file_key
                };
                db.ItemMains.Add(itemMain);
            }
            db.SaveChanges();


            History history2 = new History
            {
                file_id        = file.file_id,
                his_title      = "đã đọc xong",
                his_datecreate = DateTime.Now,
                his_status     = 1
            };

            db.Historys.Add(history2);
            db.SaveChanges();


            return(Json(null));
        }
        public ActionResult Detail(string id)
        {
            Session["key"] = null;
            FileMain file = db.FileMains.SingleOrDefault(n => n.file_key == id);

            History history = new History
            {
                file_id        = file.file_id,
                his_title      = "đã xem",
                his_datecreate = DateTime.Now,
                his_status     = 1
            };

            db.Historys.Add(history);
            db.SaveChanges();

            return(View(file));
        }
        public ActionResult GetNewFileIdforEdit(string FileNo)
        {
            //RBACUser rUser = new RBACUser(Session["UserName"].ToString());
            //if (!rUser.HasPermission("Group_Edit"))
            //{
            //    return Json("D", JsonRequestBehavior.AllowGet);
            //}

            try
            {
                FileMain FileMainAdd = new FileMain();
                var      data        = _fileMainService.All().ToList().FirstOrDefault(x => x.FileNo == FileNo);
                if (data != null)
                {
                    FileMainAdd = data;
                }
                return(Json(FileMainAdd, JsonRequestBehavior.AllowGet));
            }
            catch (Exception)
            {
                return(Json("0", JsonRequestBehavior.AllowGet));
            }
        }
        public ActionResult SaveNewFile()
        {
            HttpFileCollectionBase PhotoFile = Request.Files;
            var fMain  = Request.Form["fMain"];
            var obj1   = JObject.Parse(fMain);
            var FileNo = (string)obj1["fMain"]["FileID"];

            try
            {
                var fileNoCheck = _fileMainService.All().Where(x => x.FileNo.ToString() == FileNo).Select(x => x.FileNo).FirstOrDefault();

                if (fileNoCheck == null)
                {
                    FileMain FileMainInfo = new FileMain();
                    FileMainInfo.FileNo    = (string)obj1["fMain"]["FileID"];
                    FileMainInfo.FileSub   = (string)obj1["fMain"]["FileSub"];
                    FileMainInfo.FileRef   = (string)obj1["fMain"]["FileRef"];
                    FileMainInfo.FileText  = (string)obj1["fMain"]["FileText"];
                    FileMainInfo.AttachNum = Convert.ToByte(PhotoFile.Count);
                    //FileMainInfo.FileID = 1;
                    FileMainInfo.UserID = Convert.ToInt32(Session["UserID"].ToString());
                    //FileMainInfo.VersionNo = _actionListService.All().Select(x=>x.ActDesc).FirstOrDefault();
                    FileMainInfo.VersionNo   = "New";
                    FileMainInfo.UpdUserID   = Convert.ToInt32(Session["UserID"].ToString());
                    FileMainInfo.CreateDate  = DateTime.Now;
                    FileMainInfo.LastUpdDate = DateTime.Now;
                    _fileMainService.Add(FileMainInfo);
                    _fileMainService.Save();
                }
            }
            catch (Exception ex)
            {
                return(Json("0", JsonRequestBehavior.AllowGet));
            }
            //else
            //{
            //     return Json("2", JsonRequestBehavior.AllowGet);
            //}
            string fileName       = "";
            string NewPhotoID     = "";
            string ImgPrefix      = "";
            string ext            = "";
            string PhotoPath      = "";
            string PhysicalPhPath = "";
            string DBPhotoPath    = "";

            try
            {
                if (PhotoFile != null)
                {
                    for (int i = 0; i < PhotoFile.Count; i++)
                    {
                        string             fileId = Guid.NewGuid().ToString().Replace("-", "");
                        HttpPostedFileBase file   = PhotoFile[i];
                        fileName  = Path.GetFileName(file.FileName);
                        ext       = System.IO.Path.GetExtension(fileName);
                        ImgPrefix = FileNo;     //"Photo";//file.ContentType;//
                        int fSize = file.ContentLength;
                        //var path = Path.Combine(Server.MapPath("~/Uploads/Photo/"), MemberCode, fileId);


                        if (ext.ToLower().Contains("txt") || ext.ToLower().Contains("gif") || ext.ToLower().Contains("jpg") || ext.ToLower().Contains("jpeg") ||
                            ext.ToLower().Contains("png") || ext.ToLower().Contains(".xls") || ext.ToLower().Contains(".docx") ||
                            ext.ToLower().Contains(".xlsx") || ext.ToLower().Contains(".pdf"))
                        {
                            NewPhotoID     = ImgPrefix + fileId + ext;
                            PhotoPath      = ConfigurationManager.AppSettings["PhotoPath"];
                            PhysicalPhPath = Path.Combine(Server.MapPath(PhotoPath), NewPhotoID);
                            //var path = Path.Combine(Server.MapPath("~/Images/Photo"), fileName);
                            file.SaveAs(PhysicalPhPath);

                            DBPhotoPath = PhotoPath + "\\" + NewPhotoID;
                        }
                        var NewFile = new FileDetail
                        {
                            AttachFileName = fileName,
                            FileType       = ext,
                            Size           = fSize,
                            FileSourcePath = PhysicalPhPath,
                            //MainID = (int)obj1["fMain"]["MainID"],
                            MainID = _fileMainService.All().Where(x => x.FileNo == (string)obj1["fMain"]["FileID"]).Select(x => x.MainID).FirstOrDefault(),
                        };
                        _fileDetailService.Add(NewFile);
                        _fileDetailService.Save();
                    }
                }
                return(Json("1", JsonRequestBehavior.AllowGet));
            }
            catch (Exception)
            {
                return(Json("0", JsonRequestBehavior.AllowGet));
            }
        }
        public ActionResult UpdateFileMain()
        {
            HttpFileCollectionBase PhotoFile = Request.Files;
            var      fMain         = Request.Form["fMain"];
            var      obj1          = JObject.Parse(fMain);
            var      FileNo        = (string)obj1["fMain"]["FileID"];
            var      MainID        = _fileMainService.All().Where(x => x.FileNo == FileNo).Select(x => x.MainID).FirstOrDefault();
            FileMain _FileMainInfo = new FileMain();

            _FileMainInfo = _fileMainService.All().ToList().FirstOrDefault(x => x.MainID == MainID);

            try
            {
                if (_FileMainInfo != null)
                {
                    string   fileName       = "";
                    string   NewPhotoID     = "";
                    string   ImgPrefix      = "";
                    string   ext            = "";
                    string   PhotoPath      = "";
                    string   PhysicalPhPath = "";
                    string   DBPhotoPath    = "";
                    string[] fileList       = null;
                    string   filesToDelete  = "";
                    if (PhotoFile != null)
                    {
                        if (PhotoFile.Count != 0)
                        {
                            var ExistFD = _fileDetailService.All().ToList().Where(x => x.MainID == MainID);
                            if (ExistFD != null)
                            {
                                foreach (var item in ExistFD)
                                {
                                    _fileDetailService.Delete(item);
                                }
                            }
                        }

                        for (int i = 0; i < PhotoFile.Count; i++)
                        {
                            string             fileId = Guid.NewGuid().ToString().Replace("-", "");
                            HttpPostedFileBase file   = PhotoFile[i];
                            fileName  = Path.GetFileName(file.FileName);
                            ext       = System.IO.Path.GetExtension(fileName);
                            ImgPrefix = FileNo.ToString(); //"Photo";//file.ContentType;//
                            int fSize = file.ContentLength;

                            if (ext.ToLower().Contains("txt") || ext.ToLower().Contains("gif") || ext.ToLower().Contains("jpg") || ext.ToLower().Contains("jpeg") ||
                                ext.ToLower().Contains("png") || ext.ToLower().Contains(".xls") || ext.ToLower().Contains(".docx") ||
                                ext.ToLower().Contains(".xlsx") || ext.ToLower().Contains(".pdf"))
                            {
                                NewPhotoID     = ImgPrefix + fileId + ext;
                                PhotoPath      = ConfigurationManager.AppSettings["PhotoPath"];
                                PhysicalPhPath = Path.Combine(Server.MapPath(PhotoPath), NewPhotoID);

                                filesToDelete = ImgPrefix + "*";   // Only delete files containing "membercode+photo" in their filenames
                                fileList      = System.IO.Directory.GetFiles(Server.MapPath(PhotoPath), filesToDelete);
                                foreach (string files in fileList)
                                {
                                    System.IO.File.Delete(files);
                                }
                                file.SaveAs(PhysicalPhPath);

                                DBPhotoPath = PhotoPath + "\\" + NewPhotoID;
                            }

                            var NewFile = new FileDetail
                            {
                                AttachFileName = fileName,
                                FileType       = ext,
                                Size           = fSize,
                                FileSourcePath = PhysicalPhPath,
                                MainID         = MainID,
                            };
                            _fileDetailService.Add(NewFile);
                            _fileDetailService.Save();
                        }
                    }

                    //FileMain FileMainInfo = new FileMain();
                    var FileMainUp = _fileMainService.All().Where(x => x.MainID == MainID).FirstOrDefault();
                    FileMainUp.FileNo    = (string)obj1["fMain"]["FileID"];
                    FileMainUp.FileSub   = (string)obj1["fMain"]["FileSub"];
                    FileMainUp.FileRef   = (string)obj1["fMain"]["FileRef"];
                    FileMainUp.FileText  = (string)obj1["fMain"]["FileText"];
                    FileMainUp.AttachNum = Convert.ToByte(PhotoFile.Count);

                    //FileMainInfo.FileID = 1;
                    FileMainUp.UserID      = Convert.ToInt32(Session["UserID"].ToString());
                    FileMainUp.VersionNo   = _actionListService.All().Select(x => x.ActDesc).FirstOrDefault();
                    FileMainUp.UpdUserID   = Convert.ToInt32(Session["UserID"].ToString());
                    FileMainUp.CreateDate  = DateTime.Now;
                    FileMainUp.LastUpdDate = DateTime.Now;
                    _fileMainService.Update(FileMainUp);
                    _fileMainService.Save();
                }
                return(Json("1", JsonRequestBehavior.AllowGet));
            }
            catch (Exception ex)
            {
                return(Json("0", JsonRequestBehavior.AllowGet));
            }
        }
 public void Setvalues(FileMain entity, FileMain existingEntity)
 {
     _service.Setvalues(entity, existingEntity);
 }
 public void Delete(FileMain obj)
 {
     _service.Delete(obj);
 }
 public void Update(FileMain obj)
 {
     _service.Update(obj);
 }
 public void Add(FileMain obj)
 {
     _service.Add(obj);
 }