public bool FileUploadToDatabase(CapexFileUploadDetails capexFile) { bool result = true; try { accessManager.SqlConnectionOpen(DataBase.SQQeye); List <SqlParameter> aParameters = new List <SqlParameter>(); List <SqlParameter> aList = new List <SqlParameter>(); aList.Add(new SqlParameter("@CapexFileName", capexFile.CapexFileName)); aList.Add(new SqlParameter("@CapexFilePath", capexFile.CapexFilePath)); aList.Add(new SqlParameter("@CapexInfoId", capexFile.CapexInfoId)); aList.Add(new SqlParameter("@UserId", capexFile.userId)); result = accessManager.SaveData("sp_SaveUploadedFiles", aList); return(result); } catch (Exception e) { accessManager.SqlConnectionClose(true); throw; } finally { accessManager.SqlConnectionClose(); } }
//get files public List <CapexFileUploadDetails> GetUploadedFilesByID(int pmkey, int userid) { List <CapexFileUploadDetails> filedetails = new List <CapexFileUploadDetails>(); try { accessManager.SqlConnectionOpen(DataBase.SQQeye); List <SqlParameter> aParameters = new List <SqlParameter>(); List <SqlParameter> aList = new List <SqlParameter>(); aList.Add(new SqlParameter("@capexId", pmkey)); aList.Add(new SqlParameter("@userId", userid)); SqlDataReader dr = accessManager.GetSqlDataReader("sp_GetFileDetails", aList); while (dr.Read()) { CapexFileUploadDetails cpfileup = new CapexFileUploadDetails(); cpfileup.CapexFileUploadId = (int)dr["CapexInfoId"]; cpfileup.CapexFileName = dr["CapexFileName"].ToString(); cpfileup.CapexFilePath = dr["CapexFilePath"].ToString(); filedetails.Add(cpfileup); } return(filedetails); } catch (Exception e) { accessManager.SqlConnectionClose(true); throw; } finally { accessManager.SqlConnectionClose(); } }
[HttpPost] //Now we are getting array of files check sign [] public ActionResult UploadFiles() { int userID = Convert.ToInt32(Session["SQuserId"].ToString()); if (Request.Files.Count > 0) { var files = Request.Files; //iterating through multiple file collection foreach (string str in files) { CapexFileUploadDetails capexFileUploadDetails = new CapexFileUploadDetails(); HttpPostedFileBase file = Request.Files[str] as HttpPostedFileBase; //Checking file is available to save. if (file != null) { var currentmilse = DateTime.Now.Ticks; var InputFileName = Path.GetFileNameWithoutExtension(file.FileName); var InputFileExtention = Path.GetExtension(file.FileName); var FullFileWithext = InputFileName + currentmilse + InputFileExtention; var ServerSavePath = Path.Combine(Server.MapPath("~/Uploads/") + FullFileWithext); //Save file to server folder file.SaveAs(ServerSavePath); capexFileUploadDetails.CapexFileName = file.FileName.ToString(); capexFileUploadDetails.CapexFilePath = ServerSavePath; capexFileUploadDetails.CapexInfoId = 0; capexFileUploadDetails.userId = userID; bool res = capexApproval.FileUploadToDatabase(capexFileUploadDetails); } } return(Json("File Uploaded Successfully!")); } else { return(Json("No files to upload")); } }