/// <summary>
/// Populate FileAssociation given a filePath to an actual File
/// </summary>
/// <param name="filePath"></param>
/// <param name="associationType"></param>
/// <param name="isFileEncrypted"></param>
public void Populate(string filePath, eFileAssociationType associationType, bool isFileEncrypted)
{
mstrPath = filePath;
mstrDescription = filePath.Substring(filePath.LastIndexOf(@"\") + 1);
mobjAssociationType = associationType;
using (FileStream inStream = new FileStream(mstrPath, FileMode.Open, FileAccess.Read, FileShare.Read))
{
mintSizeInBytes = (int)inStream.Length;
}
mstrHash = CalculateFileHash(mstrPath);
mblnIsEncrypted = isFileEncrypted;
}
public bool Save(string wmSourceID, eWMSourceSystem sourceSystem, eFileAssociationType fileAssociationType)
{
DataAccess objADO = new DataAccess();
ArrayList colParameters = new ArrayList();
string strStoredProcedure = "updJobFileAssociation";
if (fileAssociationType == eFileAssociationType.UserRelated)
{
strStoredProcedure = "updUserFileAssociation";
}
int intReturn = 0;
foreach (FileAssociation fileMetadata in this)
{
if (fileAssociationType != eFileAssociationType.UserRelated)
{
colParameters.Add(new SqlParameter("@WMSourceID", wmSourceID));
colParameters.Add(new SqlParameter("@WMSourceSystem", sourceSystem.ToString()));
}
else
{
colParameters.Add(new SqlParameter("@UserID", wmSourceID));
}
colParameters.Add(new SqlParameter("@RawFileName", fileMetadata.Path.Substring(fileMetadata.Path.LastIndexOf(@"\") + 1)));
colParameters.Add(new SqlParameter("@FilePath", fileMetadata.Path));
colParameters.Add(new SqlParameter("@FileDesc", fileMetadata.Description));
colParameters.Add(new SqlParameter("@AssociationType", fileMetadata.AssociationType.ToString()));
colParameters.Add(new SqlParameter("@SizeInBytes", fileMetadata.SizeInBytes));
colParameters.Add(new SqlParameter("@FileHash", fileMetadata.Hash));
colParameters.Add(new SqlParameter("@IsEncrypted", fileMetadata.IsEncrypted));
intReturn += objADO.ExecuteSQL(strStoredProcedure, (SqlParameter[])colParameters.ToArray(typeof(SqlParameter)));
colParameters.Clear();
}
objADO = null;
return (intReturn > 0);
}
