public static void Delete(this View view, string pk, BeforeDeleteEventHandler beforeDeleteCallback, AfterDeleteEventHandler afterDeleteBeforeCommitCallback, AfterDeleteEventHandler afterDeleteAfterCommitCallback)
{
if (!view.AllowDelete)
{
throw new AccessViolationException();
}
GetDataTableAccess(view).Delete(view, pk, beforeDeleteCallback, afterDeleteBeforeCommitCallback, afterDeleteAfterCommitCallback);
}
public void Remove(string key, BeforeDeleteEventHandler bfDelete, AfterDeleteEventHandler afDelete, AfterDeleteEventHandler afDeleteAndCommit)
{
//string sql = "DELETE FROM {0} WHERE [{1}]='{2}'";
//string query = string.Format(sql,view.DataTable.TableName, view.PrimaryKeyFileds[0].DatabaseNames,key);
DataAccess.SqlAccess da = new DataAccess.SqlAccess();
da.Delete(view, key, bfDelete, afDelete, afDeleteAndCommit);
}
public static void Delete(this View view, string fk, string fkField, string stam, BeforeDeleteEventHandler beforeDeleteCallback, AfterDeleteEventHandler afterDeleteBeforeCommitCallback, AfterDeleteEventHandler afterDeleteAfterCommitCallback)
{
if (!view.AllowDelete)
{
throw new AccessViolationException();
}
((SqlAccess)GetDataTableAccess(view)).Delete(view, fk, fkField, beforeDeleteCallback, afterDeleteBeforeCommitCallback, afterDeleteAfterCommitCallback);
}
/*
* public string GetValidation(View view, DataAction dataAction, string guid)
* {
* StringBuilder validation = new StringBuilder();
*
* // var theFirstName = null;
* // $(document).ready(function() {
* // $(function() {
* // theFirstName = new Spry.Widget.ValidationTextField("theFirstName");
* // });
* // });
* ColumnFieldViewer columnFieldViewer = new ColumnFieldViewer();
*
* foreach (Field field in view.GetVisibleFieldsForRow(dataAction))
* {
* string validationVar = columnFieldViewer.GetContainerElementIDForValidation(field, dataAction, guid);
* validation.Append("var " + validationVar + " = null;");
*
* }
*
* validation.Append("$(document).ready(function() {");
* validation.Append("$(function() {");
*
* //var theCTratio1 = new Spry.Widget.ValidationTextField("theCTratio1", "real", { isRequired: false, validateOn: ["blur"], useCharacterMasking: true, minValue: 1, maxValue: 10000 });
* //var theInstallationDate = new Spry.Widget.ValidationTextField("theInstallationDate", "date", {format: "mm-dd-yyyy", isRequired: true, validateOn: ["blur", "change"] });
*
*
* foreach (Field field in view.GetVisibleFieldsForRow(dataAction).Where(f => f.FieldType == FieldType.Parent || f.FieldType == FieldType.Column))
* {
* string validationType = "none";
* string required = (field.Required) ? "true" : "false";
* string useMasking = string.Empty;
* string range = string.Empty;
* string format = string.Empty;
*
* validationType = columnFieldViewer.GetValidationType(field);
* ColumnFieldType columnFieldType = field.GetColumnFieldType();
* if (field.Validation.Range != null)
* {
* if (columnFieldType == ColumnFieldType.Integer || columnFieldType == ColumnFieldType.Real)
* {
* useMasking = ", useCharacterMasking: true";
* range = ", useCharacterMasking: true, minValue: " + field.Validation.Range.Min.ToString() + ", maxValue: " + field.Validation.Range.Min.ToString();
* }
* }
* if (string.IsNullOrEmpty(field.Validation.Format))
* {
* if (columnFieldType == ColumnFieldType.DateTime)
* {
* format = ", format: '" + view.Database.DateFormat + "'";
* }
* else
* {
* format = string.Empty;
* }
* }
* else
* {
* format = ", format: '" + field.Validation.Format + "'";
* }
*
* HtmlControlType htmlControlType = field.GetHtmlControlType();
* string validationVar = columnFieldViewer.GetContainerElementIDForValidation(field, dataAction, guid);
* if (htmlControlType == HtmlControlType.Text || htmlControlType == HtmlControlType.Autocomplete)
* {
* validation.Append(validationVar + " = new Spry.Widget.ValidationTextField('" + validationVar + "', '" + validationType + "', { isRequired: " + required + useMasking + format + "}" + ");");
* }
* else if (htmlControlType == HtmlControlType.DropDown || htmlControlType == HtmlControlType.OutsideDependency || htmlControlType == HtmlControlType.Groups)
* {
* validation.Append(validationVar + " = new Spry.Widget.ValidationSelect('" + validationVar + "', { isRequired: " + required + "}" + ");");
* }
* else if (htmlControlType == HtmlControlType.TextArea)
* {
* validation.Append(validationVar + " = new Spry.Widget.ValidationTextarea('" + validationVar + "', { isRequired: " + required + "}" + ");");
* }
*
* }
*
*
* validation.Append("});");
* validation.Append("});");
*
* return validation.ToString();
* }
*/
public void Delete(View view, string fk, string fkField, BeforeDeleteEventHandler beforeDeleteCallback, AfterDeleteEventHandler afterDeleteBeforeCommitCallback, AfterDeleteEventHandler afterDeleteAfterCommitCallback)
{
view.Delete(fk, fkField, string.Empty, beforeDeleteCallback, afterDeleteBeforeCommitCallback, afterDeleteAfterCommitCallback);
}
