public int UpdateApplicantPhoto(ApplicantPhoto photo)
 {
     using (var entities = new atmEntities())
     {
         var exist = (from a in entities.tblApplicantPhotoes where a.Id == photo.Id select a).SingleOrDefault();
         if (null != exist)
         {
             exist.ApplicantId = photo.ApplicantId;
             exist.LastModifiedBy = photo.LastModifiedBy;
             exist.LastModifiedDt = photo.LastModifiedDate;
             exist.Photo = photo.Photo;
             exist.PhotoExt = photo.PhotoExt;
             entities.SaveChanges();
             return exist.Id;
         }
     }
     return 0;
 }
 public ApplicantPhoto GetPhoto(int applicantid)
 {
     if (applicantid != 0)
     {
         using (var entities = new atmEntities())
         {
             var exist = (from a in entities.tblApplicantPhotoes where a.ApplicantId == applicantid select a).SingleOrDefault();
             if (null != exist)
             {
                 var p = new ApplicantPhoto
                 {
                     ApplicantId = exist.ApplicantId,
                     CreatedBy = exist.CreatedBy,
                     CreatedDate = exist.CreatedDt,
                     Id = exist.Id,
                     LastModifiedBy = exist.LastModifiedBy,
                     LastModifiedDate = exist.LastModifiedDt,
                     Photo = exist.Photo,
                     PhotoExt = exist.PhotoExt
                 };
                 return p;
             }
         }
     }
     return null;
 }
 public int SaveApplicantPhoto(ApplicantPhoto photo)
 {
     using (var entities = new atmEntities())
     {
         var exist = (from a in entities.tblApplicantPhotoes where a.ApplicantId == photo.ApplicantId select a).SingleOrDefault();
         if (null != exist)
         {
             photo.Id = exist.Id;
             UpdateApplicantPhoto(photo);
         }
         else
         {
             var p = new tblApplicantPhoto
             {
                 ApplicantId = photo.ApplicantId,
                 CreatedBy = photo.CreatedBy,
                 CreatedDt = photo.CreatedDate,
                 Photo = photo.Photo,
                 PhotoExt = photo.PhotoExt
             };
             entities.tblApplicantPhotoes.Add(p);
             if (entities.SaveChanges() > 0)
                 return p.Id;
         }
     }
     return 0;
 }
