public int SaveAllFiles(EmployeeFilesModel model1) { var resultVal = imgrepository.AddFiles(model1); return(0); }
public ActionResult Upload(IEnumerable <HttpPostedFileBase> files, List <String> FileDescription) { String Message = null; EmployeeFilesModel model1 = new EmployeeFilesModel(); try { var i = 0; foreach (var file in files) { //string path = AppDomain.CurrentDomain.BaseDirectory + "Uploads/"; //string filename = Path.GetFileName(Request.Files[i].FileName); String FileExt = Path.GetExtension(file.FileName).ToUpper(); AddFilesService service = new AddFilesService(); if (FileExt == ".PDF") { Stream str = file.InputStream; BinaryReader Br = new BinaryReader(str); Byte[] FileDet = Br.ReadBytes((Int32)str.Length); model1.EmployeeNumber = (Int64)Session["empId"]; model1.FileDescription = FileDescription[i]; model1.FileName = file.FileName; model1.FileContent = FileDet; service.SaveAllFiles(model1); i++; Message = "Record Inserted Successfully!"; } else { Message = "Invalid file format."; } } } catch (Exception ex) { Message = "Upload failed"; } return(RedirectToAction("Success")); }
public int AddFiles(EmployeeFilesModel model1) { try { string query = string.Empty; using (IDbConnection connection = OpenConnection()) { var param = new DynamicParameters(); if (model1 != null) { query = StoredProcedure.UploadFiles; } return(connection.Execute(query, model1, commandType: CommandType.StoredProcedure)); } } catch (Exception ex) { return(0); } }