private Task SaveFile(FormatFile ff, string outDir)
{
string toSave = ff.Content;
string fName = ff.Name + "Tests";
int i = 0;
string savePath = null;
DirectoryWorkMutex.WaitOne();
savePath = outDir + "\\" + fName + ".cs";
if (System.IO.File.Exists(savePath))
{
do
{
savePath = outDir + "\\" + fName + i++ + ".cs";
} while (System.IO.File.Exists(savePath));
}
Task saveToFileTask = Task.Run(() =>
{
using (var saveFileStream = new System.IO.StreamWriter(savePath))
{
saveFileStream.Write(toSave.ToCharArray(), 0, toSave.Length);
}
});
DirectoryWorkMutex.ReleaseMutex();
return(saveToFileTask);
}
private static Task SaveFile(FormatFile ff, string outDir)
{
string toSave = ff.Content;
string fName = ff.Name + "Tests";
int i = 0;
string savePath = null;
DirectoryWorkMutex.WaitOne();//QUESTION: why lock was not working but mutex works?
savePath = outDir + "\\" + fName + ".cs";
if (System.IO.File.Exists(savePath))
{
do
{
savePath = outDir + "\\" + fName + i++ + ".cs";
} while (System.IO.File.Exists(savePath));
}
SavedPathes.Add(savePath);
Task saveToFileTask = Task.Run(() =>
{
using (var saveFileStream = new System.IO.StreamWriter(savePath))
{
saveFileStream.Write(toSave.ToCharArray(), 0, toSave.Length);
}
});
DirectoryWorkMutex.ReleaseMutex();//QUESTION: am i right that mutex wont be blocked until awaitable task done (if there is any inside critical code)
return(saveToFileTask);
}
private FileResult SendFile(string filePathName, FormatFile formatFile)
{
var fs = new FileStream(filePathName, FileMode.Open);
var file_type = "application/" + formatFile.ToString();
var file_name = "YouFile." + formatFile.ToString();
var xz = File(fs, file_type, file_name);
return(xz);
}
/// <summary>
/// Returns a <see cref="System.String"/> that represents this instance.
/// </summary>
/// <returns>
/// A <see cref="System.String"/> that represents this instance.
/// </returns>
public new string ToString()
{
_stringBuilder.Append(activateCmdShell);
_stringBuilder.Append("'bcp ");
switch (DataSource)
{
case Keys.TAB_SQL:
_stringBuilder.Append(string.Format(@" ""{0}"" queryout ", Regex.Replace(SQLStatment, "(\n|\r)+", string.Empty)));
break;
case Keys.TAB_SP:
StringBuilder storedProcParams = new StringBuilder();
int index = 0;
foreach (var param in (MappingParams)StoredProcedureParameters)
{
storedProcParams.Append(string.Format("{0} {1}",
(index > 0)
? ","
: string.Empty,
(param.Type.ToLower().Contains("char") ||
param.Type.ToLower().Contains("date") ||
param.Type.ToLower().Contains("text"))
? string.Format("'{0}'", EvaluateExpression(param.Value, _variableDispenser))
: EvaluateExpression(param.Value, _variableDispenser)));
index++;
}
_stringBuilder.Append(string.Format(@" ""exec {0}.{1} {2}"" queryout ", Database.Trim(), StoredProcedure.Trim(), storedProcParams));
break;
case Keys.TAB_VIEW:
_stringBuilder.Append(string.Format(@" ""{0}.{1}"" out ", Database.Trim(), View.Trim()));
break;
case Keys.TAB_TABLES:
_stringBuilder.Append(string.Format(@" ""{0}.{1}"" out ", Database.Trim(), Tables.Trim()));
break;
}
_stringBuilder.Append(DestinationByFileConnection.Trim() == Keys.TRUE
? string.Format(@" ""{0}"" ", _connection[DestinationPath].ConnectionString)
: string.Format(@" ""{0}"" ", EvaluateExpression(DestinationPath, _variableDispenser)));
string srvVal = (from srv in _connection[SQLServerInstance].ConnectionString.Split(';')
where srv.Contains("Data Source")
select srv).FirstOrDefault();
if (srvVal != null)
{
_stringBuilder.Append(string.Format(@" -S""{0}""", srvVal.Split('=')[1]));
}
_stringBuilder.Append(TrustedConnection.Trim() == Keys.TRUE
? " -T "
: string.Format(@" -U""{0}"" -P""{1}"" ",
EvaluateExpression(Login, _variableDispenser),
EvaluateExpression(Password, _variableDispenser)));
//if (!string.IsNullOrEmpty(Database))
//{
// _stringBuilder.Append(string.Format(" -d [{0}]", Database));
//}
if (!string.IsNullOrEmpty(FirstRow.Trim()))
{
_stringBuilder.Append(string.Format(" -F{0}", FirstRow));
}
if (!string.IsNullOrEmpty(LastRow.Trim()))
{
_stringBuilder.Append(string.Format(" -L{0}", LastRow));
}
if (!string.IsNullOrEmpty(MaxErrors.Trim()))
{
_stringBuilder.Append(string.Format(" -m{0}", MaxErrors));
}
if (NativeDatabaseDataType == Keys.TRUE)
{
_stringBuilder.Append(" -N ");
}
if (!string.IsNullOrEmpty(FormatFile.Trim()))
{
_stringBuilder.Append(FormatFileByFileConnection == Keys.TRUE
? string.Format(@" -f""{0}"" ", _connection[FormatFile].ConnectionString)
: string.Format(@" -f""{0}"" ", EvaluateExpression(FormatFile, _variableDispenser)));
}
//else
//{
// _stringBuilder.Append(" -c ");
//}
if (!string.IsNullOrEmpty(FieldTermiantor.Trim()))
{
_stringBuilder.Append(string.Format(" -t{0} ", FieldTermiantor));
}
if (!string.IsNullOrEmpty(RowTermiantor.Trim()))
{
_stringBuilder.Append(string.Format(" -r{0} ", RowTermiantor));
}
if (!string.IsNullOrEmpty(CodePage.Trim()))
{
_stringBuilder.Append(string.Format(" -C{0} ", CodePage));
}
if (!string.IsNullOrEmpty(NetworkPacketSize.Trim()))
{
_stringBuilder.Append(string.Format(" -a{0} ", NetworkPacketSize));
}
if (UseRegionalSettings == Keys.TRUE)
{
_stringBuilder.Append(" -R ");
}
if (SET_QUOTED_IDENTIFIERS_ON == Keys.TRUE)
{
_stringBuilder.Append(" -q ");
}
if (UseCharacterDataType == Keys.TRUE)
{
_stringBuilder.Append(" -c ");
}
if (UseUnicodeCharacters == Keys.TRUE)
{
_stringBuilder.Append(" -w ");
}
_stringBuilder.Append("'");
return(_stringBuilder.ToString());
}