示例#4
0
        public ActionResult Upload()
        {
            var uploadtype = Request.Form["uploadtype"];
            var applicantid = Request.Form["applicantid"];
            foreach (string fileu in Request.Files)
            {
                var hpf = Request.Files[fileu];
                if (hpf.ContentLength != 0 && hpf.FileName != null)
                {
                    var ext = Path.GetExtension(hpf.FileName).ToLower();

                    try
                    {
                        if (uploadtype == "LETTER")
                        {
                            if (hpf.ContentLength > 1000000)
                                return Json(new { Ok = false, message = "Muat naik tidak berjaya. Saiz fail melebihi saiz yang dibenarkan (500KB)", item = new object() }, JsonRequestBehavior.AllowGet);

                            if (applicantid != null)
                            {
                                var path = ConfigurationManager.AppSettings["SuppDocFolder"];
                                var appid = 0;
                                int.TryParse(applicantid, out appid);
                                var applicant = ObjectBuilder.GetObject<IApplicantPersistence>("ApplicantPersistence").GetApplicant(appid);
                                if (applicant != null)
                                {
                                    var guid = Guid.NewGuid().ToString();
                                    applicant.OriginalPelepasanDocument = hpf.FileName;
                                    applicant.PelepasanDocument = guid + ext;
                                    hpf.SaveAs(Path.Combine(System.Web.HttpContext.Current.Server.MapPath(@"~/SuppDoc"), (guid + ext)));
                                    applicant.Save();
                                    //hpf.SaveAs(savedFileName);
                                    return Json(new { OK = true, message = "Muatnaik Berjaya", item = JsonConvert.SerializeObject(new { PelepasanDocument = applicant.PelepasanDocument, OriginalPelepasanDocument = applicant.OriginalPelepasanDocument }) }, JsonRequestBehavior.AllowGet);

                                }
                            }
                        }

                        if (uploadtype == "PROFILE")
                        {
                            if (hpf.ContentLength > 500000)
                                return Json(new { Ok = false, message = "Muat naik tidak berjaya. Saiz fail melebihi saiz yang dibenarkan (500KB)", item = new object() }, JsonRequestBehavior.AllowGet);

                            if (ext == ".jpg" || ext == ".jpeg" || ext == ".png" || ext == ".gif" || ext == ".bmp")
                            {
                                var fileBytes = new byte[hpf.ContentLength];
                                var stream = hpf.InputStream.Read(fileBytes, 0, hpf.ContentLength);

                                if (applicantid != null)
                                {
                                    var appid = 0;
                                    int.TryParse(applicantid, out appid);
                                    var applicant = ObjectBuilder.GetObject<IApplicantPersistence>("ApplicantPersistence").GetApplicant(appid);
                                    if (applicant != null)
                                    {
                                        // check where there already exist the photo or not
                                        var existphoto = ObjectBuilder.GetObject<IApplicantPersistence>("ApplicantPersistence").GetPhoto(applicant.ApplicantId);
                                        if (null != existphoto && existphoto.Id != 0)
                                        {
                                            var appphoto = new ApplicantPhoto
                                            {
                                                Photo = fileBytes,
                                                PhotoExt = ext,
                                                ApplicantId = applicant.ApplicantId,
                                                CreatedBy = applicant.CreatedBy,
                                                CreatedDate = DateTime.Now,
                                                Id = existphoto.Id
                                            };
                                            appphoto.Save();
                                        }
                                        else
                                        {
                                            var appphoto = new ApplicantPhoto
                                            {
                                                Photo = fileBytes,
                                                PhotoExt = ext,
                                                ApplicantId = applicant.ApplicantId,
                                                CreatedBy = applicant.CreatedBy,
                                                CreatedDate = DateTime.Now
                                            };
                                            appphoto.Save();
                                        }

                                    }
                                }
                            }
                            else
                                return Json(new { OK = false, message = "Muatnaik tidak berjaya. Jenis fail tidak dibenarkan", item = new object() }, JsonRequestBehavior.AllowGet);

                            //hpf.SaveAs(savedFileName);
                            return Json(new { OK = true, message = "Muatnaik Berjaya", item = JsonConvert.SerializeObject("") }, JsonRequestBehavior.AllowGet);
                        }

                        if (uploadtype == "ACQDOCFS")
                        {
                            var acquisitionid = Request.Form["acquisitionid"];
                            if (hpf.ContentLength > 5000000)
                                return Json(new { Ok = false, message = "Muat naik tidak berjaya. Saiz fail melebihi saiz yang dibenarkan (5MB)", item = new object() }, JsonRequestBehavior.AllowGet);

                            if (acquisitionid != null)
                            {
                                var path = ConfigurationManager.AppSettings["SuppDocFolder"];
                                var appid = 0;
                                int.TryParse(acquisitionid, out appid);
                                if (appid != 0)
                                {
                                    var acq = ObjectBuilder.GetObject<IAcquisitionPersistence>("AcquisitionPersistence").GetAcquisition(appid);
                                    if (null != acq)
                                    {
                                        var guid = Guid.NewGuid().ToString();
                                        var filename = guid + ext;
                                        hpf.SaveAs(Path.Combine(System.Web.HttpContext.Current.Server.MapPath(@"~/SuppDoc"), (filename)));
                                        acq.FinalSupportingDocumentOriginal = hpf.FileName;
                                        acq.FinalSupportingDocument = filename;
                                        acq.Save();
                                        return Json(new { OK = true, message = "Muatnaik Berjaya", item = JsonConvert.SerializeObject(new { DocumentName = hpf.FileName }) }, JsonRequestBehavior.AllowGet);
                                    }
                                }
                            }
                        }

                        if (uploadtype == "ACQDOCRD")
                        {
                            var acquisitionid = Request.Form["acquisitionid"];
                            if (hpf.ContentLength > 5000000)
                                return Json(new { Ok = false, message = "Muat naik tidak berjaya. Saiz fail melebihi saiz yang dibenarkan (5MB)", item = new object() }, JsonRequestBehavior.AllowGet);

                            if (acquisitionid != null)
                            {
                                var path = ConfigurationManager.AppSettings["SuppDocFolder"];
                                var appid = 0;
                                int.TryParse(acquisitionid, out appid);
                                if (appid != 0)
                                {
                                    var acq = ObjectBuilder.GetObject<IAcquisitionPersistence>("AcquisitionPersistence").GetAcquisition(appid);
                                    if (null != acq)
                                    {
                                        var guid = Guid.NewGuid().ToString();
                                        var filename = guid + ext;
                                        hpf.SaveAs(Path.Combine(System.Web.HttpContext.Current.Server.MapPath(@"~/SuppDoc"), (filename)));
                                        acq.ReportDutySupportingDocumentOriginal = hpf.FileName;
                                        acq.ReportDutySupportingDocument = filename;
                                        acq.Save();
                                        return Json(new { OK = true, message = "Muatnaik Berjaya", item = JsonConvert.SerializeObject(new { DocumentName = hpf.FileName }) }, JsonRequestBehavior.AllowGet);
                                    }
                                }
                            }
                        }

                        if (uploadtype == "ACQDOCIS")
                        {
                            var acquisitionid = Request.Form["acquisitionid"];
                            if (hpf.ContentLength > 5000000)
                                return Json(new { Ok = false, message = "Muat naik tidak berjaya. Saiz fail melebihi saiz yang dibenarkan (5MB)", item = new object() }, JsonRequestBehavior.AllowGet);

                            if (acquisitionid != null)
                            {
                                var path = ConfigurationManager.AppSettings["SuppDocFolder"];
                                var appid = 0;
                                int.TryParse(acquisitionid, out appid);
                                if (appid != 0)
                                {
                                    var acq = ObjectBuilder.GetObject<IAcquisitionPersistence>("AcquisitionPersistence").GetAcquisition(appid);
                                    if (null != acq)
                                    {
                                        var guid = Guid.NewGuid().ToString();
                                        var filename = guid + ext;
                                        hpf.SaveAs(Path.Combine(System.Web.HttpContext.Current.Server.MapPath(@"~/SuppDoc"), (filename)));
                                        acq.FirstSupportingDocumentOriginal = hpf.FileName;
                                        acq.FirstSupportingDocument = filename;
                                        acq.Save();
                                        return Json(new { OK = true, message = "Muatnaik Berjaya", item = JsonConvert.SerializeObject(new { DocumentName = hpf.FileName }) }, JsonRequestBehavior.AllowGet);
                                    }
                                }
                            }
                        }

                    }
                    catch (Exception exc)
                    {
                        throw exc;
                    }
                }
            }
            // Return JSON
            return Json(new { OK = false, message = "Tidak Berjaya", item = new object() }, JsonRequestBehavior.AllowGet);
        }