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); }