void IPlugIn.PreProcessArguments(ActionArgs args, ActionResult result, ViewPage page)
{
_annotations = new List <FieldValue>();
if (args.Values != null)
{
foreach (FieldValue v in args.Values)
{
if (v.Name.StartsWith("_Annotation_") && v.Modified)
{
_annotations.Add(v);
v.Modified = false;
}
}
}
}
protected virtual void ExecuteMethod(ActionArgs args, ActionResult result, ActionPhase phase)
{
bool match = InternalExecuteMethod(args, result, phase, true, true);
if (!(match))
{
match = InternalExecuteMethod(args, result, phase, true, false);
}
if (!(match))
{
match = InternalExecuteMethod(args, result, phase, false, true);
}
if (!(match))
{
InternalExecuteMethod(args, result, phase, false, false);
}
}
public static int ExecuteNonQuery(ActionArgs args, ActionResult result, ViewPage page, DbCommand command)
{
TransactionManager tm = Create(args.Transaction);
if (tm == null)
{
return(command.ExecuteNonQuery());
}
else
if (tm.Status == "complete")
{
return(command.ExecuteNonQuery());
}
int rowsAffected = tm.ExecuteAction(args, result, page);
tm.Arguments.Add(args);
return(rowsAffected);
}
public int ExecuteAction(ActionArgs args, ActionResult result, ViewPage page)
{
DataTable t = GetTable(args.Controller, null);
if (args.CommandName == "Insert")
{
DataRow r = t.NewRow();
foreach (FieldValue v in args.Values)
{
DataField f = page.FindField(v.Name);
if (f.IsPrimaryKey && f.ReadOnly)
{
object key = null;
if (f.Type == "Guid")
{
key = Guid.NewGuid();
}
else
if (!(PrimaryKeys.TryGetValue(args.Controller, out key)))
{
key = -1;
PrimaryKeys.Add(args.Controller, key);
}
else
{
key = (Convert.ToInt32(key) - 1);
PrimaryKeys[args.Controller] = key;
}
r[v.Name] = key;
result.Values.Add(new FieldValue(v.Name, key));
FieldValue fv = args.SelectFieldValueObject(v.Name);
fv.NewValue = key;
fv.Modified = true;
}
else
if (v.Modified)
{
if (v.NewValue == null)
{
r[v.Name] = DBNull.Value;
}
else
{
r[v.Name] = v.NewValue;
}
}
}
t.Rows.Add(r);
return(1);
}
else
{
DataRow targetRow = null;
foreach (DataRow r in t.Rows)
{
bool matched = true;
foreach (DataField f in page.Fields)
{
if (f.IsPrimaryKey)
{
object kv = r[f.Name];
object kv2 = args.SelectFieldValueObject(f.Name).OldValue;
if (((kv == null) || (kv2 == null)) || !((kv.ToString() == kv2.ToString())))
{
matched = false;
break;
}
}
}
if (matched)
{
targetRow = r;
break;
}
}
if (targetRow == null)
{
return(0);
}
if (args.CommandName == "Delete")
{
t.Rows.Remove(targetRow);
}
else
{
foreach (FieldValue v in args.Values)
{
if (v.Modified)
{
if (v.NewValue == null)
{
targetRow[v.Name] = DBNull.Value;
}
else
{
targetRow[v.Name] = v.NewValue;
}
}
}
}
return(1);
}
}
public static bool InTransaction(ActionArgs args)
{
return(!(String.IsNullOrEmpty(args.Transaction)) && !(args.Transaction.EndsWith(":complete")));
}
public static void Execute(ActionArgs args)
{
Process(args);
}
public virtual void Process(string fileName, string controller, string view, string notify, List <string> userMapping)
{
BeforeProcess(fileName, controller, view, notify, userMapping);
string logFileName = Path.GetTempFileName();
StreamWriter log = File.CreateText(logFileName);
log.WriteLine("{0:s} Import process started.", DateTime.Now);
// retrieve metadata
PageRequest request = new PageRequest();
request.Controller = controller;
request.View = view;
request.RequiresMetaData = true;
ViewPage page = ControllerFactory.CreateDataController().GetPage(controller, view, request);
// open data reader and enumerate fields
OleDbDataReader reader = OpenRead(fileName, "*");
ImportMapDictionary map = new ImportMapDictionary();
ImportLookupDictionary lookups = new ImportLookupDictionary();
EnumerateFields(reader, page, map, lookups, userMapping);
// resolve lookup data value field and data text fields
ResolveLookups(lookups);
// insert records from the file
int recordCount = 0;
int errorCount = 0;
NumberFormatInfo nfi = CultureInfo.CurrentCulture.NumberFormat;
Regex numberCleanupRegex = new Regex(String.Format("[^\\d\\{0}\\{1}\\{2}]", nfi.CurrencyDecimalSeparator, nfi.NegativeSign, nfi.NumberDecimalSeparator));
while (reader.Read())
{
ActionArgs args = new ActionArgs();
args.Controller = controller;
args.View = view;
args.LastCommandName = "New";
args.CommandName = "Insert";
List <FieldValue> values = new List <FieldValue>();
foreach (int index in map.Keys)
{
DataField field = map[index];
object v = reader[index];
if (DBNull.Value.Equals(v))
{
v = null;
}
else
if (field.Type != "String" && (v is string))
{
string s = ((string)(v));
if (field.Type == "Boolean")
{
v = s.ToLower();
}
else
if (!(field.Type.StartsWith("Date")) && field.Type != "Time")
{
v = numberCleanupRegex.Replace(s, String.Empty);
}
}
if (v != null)
{
DataField lookupField = null;
if (lookups.TryGetValue(field.Name, out lookupField))
{
if (lookupField.Items.Count > 0)
{
// copy static values
foreach (object[] item in lookupField.Items)
{
if (Convert.ToString(item[1]).Equals(Convert.ToString(v), StringComparison.CurrentCultureIgnoreCase))
{
values.Add(new FieldValue(lookupField.Name, item[0]));
}
}
}
else
{
PageRequest lookupRequest = new PageRequest();
lookupRequest.Controller = lookupField.ItemsDataController;
lookupRequest.View = lookupField.ItemsDataView;
lookupRequest.RequiresMetaData = true;
lookupRequest.PageSize = 1;
lookupRequest.Filter = new string[] {
String.Format("{0}:={1}{2}", lookupField.ItemsDataTextField, v, Convert.ToChar(0))
};
ViewPage vp = ControllerFactory.CreateDataController().GetPage(lookupRequest.Controller, lookupRequest.View, lookupRequest);
if (vp.Rows.Count > 0)
{
values.Add(new FieldValue(lookupField.ItemsDataValueField, vp.Rows[0][vp.Fields.IndexOf(vp.FindField(lookupField.ItemsDataValueField))]));
}
}
}
else
{
values.Add(new FieldValue(field.Name, v));
}
}
}
recordCount++;
if (values.Count > 0)
{
args.Values = values.ToArray();
ActionResult r = ControllerFactory.CreateDataController().Execute(controller, view, args);
if (r.Errors.Count > 0)
{
log.WriteLine("{0:s} Error importing record #{1}.", DateTime.Now, recordCount);
log.WriteLine();
foreach (string s in r.Errors)
{
log.WriteLine(s);
}
foreach (FieldValue v in values)
{
if (v.Modified)
{
log.WriteLine("{0}={1};", v.Name, v.Value);
}
}
log.WriteLine();
errorCount++;
}
}
else
{
log.WriteLine("{0:s} Record #1 has been ignored.", DateTime.Now, recordCount);
errorCount++;
}
}
reader.Close();
log.WriteLine("{0:s} Processed {1} records. Detected {2} errors.", DateTime.Now, recordCount, errorCount);
log.Close();
if (!(String.IsNullOrEmpty(notify)))
{
string[] recipients = notify.Split(',');
SmtpClient client = new SmtpClient();
foreach (string s in recipients)
{
string address = s.Trim();
if (!(String.IsNullOrEmpty(address)))
{
MailMessage message = new MailMessage();
try
{
message.To.Add(new MailAddress(address));
message.Subject = String.Format("Import of {0} has been completed", controller);
message.Body = File.ReadAllText(logFileName);
client.Send(message);
}
catch (Exception)
{
}
}
}
}
File.Delete(logFileName);
AfterProcess(fileName, controller, view, notify, userMapping);
}
ActionResult IDataController.Execute(string controller, string view, ActionArgs args)
{
ActionResult result = new ActionResult();
SelectView(controller, view);
try
{
IActionHandler handler = _config.CreateActionHandler();
if (_config.PlugIn != null)
{
_config.PlugIn.PreProcessArguments(args, result, CreateViewPage());
}
if (args.SqlCommandType != CommandConfigurationType.None)
{
using (DbConnection connection = CreateConnection())
{
ExecutePreActionCommands(args, result, connection);
if (handler != null)
{
handler.BeforeSqlAction(args, result);
}
if ((result.Errors.Count == 0) && !(result.Canceled))
{
DbCommand command = CreateCommand(connection, args);
if ((args.SelectedValues != null) && (((args.LastCommandName == "BatchEdit") && (args.CommandName == "Update")) || ((args.CommandName == "Delete") && (args.SelectedValues.Length > 1))))
{
ViewPage page = CreateViewPage();
PopulatePageFields(page);
string originalCommandText = command.CommandText;
foreach (string sv in args.SelectedValues)
{
string[] key = sv.Split(',');
int keyIndex = 0;
foreach (FieldValue v in args.Values)
{
DataField field = page.FindField(v.Name);
if (field != null)
{
if (!(field.IsPrimaryKey))
{
v.Modified = true;
}
else
if (v.Name == field.Name)
{
v.OldValue = key[keyIndex];
v.Modified = false;
keyIndex++;
}
}
}
ConfigureCommand(command, null, args.SqlCommandType, args.Values);
result.RowsAffected = (result.RowsAffected + TransactionManager.ExecuteNonQuery(command));
if (handler != null)
{
handler.AfterSqlAction(args, result);
}
command.CommandText = originalCommandText;
command.Parameters.Clear();
if (_config.PlugIn != null)
{
_config.PlugIn.ProcessArguments(args, result, page);
}
}
}
else
{
if (ConfigureCommand(command, null, args.SqlCommandType, args.Values))
{
result.RowsAffected = TransactionManager.ExecuteNonQuery(args, result, CreateViewPage(), command);
if (result.RowsAffected == 0)
{
result.RowNotFound = true;
result.Errors.Add(Localizer.Replace("RecordChangedByAnotherUser", "The record has been changed by another user."));
}
else
{
ExecutePostActionCommands(args, result, connection);
}
}
if (handler != null)
{
handler.AfterSqlAction(args, result);
}
if (_config.PlugIn != null)
{
_config.PlugIn.ProcessArguments(args, result, CreateViewPage());
}
}
}
}
}
else
if (args.CommandName.StartsWith("Export"))
{
ExecuteDataExport(args, result);
}
else
if (args.CommandName.Equals("PopulateDynamicLookups"))
{
PopulateDynamicLookups(args, result);
}
else
if (args.CommandName.Equals("ProcessImportFile"))
{
ImportProcessor.Execute(args);
}
else
if (args.CommandName.Equals("Execute"))
{
using (DbConnection connection = CreateConnection())
{
DbCommand command = CreateCommand(connection, args);
TransactionManager.ExecuteNonQuery(command);
}
}
else
if (handler != null)
{
handler.ExecuteAction(args, result);
((BusinessRules)(handler)).ProcessSpecialActions(args, result);
}
else
{
CreateBusinessRules().ProcessSpecialActions(args, result);
}
}
catch (Exception ex)
{
if (ex.GetType() == typeof(System.Reflection.TargetInvocationException))
{
ex = ex.InnerException;
}
HandleException(ex, args, result);
}
return(result);
}
private bool InternalExecuteMethod(ActionArgs args, ActionResult result, ActionPhase phase, bool viewMatch, bool argumentMatch)
{
_arguments = args;
_result = result;
bool success = false;
MethodInfo[] methods = GetType().GetMethods((BindingFlags.Public | (BindingFlags.NonPublic | BindingFlags.Instance)));
foreach (MethodInfo method in methods)
{
object[] filters = method.GetCustomAttributes(typeof(ControllerActionAttribute), true);
foreach (ControllerActionAttribute action in filters)
{
if (((action.Controller == args.Controller) || Regex.IsMatch(args.Controller, action.Controller)) && ((!(viewMatch) && String.IsNullOrEmpty(action.View)) || (action.View == args.View)))
{
if ((action.CommandName == args.CommandName) && ((!(argumentMatch) && String.IsNullOrEmpty(action.CommandArgument)) || (action.CommandArgument == args.CommandArgument)))
{
if (action.Phase == phase)
{
ParameterInfo[] parameters = method.GetParameters();
if ((parameters.Length == 2) && ((parameters[0].ParameterType == typeof(ActionArgs)) && (parameters[1].ParameterType == typeof(ActionResult))))
{
method.Invoke(this, new object[] {
args,
result
});
}
else
{
object[] arguments = new object[parameters.Length];
for (int i = 0; (i < parameters.Length); i++)
{
ParameterInfo p = parameters[i];
FieldValue v = args[p.Name];
if (v != null)
{
if (p.ParameterType.Equals(typeof(FieldValue)))
{
arguments[i] = v;
}
else
{
try
{
arguments[i] = DataControllerBase.ConvertToType(p.ParameterType, v.Value);
}
catch (Exception)
{
}
}
}
}
method.Invoke(this, arguments);
success = true;
}
}
}
}
}
}
return(success);
}
void IActionHandler.AfterSqlAction(ActionArgs args, ActionResult result)
{
ExecuteMethod(args, result, ActionPhase.After);
AfterSqlAction(args, result);
}
void IActionHandler.ExecuteAction(ActionArgs args, ActionResult result)
{
ExecuteMethod(args, result, ActionPhase.Execute);
ExecuteAction(args, result);
}
void IActionHandler.BeforeSqlAction(ActionArgs args, ActionResult result)
{
ExecuteMethod(args, result, ActionPhase.Before);
BeforeSqlAction(args, result);
}
protected virtual void ExecuteAction(ActionArgs args, ActionResult result)
{
}
protected virtual void AfterSqlAction(ActionArgs args, ActionResult result)
{
}
protected virtual void BeforeSqlAction(ActionArgs args, ActionResult result)
{
}
private void ExecuteDataExport(ActionArgs args, ActionResult result)
{
if (!(String.IsNullOrEmpty(args.CommandArgument)))
{
string[] arguments = args.CommandArgument.Split(',');
if (arguments.Length > 0)
{
bool sameController = (args.Controller == arguments[0]);
args.Controller = arguments[0];
if (arguments.Length == 1)
{
args.View = "grid1";
}
else
{
args.View = arguments[1];
}
if (sameController)
{
args.SortExpression = null;
}
SelectView(args.Controller, args.View);
}
}
PageRequest request = new PageRequest(-1, -1, null, null);
request.SortExpression = args.SortExpression;
request.Filter = args.Filter;
request.ContextKey = null;
request.PageIndex = 0;
request.PageSize = Int32.MaxValue;
if (args.CommandName.EndsWith("Template"))
{
request.PageSize = 0;
args.CommandName = "ExportCsv";
}
// store export data to a temporary file
string fileName = Path.GetTempFileName();
StreamWriter writer = File.CreateText(fileName);
try
{
ViewPage page = new ViewPage(request);
page.ApplyDataFilter(_config.CreateDataFilter(), args.Controller, args.View, null, null, null);
using (DbConnection connection = CreateConnection())
{
DbCommand selectCommand = CreateCommand(connection);
ConfigureCommand(selectCommand, page, CommandConfigurationType.Select, null);
DbDataReader reader = selectCommand.ExecuteReader();
if (args.CommandName.EndsWith("Csv"))
{
ExportDataAsCsv(page, reader, writer);
}
if (args.CommandName.EndsWith("Rss"))
{
ExportDataAsRss(page, reader, writer);
}
if (args.CommandName.EndsWith("Rowset"))
{
ExportDataAsRowset(page, reader, writer);
}
reader.Close();
}
}
finally
{
writer.Close();
}
result.Values.Add(new FieldValue("FileName", null, fileName));
}
