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);
}
}
