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