public JsonResult SaveDoc(Document postData) { long docid = default(long); string[] formats = { "dd.MM.yyyy", "dd/MM/yyyy", "dd/MM/yy" }; DateTime docdate = DateTime.Now; try { long.TryParse(Encryption64.DecryptQueryString(postData.DocInfo10), out docid); postData.DocID = docid; DateTime.TryParseExact(postData.DocInfo9, formats, System.Globalization.CultureInfo.InvariantCulture, System.Globalization.DateTimeStyles.None, out docdate); postData.DocDate = docdate; postData.Opmode = 3; postData.ModifiedBy = GlobalSettings.oUserData.ID; postData.ApprovedBy = GlobalSettings.oUserData.ID; postData.CheckedBy = GlobalSettings.oUserData.ID; var result = DBOperations <Document> .DMLOperation(postData, Constant.usp_DocumentManager, DMLOperationFlag.Update); if (result > default(int)) { return(Json(new { Success = 1, Message = "Data saved successfully" })); } else { throw new Exception("Unable to update data"); } } catch (Exception ex) { Utility.Logger(ex); return(Json(new { Success = default(int), Message = ex.Message })); } }
public ActionResult New(string id = "") { long permissionid = default(long); var obj = new UserPermissionMaster(); try { if (!string.IsNullOrEmpty(id)) { long.TryParse(Encryption64.DecryptQueryString(id), out permissionid); } if (permissionid > default(long)) { obj = DBOperations <UserPermissionMaster> .GetSpecific(new UserPermissionMaster() { AccessID = permissionid, Opmode = 4 }, Constant.usp_UserPermissionMaster); } } catch (Exception) { } return(View("New", obj)); }
public JsonResult SetApproval(string key, int key1) { long docid = default(long); try { var userid = GlobalSettings.oUserData.ID; long.TryParse(Encryption64.DecryptQueryString(key), out docid); var result = DBOperations <Document> .DMLOperation(new Document() { Opmode = 6, IsUploadApproved = key1, DocID = docid, ApprovedBy = userid }, Constant.usp_DocumentManager); if (result > default(int)) { return(Json(new { Success = 1, Message = "Approval status has been updated for the document" }, JsonRequestBehavior.AllowGet)); } else { throw new Exception("Unable to update approval status"); } } catch (Exception ex) { return(Json(new { Success = default(int), Message = ex.Message }, JsonRequestBehavior.AllowGet)); } }
public JsonResult SaveData(Organization postData) { long orgid = default(long); try { if (postData == null) { throw new Exception("No data found for insert"); } long.TryParse(Encryption64.DecryptQueryString(postData.EncryptedOrgID), out orgid); postData.OrgID = orgid; postData.Opmode = orgid > default(int) ? 3 : 2; postData.CreatedBy = postData.ModifiedBy = GlobalSettings.oUserData.ID; var result = DBOperations <Organization> .DMLOperation(postData, Constant.usp_Organization); if (result > default(int)) { return(Json(new { Success = 1, Message = string.Format("Data have been {0} successfully", orgid > default(long) ? "updated" : "saved") }, JsonRequestBehavior.AllowGet)); } else { throw new Exception("Operation has been failed to execute"); } } catch (Exception ex) { return(Json(new { Success = default(int), Message = ex.Message }, JsonRequestBehavior.AllowGet)); } }
public ActionResult New(string id = "") { long orgid = default(long); var obj = new Organization(); try { if (!string.IsNullOrEmpty(id)) { long.TryParse(Encryption64.DecryptQueryString(id), out orgid); } if (orgid > default(long)) { obj = DBOperations <Organization> .GetSpecific(new Organization() { OrgID = orgid, Opmode = 1 }, Constant.usp_Organization); } } catch (Exception) { } return(View("New", obj)); }
public ActionResult LoadAttachmentList(string docid) { long documentId = default(long); List <AttachmentFile> lst = new List <AttachmentFile>(); try { long.TryParse(Encryption64.DecryptQueryString(docid), out documentId); lst = DBOperations <AttachmentFile> .GetAllOrByRange(new AttachmentFile() { DocID = documentId, Opmode = default(int) }, Constant.usp_Attachment); } catch (Exception) { } return(PartialView("_AttachmentList", lst)); }
public ActionResult AttachmentDelete(string id, string did) { long attachid = default(long); long docid = default(long); int delresult = default(int); try { long.TryParse(Encryption64.DecryptQueryString(id), out attachid); long.TryParse(Encryption64.DecryptQueryString(did), out docid); var obj = DBOperations <AttachmentFile> .GetSpecific(new AttachmentFile() { AttachmentID = attachid, Opmode = 1 }, Constant.usp_Attachment); if (System.IO.File.Exists(string.Format(@"{0}\{1}\{2}{3}", ConfigurationManager.AppSettings["DocumentDomainRootDirectory"], docid, obj.FileName, obj.FileExtenssion))) { System.IO.File.Delete(string.Format(@"{0}\{1}\{2}{3}", ConfigurationManager.AppSettings["DocumentDomainRootDirectory"], docid, obj.FileName, obj.FileExtenssion)); } delresult = DBOperations <AttachmentFile> .DMLOperation(new AttachmentFile() { DocID = docid, AttachmentID = attachid, Opmode = 5 }, Constant.usp_Attachment, DMLOperationFlag.Delete); if (delresult > default(int)) { return(Json(new { Success = 1, Message = string.Format("Attachement file ({0}{1}) has been deleted successfully", obj.FileName, obj.FileExtenssion) }, JsonRequestBehavior.AllowGet)); } else { throw new Exception(string.Format("Unable to delete file ({0}{1})", obj.FileName, obj.FileExtenssion)); } } catch (Exception ex) { Utility.Logger(ex); return(Json(new { Success = default(int), Message = ex.Message }, JsonRequestBehavior.AllowGet)); } }
public ActionResult New(string id = "") { long docid = default(long); Document obj = new Document(); var lstDepartments = new List <SelectLists>(); try { IEnumerable <long> deptLst = GlobalSettings.oUserPermission.Select(d => d.DeptID); if (!string.IsNullOrEmpty(id)) { long.TryParse(Encryption64.DecryptQueryString(id), out docid); } if (docid > default(long)) { obj = DBOperations <Document> .GetSpecific(new Document() { DocID = docid, Opmode = 1 }, Constant.usp_DocumentManager); } //ViewBag.Projects = new DropdownClient().Getdropdown(Dropdown.Project); //ViewBag.Departments = new DropdownClient().Getdropdown(Dropdown.Department); //ViewBag.SubTypes = new DropdownClient().Getdropdown(Dropdown.SubType); //ViewBag.FinYears = new DropdownClient().Getdropdown(Dropdown.FinYear); //lstDepartments.Add(new SelectLists() { Value = 0, Text = "Select Department" }); lstDepartments.AddRange(new DropdownClient().Getdropdown(Dropdown.Department)); ViewBag.Departments = (GlobalSettings.oUserData.RoleID != (long)Role.BuiltinAdmin ? lstDepartments.Where(w => deptLst.Contains(w.Value) || w.Value == 0).ToList() : lstDepartments); ViewBag.FinYears = new DropdownClient().Getdropdown(Dropdown.FinYear); } catch (Exception) { } return(View("New", obj)); }
public FileResult DowloadUnsupportedFile(string id) { long attachid = default(long); var obj = new AttachmentFile(); try { long.TryParse(Encryption64.DecryptQueryString(id), out attachid); obj = DBOperations <AttachmentFile> .GetSpecific(new AttachmentFile() { AttachmentID = attachid, Opmode = 1 }, Constant.usp_Attachment); //var stream = new FileStream(Server.MapPath(obj.FilePath), FileMode.Open); var stream = new FileStream(obj.FilePath, FileMode.Open); //Utility.Logger(attachid.ToString()); return(File(stream, MediaTypeNames.Application.Octet, string.Format("{0}{1}", obj.FileName, obj.FileExtenssion))); } catch (Exception ex) { Utility.Logger(ex); return(null); } }
public ActionResult AttachmentPreview(string id, string iseditargument) { long attachid = default(long); int iseditrequest = default(int); AttachmentFile obj = new AttachmentFile(); try { long.TryParse(Encryption64.DecryptQueryString(id), out attachid); obj = DBOperations <AttachmentFile> .GetSpecific(new AttachmentFile() { AttachmentID = attachid, Opmode = 1 }, Constant.usp_Attachment); int.TryParse(Encryption64.DecryptQueryString(iseditargument), out iseditrequest); Tuple <AttachmentFile, int> tpl = new Tuple <AttachmentFile, int>(obj, iseditrequest); return(View("AttachmentViewer", tpl)); } catch (Exception ex) { Utility.Logger(ex); return(null); } }
public JsonResult SaveData(UserPermissionMaster postData) { long accessid = default(long); try { if (postData == null) { throw new Exception("No data found for insert"); } long.TryParse(Encryption64.DecryptQueryString(postData.EncryptedAccessID), out accessid); postData.AccessID = accessid; postData.Opmode = accessid > default(int) ? 5 : 0; UserPermissionMaster obj = new UserPermissionMaster(); obj.UserID = postData.UserID; obj.OrgID = postData.OrgID; obj.LocationID = postData.LocationID; obj.SublocationID = postData.SublocationID; obj.DeptID = postData.DeptID; obj.ProjectID = postData.ProjectID; obj.SubTypeID = postData.SubTypeID; obj.AccessID = accessid; if (postData.Opmode == 0) //add { obj.Opmode = 1; } else { obj.Opmode = 6; // edit } // var countid = default(long); if (postData.Opmode == 0) // add { var objcount = new UserPermissionMaster(); objcount = DBOperations <UserPermissionMaster> .GetSpecific(obj, Constant.usp_UserPermissionMaster); if (objcount.AccessID > default(long)) { throw new Exception("Permission already exist"); } else { var result = DBOperations <UserPermissionMaster> .DMLOperation(postData, Constant.usp_UserPermissionMaster); if (result > default(int)) { return(Json(new { Success = 1, Message = string.Format("Data have been {0} successfully", accessid > default(long) ? "updated" : "saved") }, JsonRequestBehavior.AllowGet)); } else { throw new Exception("Operation has been failed to execute"); } } } else // edit { var objcount = new UserPermissionMaster(); objcount = DBOperations <UserPermissionMaster> .GetSpecific(obj, Constant.usp_UserPermissionMaster); if (objcount.AccessID > default(long)) { throw new Exception("Permission already exist"); } else { var result = DBOperations <UserPermissionMaster> .DMLOperation(postData, Constant.usp_UserPermissionMaster); if (result > default(int)) { return(Json(new { Success = 1, Message = string.Format("Data have been {0} successfully", accessid > default(long) ? "updated" : "saved") }, JsonRequestBehavior.AllowGet)); } else { throw new Exception("Operation has been failed to execute"); } } } } catch (Exception ex) { return(Json(new { Success = default(int), Message = ex.Message }, JsonRequestBehavior.AllowGet)); } }
public ActionResult SaveUploadedFile(long deptid, long prjid, long subtype, long finyr, string docno, string id) { long docIdentity = default(long); DateTime dt = DateTime.Now; var doc = new Document(); string[] viewerSupportedFiles = ConfigurationManager.AppSettings["ViewerJSSupportedExtenssions"].Split(','); try { if (GlobalSettings.oUserData != null && GlobalSettings.oUserData.ID > default(long)) { long.TryParse(Encryption64.DecryptQueryString(id), out docIdentity); if (docIdentity <= default(long)) { doc.DeptID = deptid; doc.ProjectID = prjid; doc.SubTypeID = subtype; doc.FinYearID = finyr; doc.DocNumber = !string.IsNullOrWhiteSpace(docno.Trim()) ? docno.Trim().ToUpper() : "DOC-" + dt.ToString("yyyyMMdd") + "_" + dt.ToString("hhmmss"); doc.CreatedBy = GlobalSettings.oUserData.ID; doc.TaggingType = (int)TaggingType.ScanOnly; doc.DocDate = dt; doc.Opmode = 2; var docidstr = DBOperations <Document> .InsertWithOutputVariable(doc, Constant.usp_DocumentManager); long.TryParse(docidstr, out docIdentity); } foreach (string fileName in Request.Files) { try { HttpPostedFileBase file = Request.Files[fileName]; var contentLength = file.ContentLength; if (file != null && contentLength > 0) { byte[] imgAsBytes = new byte[contentLength]; using (BinaryReader theReader = new BinaryReader(file.InputStream)) { imgAsBytes = theReader.ReadBytes(contentLength); } //if (!Directory.Exists(Server.MapPath(string.Format("~/Uploads/{0}/", docIdentity)))) //{ // Directory.CreateDirectory(Server.MapPath(string.Format("~/Uploads/{0}/", docIdentity))); //} //if (System.IO.File.Exists(Server.MapPath(string.Format("~/Uploads/{0}/{1}", docIdentity, file.FileName)))) //{ // System.IO.File.Delete(Server.MapPath(string.Format("~/Uploads/{0}/{1}", docIdentity, file.FileName))); //} //System.IO.File.WriteAllBytes(Server.MapPath(string.Format("~/Uploads/{0}/{1}", docIdentity, file.FileName)), imgAsBytes); if (!Directory.Exists(string.Format(@"{0}\{1}\", ConfigurationManager.AppSettings["DocumentDomainRootDirectory"], docIdentity))) { Directory.CreateDirectory(string.Format(@"{0}\{1}\", ConfigurationManager.AppSettings["DocumentDomainRootDirectory"], docIdentity)); } if (System.IO.File.Exists(string.Format(@"{0}\{1}\{2}", ConfigurationManager.AppSettings["DocumentDomainRootDirectory"], docIdentity, file.FileName))) { System.IO.File.Delete(string.Format(@"{0}\{1}\{2}", ConfigurationManager.AppSettings["DocumentDomainRootDirectory"], docIdentity, file.FileName)); } System.IO.File.WriteAllBytes(string.Format(@"{0}\{1}\{2}", ConfigurationManager.AppSettings["DocumentDomainRootDirectory"], docIdentity, file.FileName), imgAsBytes); AttachmentFile a = new AttachmentFile(); a.DocID = docIdentity; a.FileSizeBytes = contentLength.ToString(); a.FileName = System.IO.Path.GetFileNameWithoutExtension(file.FileName); a.FileExtenssion = System.IO.Path.GetExtension(file.FileName); //a.FilePath = string.Format("~/Uploads/{0}/{1}", docIdentity, file.FileName); // Set Virtual Path in DB a.FilePath = string.Format(@"{0}\{1}\{2}", ConfigurationManager.AppSettings["DocumentDomainRootDirectory"], docIdentity, file.FileName); // Set Virtual Path in DB a.IsViewerSupported = viewerSupportedFiles.Contains(System.IO.Path.GetExtension(file.FileName)) ? 1 : default(int); a.CreatedOn = dt; a.CreatedBy = GlobalSettings.oUserData.ID; a.Opmode = 2; var result = DBOperations <AttachmentFile> .DMLOperation(a, Constant.usp_Attachment); } } catch (Exception ex) { //continue; throw ex; } } return(Json(new { success = true, docid = Encryption64.EncryptQueryString(docIdentity.ToString()) })); } else { throw new Exception("Session timed-out. Unable to upload. Please login again"); } } catch (Exception) { return(Json(new { success = false, docid = Encryption64.EncryptQueryString(default(long).ToString()) })); } }
public ActionResult DocumentDelete(string did) { long docid = default(long); int docdelresult = default(int); int delresult = default(int); List <AttachmentFile> lst = new List <AttachmentFile>(); StringBuilder sb = new StringBuilder(); try { long.TryParse(Encryption64.DecryptQueryString(did), out docid); lst = DBOperations <AttachmentFile> .GetAllOrByRange(new AttachmentFile() { DocID = docid, Opmode = default(int) }, Constant.usp_Attachment); if (lst != null && lst.Count() > default(int)) { foreach (var attachmentobj in lst) { try { if (System.IO.File.Exists(string.Format(@"{0}\{1}\{2}{3}", ConfigurationManager.AppSettings["DocumentDomainRootDirectory"], docid, attachmentobj.FileName, attachmentobj.FileExtenssion))) { System.IO.File.Delete(string.Format(@"{0}\{1}\{2}{3}", ConfigurationManager.AppSettings["DocumentDomainRootDirectory"], docid, attachmentobj.FileName, attachmentobj.FileExtenssion)); delresult = DBOperations <AttachmentFile> .DMLOperation(new AttachmentFile() { DocID = docid, AttachmentID = attachmentobj.AttachmentID, Opmode = 5 }, Constant.usp_Attachment, DMLOperationFlag.Delete); } } catch (Exception ex) { Utility.Logger(ex); sb.AppendLine(ex.Message); continue; } } } if (string.IsNullOrWhiteSpace(sb.ToString())) { docdelresult = DBOperations <Document> .DMLOperation(new Document() { DocID = docid, Opmode = 5 }, Constant.usp_DocumentManager, DMLOperationFlag.Delete); if (docdelresult > default(int)) { return(Json(new { Success = 1, Message = "Document has been deleted successfully" }, JsonRequestBehavior.AllowGet)); } else { throw new Exception("Unable to delete document right now. Please try again after some time"); } } else { throw new Exception(sb.ToString()); } } catch (Exception ex) { Utility.Logger(ex); return(Json(new { Success = default(int), Message = ex.Message }, JsonRequestBehavior.AllowGet)); } }