public override void OnGUI(Rect position, SerializedProperty property, GUIContent label)
{
ValidateField attribute = this.attribute as ValidateField;
SingleCheck(property, attribute);
EditorGUI.PropertyField(position, property, label, true);
}
public static void UpdateFashion(int oldId, string ids, string names, string defs)
{
BufferData bufferData = BufferData.GetInstance();
int id = ValidateField.ValidateKey(ids, oldId, bufferData.DestinationTable.GetIdList());
string name = ValidateField.ValidateString(names);
string def = ValidateField.ValidateString(defs);
string query;
if (bufferData.EditMode == BufferData.EditModes.Update)
{
query = "Update fashion set id_fashion = " + id +
", name = '" + name + "', definition = '" + def +
"' where id_fashion = " + oldId + ";";
DepotDbConnector.GetInstance().UpdateQuerry(query);
}
if (bufferData.EditMode == BufferData.EditModes.Insert)
{
query = "Insert into fashion (id_fashion, name, definition) values (" + id +
", '" + name + "', '" + def + "');";
DepotDbConnector.GetInstance().InsertQuerry(query);
}
}
public static void UpdateManufacturer(int oldId, string ids, string names, string countrys, string citys, string tels)
{
BufferData bufferData = BufferData.GetInstance();
int id = ValidateField.ValidateKey(ids, oldId, bufferData.DestinationTable.GetIdList());
string name = ValidateField.ValidateString(names);
string country = ValidateField.ValidateString(countrys);
string city = ValidateField.ValidateString(citys);
string tel = ValidateField.ValidateTelephone(tels);
string query;
if (bufferData.EditMode == BufferData.EditModes.Update)
{
query = "Update manufacturer set id_manufacturer = " + id +
", name = '" + name +
"', country = '" + country +
"', city = '" + city +
"', telephone = '" + tel +
"' where id_manufacturer = " + oldId + ";";
DepotDbConnector.GetInstance().UpdateQuerry(query);
}
if (bufferData.EditMode == BufferData.EditModes.Insert)
{
query = "Insert into manufacturer (id_manufacturer, name, country, city, telephone) values (" +
id + ", '" +
name + "', '" +
country + "', '" +
city + "', '" +
tel + "');";
DepotDbConnector.GetInstance().InsertQuerry(query);
}
}
public static void UpdateReceivedMaterial(int oldId, string ids, string dates, string amounts, string idMats)
{
BufferData bufferData = BufferData.GetInstance();
int id = ValidateField.ValidateKey(ids, oldId, bufferData.DestinationTable.GetIdList());
string date = ValidateField.ValidateDate(dates);
int amount = ValidateField.ValidateNumber(amounts);
int idMat = ValidateField.ValidateNumber(idMats);
string query;
if (bufferData.EditMode == BufferData.EditModes.Update)
{
query = "Update received_material set id_received_material = " + id +
", date_received = '" + date +
"', amount = '" + amount +
"', id_material = '" + idMat +
"' where id_received_material = " + oldId + ";";
DepotDbConnector.GetInstance().UpdateQuerry(query);
}
if (bufferData.EditMode == BufferData.EditModes.Insert)
{
query = "Insert into received_material (id_received_material, date_received, amount, id_material) values (" +
id + ", '" +
date + "', '" +
amount + "', '" +
idMat + "');";
DepotDbConnector.GetInstance().InsertQuerry(query);
}
}
private bool CheckElement(object target, ValidateField attribute)
{
if (target == null)
{
return(true);
}
System.Type targetType = target.GetType();
return(attribute.Type.IsAssignableFrom(targetType));
}
private void SingleCheck(SerializedProperty property, ValidateField attribute)
{
Object interationTarget = property.objectReferenceValue;
if (!CheckElement(interationTarget, attribute))
{
property.objectReferenceValue = null;
property.serializedObject.ApplyModifiedProperties();
Debug.LogError("Incorrect component type in field :" + property.displayName);
}
}
private bool CanLogin()
{
string emailErrors = "";
string passwordErrors = "";
bool canLogin = false;
if ((ValidateField.Email(Email, ref emailErrors) && ValidateField.Password(Password, ref passwordErrors)) == true)
{
canLogin = true;
}
return(canLogin);
}
protected override void configure(FubuRegistry registry)
{
registry.Actions.IncludeType <CreateUserEndpoint>();
registry.Import <FubuMvcValidation>();
theUserService = new UserService();
registry.Services(r => r.SetServiceIfNone <IUserService>(theUserService));
var rule = RemoteFieldRule.For(ReflectionHelper.GetAccessor <CreateUser>(x => x.Username), new UniqueUsernameRule());
theField = new ValidateField {
Hash = rule.ToHash(), Value = "joel_arnold"
};
theUserService.AddUser(theField.Value);
}
// Adds record to the table orders
public static bool AddOrder(string dates, string amounts, string mats, string dests,
string fashions, string types)
{
BufferData bufferData = BufferData.GetInstance();
int id = bufferData.OrdersViewTable.Data.Max(x => x.IdOrder) + 1;
string date = ValidateField.ValidateDate(dates);
int amount = ValidateField.ValidateNumber(amounts);
mats = ValidateField.ValidateString(mats);
dests = ValidateField.ValidateString(dests);
fashions = ValidateField.ValidateString(fashions);
types = ValidateField.ValidateString(types);
int idDest = bufferData.DestinationTable.Data.First(x => x.Type == dests).IdDestination;
int idState;
int idFashion = bufferData.FashionTable.Data.First(x => x.Name == fashions).IdFashion;
int idType = bufferData.MaterialTypeTable.Data.First(x => x.Name == types).IdMaterialType;
int idMat = bufferData.MaterialTable.Data.First(
x => x.Name == mats &&
x.IdFashion == idFashion &&
x.IdMaterialType == idType).IdMaterial;
if ((StockCalculate.GetTotalExistMaterial(idMat) - amount) >= 0)
{
idState = 1;
}
else
{
idState = 2;
}
string query;
query = "Insert into orders (id_order, date, amount_material, id_material, id_destination, id_state) values (" +
id + ", '" +
date + "', '" +
amount + "', '" +
idMat + "', '" +
idDest + "', '" +
idState + "');";
DepotDbConnector.GetInstance().InsertQuerry(query);
return((idState == 1) ? true : false);
}
public static void UpdateOrders(int oldId, string ids, string dates, string amounts, string idMats, string idDests, string idStates)
{
BufferData bufferData = BufferData.GetInstance();
int id = ValidateField.ValidateKey(ids, oldId, bufferData.DestinationTable.GetIdList());
string date = ValidateField.ValidateDate(dates);
int amount = ValidateField.ValidateNumber(amounts);
int idMat = ValidateField.ValidateNumber(idMats);
int idDest = ValidateField.ValidateNumber(idDests);
int idState = ValidateField.ValidateNumber(idStates);
if ((StockCalculate.GetTotalExistMaterial(idMat) - amount) >= 0)
{
idState = 1;
}
else
{
idState = 2;
}
string query;
if (bufferData.EditMode == BufferData.EditModes.Update)
{
query = "Update orders set id_order = " + id +
", date = '" + date +
"', amount_material = '" + amount +
"', id_material = '" + idMat +
"', id_destination = '" + idDest +
"', id_state = '" + idState +
"' where id_order = " + oldId + ";";
DepotDbConnector.GetInstance().UpdateQuerry(query);
}
if (bufferData.EditMode == BufferData.EditModes.Insert)
{
query = "Insert into orders (id_order, date, amount_material, id_material, id_destination, id_state) values (" +
id + ", '" +
date + "', '" +
amount + "', '" +
idMat + "', '" +
idDest + "', '" +
idState + "');";
DepotDbConnector.GetInstance().InsertQuerry(query);
}
}
protected override void beforeEach()
{
var theAccessor = ReflectionHelper.GetAccessor <ValidateFieldTarget>(x => x.Name);
theGraph = new RemoteRuleGraph();
theGraph.RegisterRule(theAccessor, new RequiredFieldRule());
Services.Inject(theGraph);
theRemoteRule = RemoteFieldRule.For(theAccessor, new RequiredFieldRule());
theInputModel = new ValidateField {
Hash = theRemoteRule.ToHash(), Value = "Test"
};
theNotification = new Notification();
theContinuation = new AjaxContinuation();
MockFor <IRuleRunner>().Stub(x => x.Run(theRemoteRule, theInputModel.Value)).Return(theNotification);
MockFor <IAjaxContinuationResolver>().Stub(x => x.Resolve(theNotification)).Return(theContinuation);
}
public static void UpdateMaterial(int oldId, string ids, string names, string dates, string idManufacturers, string idMatTypes, string idFashions)
{
BufferData bufferData = BufferData.GetInstance();
int id = ValidateField.ValidateKey(ids, oldId, bufferData.DestinationTable.GetIdList());
string name = ValidateField.ValidateString(names);
string date = ValidateField.ValidateDate(dates);
int idMan = ValidateField.ValidateNumber(idManufacturers);
int idMat = ValidateField.ValidateNumber(idMatTypes);
int idFashion = ValidateField.ValidateNumber(idFashions);
string query;
if (bufferData.EditMode == BufferData.EditModes.Update)
{
query = "Update material set id_material = " + id +
", name = '" + name +
"', date_producing = '" + date +
"', id_manufacturer = '" + idMan +
"', id_material_type = '" + idMat +
"', id_fashion = '" + idFashion +
"' where id_material = " + oldId + ";";
DepotDbConnector.GetInstance().UpdateQuerry(query);
}
if (bufferData.EditMode == BufferData.EditModes.Insert)
{
query = "Insert into material (id_material, name, date_producing, id_manufacturer, id_material_type, id_fashion) values (" +
id + ", '" +
name + "', '" +
date + "', '" +
idMan + "', '" +
idMat + "', '" +
idFashion + "');";
DepotDbConnector.GetInstance().InsertQuerry(query);
}
}
public static void UpdateDestination(int oldId, string ids, string types)
{
BufferData bufferData = BufferData.GetInstance();
int id = ValidateField.ValidateKey(ids, oldId, bufferData.DestinationTable.GetIdList());
string type = ValidateField.ValidateString(types);
string query;
if (bufferData.EditMode == BufferData.EditModes.Update)
{
query = "Update destination set id_destination = " + id +
", type = '" + type + "' where id_destination = " + oldId + ";";
DepotDbConnector.GetInstance().UpdateQuerry(query);
}
if (bufferData.EditMode == BufferData.EditModes.Insert)
{
query = "Insert into destination (id_destination, type) values (" + id +
", '" + type + "');";
DepotDbConnector.GetInstance().InsertQuerry(query);
}
}
public static Validation <Error, long> ValidateToDocumentTypeId(long toDocumentTypeId) => ValidateField(ValidateMinValue(1), "InvalidId")(toDocumentTypeId, nameof(toDocumentTypeId));
public static Validation <Error, long> ValidateFromDocumentId(long fromDocumentId) => ValidateField(ValidateMinValue(1), "InvalidId")(fromDocumentId, nameof(fromDocumentId));
public static Validation <Error, long> ValidateAnnotationTypeId(long annotationTypeId) => ValidateField(ValidateMinValue(1), "InvalidId")(annotationTypeId, nameof(annotationTypeId));
public static Validation <Error, DateTime> ValidateAfter(DateTime milestone, DateTime date, string fieldName) => ValidateField(ValidateDateAfter(milestone), "DateMustBeAfter")(date, fieldName);
public static Validation <Error, DateTime> ValidateBeforeToday(DateTime date, string fieldName) => ValidateField <DateTime>(ValidateDateBeforeToday, "DateMustHavePassed")(date, fieldName);
public static Validation <Error, long> ValidateId(long id, string fieldName) => ValidateField(ValidateMinValue(1), "InvalidId")(id, fieldName);
public static Validation <Error, long> ValidateId(long id) => ValidateField(ValidateMinValue(1), "InvalidId")(id, nameof(id));
ValidateFieldMaxLength(int maxLength) => (string str, string fieldName) => ValidateField(ValidateMaxLength(maxLength), "MaxLength")(str, fieldName);
public static Validation <Error, T[]> ValidateArrayFieldNonEmpty <T>(T[] value, string fieldName) => ValidateField <T[]>(ValidateArrayNonEmpty, "EmptyArray")(value, fieldName);
public static Validation <Error, T> ValidateFieldNonNull <T>(T value, string fieldName)
where T : class
=> ValidateField <T>(ValidateNonNull, "NullValue")(value, fieldName);
ValidateFieldNonEmpty(string str, string fieldName) => ValidateField <string>(ValidateNonEmpty, "EmptyField")(str, fieldName);
public static Validation <Error, long> ValidateToEntityId(long toEntityId) => ValidateField(ValidateMinValue(1), "InvalidId")(toEntityId, nameof(toEntityId));
public static bool IsValidOption(ValidateField validateField, Task task)
{
Type type = task.GetType();
var left = validateField.Field;
var right = validateField.With;
object val = null;
var propLeft = type.GetProperty(left);
if (propLeft.PropertyType == typeof(string))
{
val = right != "null" ? right : null;
}
if (propLeft.PropertyType.IsClass)
{
val = null;
}
var isNumeric = propLeft.PropertyType == typeof(int) || propLeft.PropertyType == typeof(double);
if (propLeft.PropertyType == typeof(int))
{
if (int.TryParse(right, out var res))
{
val = res;
}
else
{
val = null;
}
}
if (propLeft.PropertyType == typeof(double))
{
if (double.TryParse(right, out var res))
{
val = res;
}
else
{
val = null;
}
}
switch (validateField.Operation.Name)
{
case "<":
if (isNumeric)
{
return(((double?)propLeft.GetValue(task)) < (double?)val);
}
else
{
return(string.Compare(propLeft.GetValue(task)?.ToString(), val?.ToString()) < 0);
}
case ">":
if (isNumeric)
{
return(((double?)propLeft.GetValue(task)) > (double?)val);
}
else
{
return(string.Compare(propLeft.GetValue(task)?.ToString(), val?.ToString()) > 0);
}
case "==":
return(Equals(propLeft.GetValue(task), val));
case "!=":
return(!Equals(propLeft.GetValue(task), val));
}
return(false);
}
public static Validation <Error, long> ValidateToPublicationYear(long toPublicationYear) => from x in ValidateField(ValidateMinValue(1900), "MinValue")(toPublicationYear, nameof(toPublicationYear)) from y in ValidateField(ValidateMaxValue(DateTime.Now.Year), "MaxValue")(toPublicationYear, nameof(toPublicationYear)) select y;
ValidateEmailField(string email, string fieldName) => ValidateField <string>(ValidateEmail, "ValidEmail")(email, fieldName);
