/// <summary>
/// Save information about files rejected by the Middleware app.
/// information include the Json frame sent to MW.
/// </summary>
/// <param name="prob"></param>
/// <returns></returns>
public int writeProblemFile(ProblemFiles prob)
{
int resp = 0;
try
{
System.Collections.Specialized.NameValueCollection args = new NameValueCollection();
args.Add("@fileType", prob.FileType.ToString());
args.Add("@fileName", prob.FileName.ToString());
args.Add("@fileNumber", prob.FileNumber.ToString());
args.Add("@jsonData", prob.JsonData.ToString());
DBContext.DBAccess access = new DBContext.DBAccess();
// ===== >
resp = access.ExecuteNonQuery("[MW_NavImportProblemsInsert]", DBContext.DBAccess.DBConnection.SqlMainNew, args);
// < =====
}
catch
{
writeSyncLog(1, Convert.ToInt16(ConfigurationManager.AppSettings["ServiceID"]), 1,
ConfigurationManager.AppSettings["TableName"], "Service for " + ConfigurationManager.AppSettings["TableName"] + " MW_NavImportProblems access error ");
}
finally
{ }
return(resp);
}
public int updImportControl(int type, int status)
{
int resp = 0;
try
{
System.Collections.Specialized.NameValueCollection args = new NameValueCollection();
args.Add("@etlTaskId", type.ToString());
args.Add("@status", status.ToString());
DBContext.DBAccess access = new DBContext.DBAccess();
// ===== >
resp = access.ExecuteNonQuery("[MW_UpdETLTaskTimer]", DBContext.DBAccess.DBConnection.SqlMainNew, args);
// < =====
}
catch
{
//writeSyncLog(1, Convert.ToInt16(ConfigurationManager.AppSettings["ServiceID"]), 1,
//ConfigurationManager.AppSettings["TableName"], "Service for " + ConfigurationManager.AppSettings["TableName"] + " EtlTimer access error ");
}
finally
{ }
return(resp);
}
