protected void UpdateImportStatus(string Table, string AssetOID, ImportStatuses ImportStatus, string ImportDetail)
{
//_logger.Info("Status: {0} Message is {1}", AssetOID, ImportDetail);
StringBuilder sb = new StringBuilder();
sb.Append("UPDATE " + Table + " ");
sb.Append("SET ImportStatus = '" + ImportStatus.ToString() + "', ");
sb.Append("ImportDetails = '" + ImportDetail + "' ");
sb.Append("WHERE AssetOID = '" + AssetOID + "';");
using (SqlCommand cmd = new SqlCommand(sb.ToString(), _sqlConn))
{
cmd.ExecuteNonQuery();
}
}
protected void UpdateNewAssetOIDAndStatus(string Table, string OldAssetOID, string NewAssetOID, ImportStatuses ImportStatus, string ImportDetail)
{
StringBuilder sb = new StringBuilder();
sb.Append("UPDATE " + Table + " ");
sb.Append("SET NewAssetOID = '" + NewAssetOID + "', ");
sb.Append("ImportStatus = '" + ImportStatus.ToString() + "', ");
sb.Append("ImportDetails = '" + ImportDetail + "' ");
sb.Append("WHERE AssetOID = '" + OldAssetOID + "';");
using (SqlCommand cmd = new SqlCommand(sb.ToString(), _sqlConn))
{
cmd.ExecuteNonQuery();
}
}
protected void UpdateImportStatus(string Table, string AssetOID, ImportStatuses ImportStatus, string ImportDetail)
{
//_logger.Info("Status: {0} Message is {1}", AssetOID, ImportDetail);
StringBuilder sb = new StringBuilder();
sb.Append("UPDATE " + Table + " ");
sb.Append("SET ImportStatus = '" + ImportStatus.ToString() + "', ");
sb.Append("ImportDetails = '" + ImportDetail + "' ");
sb.Append("WHERE AssetOID = '" + AssetOID + "';");
using (SqlCommand cmd = new SqlCommand(sb.ToString(), _sqlConn))
{
cmd.ExecuteNonQuery();
}
}
protected void UpdateAssetRecordWithNumber(string Table, string OldAssetOID, string NewAssetOID, string NewAssetNumber, ImportStatuses ImportStatus, string ImportDetail)
{
StringBuilder sb = new StringBuilder();
sb.Append("UPDATE " + Table + " ");
sb.Append("SET NewAssetOID = '" + NewAssetOID + "', ");
sb.Append("NewAssetNumber = '" + NewAssetNumber + "', ");
sb.Append("ImportStatus = '" + ImportStatus.ToString() + "', ");
sb.Append("ImportDetails = '" + ImportDetail + "' ");
sb.Append("WHERE AssetOID = '" + OldAssetOID + "';");
using (SqlCommand cmd = new SqlCommand(sb.ToString(), _sqlConn))
{
cmd.ExecuteNonQuery();
}
}
