SpriteFont storageFont; //显示收获的白菜和胡萝卜的数目字体设置
#endregion Fields
#region Constructors
public Cultivate(GraphicsDeviceManager gdm)
{
gdm.IsFullScreen = true;
TouchPanel.EnabledGestures = GestureType.Tap;
gdm.PreferredBackBufferWidth = 480;
gdm.PreferredBackBufferHeight = 800;
position_01 = new Vector2(80, 710);
position_02 = new Vector2(320, 710);
field[0] = new fields(1, 50, 50, 0, 0, 0);
field[1] = new fields(3, 50, 275, 0, 0, 0);
field[2] = new fields(2, 290, 50, 0, 0, 0);
field[3] = new fields(4, 290, 275, 0, 0, 0);
field[4] = new fields(5, 50, 500, 0, 0, 0);
field[5] = new fields(6, 290, 500, 0, 0, 0);
// Windows Phone 的默认帧速率为 30 fps。
TargetElapsedTime = TimeSpan.FromTicks(333333);
// 延长锁定时的电池寿命。
InactiveSleepTime = TimeSpan.FromSeconds(1);
}
public field_values CreateFieldValue(cases aCase, check_lists checkList, fields f, int?ud_id, int?userId, string value, int?version, workers worker)
{
field_values fv = new field_values();
fv.case_id = aCase.id;
fv.check_list = checkList;
fv.check_list_id = checkList.id;
fv.created_at = DateTime.Now;
fv.date = DateTime.Now;
fv.done_at = DateTime.Now;
fv.field = f;
fv.field_id = f.id;
fv.updated_at = DateTime.Now;
if (ud_id != null)
{
fv.uploaded_data_id = ud_id;
}
fv.user_id = userId;
fv.value = value;
fv.version = version;
fv.worker = worker;
fv.workflow_state = Constants.WorkflowStates.Created;
DbContext.field_values.Add(fv);
DbContext.SaveChanges();
return(fv);
}
public string insertField(fields newField, out Guid fieldId
, string tag = "")
{
string ret;
newField.fieldId = getNewId("fields", tag);
fieldId = newField.fieldId;
ret = fieldL.Insert(newField);
return(ret);
}
/// <summary>
/// Equivalence between Salesforce and SQL Server data types
/// </summary>
/// <param name="field"></param>
/// <returns></returns>
static string DataType(fields field)
{
switch (field.type)
{
case "picklist": return("varchar(" + field.length + ") null");
case "id": return("varchar(" + field.length + ") not null PRIMARY KEY");
case "datetime": return("datetime null");
case "reference": return("varchar(" + field.length + ") null");
case "boolean": return("bit null");
case "string": return("varchar(" + field.length + ") null");
case "date": return("datetime null");
case "textarea": return("varchar(max) null");
case "double": return("decimal (22,4) null");
case "address": return("varchar(max) null");
case "int": return("int null");
case "multipicklist": return("varchar(max) null");
case "anyType": return("varchar(max) null");
case "url": return("varchar(" + field.length + ") null");
case "currency": return("decimal (22,4) null");
case "percent": return("decimal (6,3) null");
case "phone": return("varchar(" + field.length + ") null");
case "email": return("varchar(" + field.length + ") null");
case "base64": return("varchar(max) null");
case "combobox": return("varchar(255) null");
case "time": return("datetime null");
case "encryptedstring": return("varchar(max) null");
case "complexvalue": return("varchar(max) null");
}
return("varchar(max) null");
}
protected void btnAdd_Click(object sender, EventArgs e)
{
fields s = new fields();
s.description = ddlDescription.SelectedItem.Text;
List<Stationary_Catalogue> Codelist = empCtrl.getItemCode(s.description);
ItemCode = Codelist.First().Item_Code.ToString();
s.itemCode = ItemCode;
s.quantity = txtQuantity.Text;
data.Add(s);
itemDetailsGrid.DataSource = data;
itemDetailsGrid.DataBind();
btnSubmit.Enabled = true;
}
/// <summary> </summary>
public static string get_field_value(field_types field_type, posting _post)
{
string value = "";
List <AbstractCriterion> typeEx = new List <AbstractCriterion>();
typeEx.Add(Expression.Eq("type", field_type));
if (!object.ReferenceEquals(_post, null))
{
typeEx.Add(Expression.Eq("owner", _post.baseid));
}
fields field = ActiveRecordBase <fields> .FindFirst(typeEx.ToArray());
value = fieldsService.getFieldVal(field_type, field);
return(value);
}
/// <summary> </summary>
public static string get_field(field_types field_type, dynamic item)
{
List <AbstractCriterion> typeEx = new List <AbstractCriterion>();
typeEx.Add(Expression.Eq("type", field_type));
if (!object.ReferenceEquals(item, null))
{
typeEx.Add(Expression.Eq("owner", item.baseid));
}
fields field = ActiveRecordBase <fields> .FindFirst(typeEx.ToArray());
string ele_str = fieldsService.getfieldmodel_dynamic(field_type, field == null ? null : field.value.ToString());
return(ele_str);
}
public async Task <fields> CreateField(short?barcodeEnabled, string barcodeType, check_lists checkList, string color, string custom, int?decimalCount, string defaultValue, string description, int?displayIndex, short?dummy, field_types ft, short?geolocationEnabled, short?geolocationForced, short?geolocationHidden, short?isNum, string label, short?mandatory, int maxLength, string maxValue, string minValue, short?multi, short?optional, string queryType, short?readOnly, short?selected, short?splitScreen, short?stopOnSave, string unitName, int version)
{
fields f = new fields();
f.FieldTypeId = ft.Id;
f.BarcodeEnabled = barcodeEnabled;
f.BarcodeType = barcodeType;
f.CheckListId = checkList.Id;
f.Color = color;
f.CreatedAt = DateTime.UtcNow;
f.Custom = custom;
f.DecimalCount = decimalCount;
f.DefaultValue = defaultValue;
f.Description = description;
f.DisplayIndex = displayIndex;
f.Dummy = dummy;
f.GeolocationEnabled = geolocationEnabled;
f.GeolocationForced = geolocationForced;
f.GeolocationHidden = geolocationHidden;
f.IsNum = isNum;
f.Label = label;
f.Mandatory = mandatory;
f.MaxLength = maxLength;
f.MaxValue = maxValue;
f.MinValue = minValue;
f.Multi = multi;
f.Optional = optional;
f.QueryType = queryType;
f.ReadOnly = readOnly;
f.Selected = selected;
f.SplitScreen = splitScreen;
f.StopOnSave = stopOnSave;
f.UnitName = unitName;
f.UpdatedAt = DateTime.UtcNow;
f.Version = version;
f.WorkflowState = Constants.WorkflowStates.Created;
dbContext.fields.Add(f);
await dbContext.SaveChangesAsync().ConfigureAwait(false);
Thread.Sleep(2000);
return(f);
}
public fields CreateField(short?barcodeEnabled, string barcodeType, check_lists checkList, string color, string custom, int?decimalCount, string defaultValue, string description, int?displayIndex, short?dummy, field_types ft, short?geolocationEnabled, short?geolocationForced, short?geolocationHidden, short?isNum, string label, short?mandatory, int maxLength, string maxValue, string minValue, short?multi, short?optional, string queryType, short?readOnly, short?selected, short?splitScreen, short?stopOnSave, string unitName, int version)
{
fields f = new fields();
f.field_type_id = ft.id;
f.barcode_enabled = barcodeEnabled;
f.barcode_type = barcodeType;
f.check_list_id = checkList.id;
f.color = color;
f.created_at = DateTime.Now;
f.custom = custom;
f.decimal_count = decimalCount;
f.default_value = defaultValue;
f.description = description;
f.display_index = displayIndex;
f.dummy = dummy;
f.geolocation_enabled = geolocationEnabled;
f.geolocation_forced = geolocationForced;
f.geolocation_hidden = geolocationHidden;
f.is_num = isNum;
f.label = label;
f.mandatory = mandatory;
f.max_length = maxLength;
f.max_value = maxValue;
f.min_value = minValue;
f.multi = multi;
f.optional = optional;
f.query_type = queryType;
f.read_only = readOnly;
f.selected = selected;
f.split_screen = splitScreen;
f.stop_on_save = stopOnSave;
f.unit_name = unitName;
f.updated_at = DateTime.Now;
f.version = version;
f.workflow_state = Constants.WorkflowStates.Created;
DbContext.fields.Add(f);
DbContext.SaveChanges();
Thread.Sleep(2000);
return(f);
}
/// <summary> </summary>
public static string getFieldVal(field_types field_type, fields field)
{
dynamic value;
string output = "";
var jss = new JavaScriptSerializer();
dynamic sel = null;
if (field != null && !String.IsNullOrEmpty(field.value))
{
sel = jss.Deserialize <Dictionary <string, dynamic> >(field.value.ToString());
}
var ele = jss.Deserialize <Dictionary <string, dynamic> >(field_type.attr.ToString());
if (ele != null && sel != null && sel.TryGetValue("selections", out value) && ele["type"] == "dropdown")
{
foreach (dynamic _option in ele["options"])
{
foreach (dynamic _val in sel["selections"])
{
if (_val.TryGetValue("val", out value) && _option["val"] == _val["val"])
{
output = _val["val"];
}
}
}
}
else if (sel != null && sel["selections"][0].TryGetValue("val", out value))
{
foreach (dynamic _option in ele["options"])
{
_option["selected"] = "";
if (sel["selections"][0]["val"] != "")
{
output = sel["selections"][0]["val"];
}
}
}
return(output);
}
public async Task SQL_SiteWorker_SiteWorkerCreate_ReturnsID()
{
// Arrance
#region Arrance
#region Checklist
DateTime cl1_Ca = DateTime.Now;
DateTime cl1_Ua = DateTime.Now;
check_lists Cl1 = await testHelpers.CreateTemplate(cl1_Ca, cl1_Ua, "A1", "D1", "caseType1", "WhereItIs", 1, 0);
#endregion
#region SubCheckList
check_lists Cl2 = await testHelpers.CreateSubTemplate("A2", "D2", "caseType2", 2, 0, Cl1);
#endregion
#region Fields
#region field1
fields f1 = await testHelpers.CreateField(1, "barcode", Cl2, "e2f4fb", "custom", null, "", "Comment field description",
5, 1, dbContext.field_types.Where(x => x.FieldType == "picture").First(), 0, 0, 1, 0, "Comment field", 1, 55, "55", "0", 0, 0, null, 1, 0,
0, 0, "", 49);
#endregion
#region field2
fields f2 = await testHelpers.CreateField(1, "barcode", Cl2, "f5eafa", "custom", null, "", "showPDf Description",
45, 1, dbContext.field_types.Where(x => x.FieldType == "comment").First(), 0, 1, 0, 0,
"ShowPdf", 0, 5, "5", "0", 0, 0, null, 0, 0, 0, 0, "", 9);
#endregion
#region field3
fields f3 = await testHelpers.CreateField(0, "barcode", Cl2, "f0f8db", "custom", 3, "", "Number Field Description",
83, 0, dbContext.field_types.Where(x => x.FieldType == "picture").First(), 0, 0, 1, 0,
"Numberfield", 1, 8, "4865", "0", 0, 1, null, 1, 0, 0, 0, "", 1);
#endregion
#region field4
fields f4 = await testHelpers.CreateField(1, "barcode", Cl2, "fff6df", "custom", null, "", "date Description",
84, 0, dbContext.field_types.Where(x => x.FieldType == "picture").First(), 0, 0, 1, 0,
"Date", 1, 666, "41153", "0", 0, 1, null, 0, 1, 0, 0, "", 1);
#endregion
#region field5
fields f5 = await testHelpers.CreateField(0, "barcode", Cl2, "ffe4e4", "custom", null, "", "picture Description",
85, 0, dbContext.field_types.Where(x => x.FieldType == "comment").First(), 1, 0, 1, 0,
"Picture", 1, 69, "69", "1", 0, 1, null, 0, 1, 0, 0, "", 1);
#endregion
#region field6
fields f6 = await testHelpers.CreateField(0, "barcode", Cl2, "ffe4e4", "custom", null, "", "picture Description",
86, 0, dbContext.field_types.Where(x => x.FieldType == "comment").First(), 1, 0, 1, 0,
"Picture", 1, 69, "69", "1", 0, 1, null, 0, 1, 0, 0, "", 1);
#endregion
#region field7
fields f7 = await testHelpers.CreateField(0, "barcode", Cl2, "ffe4e4", "custom", null, "", "picture Description",
87, 0, dbContext.field_types.Where(x => x.FieldType == "comment").First(), 1, 0, 1, 0,
"Picture", 1, 69, "69", "1", 0, 1, null, 0, 1, 0, 0, "", 1);
#endregion
#region field8
fields f8 = await testHelpers.CreateField(0, "barcode", Cl2, "ffe4e4", "custom", null, "", "picture Description",
88, 0, dbContext.field_types.Where(x => x.FieldType == "comment").First(), 1, 0, 1, 0,
"Picture", 1, 69, "69", "1", 0, 1, null, 0, 1, 0, 0, "", 1);
#endregion
#region field9
fields f9 = await testHelpers.CreateField(0, "barcode", Cl2, "ffe4e4", "custom", null, "", "picture Description",
89, 0, dbContext.field_types.Where(x => x.FieldType == "comment").First(), 1, 0, 1, 0,
"Picture", 1, 69, "69", "1", 0, 1, null, 0, 1, 0, 0, "", 1);
#endregion
#region field10
fields f10 = await testHelpers.CreateField(0, "barcode", Cl2, "ffe4e4", "custom", null, "", "picture Description",
90, 0, dbContext.field_types.Where(x => x.FieldType == "comment").First(), 1, 0, 1, 0,
"Picture", 1, 69, "69", "1", 0, 1, null, 0, 1, 0, 0, "", 1);
#endregion
#endregion
#region Workers
#region worker1
workers worker1 = await testHelpers.CreateWorker("*****@*****.**", "Arne", "Jensen", 21);
#endregion
#region worker2
workers worker2 = await testHelpers.CreateWorker("*****@*****.**", "Lasse", "Johansen", 44);
#endregion
#region worker3
workers worker3 = await testHelpers.CreateWorker("*****@*****.**", "Svend", "Jensen", 22);
#endregion
#region worker4
workers worker4 = await testHelpers.CreateWorker("*****@*****.**", "Bjarne", "Nielsen", 23);
#endregion
#region worker5
workers worker5 = await testHelpers.CreateWorker("*****@*****.**", "Ib", "Hansen", 24);
#endregion
#region worker6
workers worker6 = await testHelpers.CreateWorker("*****@*****.**", "Hozan", "Aziz", 25);
#endregion
#region worker7
workers worker7 = await testHelpers.CreateWorker("*****@*****.**", "Nicolai", "Peders", 26);
#endregion
#region worker8
workers worker8 = await testHelpers.CreateWorker("*****@*****.**", "Amin", "Safari", 27);
#endregion
#region worker9
workers worker9 = await testHelpers.CreateWorker("*****@*****.**", "Leo", "Rebaz", 28);
#endregion
#region worker10
workers worker10 = await testHelpers.CreateWorker("*****@*****.**", "Stig", "Berthelsen", 29);
#endregion
#endregion
#region sites
#region Site1
sites site1 = await testHelpers.CreateSite("SiteName1", 88);
#endregion
#region Site2
sites site2 = await testHelpers.CreateSite("SiteName2", 89);
#endregion
#region Site3
sites site3 = await testHelpers.CreateSite("SiteName3", 90);
#endregion
#region Site4
sites site4 = await testHelpers.CreateSite("SiteName4", 91);
#endregion
#region Site5
sites site5 = await testHelpers.CreateSite("SiteName5", 92);
#endregion
#region Site6
sites site6 = await testHelpers.CreateSite("SiteName6", 93);
#endregion
#region Site7
sites site7 = await testHelpers.CreateSite("SiteName7", 94);
#endregion
#region Site8
sites site8 = await testHelpers.CreateSite("SiteName8", 95);
#endregion
#region Site9
sites site9 = await testHelpers.CreateSite("SiteName9", 96);
#endregion
#region Site10
sites site10 = await testHelpers.CreateSite("SiteName10", 97);
#endregion
#endregion
#region units
units unit = await testHelpers.CreateUnit(48, 49, site1, 348);
#endregion
#endregion
// Act
var match = await sut.SiteWorkerCreate(5, (int)site1.MicrotingUid, (int)worker1.MicrotingUid);
// Assert
var siteWorkers = dbContext.site_workers.AsNoTracking().ToList();
Assert.NotNull(match);
Assert.AreEqual(1, siteWorkers.Count());
Assert.AreEqual(Constants.WorkflowStates.Created, siteWorkers[0].WorkflowState);
}
public void SQL_Check_CheckRead_ReturnsReplyElement()
{
// Arrance
#region Arrance
#region Template1
DateTime cl1_Ca = DateTime.Now;
DateTime cl1_Ua = DateTime.Now;
check_lists cl1 = testHelpers.CreateTemplate(cl1_Ca, cl1_Ua, "A", "D", "CheckList", "Template1FolderName", 1, 1);
#endregion
#region SubTemplate1
check_lists cl2 = testHelpers.CreateSubTemplate("A.1", "D.1", "CheckList", 1, 1, cl1);
#endregion
#region Fields
#region field1
fields f1 = testHelpers.CreateField(1, "barcode", cl2, "e2f4fb", "custom", null, "", "Comment field description",
5, 1, DbContext.field_types.Where(x => x.field_type == "comment").First(), 0, 0, 1, 0, "Comment field", 1, 55, "55", "0", 0, 0, null, 1, 0,
0, 0, "", 49);
#endregion
#region field2
fields f2 = testHelpers.CreateField(1, "barcode", cl2, "f5eafa", "custom", null, "", "showPDf Description",
45, 1, DbContext.field_types.Where(x => x.field_type == "comment").First(), 0, 1, 0, 0,
"ShowPdf", 0, 5, "5", "0", 0, 0, null, 0, 0, 0, 0, "", 9);
#endregion
#region field3
fields f3 = testHelpers.CreateField(0, "barcode", cl2, "f0f8db", "custom", 3, "", "Number Field Description",
83, 0, DbContext.field_types.Where(x => x.field_type == "number").First(), 0, 0, 1, 0,
"Numberfield", 1, 8, "4865", "0", 0, 1, null, 1, 0, 0, 0, "", 1);
#endregion
#region field4
fields f4 = testHelpers.CreateField(1, "barcode", cl2, "fff6df", "custom", null, "", "date Description",
84, 0, DbContext.field_types.Where(x => x.field_type == "comment").First(), 0, 0, 1, 0,
"Date", 1, 666, "41153", "0", 0, 1, null, 0, 1, 0, 0, "", 1);
#endregion
#region field5
fields f5 = testHelpers.CreateField(0, "barcode", cl2, "ffe4e4", "custom", null, "", "picture Description",
85, 0, DbContext.field_types.Where(x => x.field_type == "comment").First(), 1, 0, 1, 0,
"Picture", 1, 69, "69", "1", 0, 1, null, 0, 1, 0, 0, "", 1);
#endregion
#endregion
#region Worker
workers worker = testHelpers.CreateWorker("*****@*****.**", "Arne", "Jensen", 21);
#endregion
#region site
sites site = testHelpers.CreateSite("SiteName", 88);
#endregion
#region units
units unit = testHelpers.CreateUnit(48, 49, site, 348);
#endregion
#region site_workers
site_workers site_workers = testHelpers.CreateSiteWorker(55, site, worker);
#endregion
#region Case1
cases aCase = testHelpers.CreateCase("caseUId", cl1, DateTime.Now, "custom", DateTime.Now,
worker, "microtingCheckUId", "microtingUId",
site, 66, "caseType", unit, DateTime.Now, 1, worker, Constants.WorkflowStates.Created);
#endregion
#region Check List Values
check_list_values check_List_Values = testHelpers.CreateCheckListValue(aCase, cl2, "completed", null, 865);
#endregion
#region Field Values
#region fv1
field_values field_Values1 = testHelpers.CreateFieldValue(aCase, cl2, f1, null, null, "tomt1", 61234, worker);
#endregion
#region fv2
field_values field_Values2 = testHelpers.CreateFieldValue(aCase, cl2, f2, null, null, "tomt2", 61234, worker);
#endregion
#region fv3
field_values field_Values3 = testHelpers.CreateFieldValue(aCase, cl2, f3, null, null, "tomt3", 61234, worker);
#endregion
#region fv4
field_values field_Values4 = testHelpers.CreateFieldValue(aCase, cl2, f4, null, null, "tomt4", 61234, worker);
#endregion
#region fv5
field_values field_Values5 = testHelpers.CreateFieldValue(aCase, cl2, f5, null, null, "tomt5", 61234, worker);
#endregion
#endregion
#endregion
// Act
ReplyElement match = sut.CheckRead(aCase.microting_uid, aCase.microting_check_uid);
// Assert
#region Assert
Assert.AreEqual(1, match.ElementList.Count());
CheckListValue clv = (CheckListValue)match.ElementList[0];
Assert.AreEqual(5, clv.DataItemList.Count);
#region casts
Field _f1 = (Field)clv.DataItemList[0];
Field _f2 = (Field)clv.DataItemList[1];
Field _f3 = (Field)clv.DataItemList[2];
Field _f4 = (Field)clv.DataItemList[3];
Field _f5 = (Field)clv.DataItemList[4];
#endregion
#region Barcode
Assert.AreEqual(f1.barcode_enabled, 1);
Assert.AreEqual(f2.barcode_enabled, 1);
Assert.AreEqual(f3.barcode_enabled, 0);
Assert.AreEqual(f4.barcode_enabled, 1);
Assert.AreEqual(f5.barcode_enabled, 0);
Assert.AreEqual(f1.barcode_type, "barcode");
Assert.AreEqual(f2.barcode_type, "barcode");
Assert.AreEqual(f3.barcode_type, "barcode");
Assert.AreEqual(f4.barcode_type, "barcode");
Assert.AreEqual(f5.barcode_type, "barcode");
#endregion
#region chckl_id
Assert.AreEqual(f1.check_list_id, cl2.id);
Assert.AreEqual(f2.check_list_id, cl2.id);
Assert.AreEqual(f3.check_list_id, cl2.id);
Assert.AreEqual(f4.check_list_id, cl2.id);
Assert.AreEqual(f5.check_list_id, cl2.id);
#endregion
#region Color
Assert.AreEqual(f1.color, _f1.FieldValues[0].Color);
Assert.AreEqual(f2.color, _f2.FieldValues[0].Color);
Assert.AreEqual(f3.color, _f3.FieldValues[0].Color);
Assert.AreEqual(f4.color, _f4.FieldValues[0].Color);
Assert.AreEqual(f5.color, _f5.FieldValues[0].Color);
#endregion
#region custom
// Assert.AreEqual(f1.custom, _f1.FieldValues[0].Id);
#endregion
#region Decimal_Count
Assert.AreEqual(f1.decimal_count, null);
Assert.AreEqual(f2.decimal_count, null);
Assert.AreEqual(f3.decimal_count, 3);
Assert.AreEqual(f4.decimal_count, null);
Assert.AreEqual(f5.decimal_count, null);
#endregion
#region Default_value
Assert.AreEqual(f1.default_value, "");
Assert.AreEqual(f2.default_value, "");
Assert.AreEqual(f3.default_value, "");
Assert.AreEqual(f4.default_value, "");
Assert.AreEqual(f5.default_value, "");
#endregion
#region Description
CDataValue f1desc = (CDataValue)_f1.Description;
CDataValue f2desc = (CDataValue)_f2.Description;
CDataValue f3desc = (CDataValue)_f3.Description;
CDataValue f4desc = (CDataValue)_f4.Description;
CDataValue f5desc = (CDataValue)_f5.Description;
Assert.AreEqual(f1.description, f1desc.InderValue);
Assert.AreEqual(f2.description, f2desc.InderValue);
Assert.AreEqual(f3.description, f3desc.InderValue);
Assert.AreEqual(f4.description, f4desc.InderValue);
Assert.AreEqual(f5.description, f5desc.InderValue);
#endregion
#region Displayindex
Assert.AreEqual(f1.display_index, _f1.FieldValues[0].DisplayOrder);
Assert.AreEqual(f2.display_index, _f2.FieldValues[0].DisplayOrder);
Assert.AreEqual(f3.display_index, _f3.FieldValues[0].DisplayOrder);
Assert.AreEqual(f4.display_index, _f4.FieldValues[0].DisplayOrder);
Assert.AreEqual(f5.display_index, _f5.FieldValues[0].DisplayOrder);
#endregion
#region Dummy
Assert.AreEqual(f1.dummy, 1);
Assert.AreEqual(f2.dummy, 1);
Assert.AreEqual(f3.dummy, 0);
Assert.AreEqual(f4.dummy, 0);
Assert.AreEqual(f5.dummy, 0);
#endregion
#region geolocation
#region enabled
Assert.AreEqual(f1.geolocation_enabled, 0);
Assert.AreEqual(f2.geolocation_enabled, 0);
Assert.AreEqual(f3.geolocation_enabled, 0);
Assert.AreEqual(f4.geolocation_enabled, 0);
Assert.AreEqual(f5.geolocation_enabled, 1);
#endregion
#region forced
Assert.AreEqual(f1.geolocation_forced, 0);
Assert.AreEqual(f2.geolocation_forced, 1);
Assert.AreEqual(f3.geolocation_forced, 0);
Assert.AreEqual(f4.geolocation_forced, 0);
Assert.AreEqual(f5.geolocation_forced, 0);
#endregion
#region hidden
Assert.AreEqual(f1.geolocation_hidden, 1);
Assert.AreEqual(f2.geolocation_hidden, 0);
Assert.AreEqual(f3.geolocation_hidden, 1);
Assert.AreEqual(f4.geolocation_hidden, 1);
Assert.AreEqual(f5.geolocation_hidden, 1);
#endregion
#endregion
#region isNum
Assert.AreEqual(f1.is_num, 0);
Assert.AreEqual(f2.is_num, 0);
Assert.AreEqual(f3.is_num, 0);
Assert.AreEqual(f4.is_num, 0);
Assert.AreEqual(f5.is_num, 0);
#endregion
#region Label
Assert.AreEqual(f1.label, _f1.Label);
Assert.AreEqual(f2.label, _f2.Label);
Assert.AreEqual(f3.label, _f3.Label);
Assert.AreEqual(f4.label, _f4.Label);
Assert.AreEqual(f5.label, _f5.Label);
#endregion
#region Mandatory
Assert.AreEqual(f1.mandatory, 1);
Assert.AreEqual(f2.mandatory, 0);
Assert.AreEqual(f3.mandatory, 1);
Assert.AreEqual(f4.mandatory, 1);
Assert.AreEqual(f5.mandatory, 1);
#endregion
#region maxLength
Assert.AreEqual(f1.max_length, 55);
Assert.AreEqual(f2.max_length, 5);
Assert.AreEqual(f3.max_length, 8);
Assert.AreEqual(f4.max_length, 666);
Assert.AreEqual(f5.max_length, 69);
#endregion
#region min/max_Value
#region max
Assert.AreEqual(f1.max_value, "55");
Assert.AreEqual(f2.max_value, "5");
Assert.AreEqual(f3.max_value, "4865");
Assert.AreEqual(f4.max_value, "41153");
Assert.AreEqual(f5.max_value, "69");
#endregion
#region min
Assert.AreEqual(f1.min_value, "0");
Assert.AreEqual(f2.min_value, "0");
Assert.AreEqual(f3.min_value, "0");
Assert.AreEqual(f4.min_value, "0");
Assert.AreEqual(f5.min_value, "1");
#endregion
#endregion
#region Multi
Assert.AreEqual(f1.multi, 0);
Assert.AreEqual(f2.multi, 0);
Assert.AreEqual(f3.multi, 0);
Assert.AreEqual(f4.multi, 0);
Assert.AreEqual(f5.multi, 0);
#endregion
#region Optional
Assert.AreEqual(f1.optional, 0);
Assert.AreEqual(f2.optional, 0);
Assert.AreEqual(f3.optional, 1);
Assert.AreEqual(f4.optional, 1);
Assert.AreEqual(f5.optional, 1);
#endregion
#region Query_Type
Assert.AreEqual(f1.query_type, null);
Assert.AreEqual(f2.query_type, null);
Assert.AreEqual(f3.query_type, null);
Assert.AreEqual(f4.query_type, null);
Assert.AreEqual(f5.query_type, null);
#endregion
#region Read_Only
Assert.AreEqual(f1.read_only, 1);
Assert.AreEqual(f2.read_only, 0);
Assert.AreEqual(f3.read_only, 1);
Assert.AreEqual(f4.read_only, 0);
Assert.AreEqual(f5.read_only, 0);
#endregion
#region Selected
Assert.AreEqual(f1.selected, 0);
Assert.AreEqual(f2.selected, 0);
Assert.AreEqual(f3.selected, 0);
Assert.AreEqual(f4.selected, 1);
Assert.AreEqual(f5.selected, 1);
#endregion
#region Split_Screen
Assert.AreEqual(f1.split_screen, 0);
Assert.AreEqual(f2.split_screen, 0);
Assert.AreEqual(f3.split_screen, 0);
Assert.AreEqual(f4.split_screen, 0);
Assert.AreEqual(f5.split_screen, 0);
#endregion
#region Stop_On_Save
Assert.AreEqual(f1.stop_on_save, 0);
Assert.AreEqual(f2.stop_on_save, 0);
Assert.AreEqual(f3.stop_on_save, 0);
Assert.AreEqual(f4.stop_on_save, 0);
Assert.AreEqual(f5.stop_on_save, 0);
#endregion
#region Unit_Name
Assert.AreEqual(f1.unit_name, "");
Assert.AreEqual(f2.unit_name, "");
Assert.AreEqual(f3.unit_name, "");
Assert.AreEqual(f4.unit_name, "");
Assert.AreEqual(f5.unit_name, "");
#endregion
#region Values
Assert.AreEqual(1, _f1.FieldValues.Count());
Assert.AreEqual(1, _f2.FieldValues.Count());
Assert.AreEqual(1, _f3.FieldValues.Count());
Assert.AreEqual(1, _f4.FieldValues.Count());
Assert.AreEqual(1, _f5.FieldValues.Count());
Assert.AreEqual(field_Values1.value, _f1.FieldValues[0].Value);
Assert.AreEqual(field_Values2.value, _f2.FieldValues[0].Value);
Assert.AreEqual(field_Values3.value, _f3.FieldValues[0].Value);
Assert.AreEqual(field_Values4.value, _f4.FieldValues[0].Value);
Assert.AreEqual(field_Values5.value, _f5.FieldValues[0].Value);
#endregion
#region Version
Assert.AreEqual(f1.version, 49);
Assert.AreEqual(f2.version, 9);
Assert.AreEqual(f3.version, 1);
Assert.AreEqual(f4.version, 1);
Assert.AreEqual(f5.version, 1);
#endregion
#endregion
}
var(sgn, body) = CreateConstructorCore(declaringType, cx, fields, privateNoValidationVersion: false);
public void SQL_Check_FieldRead_ReturnsField()
{
// Arrance
#region Template1
DateTime cl1_Ca = DateTime.Now;
DateTime cl1_Ua = DateTime.Now;
check_lists cl1 = testHelpers.CreateTemplate(cl1_Ca, cl1_Ua, "A", "D", "CheckList", "Template1FolderName", 1, 1);
#endregion
#region SubTemplate1
check_lists cl2 = testHelpers.CreateSubTemplate("A.1", "D.1", "CheckList", 1, 1, cl1);
#endregion
#region Fields
#region field1
fields f1 = testHelpers.CreateField(1, "barcode", cl2, "e2f4fb", "custom", null, "", "Comment field description",
5, 1, DbContext.field_types.Where(x => x.field_type == "comment").First(), 0, 0, 1, 0, "Comment field", 1, 55, "55", "0", 0, 0, null, 1, 0,
0, 0, "", 49);
#endregion
#region field2
fields f2 = testHelpers.CreateField(1, "barcode", cl2, "f5eafa", "custom", null, "", "showPDf Description",
45, 1, DbContext.field_types.Where(x => x.field_type == "comment").First(), 0, 1, 0, 0,
"ShowPdf", 0, 5, "5", "0", 0, 0, null, 0, 0, 0, 0, "", 9);
#endregion
#region field3
fields f3 = testHelpers.CreateField(0, "barcode", cl2, "f0f8db", "custom", 3, "", "Number Field Description",
83, 0, DbContext.field_types.Where(x => x.field_type == "number").First(), 0, 0, 1, 0,
"Numberfield", 1, 8, "4865", "0", 0, 1, null, 1, 0, 0, 0, "", 1);
#endregion
#region field4
fields f4 = testHelpers.CreateField(1, "barcode", cl2, "fff6df", "custom", null, "", "date Description",
84, 0, DbContext.field_types.Where(x => x.field_type == "comment").First(), 0, 0, 1, 0,
"Date", 1, 666, "41153", "0", 0, 1, null, 0, 1, 0, 0, "", 1);
#endregion
#region field5
fields f5 = testHelpers.CreateField(0, "barcode", cl2, "ffe4e4", "custom", null, "", "picture Description",
85, 0, DbContext.field_types.Where(x => x.field_type == "comment").First(), 1, 0, 1, 0,
"Picture", 1, 69, "69", "1", 0, 1, null, 0, 1, 0, 0, "", 1);
#endregion
#endregion
// Act
Field match = sut.FieldRead(f1.id);
// Assert
Assert.AreEqual(f1.id, match.Id);
}
public void SQL_Check_CheckListValueStatusRead_ReturnsCheckListValuesStatus()
{
// Arrance
#region Arrance
#region Template1
DateTime cl1_Ca = DateTime.Now;
DateTime cl1_Ua = DateTime.Now;
check_lists cl1 = testHelpers.CreateTemplate(cl1_Ca, cl1_Ua, "A", "D", "CheckList", "Template1FolderName", 1, 1);
#endregion
#region SubTemplate1
check_lists cl2 = testHelpers.CreateSubTemplate("A.1", "D.1", "CheckList", 1, 1, cl1);
#endregion
#region Fields
#region field1
fields f1 = testHelpers.CreateField(1, "barcode", cl2, "e2f4fb", "custom", null, "", "Comment field description",
5, 1, DbContext.field_types.Where(x => x.field_type == "picture").First(), 0, 0, 1, 0, "Comment field", 1, 55, "55", "0", 0, 0, null, 1, 0,
0, 0, "", 49);
#endregion
#region field2
fields f2 = testHelpers.CreateField(1, "barcode", cl2, "f5eafa", "custom", null, "", "showPDf Description",
45, 1, DbContext.field_types.Where(x => x.field_type == "picture").First(), 0, 1, 0, 0,
"ShowPdf", 0, 5, "5", "0", 0, 0, null, 0, 0, 0, 0, "", 9);
#endregion
#region field3
fields f3 = testHelpers.CreateField(0, "barcode", cl2, "f0f8db", "custom", 3, "", "Number Field Description",
83, 0, DbContext.field_types.Where(x => x.field_type == "picture").First(), 0, 0, 1, 0,
"Numberfield", 1, 8, "4865", "0", 0, 1, null, 1, 0, 0, 0, "", 1);
#endregion
#region field4
fields f4 = testHelpers.CreateField(1, "barcode", cl2, "fff6df", "custom", null, "", "date Description",
84, 0, DbContext.field_types.Where(x => x.field_type == "picture").First(), 0, 0, 1, 0,
"Date", 1, 666, "41153", "0", 0, 1, null, 0, 1, 0, 0, "", 1);
#endregion
#region field5
fields f5 = testHelpers.CreateField(0, "barcode", cl2, "ffe4e4", "custom", null, "", "picture Description",
85, 0, DbContext.field_types.Where(x => x.field_type == "picture").First(), 1, 0, 1, 0,
"Picture", 1, 69, "69", "1", 0, 1, null, 0, 1, 0, 0, "", 1);
#endregion
#endregion
#region Worker
workers worker = testHelpers.CreateWorker("*****@*****.**", "Arne", "Jensen", 21);
#endregion
#region site
sites site = testHelpers.CreateSite("SiteName", 88);
#endregion
#region units
units unit = testHelpers.CreateUnit(48, 49, site, 348);
#endregion
#region site_workers
site_workers site_workers = testHelpers.CreateSiteWorker(55, site, worker);
#endregion
#region Case1
cases aCase = testHelpers.CreateCase("caseUId", cl1, DateTime.Now, "custom", DateTime.Now,
worker, "microtingCheckUId", "microtingUId",
site, 66, "caseType", unit, DateTime.Now, 1, worker, Constants.WorkflowStates.Created);
#endregion
#region UploadedData
#region ud1
uploaded_data ud1 = testHelpers.CreateUploadedData("checksum", "File1", "no", "hjgjghjhg", "File1", 1, worker,
"local", 55, false);
#endregion
#region ud2
uploaded_data ud2 = testHelpers.CreateUploadedData("checksum", "File1", "no", "hjgjghjhg", "File2", 1, worker,
"local", 55, false);
#endregion
#region ud3
uploaded_data ud3 = testHelpers.CreateUploadedData("checksum", "File1", "no", "hjgjghjhg", "File3", 1, worker,
"local", 55, false);
#endregion
#region ud4
uploaded_data ud4 = testHelpers.CreateUploadedData("checksum", "File1", "no", "hjgjghjhg", "File4", 1, worker,
"local", 55, false);
#endregion
#region ud5
uploaded_data ud5 = testHelpers.CreateUploadedData("checksum", "File1", "no", "hjgjghjhg", "File5", 1, worker,
"local", 55, false);
#endregion
#endregion
#region Check List Values
check_list_values check_List_Values = testHelpers.CreateCheckListValue(aCase, cl2, "checked", null, 865);
#endregion
#region Field Values
#region fv1
field_values field_Value1 = testHelpers.CreateFieldValue(aCase, cl2, f1, ud1.id, null, "tomt1", 61234, worker);
#endregion
#region fv2
field_values field_Value2 = testHelpers.CreateFieldValue(aCase, cl2, f2, ud2.id, null, "tomt2", 61234, worker);
#endregion
#region fv3
field_values field_Value3 = testHelpers.CreateFieldValue(aCase, cl2, f3, ud3.id, null, "tomt3", 61234, worker);
#endregion
#region fv4
field_values field_Value4 = testHelpers.CreateFieldValue(aCase, cl2, f4, ud4.id, null, "tomt4", 61234, worker);
#endregion
#region fv5
field_values field_Value5 = testHelpers.CreateFieldValue(aCase, cl2, f5, ud5.id, null, "tomt5", 61234, worker);
#endregion
#endregion
#endregion
// Act
var match = sut.CheckListValueStatusRead(aCase.id, cl2.id);
// Assert
Assert.AreEqual(check_List_Values.status, "checked");
}
public async Task SQL_Unit_UnitUpdate_UpdatesUnit()
{
// Arrance
#region Arrance
#region Checklist
DateTime cl1_Ca = DateTime.Now;
DateTime cl1_Ua = DateTime.Now;
check_lists Cl1 = await testHelpers.CreateTemplate(cl1_Ca, cl1_Ua, "A1", "D1", "caseType1", "WhereItIs", 1, 0);
#endregion
#region SubCheckList
check_lists Cl2 = await testHelpers.CreateSubTemplate("A2", "D2", "caseType2", 2, 0, Cl1);
#endregion
#region Fields
#region field1
fields f1 = await testHelpers.CreateField(1, "barcode", Cl2, "e2f4fb", "custom", null, "", "Comment field description",
5, 1, dbContext.field_types.Where(x => x.FieldType == "picture").First(), 0, 0, 1, 0, "Comment field", 1, 55, "55", "0", 0, 0, null, 1, 0,
0, 0, "", 49);
#endregion
#region field2
fields f2 = await testHelpers.CreateField(1, "barcode", Cl2, "f5eafa", "custom", null, "", "showPDf Description",
45, 1, dbContext.field_types.Where(x => x.FieldType == "comment").First(), 0, 1, 0, 0,
"ShowPdf", 0, 5, "5", "0", 0, 0, null, 0, 0, 0, 0, "", 9);
#endregion
#region field3
fields f3 = await testHelpers.CreateField(0, "barcode", Cl2, "f0f8db", "custom", 3, "", "Number Field Description",
83, 0, dbContext.field_types.Where(x => x.FieldType == "picture").First(), 0, 0, 1, 0,
"Numberfield", 1, 8, "4865", "0", 0, 1, null, 1, 0, 0, 0, "", 1);
#endregion
#region field4
fields f4 = await testHelpers.CreateField(1, "barcode", Cl2, "fff6df", "custom", null, "", "date Description",
84, 0, dbContext.field_types.Where(x => x.FieldType == "picture").First(), 0, 0, 1, 0,
"Date", 1, 666, "41153", "0", 0, 1, null, 0, 1, 0, 0, "", 1);
#endregion
#region field5
fields f5 = await testHelpers.CreateField(0, "barcode", Cl2, "ffe4e4", "custom", null, "", "picture Description",
85, 0, dbContext.field_types.Where(x => x.FieldType == "comment").First(), 1, 0, 1, 0,
"Picture", 1, 69, "69", "1", 0, 1, null, 0, 1, 0, 0, "", 1);
#endregion
#region field6
fields f6 = await testHelpers.CreateField(0, "barcode", Cl2, "ffe4e4", "custom", null, "", "picture Description",
86, 0, dbContext.field_types.Where(x => x.FieldType == "comment").First(), 1, 0, 1, 0,
"Picture", 1, 69, "69", "1", 0, 1, null, 0, 1, 0, 0, "", 1);
#endregion
#region field7
fields f7 = await testHelpers.CreateField(0, "barcode", Cl2, "ffe4e4", "custom", null, "", "picture Description",
87, 0, dbContext.field_types.Where(x => x.FieldType == "comment").First(), 1, 0, 1, 0,
"Picture", 1, 69, "69", "1", 0, 1, null, 0, 1, 0, 0, "", 1);
#endregion
#region field8
fields f8 = await testHelpers.CreateField(0, "barcode", Cl2, "ffe4e4", "custom", null, "", "picture Description",
88, 0, dbContext.field_types.Where(x => x.FieldType == "comment").First(), 1, 0, 1, 0,
"Picture", 1, 69, "69", "1", 0, 1, null, 0, 1, 0, 0, "", 1);
#endregion
#region field9
fields f9 = await testHelpers.CreateField(0, "barcode", Cl2, "ffe4e4", "custom", null, "", "picture Description",
89, 0, dbContext.field_types.Where(x => x.FieldType == "comment").First(), 1, 0, 1, 0,
"Picture", 1, 69, "69", "1", 0, 1, null, 0, 1, 0, 0, "", 1);
#endregion
#region field10
fields f10 = await testHelpers.CreateField(0, "barcode", Cl2, "ffe4e4", "custom", null, "", "picture Description",
90, 0, dbContext.field_types.Where(x => x.FieldType == "comment").First(), 1, 0, 1, 0,
"Picture", 1, 69, "69", "1", 0, 1, null, 0, 1, 0, 0, "", 1);
#endregion
#endregion
#region Workers
#region worker1
workers worker1 = await testHelpers.CreateWorker("*****@*****.**", "Arne", "Jensen", 21);
#endregion
#region worker2
workers worker2 = await testHelpers.CreateWorker("*****@*****.**", "Lasse", "Johansen", 44);
#endregion
#region worker3
workers worker3 = await testHelpers.CreateWorker("*****@*****.**", "Svend", "Jensen", 22);
#endregion
#region worker4
workers worker4 = await testHelpers.CreateWorker("*****@*****.**", "Bjarne", "Nielsen", 23);
#endregion
#region worker5
workers worker5 = await testHelpers.CreateWorker("*****@*****.**", "Ib", "Hansen", 24);
#endregion
#region worker6
workers worker6 = await testHelpers.CreateWorker("*****@*****.**", "Hozan", "Aziz", 25);
#endregion
#region worker7
workers worker7 = await testHelpers.CreateWorker("*****@*****.**", "Nicolai", "Peders", 26);
#endregion
#region worker8
workers worker8 = await testHelpers.CreateWorker("*****@*****.**", "Amin", "Safari", 27);
#endregion
#region worker9
workers worker9 = await testHelpers.CreateWorker("*****@*****.**", "Leo", "Rebaz", 28);
#endregion
#region worker10
workers worker10 = await testHelpers.CreateWorker("*****@*****.**", "Stig", "Berthelsen", 29);
#endregion
#endregion
#region sites
#region Site1
sites site1 = await testHelpers.CreateSite("SiteName1", 88);
#endregion
#region Site2
sites site2 = await testHelpers.CreateSite("SiteName2", 89);
#endregion
#region Site3
sites site3 = await testHelpers.CreateSite("SiteName3", 90);
#endregion
#region Site4
sites site4 = await testHelpers.CreateSite("SiteName4", 91);
#endregion
#region Site5
sites site5 = await testHelpers.CreateSite("SiteName5", 92);
#endregion
#region Site6
sites site6 = await testHelpers.CreateSite("SiteName6", 93);
#endregion
#region Site7
sites site7 = await testHelpers.CreateSite("SiteName7", 94);
#endregion
#region Site8
sites site8 = await testHelpers.CreateSite("SiteName8", 95);
#endregion
#region Site9
sites site9 = await testHelpers.CreateSite("SiteName9", 96);
#endregion
#region Site10
sites site10 = await testHelpers.CreateSite("SiteName10", 97);
#endregion
#endregion
#region units
#region Unit1
units unit1 = await testHelpers.CreateUnit(48, 49, site1, 348);
#endregion
#region Unit2
units unit2 = await testHelpers.CreateUnit(2, 55, site2, 349);
#endregion
#region Unit3
units unit3 = await testHelpers.CreateUnit(3, 51, site3, 350);
#endregion
#region Unit4
units unit4 = await testHelpers.CreateUnit(4, 52, site4, 351);
#endregion
#region Unit5
units unit5 = await testHelpers.CreateUnit(5, 6, site5, 352);
#endregion
#region Unit6
units unit6 = await testHelpers.CreateUnit(6, 85, site6, 353);
#endregion
#region Unit7
units unit7 = await testHelpers.CreateUnit(7, 62, site7, 354);
#endregion
#region Unit8
units unit8 = await testHelpers.CreateUnit(8, 96, site8, 355);
#endregion
#region Unit9
units unit9 = await testHelpers.CreateUnit(9, 69, site9, 356);
#endregion
#region Unit10
units unit10 = await testHelpers.CreateUnit(10, 100, site10, 357);
#endregion
#endregion
#region site_workers
site_workers site_workers = await testHelpers.CreateSiteWorker(55, site1, worker1);
#endregion
#endregion
// Act
var match = await sut.UnitUpdate((int)unit1.MicrotingUid, (int)unit1.CustomerNo, (int)unit1.OtpCode, (int)unit1.SiteId);
// Assert
Assert.True(match);
}
public ActionResult Index(MotaskraningModel empmodel)
{
// Gera eithvað við upplýsingarnar
// Kalla á SendToJira fall með upplýsingunum úr epmodel
string upplysingar = empmodel.skraning.DagsFra + ";" + empmodel.skraning.DagsTil + ";" + empmodel.skraning.motshaldari + ";" + empmodel.skraning.stadsetning + ";" + empmodel.skraning.domari;
if (empmodel.Greinar != null)
{
foreach (var grein in empmodel.Greinar)
{
upplysingar += ";" + grein.gerdGreinar + ";" + grein.nafnGreinar;
}
}
fieldHolder JiraDot = new fieldHolder();
fields fields = new fields();
Project verkefni = new Project();
verkefni.key = "PRUFA";
fields.project = verkefni;
fields.summary = "Prufa frá Motaskraningarforriti.";
fields.description = upplysingar;
Issuetype issType = new Issuetype();
issType.name = "Task";
fields.issuetype = issType;
Assignee assignee = new Assignee();
assignee.name = "jira-software-users";
fields.assignee = assignee;
JiraDot.fields = fields;
SendToJira(JiraDot);
// Ná í og skila upphafsupplýsingum
/*List<Domari> Domarar = NaIDomara();
*
* List<Grein> Greinar = NaIGreinar();
*
* MotaskraningModel model = new MotaskraningModel();
*
* model.Domarar = Domarar;
* model.Greinar = Greinar;
* model.skraning = new Skraning();
*
* List<SelectListItem> listi = new List<SelectListItem>();
*
* foreach (Domari dom in Domarar)
* {
* listi.Add(new SelectListItem()
* {
* Text = dom.nafn,
* Value = dom.nafn
* });
* }
*
* SelectList val = new SelectList(listi, "Value", "Text"); // (Greinar, "nafnGreinar", "gerdGreinar");
*
* ViewBag.CityList = val;*/
List <Domari> Domarar = NaIDomara();
List <List <TextValueHolder> > Greinar = NaIGreinar();
List <string> Haldarar = NaIMotshaldara();
List <TextValueHolder> Stadsetningar = NaIStadsetningar();
MotaskraningModel model = new MotaskraningModel();
//model.Domarar = Domarar;
//model.Greinar = Greinar;
model.skraning = new Skraning();
List <SelectListItem> listi = new List <SelectListItem>();
foreach (Domari dom in Domarar)
{
listi.Add(new SelectListItem()
{
Text = dom.nafn,
Value = dom.nafn
});
}
SelectList val = new SelectList(listi, "Value", "Text"); // (Greinar, "nafnGreinar", "gerdGreinar");
List <SelectListItem> listi2 = new List <SelectListItem>();
foreach (string dom in Haldarar)
{
listi2.Add(new SelectListItem()
{
Text = dom,
Value = dom
});
}
SelectList val2 = new SelectList(listi2, "Value", "Text"); // (Greinar, "nafnGreinar", "gerdGreinar");
List <SelectListItem> listi3 = new List <SelectListItem>();
foreach (TextValueHolder dom in Stadsetningar)
{
listi3.Add(new SelectListItem()
{
Text = dom.Text,
Value = dom.Value
});
}
SelectList val3 = new SelectList(listi3, "Value", "Text"); // (Greinar, "nafnGreinar", "gerdGreinar");
List <SelectListItem> listi4 = new List <SelectListItem>();
foreach (TextValueHolder dom in Greinar[0])
{
listi4.Add(new SelectListItem()
{
Text = dom.Text,
Value = dom.Value
});
}
SelectList val4 = new SelectList(listi4, "Value", "Text"); // (Greinar, "nafnGreinar", "gerdGreinar");
List <SelectListItem> listi5 = new List <SelectListItem>();
foreach (TextValueHolder dom in Greinar[1])
{
listi5.Add(new SelectListItem()
{
Text = dom.Text,
Value = dom.Value
});
}
SelectList val5 = new SelectList(listi5, "Value", "Text"); // (Greinar, "nafnGreinar", "gerdGreinar");
List <SelectListItem> listi6 = new List <SelectListItem>();
foreach (TextValueHolder dom in Greinar[2])
{
listi6.Add(new SelectListItem()
{
Text = dom.Text,
Value = dom.Value
});
}
SelectList val6 = new SelectList(listi6, "Value", "Text"); // (Greinar, "nafnGreinar", "gerdGreinar");
List <SelectListItem> listi7 = new List <SelectListItem>();
foreach (TextValueHolder dom in Greinar[3])
{
listi7.Add(new SelectListItem()
{
Text = dom.Text,
Value = dom.Value
});
}
SelectList val7 = new SelectList(listi7, "Value", "Text"); // (Greinar, "nafnGreinar", "gerdGreinar");
ViewBag.CityList = val;
ViewBag.CityList2 = val2;
ViewBag.CityList3 = val3;
ViewBag.GreinarInniKarla = val4;
ViewBag.GreinarInniKvenna = val5;
ViewBag.GreinarUtiKarla = val6;
ViewBag.GreinarUtiKvenna = val7;
return(View(model));
}
public async Task SQL_Check_FieldValueReadList_ReturnsList()
{
// Arrance
#region Arrance
Random rnd = new Random();
#region Template1
DateTime cl1_Ca = DateTime.Now;
DateTime cl1_Ua = DateTime.Now;
check_lists cl1 = await testHelpers.CreateTemplate(cl1_Ca, cl1_Ua, "A", "D", "CheckList", "Template1FolderName", 1, 1);
#endregion
#region SubTemplate1
check_lists cl2 = await testHelpers.CreateSubTemplate("A.1", "D.1", "CheckList", 1, 1, cl1);
#endregion
#region Fields
#region field1
fields f1 = await testHelpers.CreateField(1, "barcode", cl2, "e2f4fb", "custom", null, "", "Comment field description",
5, 1, dbContext.field_types.Where(x => x.FieldType == "comment").First(), 0, 0, 1, 0, "Comment field", 1, 55, "55", "0", 0, 0, null, 1, 0,
0, 0, "", 49);
#endregion
#region field2
fields f2 = await testHelpers.CreateField(1, "barcode", cl2, "f5eafa", "custom", null, "", "showPDf Description",
45, 1, dbContext.field_types.Where(x => x.FieldType == "comment").First(), 0, 1, 0, 0,
"ShowPdf", 0, 5, "5", "0", 0, 0, null, 0, 0, 0, 0, "", 9);
#endregion
#region field3
fields f3 = await testHelpers.CreateField(0, "barcode", cl2, "f0f8db", "custom", 3, "", "Number Field Description",
83, 0, dbContext.field_types.Where(x => x.FieldType == "number").First(), 0, 0, 1, 0,
"Numberfield", 1, 8, "4865", "0", 0, 1, null, 1, 0, 0, 0, "", 1);
#endregion
#region field4
fields f4 = await testHelpers.CreateField(1, "barcode", cl2, "fff6df", "custom", null, "", "date Description",
84, 0, dbContext.field_types.Where(x => x.FieldType == "comment").First(), 0, 0, 1, 0,
"Date", 1, 666, "41153", "0", 0, 1, null, 0, 1, 0, 0, "", 1);
#endregion
#region field5
fields f5 = await testHelpers.CreateField(0, "barcode", cl2, "ffe4e4", "custom", null, "", "picture Description",
85, 0, dbContext.field_types.Where(x => x.FieldType == "comment").First(), 1, 0, 1, 0,
"Picture", 1, 69, "69", "1", 0, 1, null, 0, 1, 0, 0, "", 1);
#endregion
#endregion
#region Worker
workers worker = await testHelpers.CreateWorker("*****@*****.**", "Arne", "Jensen", 21);
#endregion
#region site
sites site = await testHelpers.CreateSite("SiteName", 88);
#endregion
#region units
units unit = await testHelpers.CreateUnit(48, 49, site, 348);
#endregion
#region site_workers
site_workers site_workers = await testHelpers.CreateSiteWorker(55, site, worker);
#endregion
#region Case1
cases aCase = await testHelpers.CreateCase("caseUId", cl1, DateTime.Now, "custom", DateTime.Now,
worker, rnd.Next(1, 255), rnd.Next(1, 255),
site, 66, "caseType", unit, DateTime.Now, 1, worker, Constants.WorkflowStates.Created);
#endregion
#region Check List Values
check_list_values check_List_Values = await testHelpers.CreateCheckListValue(aCase, cl2, "completed", null, 865);
#endregion
#region Field Values
#region fv1
field_values field_Value1 = await testHelpers.CreateFieldValue(aCase, cl2, f1, null, null, "tomt1", 61234, worker);
#endregion
#region fv2
field_values field_Value2 = await testHelpers.CreateFieldValue(aCase, cl2, f2, null, null, "tomt2", 61234, worker);
#endregion
#region fv3
field_values field_Value3 = await testHelpers.CreateFieldValue(aCase, cl2, f3, null, null, "tomt3", 61234, worker);
#endregion
#region fv4
field_values field_Value4 = await testHelpers.CreateFieldValue(aCase, cl2, f4, null, null, "tomt4", 61234, worker);
#endregion
#region fv5
field_values field_Value5 = await testHelpers.CreateFieldValue(aCase, cl2, f5, null, null, "tomt5", 61234, worker);
#endregion
#endregion
#endregion
// Act
List <FieldValue> match = await sut.FieldValueReadList(f1.Id, 5);
// Assert
Assert.AreEqual(field_Value1.Value, match[0].Value);
}
//protected string deleteDataTable(DataTable dt)
//{
// string ret = "";
// string tableName = DataTableName(dt);
// return ret;
//}
public string ImportDataTableSaveas(DataTable dt
, string saveAsNewTablename = "", bool append = false)
{
string ret = "";
Console.WriteLine(DateTime.Now.ToString("HH:mm:ss") + " ImportDataTableSaveas 1");
if (saveAsNewTablename == "")
{
saveAsNewTablename = DataTableName(dt);
}
// import datatable save as new table
// if new table existed, append false to overwrite
// delete target table
if (!append)
{
Console.WriteLine(DateTime.Now.ToString("HH:mm:ss") + " ImportDataTableSaveas 2b");
dbBig.deleteTag(saveAsNewTablename);
Console.WriteLine(DateTime.Now.ToString("HH:mm:ss") + " ImportDataTableSaveas 2");
dbBig.deleteTable(saveAsNewTablename);
}
Console.WriteLine(DateTime.Now.ToString("HH:mm:ss") + " ImportDataTableSaveas 3");
// write to tables
tables tbl = new tables();
tbl.tableName = saveAsNewTablename;
Guid tableId;
ret = dbBig.insertTable(tbl, out tableId,
saveAsNewTablename);
Console.WriteLine(DateTime.Now.ToString("HH:mm:ss") + " ImportDataTableSaveas 4");
// write to fields
List <string> colNames = DataTableColumnNames(dt);
List <string> colTypes = DataTableColumnTypes(dt);
Dictionary <string, Guid> name2id = new Dictionary <string, Guid>();
for (int i = 0; i < colNames.Count && i < colTypes.Count; i++)
{
fields fld = new fields();
fld.fieldName = colNames[i];
fld.fieldDesc = colTypes[i];
fld.tableId = tableId;
fld.defaultOrder = i + 1;
Guid fieldId = Guid.Empty;
ret = dbBig.insertField(fld, out fieldId,
saveAsNewTablename);
name2id.Add(fld.fieldName, fieldId);
//Console.WriteLine(DateTime.Now.ToString("HH:mm:ss") + " ImportDataTableSaveas 5 i="+i);
}
Console.WriteLine(DateTime.Now.ToString("HH:mm:ss") + " ImportDataTableSaveas 6");
List <Dictionary <string, string> > dtCells =
DataTableCellValue(dt);
int j = 0;
foreach (Dictionary <string, string> rowCols in dtCells)
{
// write to rows
Guid rowId = Guid.Empty;
rows rw = new rows();
rw.tableId = tableId;
ret = dbBig.insertRow(rw, out rowId,
saveAsNewTablename);
if (++j % 10000 == 0)
{
Console.WriteLine(DateTime.Now.ToString("HH:mm:ss") +
$" ImportDataTableSaveas 7 [{j}/{dtCells.Count}]");
}
// write to field values
foreach (KeyValuePair <string, string> pair in rowCols)
{
fieldValues fv = new fieldValues();
fv.rowId = rowId;
fv.fieldId = name2id[pair.Key];
fv.fieldValue = pair.Value;
ret = dbBig.insertFieldValue(fv);
}
}
Console.WriteLine(DateTime.Now.ToString("HH:mm:ss") + " ImportDataTableSaveas 8 end");
return(ret);
}
public void SQL_Site_SiteGetAll_DoesReturnAllSites()
{
// Arrance
#region Arrance
#region Checklist
DateTime cl1_Ca = DateTime.Now;
DateTime cl1_Ua = DateTime.Now;
check_lists Cl1 = testHelpers.CreateTemplate(cl1_Ca, cl1_Ua, "A1", "D1", "caseType1", "WhereItIs", 1, 0);
#endregion
#region SubCheckList
check_lists Cl2 = testHelpers.CreateSubTemplate("A2", "D2", "caseType2", 2, 0, Cl1);
#endregion
#region Fields
#region field1
fields f1 = testHelpers.CreateField(1, "barcode", Cl2, "e2f4fb", "custom", null, "", "Comment field description",
5, 1, DbContext.field_types.Where(x => x.field_type == "picture").First(), 0, 0, 1, 0, "Comment field", 1, 55, "55", "0", 0, 0, null, 1, 0,
0, 0, "", 49);
#endregion
#region field2
fields f2 = testHelpers.CreateField(1, "barcode", Cl2, "f5eafa", "custom", null, "", "showPDf Description",
45, 1, DbContext.field_types.Where(x => x.field_type == "comment").First(), 0, 1, 0, 0,
"ShowPdf", 0, 5, "5", "0", 0, 0, null, 0, 0, 0, 0, "", 9);
#endregion
#region field3
fields f3 = testHelpers.CreateField(0, "barcode", Cl2, "f0f8db", "custom", 3, "", "Number Field Description",
83, 0, DbContext.field_types.Where(x => x.field_type == "picture").First(), 0, 0, 1, 0,
"Numberfield", 1, 8, "4865", "0", 0, 1, null, 1, 0, 0, 0, "", 1);
#endregion
#region field4
fields f4 = testHelpers.CreateField(1, "barcode", Cl2, "fff6df", "custom", null, "", "date Description",
84, 0, DbContext.field_types.Where(x => x.field_type == "picture").First(), 0, 0, 1, 0,
"Date", 1, 666, "41153", "0", 0, 1, null, 0, 1, 0, 0, "", 1);
#endregion
#region field5
fields f5 = testHelpers.CreateField(0, "barcode", Cl2, "ffe4e4", "custom", null, "", "picture Description",
85, 0, DbContext.field_types.Where(x => x.field_type == "comment").First(), 1, 0, 1, 0,
"Picture", 1, 69, "69", "1", 0, 1, null, 0, 1, 0, 0, "", 1);
#endregion
#region field6
fields f6 = testHelpers.CreateField(0, "barcode", Cl2, "ffe4e4", "custom", null, "", "picture Description",
86, 0, DbContext.field_types.Where(x => x.field_type == "comment").First(), 1, 0, 1, 0,
"Picture", 1, 69, "69", "1", 0, 1, null, 0, 1, 0, 0, "", 1);
#endregion
#region field7
fields f7 = testHelpers.CreateField(0, "barcode", Cl2, "ffe4e4", "custom", null, "", "picture Description",
87, 0, DbContext.field_types.Where(x => x.field_type == "comment").First(), 1, 0, 1, 0,
"Picture", 1, 69, "69", "1", 0, 1, null, 0, 1, 0, 0, "", 1);
#endregion
#region field8
fields f8 = testHelpers.CreateField(0, "barcode", Cl2, "ffe4e4", "custom", null, "", "picture Description",
88, 0, DbContext.field_types.Where(x => x.field_type == "comment").First(), 1, 0, 1, 0,
"Picture", 1, 69, "69", "1", 0, 1, null, 0, 1, 0, 0, "", 1);
#endregion
#region field9
fields f9 = testHelpers.CreateField(0, "barcode", Cl2, "ffe4e4", "custom", null, "", "picture Description",
89, 0, DbContext.field_types.Where(x => x.field_type == "comment").First(), 1, 0, 1, 0,
"Picture", 1, 69, "69", "1", 0, 1, null, 0, 1, 0, 0, "", 1);
#endregion
#region field10
fields f10 = testHelpers.CreateField(0, "barcode", Cl2, "ffe4e4", "custom", null, "", "picture Description",
90, 0, DbContext.field_types.Where(x => x.field_type == "comment").First(), 1, 0, 1, 0,
"Picture", 1, 69, "69", "1", 0, 1, null, 0, 1, 0, 0, "", 1);
#endregion
#endregion
#region Worker
workers worker = testHelpers.CreateWorker("*****@*****.**", "Arne", "Jensen", 21);
#endregion
#region sites
#region Site1
sites site1 = testHelpers.CreateSite("SiteName1", 88);
#endregion
#region Site2
sites site2 = testHelpers.CreateSite("SiteName2", 88);
#endregion
#region Site3
sites site3 = testHelpers.CreateSite("SiteName3", 88);
#endregion
#region Site4
sites site4 = testHelpers.CreateSite("SiteName4", 88);
#endregion
#region Site5
sites site5 = testHelpers.CreateSite("SiteName5", 88);
#endregion
#region Site6
sites site6 = testHelpers.CreateSite("SiteName6", 88);
#endregion
#region Site7
sites site7 = testHelpers.CreateSite("SiteName7", 88);
#endregion
#region Site8
sites site8 = testHelpers.CreateSite("SiteName8", 88);
#endregion
#region Site9
sites site9 = testHelpers.CreateSite("SiteName9", 88);
#endregion
#region Site10
sites site10 = testHelpers.CreateSite("SiteName10", 88);
#endregion
#endregion
#endregion
// Act
var getAllSitesOnlyCreated = sut.SiteGetAll(false).ToList();
var getAllSitesInclRemoved = sut.SiteGetAll(true).ToList();
// Assert
Assert.True(true);
Assert.AreEqual(10, getAllSitesOnlyCreated.Count());
Assert.AreEqual(10, getAllSitesInclRemoved.Count());
Assert.AreEqual(site1.name, getAllSitesOnlyCreated[0].SiteName);
Assert.AreEqual(site2.name, getAllSitesOnlyCreated[1].SiteName);
Assert.AreEqual(site3.name, getAllSitesOnlyCreated[2].SiteName);
Assert.AreEqual(site4.name, getAllSitesOnlyCreated[3].SiteName);
Assert.AreEqual(site5.name, getAllSitesOnlyCreated[4].SiteName);
Assert.AreEqual(site6.name, getAllSitesOnlyCreated[5].SiteName);
Assert.AreEqual(site7.name, getAllSitesOnlyCreated[6].SiteName);
Assert.AreEqual(site8.name, getAllSitesOnlyCreated[7].SiteName);
Assert.AreEqual(site9.name, getAllSitesOnlyCreated[8].SiteName);
Assert.AreEqual(site10.name, getAllSitesOnlyCreated[9].SiteName);
Assert.AreEqual(site1.name, getAllSitesInclRemoved[0].SiteName);
Assert.AreEqual(site2.name, getAllSitesInclRemoved[1].SiteName);
Assert.AreEqual(site3.name, getAllSitesInclRemoved[2].SiteName);
Assert.AreEqual(site4.name, getAllSitesInclRemoved[3].SiteName);
Assert.AreEqual(site5.name, getAllSitesInclRemoved[4].SiteName);
Assert.AreEqual(site6.name, getAllSitesInclRemoved[5].SiteName);
Assert.AreEqual(site7.name, getAllSitesInclRemoved[6].SiteName);
Assert.AreEqual(site8.name, getAllSitesInclRemoved[7].SiteName);
Assert.AreEqual(site9.name, getAllSitesInclRemoved[8].SiteName);
Assert.AreEqual(site10.name, getAllSitesInclRemoved[9].SiteName);
}
public string CreateMultiPictureXMLResult(bool create)
{
if (create)
{
sites site = testHelpers.CreateSite("TestSite1", 12334);
units unit = testHelpers.CreateUnit(20934, 234234, site, 24234);
workers worker = testHelpers.CreateWorker("*****@*****.**", "John", "Doe", 2342341);
site_workers sw = testHelpers.CreateSiteWorker(242345, site, worker);
DateTime cl1_ca = DateTime.Now;
DateTime cl1_ua = DateTime.Now;
check_lists cl1 = testHelpers.CreateTemplate(cl1_ca, cl1_ua, "MultiPictureXMLResult", "MultiPictureXMLResult_Description", "", "", 0, 0);
check_lists cl2 = testHelpers.CreateSubTemplate("Sub1", "Sub1Description", "", 0, 0, cl1);
fields f1 = testHelpers.CreateField(0, "", cl2, Constants.FieldColors.Blue, "", null, "", "PictureDescription", 0, 0, testHelpers.DbContext.field_types.Where(x => x.field_type == "picture").First(), 0, 0, 0, 0, "Take picture", 0, 0, "", "", 0, 0, "", 0, 0, 0, 0, "", 0);
check_list_sites cls = testHelpers.CreateCheckListSite(cl1, cl1_ca, site, cl1_ua, 0, Constants.WorkflowStates.Created, "MultiPictureTestInMultipleChecks");
//returnXML = ;
return("MultiPictureTestInMultipleChecks");
}
else
{
sites site = testHelpers.DbContext.sites.First();
units unit = testHelpers.DbContext.units.First();
workers worker = testHelpers.DbContext.workers.First();
check_lists cl1 = testHelpers.DbContext.check_lists.ToList()[0];
check_lists cl2 = testHelpers.DbContext.check_lists.ToList()[1];
fields f1 = testHelpers.DbContext.fields.First();
#region return xml
return($@"<?xml version='1.0' encoding='UTF-8'?>
<Response>
<Value type='success'>MultiPictureTestInMultipleChecks</Value>
<Checks>
<Check worker='John Doe' worker_id='{worker.microting_uid}' date='2018-04-25 14:29:21 +0200' unit_id='{unit.microting_uid}' id='7'>
<ElementList>
<Id>{cl2.id}</Id>
<Status>approved</Status>
<DataItemList>
<DataItem>
<Id>{f1.id}</Id>
<Geolocation>
<Latitude></Latitude>
<Longitude></Longitude>
<Altitude></Altitude>
<Heading></Heading>
<Accuracy></Accuracy>
<Date></Date>
</Geolocation>
<Value></Value>
<Extension>.jpeg</Extension>
<URL>https://www.microting.com/wp-content/themes/Artificial-Reason-WP/img/close.png</URL>
</DataItem>
</DataItemList>
<ExtraDataItemList></ExtraDataItemList>
</ElementList>
</Check>
<Check worker='John Doe' worker_id='{worker.microting_uid}' date='2018-04-25 14:29:52 +0200' unit_id='{unit.microting_uid}' id='12'>
<ElementList>
<Id>{cl2.id}</Id>
<Status>approved</Status>
<DataItemList>
<DataItem>
<Id>{f1.id}</Id>
<Geolocation>
<Latitude></Latitude>
<Longitude></Longitude>
<Altitude></Altitude>
<Heading></Heading>
<Accuracy></Accuracy>
<Date></Date>
</Geolocation>
<Value></Value>
<Extension>.jpeg</Extension>
<URL>https://www.microting.com/wp-content/themes/Artificial-Reason-WP/img/close.png</URL>
</DataItem>
<DataItem>
<Id>{f1.id}</Id>
<Geolocation>
<Latitude></Latitude>
<Longitude></Longitude>
<Altitude></Altitude>
<Heading></Heading>
<Accuracy></Accuracy>
<Date></Date>
</Geolocation>
<Value></Value>
<Extension>.jpeg</Extension>
<URL>https://www.microting.com/wp-content/themes/Artificial-Reason-WP/img/close.png</URL>
</DataItem>
</DataItemList>
<ExtraDataItemList></ExtraDataItemList>
</ElementList>
</Check>
<Check worker='John Doe' worker_id='{worker.microting_uid}' date='2018-04-25 14:39:43 +0200' unit_id='{unit.microting_uid}' id='17'>
<ElementList>
<Id>{cl2.id}</Id>
<Status>approved</Status>
<DataItemList>
<DataItem>
<Id>{f1.id}</Id>
<Geolocation>
<Latitude></Latitude>
<Longitude></Longitude>
<Altitude></Altitude>
<Heading></Heading>
<Accuracy></Accuracy>
<Date></Date>
</Geolocation>
<Value></Value>
<Extension>.jpeg</Extension>
<URL>https://www.microting.com/wp-content/themes/Artificial-Reason-WP/img/close.png</URL>
</DataItem>
<DataItem>
<Id>{f1.id}</Id>
<Geolocation>
<Latitude></Latitude>
<Longitude></Longitude>
<Altitude></Altitude>
<Heading></Heading>
<Accuracy></Accuracy>
<Date></Date>
</Geolocation>
<Value></Value>
<Extension>.jpeg</Extension>
<URL>https://www.microting.com/wp-content/themes/Artificial-Reason-WP/img/close.png</URL>
</DataItem>
</DataItemList>
<ExtraDataItemList></ExtraDataItemList>
</ElementList>
</Check>
</Checks>
</Response>".Replace("'", "\""));
#endregion
}
}
//открытия бд и создание информации о каждой таблицы
public bool open_db_and_show_info()
{
q_conn = new SQLiteConnection();
q_conn.ConnectionString = "Data source =" + path_to_db + ";";
db_conn_open();
q_comm = new SQLiteCommand(q_conn);
//извлечение информации о таблицах
q_comm.CommandText = "SELECT name FROM sqlite_master WHERE type =\"table\" order by name;";
SQLiteDataReader q_rd = q_comm.ExecuteReader();
comboBox1.Items.Clear();
clear(1);
if (q_rd.FieldCount > 0)
//заполнение коллекции таблиц
while (q_rd.Read())
{
if (q_rd["name"].ToString() != "sqlite_sequence")
{
info_tbl inf = new info_tbl();
//имя базы данных
inf.name_tbl = q_rd["name"].ToString();
//
informations_of_tbl.Add(inf);
}
}
//заполение comboBox именами таблиц
foreach (info_tbl tb in informations_of_tbl)
{
comboBox1.Items.Add(tb.name_tbl);
}
if (comboBox1.Items.Count > 0)
comboBox1.SelectedItem = comboBox1.Items[0];
for (int i = 0; i < informations_of_tbl.Count; i++)
{
info_tbl tbl = (info_tbl)informations_of_tbl[i];
q_comm = new SQLiteCommand(q_conn);
q_comm.CommandText = "PRAGMA TABLE_INFO(" + tbl.name_tbl + ");";
SQLHistory(q_comm.CommandText);
q_rd = q_comm.ExecuteReader();
if (q_rd.FieldCount > 0)
while (q_rd.Read())
{
//структура для хранения имен и типов полей таблицы
fields fld = new fields();
fld.cid = Convert.ToInt32(q_rd[0]);
fld.name_f = q_rd["name"].ToString();
fld.type_f = q_rd["type"].ToString();
fld.primary_key = Convert.ToInt32(q_rd["pk"]);
tbl.fields_arr.Add(fld);
}
informations_of_tbl.RemoveAt(i);
informations_of_tbl.Insert(i, tbl);
}
return true;
}
public async Task SQL_Check_CheckListValueStatusUpdate_UpdatesCheckListValues()
{
// Arrance
#region Arrance
Random rnd = new Random();
#region Template1
DateTime cl1_Ca = DateTime.Now;
DateTime cl1_Ua = DateTime.Now;
check_lists cl1 = await testHelpers.CreateTemplate(cl1_Ca, cl1_Ua, "A", "D", "CheckList", "Template1FolderName", 1, 1);
#endregion
#region SubTemplate1
check_lists cl2 = await testHelpers.CreateSubTemplate("A.1", "D.1", "CheckList", 1, 1, cl1);
#endregion
#region Fields
#region field1
fields f1 = await testHelpers.CreateField(1, "barcode", cl2, "e2f4fb", "custom", null, "", "Comment field description",
5, 1, dbContext.field_types.Where(x => x.FieldType == "picture").First(), 0, 0, 1, 0, "Comment field", 1, 55, "55", "0", 0, 0, null, 1, 0,
0, 0, "", 49);
#endregion
#region field2
fields f2 = await testHelpers.CreateField(1, "barcode", cl2, "f5eafa", "custom", null, "", "showPDf Description",
45, 1, dbContext.field_types.Where(x => x.FieldType == "picture").First(), 0, 1, 0, 0,
"ShowPdf", 0, 5, "5", "0", 0, 0, null, 0, 0, 0, 0, "", 9);
#endregion
#region field3
fields f3 = await testHelpers.CreateField(0, "barcode", cl2, "f0f8db", "custom", 3, "", "Number Field Description",
83, 0, dbContext.field_types.Where(x => x.FieldType == "picture").First(), 0, 0, 1, 0,
"Numberfield", 1, 8, "4865", "0", 0, 1, null, 1, 0, 0, 0, "", 1);
#endregion
#region field4
fields f4 = await testHelpers.CreateField(1, "barcode", cl2, "fff6df", "custom", null, "", "date Description",
84, 0, dbContext.field_types.Where(x => x.FieldType == "picture").First(), 0, 0, 1, 0,
"Date", 1, 666, "41153", "0", 0, 1, null, 0, 1, 0, 0, "", 1);
#endregion
#region field5
fields f5 = await testHelpers.CreateField(0, "barcode", cl2, "ffe4e4", "custom", null, "", "picture Description",
85, 0, dbContext.field_types.Where(x => x.FieldType == "picture").First(), 1, 0, 1, 0,
"Picture", 1, 69, "69", "1", 0, 1, null, 0, 1, 0, 0, "", 1);
#endregion
#endregion
#region Worker
workers worker = await testHelpers.CreateWorker("*****@*****.**", "Arne", "Jensen", 21);
#endregion
#region site
sites site = await testHelpers.CreateSite("SiteName", 88);
#endregion
#region units
units unit = await testHelpers.CreateUnit(48, 49, site, 348);
#endregion
#region site_workers
site_workers site_workers = await testHelpers.CreateSiteWorker(55, site, worker);
#endregion
#region Case1
cases aCase = await testHelpers.CreateCase("caseUId", cl1, DateTime.Now, "custom", DateTime.Now,
worker, rnd.Next(1, 255), rnd.Next(1, 255),
site, 66, "caseType", unit, DateTime.Now, 1, worker, Constants.WorkflowStates.Created);
#endregion
#region UploadedData
#region ud1
uploaded_data ud1 = await testHelpers.CreateUploadedData("checksum", "File1", "no", "hjgjghjhg", "File1", 1, worker,
"local", 55, false);
#endregion
#region ud2
uploaded_data ud2 = await testHelpers.CreateUploadedData("checksum", "File1", "no", "hjgjghjhg", "File2", 1, worker,
"local", 55, false);
#endregion
#region ud3
uploaded_data ud3 = await testHelpers.CreateUploadedData("checksum", "File1", "no", "hjgjghjhg", "File3", 1, worker,
"local", 55, false);
#endregion
#region ud4
uploaded_data ud4 = await testHelpers.CreateUploadedData("checksum", "File1", "no", "hjgjghjhg", "File4", 1, worker,
"local", 55, false);
#endregion
#region ud5
uploaded_data ud5 = await testHelpers.CreateUploadedData("checksum", "File1", "no", "hjgjghjhg", "File5", 1, worker,
"local", 55, false);
#endregion
#endregion
#region Check List Values
check_list_values check_List_Values = await testHelpers.CreateCheckListValue(aCase, cl2, "checked", null, 865);
#endregion
#region Field Values
#region fv1
field_values field_Value1 = await testHelpers.CreateFieldValue(aCase, cl2, f1, ud1.Id, null, "tomt1", 61234, worker);
#endregion
#region fv2
field_values field_Value2 = await testHelpers.CreateFieldValue(aCase, cl2, f2, ud2.Id, null, "tomt2", 61234, worker);
#endregion
#region fv3
field_values field_Value3 = await testHelpers.CreateFieldValue(aCase, cl2, f3, ud3.Id, null, "tomt3", 61234, worker);
#endregion
#region fv4
field_values field_Value4 = await testHelpers.CreateFieldValue(aCase, cl2, f4, ud4.Id, null, "tomt4", 61234, worker);
#endregion
#region fv5
field_values field_Value5 = await testHelpers.CreateFieldValue(aCase, cl2, f5, ud5.Id, null, "tomt5", 61234, worker);
#endregion
#endregion
#endregion
// Act
await sut.CheckListValueStatusUpdate(aCase.Id, cl2.Id, "not_approved");
// Assert
var newValue = await dbContext.check_list_values.AsNoTracking().SingleOrDefaultAsync(x => x.Id == check_List_Values.Id);
Assert.AreEqual(newValue.Status, "not_approved");
}
public async Task Core_Template_TemplateItemRead_ReadsTemplateItems()
{
// Arrance
#region Templates
#region template1
DateTime cl1_ca = DateTime.Now;
DateTime cl1_ua = DateTime.Now;
check_lists Template1 = await testHelpers.CreateTemplate(cl1_ca, cl1_ua, "Label1", "Description1",
"CaseType1", "FolderWithTemplate", 1, 0);
#endregion
#region template2
DateTime cl2_ca = DateTime.Now;
DateTime cl2_ua = DateTime.Now;
check_lists Template2 = await testHelpers.CreateTemplate(cl2_ca, cl2_ua, "Label2", "Description2",
"CaseType2", "FolderWithTemplate", 0, 1);
#endregion
#region template3
DateTime cl3_ca = DateTime.Now;
DateTime cl3_ua = DateTime.Now;
check_lists Template3 = await testHelpers.CreateTemplate(cl3_ca, cl3_ua, "Label3", "Description3",
"CaseType3", "FolderWithTemplate", 1, 1);
#endregion
#region template4
DateTime cl4_ca = DateTime.Now;
DateTime cl4_ua = DateTime.Now;
check_lists Template4 = await testHelpers.CreateTemplate(cl4_ca, cl4_ua, "Label4", "Description4",
"CaseType4", "FolderWithTemplate", 0, 0);
#endregion
#endregion
#region SubTemplates
#region subTemplate1
check_lists subTemplate1 = await testHelpers.CreateSubTemplate("SubLabel1", "SubDescription1",
"CaseType1", 1, 0, Template1);
#endregion
#region subTemplate2
check_lists subTemplate2 = await testHelpers.CreateSubTemplate("SubLabel2", "SubDescription2",
"CaseType2", 0, 1, Template2);
#endregion
#region subTemplate3
check_lists subTemplate3 = await testHelpers.CreateSubTemplate("SubLabel3", "SubDescription3",
"CaseType3", 1, 1, Template3);
#endregion
#region subTemplate4
check_lists subTemplate4 = await testHelpers.CreateSubTemplate("SubLabel4", "SubDescription4",
"CaseType4", 0, 0, Template4);
#endregion
#endregion
#region Fields
#region Field1
fields Field1 = await testHelpers.CreateField(1, "barcode", subTemplate1, "e2f4fb", "custom", null, "", "Comment field description",
5, 1, dbContext.field_types.Where(x => x.FieldType == "picture").First(), 0, 0, 1, 0, "Comment field", 1, 55, "55", "0", 0, 0, null, 1, 0,
0, 0, "", 49);
#endregion
#region Field2
fields Field2 = await testHelpers.CreateField(1, "barcode", subTemplate1, "f5eafa", "custom", null, "", "showPDf Description",
45, 1, dbContext.field_types.Where(x => x.FieldType == "comment").First(), 0, 1, 0, 0,
"ShowPdf", 0, 5, "5", "0", 0, 0, null, 0, 0, 0, 0, "", 9);
#endregion
#region Field3
fields Field3 = await testHelpers.CreateField(0, "barcode", subTemplate2, "f0f8db", "custom", 3, "", "Number Field Description",
83, 0, dbContext.field_types.Where(x => x.FieldType == "picture").First(), 0, 0, 1, 0,
"Numberfield", 1, 8, "4865", "0", 0, 1, null, 1, 0, 0, 0, "", 1);
#endregion
#region Field4
fields Field4 = await testHelpers.CreateField(1, "barcode", subTemplate2, "fff6df", "custom", null, "", "date Description",
84, 0, dbContext.field_types.Where(x => x.FieldType == "picture").First(), 0, 0, 1, 0,
"Date", 1, 666, "41153", "0", 0, 1, null, 0, 1, 0, 0, "", 1);
#endregion
#region Field5
fields Field5 = await testHelpers.CreateField(0, "barcode", subTemplate2, "ffe4e4", "custom", null, "", "picture Description",
85, 0, dbContext.field_types.Where(x => x.FieldType == "comment").First(), 1, 0, 1, 0,
"Picture", 1, 69, "69", "1", 0, 1, null, 0, 1, 0, 0, "", 1);
#endregion
#region Field6
fields Field6 = await testHelpers.CreateField(0, "barcode", subTemplate3, "ffe4e4", "custom", null, "", "picture Description",
86, 0, dbContext.field_types.Where(x => x.FieldType == "comment").First(), 1, 0, 1, 0,
"Picture", 1, 69, "69", "1", 0, 1, null, 0, 1, 0, 0, "", 1);
#endregion
#region Field7
fields Field7 = await testHelpers.CreateField(0, "barcode", subTemplate3, "ffe4e4", "custom", null, "", "picture Description",
87, 0, dbContext.field_types.Where(x => x.FieldType == "comment").First(), 1, 0, 1, 0,
"Picture", 1, 69, "69", "1", 0, 1, null, 0, 1, 0, 0, "", 1);
#endregion
#region Field8
fields Field8 = await testHelpers.CreateField(0, "barcode", subTemplate4, "ffe4e4", "custom", null, "", "picture Description",
88, 0, dbContext.field_types.Where(x => x.FieldType == "comment").First(), 1, 0, 1, 0,
"Picture", 1, 69, "69", "1", 0, 1, null, 0, 1, 0, 0, "", 1);
#endregion
#region Field9
fields Field9 = await testHelpers.CreateField(0, "barcode", subTemplate4, "ffe4e4", "custom", null, "", "picture Description",
89, 0, dbContext.field_types.Where(x => x.FieldType == "comment").First(), 1, 0, 1, 0,
"Picture", 1, 69, "69", "1", 0, 1, null, 0, 1, 0, 0, "", 1);
#endregion
#region Field10
fields Field10 = await testHelpers.CreateField(0, "barcode", subTemplate4, "ffe4e4", "custom", null, "", "picture Description",
90, 0, dbContext.field_types.Where(x => x.FieldType == "comment").First(), 1, 0, 1, 0,
"Picture", 1, 69, "69", "1", 0, 1, null, 0, 1, 0, 0, "", 1);
#endregion
#endregion
#region Tag
//tags tag = await testHelpers.CreateTag("Tag1", Constants.WorkflowStates.Created, 1);
#endregion
// Act
var match1 = await sut.TemplateItemRead(Template1.Id);
var match2 = await sut.TemplateItemRead(Template2.Id);
var match3 = await sut.TemplateItemRead(Template3.Id);
var match4 = await sut.TemplateItemRead(Template4.Id);
// Assert
#region template1
Assert.NotNull(match1);
Assert.AreEqual(match1.Description, "Description1");
Assert.AreEqual(match1.Label, "Label1");
Assert.AreEqual(match1.CreatedAt.ToString(), Template1.CreatedAt.ToString());
Assert.AreEqual(match1.FolderName, "FolderWithTemplate");
Assert.AreEqual(match1.Id, Template1.Id);
// Assert.AreEqual(match1.UpdatedAt.ToString(), Template1.UpdatedAt.ToString());
#endregion
#region template2
Assert.NotNull(match1);
Assert.AreEqual(match2.Description, "Description2");
Assert.AreEqual(match2.Label, "Label2");
Assert.AreEqual(match2.CreatedAt.ToString(), Template2.CreatedAt.ToString());
Assert.AreEqual(match2.FolderName, "FolderWithTemplate");
Assert.AreEqual(match2.Id, Template2.Id);
// Assert.AreEqual(match2.UpdatedAt.ToString(), Template2.UpdatedAt.ToString());
#endregion
#region template3
Assert.NotNull(match1);
Assert.AreEqual(match3.Description, "Description3");
Assert.AreEqual(match3.Label, "Label3");
Assert.AreEqual(match3.CreatedAt.ToString(), Template3.CreatedAt.ToString());
Assert.AreEqual(match3.FolderName, "FolderWithTemplate");
Assert.AreEqual(match3.Id, Template3.Id);
// Assert.AreEqual(match3.UpdatedAt.ToString(), Template3.UpdatedAt.ToString());
#endregion
#region template4
Assert.NotNull(match1);
Assert.AreEqual(match4.Description, "Description4");
Assert.AreEqual(match4.Label, "Label4");
Assert.AreEqual(match4.CreatedAt.ToString(), Template4.CreatedAt.ToString());
Assert.AreEqual(match4.FolderName, "FolderWithTemplate");
Assert.AreEqual(match4.Id, Template4.Id);
// Assert.AreEqual(match4.UpdatedAt.ToString(), Template4.UpdatedAt.ToString());
#endregion
}
public async Task SQL_Check_FieldValueRead_ReturnsAnswer()
{
// Arrance
#region Arrance
Random rnd = new Random();
#region Template1
DateTime cl1_Ca = DateTime.Now;
DateTime cl1_Ua = DateTime.Now;
check_lists cl1 = await testHelpers.CreateTemplate(cl1_Ca, cl1_Ua, "A", "D", "CheckList", "Template1FolderName", 1, 1);
#endregion
#region SubTemplate1
check_lists cl2 = await testHelpers.CreateSubTemplate("A.1", "D.1", "CheckList", 1, 1, cl1);
#endregion
#region Fields
#region field1
fields f1 = await testHelpers.CreateField(1, "barcode", cl2, "e2f4fb", "custom", null, "", "Comment field description",
5, 1, dbContext.field_types.Where(x => x.FieldType == "comment").First(), 0, 0, 1, 0, "Comment field", 1, 55, "55", "0", 0, 0, null, 1, 0,
0, 0, "", 49);
#endregion
#region field2
fields f2 = await testHelpers.CreateField(1, "barcode", cl2, "f5eafa", "custom", null, "", "showPDf Description",
45, 1, dbContext.field_types.Where(x => x.FieldType == "comment").First(), 0, 1, 0, 0,
"ShowPdf", 0, 5, "5", "0", 0, 0, null, 0, 0, 0, 0, "", 9);
#endregion
#region field3
fields f3 = await testHelpers.CreateField(0, "barcode", cl2, "f0f8db", "custom", 3, "", "Number Field Description",
83, 0, dbContext.field_types.Where(x => x.FieldType == "number").First(), 0, 0, 1, 0,
"Numberfield", 1, 8, "4865", "0", 0, 1, null, 1, 0, 0, 0, "", 1);
#endregion
#region field4
fields f4 = await testHelpers.CreateField(1, "barcode", cl2, "fff6df", "custom", null, "", "date Description",
84, 0, dbContext.field_types.Where(x => x.FieldType == "comment").First(), 0, 0, 1, 0,
"Date", 1, 666, "41153", "0", 0, 1, null, 0, 1, 0, 0, "", 1);
#endregion
#region field5
fields f5 = await testHelpers.CreateField(0, "barcode", cl2, "ffe4e4", "custom", null, "", "picture Description",
85, 0, dbContext.field_types.Where(x => x.FieldType == "comment").First(), 1, 0, 1, 0,
"Picture", 1, 69, "69", "1", 0, 1, null, 0, 1, 0, 0, "", 1);
#endregion
#endregion
#region Worker
workers worker = await testHelpers.CreateWorker("*****@*****.**", "Arne", "Jensen", 21);
#endregion
#region site
sites site = await testHelpers.CreateSite("SiteName", 88);
#endregion
#region units
units unit = await testHelpers.CreateUnit(48, 49, site, 348);
#endregion
#region site_workers
site_workers site_workers = await testHelpers.CreateSiteWorker(55, site, worker);
#endregion
#region Case1
cases aCase = await testHelpers.CreateCase("caseUId", cl1, DateTime.Now, "custom", DateTime.Now,
worker, rnd.Next(1, 255), rnd.Next(1, 255),
site, 66, "caseType", unit, DateTime.Now, 1, worker, Constants.WorkflowStates.Created);
#endregion
#region Check List Values
check_list_values check_List_Values = await testHelpers.CreateCheckListValue(aCase, cl2, "completed", null, 865);
#endregion
#region UploadedData
uploaded_data ud = await testHelpers.CreateUploadedData("checksum", "File1", "no", "mappe", "File1", 1, worker,
"local", 55, false);
#endregion
#region Field Values
#region fv1
field_values field_Value1 = await testHelpers.CreateFieldValue(aCase, cl2, f1, ud.Id, null, "tomt1", 61234, worker);
#endregion
#region fv2
field_values field_Value2 = await testHelpers.CreateFieldValue(aCase, cl2, f2, null, null, "tomt2", 61234, worker);
#endregion
#region fv3
field_values field_Value3 = await testHelpers.CreateFieldValue(aCase, cl2, f3, null, null, "tomt3", 61234, worker);
#endregion
#region fv4
field_values field_Value4 = await testHelpers.CreateFieldValue(aCase, cl2, f4, null, null, "tomt4", 61234, worker);
#endregion
#region fv5
field_values field_Value5 = await testHelpers.CreateFieldValue(aCase, cl2, f5, null, null, "tomt5", 61234, worker);
#endregion
#endregion
#endregion
// Act
var match = await sut.FieldValueRead(field_Value1, false);
// Assert
#region Assert
Assert.True(match is FieldValue);
Assert.AreEqual(field_Value1.Accuracy, match.Accuracy);
Assert.AreEqual(field_Value1.Altitude, match.Altitude);
// Assert.AreEqual(field_Value1.case_id, match.case_id);
// Assert.AreEqual(field_Value1.check_list, match.check_list);
// Assert.AreEqual(field_Value1.check_list_duplicate_id, match.check_list_duplicate_id);
// Assert.AreEqual(field_Value1.check_list_id, match.check_list_id);
// Assert.AreEqual(field_Value1.created_at, match.created_at);
Assert.AreEqual(field_Value1.Date, match.Date);
// Assert.AreEqual(field_Value1.done_at, match.done_at);
Assert.AreEqual(field_Value1.Field, f1);
Assert.AreEqual(field_Value1.FieldId, match.FieldId);
Assert.AreEqual(field_Value1.Heading, match.Heading);
Assert.AreEqual(field_Value1.Id, match.Id);
Assert.AreEqual(field_Value1.Latitude, match.Latitude);
Assert.AreEqual(field_Value1.Longitude, match.Longitude);
// Assert.AreEqual(field_Value1.updated_at, match.updated_at);
// Assert.AreEqual("mappeFile1", match.UploadedData);
Assert.AreEqual(field_Value1.UploadedData.Checksum, match.UploadedDataObj.Checksum);
Assert.AreEqual(field_Value1.UploadedData.CurrentFile, match.UploadedDataObj.CurrentFile);
Assert.AreEqual(field_Value1.UploadedData.Extension, match.UploadedDataObj.Extension);
Assert.AreEqual(field_Value1.UploadedData.FileLocation, match.UploadedDataObj.FileLocation);
Assert.AreEqual(field_Value1.UploadedData.FileName, match.UploadedDataObj.FileName);
Assert.AreEqual(field_Value1.UploadedData.Id, match.UploadedDataObj.Id);
Assert.AreEqual(field_Value1.UploadedData.UploaderId, match.UploadedDataObj.UploaderId);
Assert.AreEqual(field_Value1.UploadedData.UploaderType, match.UploadedDataObj.UploaderType);
// Assert.AreEqual(field_Value1.user_id, match.user_id);
Assert.AreEqual(field_Value1.Value, match.Value);
// Assert.AreEqual(field_Value1.version, match.version);
// Assert.AreEqual(field_Value1.worker, match.worker);
// Assert.AreEqual(field_Value1.workflow_state, match.workflow_state);
#endregion
}
public async Task FieldValues_Delete_DoesSetWorkflowStateToRemoved()
{
short shortMinValue = Int16.MinValue;
short shortmaxValue = Int16.MaxValue;
Random rnd = new Random();
bool randomBool = rnd.Next(0, 2) > 0;
sites site = new sites
{
Name = Guid.NewGuid().ToString(),
MicrotingUid = rnd.Next(1, 255)
};
await site.Create(dbContext).ConfigureAwait(false);
units unit = new units
{
CustomerNo = rnd.Next(1, 255),
MicrotingUid = rnd.Next(1, 255),
OtpCode = rnd.Next(1, 255),
SiteId = site.Id
};
await unit.Create(dbContext).ConfigureAwait(false);
check_lists checklist = new check_lists
{
Color = Guid.NewGuid().ToString(),
Custom = Guid.NewGuid().ToString(),
Description = Guid.NewGuid().ToString(),
Field1 = rnd.Next(1, 255),
Field2 = rnd.Next(1, 255),
Field4 = rnd.Next(1, 255),
Field5 = rnd.Next(1, 255),
Field6 = rnd.Next(1, 255),
Field7 = rnd.Next(1, 255),
Field8 = rnd.Next(1, 255),
Field9 = rnd.Next(1, 255),
Field10 = rnd.Next(1, 255),
Label = Guid.NewGuid().ToString(),
Repeated = rnd.Next(1, 255),
ApprovalEnabled = (short)rnd.Next(shortMinValue, shortmaxValue),
CaseType = Guid.NewGuid().ToString(),
DisplayIndex = rnd.Next(1, 255),
DownloadEntities = (short)rnd.Next(shortMinValue, shortmaxValue),
FastNavigation = (short)rnd.Next(shortMinValue, shortmaxValue),
FolderName = Guid.NewGuid().ToString(),
ManualSync = (short)rnd.Next(shortMinValue, shortmaxValue),
MultiApproval = (short)rnd.Next(shortMinValue, shortmaxValue),
OriginalId = Guid.NewGuid().ToString(),
ReviewEnabled = (short)rnd.Next(shortMinValue, shortmaxValue),
DocxExportEnabled = randomBool,
DoneButtonEnabled = (short)rnd.Next(shortMinValue, shortmaxValue),
ExtraFieldsEnabled = (short)rnd.Next(shortMinValue, shortmaxValue),
JasperExportEnabled = randomBool,
QuickSyncEnabled = (short)rnd.Next(shortMinValue, shortmaxValue)
};
await checklist.Create(dbContext).ConfigureAwait(false);
entity_groups entityGroup = new entity_groups
{
Name = Guid.NewGuid().ToString(),
Type = Guid.NewGuid().ToString(),
MicrotingUid = Guid.NewGuid().ToString()
};
await entityGroup.Create(dbContext).ConfigureAwait(false);
field_types fieldType = new field_types
{
Description = Guid.NewGuid().ToString(),
FieldType = Guid.NewGuid().ToString()
};
await fieldType.Create(dbContext).ConfigureAwait(false);
fields field = new fields
{
Color = Guid.NewGuid().ToString(),
Custom = Guid.NewGuid().ToString(),
Description = Guid.NewGuid().ToString(),
Dummy = (short)rnd.Next(shortMinValue, shortmaxValue),
Label = Guid.NewGuid().ToString(),
Mandatory = (short)rnd.Next(shortMinValue, shortmaxValue),
Multi = rnd.Next(1, 255),
Optional = (short)rnd.Next(shortMinValue, shortmaxValue),
Selected = (short)rnd.Next(shortMinValue, shortmaxValue),
BarcodeEnabled = (short)rnd.Next(shortMinValue, shortmaxValue),
BarcodeType = Guid.NewGuid().ToString(),
DecimalCount = rnd.Next(1, 255),
DefaultValue = Guid.NewGuid().ToString(),
DisplayIndex = rnd.Next(1, 255),
GeolocationEnabled = (short)rnd.Next(shortMinValue, shortmaxValue),
GeolocationForced = (short)rnd.Next(shortMinValue, shortmaxValue),
GeolocationHidden = (short)rnd.Next(shortMinValue, shortmaxValue),
IsNum = (short)rnd.Next(shortMinValue, shortmaxValue),
MaxLength = rnd.Next(1, 255),
MaxValue = Guid.NewGuid().ToString(),
MinValue = Guid.NewGuid().ToString(),
OriginalId = Guid.NewGuid().ToString(),
QueryType = Guid.NewGuid().ToString(),
ReadOnly = (short)rnd.Next(shortMinValue, shortmaxValue),
SplitScreen = (short)rnd.Next(shortMinValue, shortmaxValue),
UnitName = Guid.NewGuid().ToString(),
StopOnSave = (short)rnd.Next(shortMinValue, shortmaxValue),
KeyValuePairList = Guid.NewGuid().ToString(),
CheckListId = checklist.Id,
EntityGroupId = entityGroup.Id,
FieldTypeId = fieldType.Id
};
await field.Create(dbContext).ConfigureAwait(false);
workers worker = new workers
{
Email = Guid.NewGuid().ToString(),
FirstName = Guid.NewGuid().ToString(),
LastName = Guid.NewGuid().ToString(),
MicrotingUid = rnd.Next(1, 255)
};
await worker.Create(dbContext).ConfigureAwait(false);
cases theCase = new cases
{
Custom = Guid.NewGuid().ToString(),
Status = rnd.Next(1, 255),
Type = Guid.NewGuid().ToString(),
CaseUid = Guid.NewGuid().ToString(),
DoneAt = DateTime.Now,
FieldValue1 = Guid.NewGuid().ToString(),
FieldValue2 = Guid.NewGuid().ToString(),
FieldValue3 = Guid.NewGuid().ToString(),
FieldValue4 = Guid.NewGuid().ToString(),
FieldValue5 = Guid.NewGuid().ToString(),
FieldValue6 = Guid.NewGuid().ToString(),
FieldValue7 = Guid.NewGuid().ToString(),
FieldValue8 = Guid.NewGuid().ToString(),
FieldValue9 = Guid.NewGuid().ToString(),
FieldValue10 = Guid.NewGuid().ToString(),
MicrotingUid = rnd.Next(shortMinValue, shortmaxValue),
SiteId = site.Id,
UnitId = unit.Id,
WorkerId = worker.Id,
CheckListId = checklist.Id,
MicrotingCheckUid = rnd.Next(shortMinValue, shortmaxValue)
};
await theCase.Create(dbContext).ConfigureAwait(false);
uploaded_data uploadedData = new uploaded_data
{
Checksum = Guid.NewGuid().ToString(),
Extension = Guid.NewGuid().ToString(),
Local = (short)rnd.Next(shortMinValue, shortmaxValue),
CurrentFile = Guid.NewGuid().ToString(),
ExpirationDate = DateTime.Now,
FileLocation = Guid.NewGuid().ToString(),
FileName = Guid.NewGuid().ToString(),
TranscriptionId = rnd.Next(1, 255),
UploaderId = rnd.Next(1, 255),
UploaderType = Guid.NewGuid().ToString()
};
await uploadedData.Create(dbContext).ConfigureAwait(false);
field_values fieldValue = new field_values
{
Accuracy = Guid.NewGuid().ToString(),
Altitude = Guid.NewGuid().ToString(),
Date = DateTime.Now,
Heading = Guid.NewGuid().ToString(),
Latitude = Guid.NewGuid().ToString(),
Longitude = Guid.NewGuid().ToString(),
Value = Guid.NewGuid().ToString(),
CaseId = theCase.Id,
DoneAt = DateTime.Now,
FieldId = field.Id,
WorkerId = worker.Id,
CheckListId = checklist.Id,
UploadedDataId = uploadedData.Id
};
await fieldValue.Create(dbContext).ConfigureAwait(false);
//Act
DateTime?oldUpdatedAt = fieldValue.UpdatedAt;
await fieldValue.Delete(dbContext);
List <field_values> fieldValues = dbContext.field_values.AsNoTracking().ToList();
List <field_value_versions> fieldValueVersions = dbContext.field_value_versions.AsNoTracking().ToList();
Assert.NotNull(fieldValues);
Assert.NotNull(fieldValueVersions);
Assert.AreEqual(1, fieldValues.Count());
Assert.AreEqual(2, fieldValueVersions.Count());
Assert.AreEqual(fieldValue.CreatedAt.ToString(), fieldValues[0].CreatedAt.ToString());
Assert.AreEqual(fieldValue.Version, fieldValues[0].Version);
// Assert.AreEqual(fieldValue.UpdatedAt.ToString(), fieldValues[0].UpdatedAt.ToString());
Assert.AreEqual(fieldValues[0].WorkflowState, Constants.WorkflowStates.Removed);
Assert.AreEqual(fieldValue.Id, fieldValues[0].Id);
Assert.AreEqual(fieldValue.Accuracy, fieldValues[0].Accuracy);
Assert.AreEqual(fieldValue.Date.ToString(), fieldValues[0].Date.ToString());
Assert.AreEqual(fieldValue.Heading, fieldValues[0].Heading);
Assert.AreEqual(fieldValue.Latitude, fieldValues[0].Latitude);
Assert.AreEqual(fieldValue.Longitude, fieldValues[0].Longitude);
Assert.AreEqual(fieldValue.Value, fieldValues[0].Value);
Assert.AreEqual(fieldValue.CaseId, theCase.Id);
Assert.AreEqual(fieldValue.DoneAt.ToString(), fieldValues[0].DoneAt.ToString());
Assert.AreEqual(fieldValue.FieldId, field.Id);
Assert.AreEqual(fieldValue.WorkerId, worker.Id);
Assert.AreEqual(fieldValue.CheckListId, checklist.Id);
Assert.AreEqual(fieldValue.UploadedDataId, uploadedData.Id);
//Old Version
Assert.AreEqual(fieldValue.CreatedAt.ToString(), fieldValueVersions[0].CreatedAt.ToString());
Assert.AreEqual(1, fieldValueVersions[0].Version);
// Assert.AreEqual(oldUpdatedAt.ToString(), fieldValueVersions[0].UpdatedAt.ToString());
Assert.AreEqual(fieldValueVersions[0].WorkflowState, Constants.WorkflowStates.Created);
Assert.AreEqual(fieldValue.Id, fieldValueVersions[0].FieldId);
Assert.AreEqual(fieldValue.Accuracy, fieldValueVersions[0].Accuracy);
Assert.AreEqual(fieldValue.Date.ToString(), fieldValueVersions[0].Date.ToString());
Assert.AreEqual(fieldValue.Heading, fieldValueVersions[0].Heading);
Assert.AreEqual(fieldValue.Latitude, fieldValueVersions[0].Latitude);
Assert.AreEqual(fieldValue.Longitude, fieldValueVersions[0].Longitude);
Assert.AreEqual(fieldValue.Value, fieldValueVersions[0].Value);
Assert.AreEqual(theCase.Id, fieldValueVersions[0].CaseId);
Assert.AreEqual(fieldValue.DoneAt.ToString(), fieldValueVersions[0].DoneAt.ToString());
Assert.AreEqual(field.Id, fieldValueVersions[0].FieldId);
Assert.AreEqual(worker.Id, fieldValueVersions[0].WorkerId);
Assert.AreEqual(checklist.Id, fieldValueVersions[0].CheckListId);
Assert.AreEqual(uploadedData.Id, fieldValueVersions[0].UploadedDataId);
//New Version
Assert.AreEqual(fieldValue.CreatedAt.ToString(), fieldValueVersions[1].CreatedAt.ToString());
Assert.AreEqual(2, fieldValueVersions[1].Version);
// Assert.AreEqual(fieldValue.UpdatedAt.ToString(), fieldValueVersions[1].UpdatedAt.ToString());
Assert.AreEqual(fieldValueVersions[1].WorkflowState, Constants.WorkflowStates.Removed);
Assert.AreEqual(fieldValue.Id, fieldValueVersions[1].FieldId);
Assert.AreEqual(fieldValue.Accuracy, fieldValueVersions[1].Accuracy);
Assert.AreEqual(fieldValue.Date.ToString(), fieldValueVersions[1].Date.ToString());
Assert.AreEqual(fieldValue.Heading, fieldValueVersions[1].Heading);
Assert.AreEqual(fieldValue.Latitude, fieldValueVersions[1].Latitude);
Assert.AreEqual(fieldValue.Longitude, fieldValueVersions[1].Longitude);
Assert.AreEqual(fieldValue.Value, fieldValueVersions[1].Value);
Assert.AreEqual(theCase.Id, fieldValueVersions[1].CaseId);
Assert.AreEqual(fieldValue.DoneAt.ToString(), fieldValueVersions[1].DoneAt.ToString());
Assert.AreEqual(field.Id, fieldValueVersions[1].FieldId);
Assert.AreEqual(worker.Id, fieldValueVersions[1].WorkerId);
Assert.AreEqual(checklist.Id, fieldValueVersions[1].CheckListId);
Assert.AreEqual(uploadedData.Id, fieldValueVersions[1].UploadedDataId);
}
/// <summary>
/// 允许游戏在开始运行之前执行其所需的任何初始化。
/// 游戏能够在此时查询任何所需服务并加载任何非图形
/// 相关的内容。调用 base.Initialize 将枚举所有组件
/// 并对其进行初始化。
/// </summary>
protected override void Initialize()
{
// TODO: 在此处添加初始化逻辑
field[0] = new fields(1, 50, 50, 0, 0, 0);
field[1] = new fields(3, 50, 275, 0, 0, 0);
field[2] = new fields(2, 290, 50, 0, 0, 0);
field[3] = new fields(4, 290, 275, 0, 0, 0);
field[4] = new fields(5, 50, 500, 0, 0, 0);
field[5] = new fields(6, 290, 500, 0, 0, 0);
//打开本地存储独立空间，加载存在文件中的数据
#if WINDOWS_PHONE
using (IsolatedStorageFile savegameStorage = IsolatedStorageFile.GetUserStoreForApplication())
#else
using (IsolatedStorageFile savegameStorage = IsolatedStorageFile.GetUserStoreForDomain())
#endif
{
if (savegameStorage.FileExists("cabbage"))
{
using (IsolatedStorageFileStream fs = savegameStorage.OpenFile("cabbage", System.IO.FileMode.Open, System.IO.FileAccess.Read))
{
if (fs != null)
{
//重载存储的最高记录
byte[] saveBytes_cabbage = new byte[4];
int count_cabbage = fs.Read(saveBytes_cabbage, 0, 4);
if (count_cabbage > 0)
{
this.Chinese_cabbage = System.BitConverter.ToInt32(saveBytes_cabbage, 0);
}
}
}
}
if (savegameStorage.FileExists("carrot"))
{//读取独立存储空间中的胡萝卜数目
using (IsolatedStorageFileStream fs = savegameStorage.OpenFile("carrot", System.IO.FileMode.Open, System.IO.FileAccess.Read))
{
if (fs != null)
{
byte[] saveBytes_carrot = new byte[4];
int count_carrot = fs.Read(saveBytes_carrot, 0, 4);
if (count_carrot > 0)
{
this.carrot = System.BitConverter.ToInt32(saveBytes_carrot, 0);
}
}
}
}
for (int i = 1; i <= 6; i++)
{
String str_01 = "-1".Insert(0, i.ToString());
if (savegameStorage.FileExists(str_01))
{
using (IsolatedStorageFileStream fs_01 = savegameStorage.OpenFile(str_01, System.IO.FileMode.Open, System.IO.FileAccess.Read))
{
if (fs_01 != null)
{
//重载该块田的第一个属性值
byte[] saw = new byte[4];
int sa = fs_01.Read(saw, 0, 4);
if (sa > 0)
{//载入当前变量中
this.field[i - 1].isSaw = System.BitConverter.ToInt32(saw, 0);
}
}
}
}
String str_02 = "-2".Insert(0, i.ToString());
if (savegameStorage.FileExists(str_02))
{
using (IsolatedStorageFileStream fs_02 = savegameStorage.OpenFile(str_02, System.IO.FileMode.Open, System.IO.FileAccess.Read))
{
if (fs_02 != null)
{
//重载该块田的第二个属性值
byte[] ripe = new byte[4];
int ri = fs_02.Read(ripe, 0, 4);
if (ri > 0)
{//载入当前变量中
this.field[i - 1].isRipe = System.BitConverter.ToInt32(ripe, 0);
}
}
}
}
String str_03 = "-3".Insert(0, i.ToString());
if (savegameStorage.FileExists(str_03))
{
using (IsolatedStorageFileStream fs_03 = savegameStorage.OpenFile(str_03, System.IO.FileMode.Open, System.IO.FileAccess.Read))
{
if (fs_03 != null)
{
//重载该块田的第三个属性值
byte[] harvested = new byte[4];
int ha = fs_03.Read(harvested, 0, 4);
if (ha > 0)
{//载入当前变量中
this.field[i - 1].isHarvested = System.BitConverter.ToInt32(harvested, 0);
}
}
}
}
String str_04 = "-4".Insert(0, i.ToString());
if (savegameStorage.FileExists(str_04))
{
using (IsolatedStorageFileStream fs_04 = savegameStorage.OpenFile(str_04, System.IO.FileMode.Open, System.IO.FileAccess.Read))
{
if (fs_04 != null)
{
//重载该块田的第四个属性值
byte[] tickCount = new byte[4];
int ti = fs_04.Read(tickCount, 0, 4);
if (ti > 0)
{//载入当前变量中
this.field[i - 1].tick = System.BitConverter.ToInt32(tickCount, 0);
}
}
}
}
String str_05 = "-5".Insert(0, i.ToString());
if (savegameStorage.FileExists(str_05))
{
using (IsolatedStorageFileStream fs_05 = savegameStorage.OpenFile(str_05, System.IO.FileMode.Open, System.IO.FileAccess.Read))
{
if (fs_05 != null)
{
//重载该块田的第五个属性值
byte[] type = new byte[4];
int ty = fs_05.Read(type, 0, 4);
if (ty > 0)
{//载入当前变量中
this.field[i - 1].type = System.BitConverter.ToInt32(type, 0);
}
}
}
}
}
}
base.Initialize();
}
[Test]//needs http mock done
public async Task Core_Case_CaseCreate_CreatesCase()
{
// Arrange
#region Template1
DateTime c1_Ca = DateTime.Now;
DateTime c1_Ua = DateTime.Now;
check_lists cl1 = await testHelpers.CreateTemplate(c1_Ca, c1_Ua, "A", "D", "CheckList", "Template1FolderName", 1, 1);
#endregion
#region SubTemplate1
check_lists cl2 = await testHelpers.CreateSubTemplate("A.1", "D.1", "CheckList", 1, 1, cl1);
#endregion
#region Fields
#region field1
fields f1 = await testHelpers.CreateField(1, "barcode", cl2, "e2f4fb", "custom", null, "", "Comment field description",
5, 1, dbContext.field_types.Where(x => x.FieldType == "picture").First(), 0, 0, 1, 0, "Comment field", 1, 55, "55", "0", 0, 0, null, 1, 0,
0, 0, "", 49);
#endregion
#region field2
fields f2 = await testHelpers.CreateField(1, "barcode", cl2, "f5eafa", "custom", null, "", "showPDf Description",
45, 1, dbContext.field_types.Where(x => x.FieldType == "comment").First(), 0, 1, 0, 0,
"ShowPdf", 0, 5, "5", "0", 0, 0, null, 0, 0, 0, 0, "", 9);
#endregion
#region field3
fields f3 = await testHelpers.CreateField(0, "barcode", cl2, "f0f8db", "custom", 3, "", "Number Field Description",
83, 0, dbContext.field_types.Where(x => x.FieldType == "picture").First(), 0, 0, 1, 0,
"Numberfield", 1, 8, "4865", "0", 0, 1, null, 1, 0, 0, 0, "", 1);
#endregion
#region field4
fields f4 = await testHelpers.CreateField(1, "barcode", cl2, "fff6df", "custom", null, "", "date Description",
84, 0, dbContext.field_types.Where(x => x.FieldType == "picture").First(), 0, 0, 1, 0,
"Date", 1, 666, "41153", "0", 0, 1, null, 0, 1, 0, 0, "", 1);
#endregion
#region field5
fields f5 = await testHelpers.CreateField(0, "barcode", cl2, "ffe4e4", "custom", null, "", "picture Description",
85, 0, dbContext.field_types.Where(x => x.FieldType == "comment").First(), 1, 0, 1, 0,
"Picture", 1, 69, "69", "1", 0, 1, null, 0, 1, 0, 0, "", 1);
#endregion
#endregion
#region Worker
workers worker = await testHelpers.CreateWorker("*****@*****.**", "Arne", "Jensen", 21);
#endregion
#region site
sites site = await testHelpers.CreateSite("SiteName", 88);
#endregion
CoreElement CElement = new CoreElement();
//CElement.ElementList = new List<Element>();
MainElement main = new MainElement(1, "label1", 1, "FolderWithList",
0, DateTime.Now, DateTime.Now.AddDays(2),
"Swahili", false, false, false, false,
"Type1", "Push", "TextForBody", false,
CElement.ElementList, "Blue");
// Act
var match = await sut.CaseCreate(main, "", (int)site.MicrotingUid, null);
// Assert
Assert.NotNull(match);
}
public void SQL_Worker_WorkerUpdate_UpdatesWorker()
{
// Arrance
#region Arrance
#region Checklist
DateTime cl1_Ca = DateTime.Now;
DateTime cl1_Ua = DateTime.Now;
check_lists Cl1 = testHelpers.CreateTemplate(cl1_Ca, cl1_Ua, "A1", "D1", "caseType1", "WhereItIs", 1, 0);
#endregion
#region SubCheckList
check_lists Cl2 = testHelpers.CreateSubTemplate("A2", "D2", "caseType2", 2, 0, Cl1);
#endregion
#region Fields
#region field1
fields f1 = testHelpers.CreateField(1, "barcode", Cl2, "e2f4fb", "custom", null, "", "Comment field description",
5, 1, DbContext.field_types.Where(x => x.field_type == "picture").First(), 0, 0, 1, 0, "Comment field", 1, 55, "55", "0", 0, 0, null, 1, 0,
0, 0, "", 49);
#endregion
#region field2
fields f2 = testHelpers.CreateField(1, "barcode", Cl2, "f5eafa", "custom", null, "", "showPDf Description",
45, 1, DbContext.field_types.Where(x => x.field_type == "comment").First(), 0, 1, 0, 0,
"ShowPdf", 0, 5, "5", "0", 0, 0, null, 0, 0, 0, 0, "", 9);
#endregion
#region field3
fields f3 = testHelpers.CreateField(0, "barcode", Cl2, "f0f8db", "custom", 3, "", "Number Field Description",
83, 0, DbContext.field_types.Where(x => x.field_type == "picture").First(), 0, 0, 1, 0,
"Numberfield", 1, 8, "4865", "0", 0, 1, null, 1, 0, 0, 0, "", 1);
#endregion
#region field4
fields f4 = testHelpers.CreateField(1, "barcode", Cl2, "fff6df", "custom", null, "", "date Description",
84, 0, DbContext.field_types.Where(x => x.field_type == "picture").First(), 0, 0, 1, 0,
"Date", 1, 666, "41153", "0", 0, 1, null, 0, 1, 0, 0, "", 1);
#endregion
#region field5
fields f5 = testHelpers.CreateField(0, "barcode", Cl2, "ffe4e4", "custom", null, "", "picture Description",
85, 0, DbContext.field_types.Where(x => x.field_type == "comment").First(), 1, 0, 1, 0,
"Picture", 1, 69, "69", "1", 0, 1, null, 0, 1, 0, 0, "", 1);
#endregion
#region field6
fields f6 = testHelpers.CreateField(0, "barcode", Cl2, "ffe4e4", "custom", null, "", "picture Description",
86, 0, DbContext.field_types.Where(x => x.field_type == "comment").First(), 1, 0, 1, 0,
"Picture", 1, 69, "69", "1", 0, 1, null, 0, 1, 0, 0, "", 1);
#endregion
#region field7
fields f7 = testHelpers.CreateField(0, "barcode", Cl2, "ffe4e4", "custom", null, "", "picture Description",
87, 0, DbContext.field_types.Where(x => x.field_type == "comment").First(), 1, 0, 1, 0,
"Picture", 1, 69, "69", "1", 0, 1, null, 0, 1, 0, 0, "", 1);
#endregion
#region field8
fields f8 = testHelpers.CreateField(0, "barcode", Cl2, "ffe4e4", "custom", null, "", "picture Description",
88, 0, DbContext.field_types.Where(x => x.field_type == "comment").First(), 1, 0, 1, 0,
"Picture", 1, 69, "69", "1", 0, 1, null, 0, 1, 0, 0, "", 1);
#endregion
#region field9
fields f9 = testHelpers.CreateField(0, "barcode", Cl2, "ffe4e4", "custom", null, "", "picture Description",
89, 0, DbContext.field_types.Where(x => x.field_type == "comment").First(), 1, 0, 1, 0,
"Picture", 1, 69, "69", "1", 0, 1, null, 0, 1, 0, 0, "", 1);
#endregion
#region field10
fields f10 = testHelpers.CreateField(0, "barcode", Cl2, "ffe4e4", "custom", null, "", "picture Description",
90, 0, DbContext.field_types.Where(x => x.field_type == "comment").First(), 1, 0, 1, 0,
"Picture", 1, 69, "69", "1", 0, 1, null, 0, 1, 0, 0, "", 1);
#endregion
#endregion
#region Workers
#region worker1
workers worker1 = testHelpers.CreateWorker("*****@*****.**", "Arne", "Jensen", 21);
#endregion
#region worker2
workers worker2 = testHelpers.CreateWorker("*****@*****.**", "Lasse", "Johansen", 44);
#endregion
#region worker3
workers worker3 = testHelpers.CreateWorker("*****@*****.**", "Svend", "Jensen", 22);
#endregion
#region worker4
workers worker4 = testHelpers.CreateWorker("*****@*****.**", "Bjarne", "Nielsen", 23);
#endregion
#region worker5
workers worker5 = testHelpers.CreateWorker("*****@*****.**", "Ib", "Hansen", 24);
#endregion
#region worker6
workers worker6 = testHelpers.CreateWorker("*****@*****.**", "Hozan", "Aziz", 25);
#endregion
#region worker7
workers worker7 = testHelpers.CreateWorker("*****@*****.**", "Nicolai", "Peders", 26);
#endregion
#region worker8
workers worker8 = testHelpers.CreateWorker("*****@*****.**", "Amin", "Safari", 27);
#endregion
#region worker9
workers worker9 = testHelpers.CreateWorker("*****@*****.**", "Leo", "Rebaz", 28);
#endregion
#region worker10
workers worker10 = testHelpers.CreateWorker("*****@*****.**", "Stig", "Berthelsen", 29);
#endregion
#endregion
#region sites
#region Site1
sites site1 = testHelpers.CreateSite("SiteName1", 88);
#endregion
#region Site2
sites site2 = testHelpers.CreateSite("SiteName2", 89);
#endregion
#region Site3
sites site3 = testHelpers.CreateSite("SiteName3", 90);
#endregion
#region Site4
sites site4 = testHelpers.CreateSite("SiteName4", 91);
#endregion
#region Site5
sites site5 = testHelpers.CreateSite("SiteName5", 92);
#endregion
#region Site6
sites site6 = testHelpers.CreateSite("SiteName6", 93);
#endregion
#region Site7
sites site7 = testHelpers.CreateSite("SiteName7", 94);
#endregion
#region Site8
sites site8 = testHelpers.CreateSite("SiteName8", 95);
#endregion
#region Site9
sites site9 = testHelpers.CreateSite("SiteName9", 96);
#endregion
#region Site10
sites site10 = testHelpers.CreateSite("SiteName10", 97);
#endregion
#endregion
#region units
units unit = testHelpers.CreateUnit(48, 49, site1, 348);
#endregion
#region site_workers
site_workers site_workers = testHelpers.CreateSiteWorker(55, site1, worker1);
#endregion
#endregion
// Act
var match = sut.WorkerUpdate(worker1.microting_uid, worker1.first_name, worker1.last_name, worker1.email);
// Assert
Assert.True(match);
}
public void Core_Site_SiteRead_ReturnsFullSite()
{
//Arrance
#region Template1
DateTime cl1_Ca = DateTime.Now;
DateTime cl1_Ua = DateTime.Now;
check_lists cl1 = testHelpers.CreateTemplate(cl1_Ca, cl1_Ua, "A", "D", "CheckList", "Template1FolderName", 1, 1);
#endregion
#region subtemplates
#region SubTemplate1
check_lists cl2 = testHelpers.CreateSubTemplate("A.1", "D.1", "CheckList", 1, 1, cl1);
#endregion
#region SubTemplate1
check_lists cl3 = testHelpers.CreateSubTemplate("A.2", "D.2", "CheckList", 1, 1, cl1);
#endregion
#region SubTemplate1
check_lists cl4 = testHelpers.CreateSubTemplate("A.3", "D.3", "CheckList", 1, 1, cl1);
#endregion
#region SubTemplate1
check_lists cl5 = testHelpers.CreateSubTemplate("A.4", "D.4", "CheckList", 1, 1, cl1);
#endregion
#region SubTemplate1
check_lists cl6 = testHelpers.CreateSubTemplate("A.5", "D.5", "CheckList", 1, 1, cl1);
#endregion
#region SubTemplate1
check_lists cl7 = testHelpers.CreateSubTemplate("A.6", "D.6", "CheckList", 1, 1, cl1);
#endregion
#region SubTemplate1
check_lists cl8 = testHelpers.CreateSubTemplate("A.7", "D.7", "CheckList", 1, 1, cl1);
#endregion
#region SubTemplate1
check_lists cl9 = testHelpers.CreateSubTemplate("A.8", "D.8", "CheckList", 1, 1, cl1);
#endregion
#region SubTemplate1
check_lists cl10 = testHelpers.CreateSubTemplate("A.9", "D.9", "CheckList", 1, 1, cl1);
#endregion
#region SubTemplate1
check_lists cl11 = testHelpers.CreateSubTemplate("A.10", "D.10", "CheckList", 1, 1, cl1);
#endregion
#endregion
#region Fields
#region field1
fields f1 = testHelpers.CreateField(1, "barcode", cl2, "e2f4fb", "custom", null, "", "Comment field description",
5, 1, DbContext.field_types.Where(x => x.field_type == "comment").First(), 0, 0, 1, 0, "Comment field", 1, 55, "55", "0", 0, 0, null, 1, 0,
0, 0, "", 49);
#endregion
#region field2
fields f2 = testHelpers.CreateField(1, "barcode", cl2, "f5eafa", "custom", null, "", "showPDf Description",
45, 1, DbContext.field_types.Where(x => x.field_type == "comment").First(), 0, 1, 0, 0,
"ShowPdf", 0, 5, "5", "0", 0, 0, null, 0, 0, 0, 0, "", 9);
#endregion
#region field3
fields f3 = testHelpers.CreateField(0, "barcode", cl2, "f0f8db", "custom", 3, "", "Number Field Description",
83, 0, DbContext.field_types.Where(x => x.field_type == "comment").First(), 0, 0, 1, 0,
"Numberfield", 1, 8, "4865", "0", 0, 1, null, 1, 0, 0, 0, "", 1);
#endregion
#region field4
fields f4 = testHelpers.CreateField(1, "barcode", cl2, "fff6df", "custom", null, "", "date Description",
84, 0, DbContext.field_types.Where(x => x.field_type == "comment").First(), 0, 0, 1, 0,
"Date", 1, 666, "41153", "0", 0, 1, null, 0, 1, 0, 0, "", 1);
#endregion
#region field5
fields f5 = testHelpers.CreateField(0, "barcode", cl2, "ffe4e4", "custom", null, "", "picture Description",
85, 0, DbContext.field_types.Where(x => x.field_type == "comment").First(), 1, 0, 1, 0,
"Picture", 1, 69, "69", "1", 0, 1, null, 0, 1, 0, 0, "", 1);
#endregion
#region field6
fields f6 = testHelpers.CreateField(0, "barcode", cl2, "ffe4e4", "custom", null, "", "picture Description",
86, 0, DbContext.field_types.Where(x => x.field_type == "comment").First(), 1, 0, 1, 0,
"Picture", 1, 69, "69", "1", 0, 1, null, 0, 1, 0, 0, "", 1);
#endregion
#region field7
fields f7 = testHelpers.CreateField(0, "barcode", cl2, "ffe4e4", "custom", null, "", "picture Description",
87, 0, DbContext.field_types.Where(x => x.field_type == "comment").First(), 1, 0, 1, 0,
"Picture", 1, 69, "69", "1", 0, 1, null, 0, 1, 0, 0, "", 1);
#endregion
#region field8
fields f8 = testHelpers.CreateField(0, "barcode", cl2, "ffe4e4", "custom", null, "", "picture Description",
88, 0, DbContext.field_types.Where(x => x.field_type == "comment").First(), 1, 0, 1, 0,
"Picture", 1, 69, "69", "1", 0, 1, null, 0, 1, 0, 0, "", 1);
#endregion
#region field9
fields f9 = testHelpers.CreateField(0, "barcode", cl2, "ffe4e4", "custom", null, "", "picture Description",
89, 0, DbContext.field_types.Where(x => x.field_type == "comment").First(), 1, 0, 1, 0,
"Picture", 1, 69, "69", "1", 0, 1, null, 0, 1, 0, 0, "", 1);
#endregion
#region field10
fields f10 = testHelpers.CreateField(0, "barcode", cl2, "ffe4e4", "custom", null, "", "picture Description",
90, 0, DbContext.field_types.Where(x => x.field_type == "comment").First(), 1, 0, 1, 0,
"Picture", 1, 69, "69", "1", 0, 1, null, 0, 1, 0, 0, "", 1);
#endregion
#endregion
#region Worker
workers worker = testHelpers.CreateWorker("*****@*****.**", "Arne", "Jensen", 21);
#endregion
#region site
sites site = testHelpers.CreateSite("SiteName", 88);
#endregion
#region units
units unit = testHelpers.CreateUnit(48, 49, site, 348);
#endregion
#region site_workers
site_workers site_workers = testHelpers.CreateSiteWorker(55, site, worker);
#endregion
//Act
var match = sut.SiteRead((int)site.microting_uid);
//Assert
Assert.NotNull(match);
Assert.AreEqual(match.SiteId, site.microting_uid);
Assert.AreEqual(match.SiteName, site.name);
}
public void SQL_Site_SiteUpdate_UpdatesSite()
{
// Arrance
#region Arrance
#region Checklist
DateTime cl1_Ca = DateTime.Now;
DateTime cl1_Ua = DateTime.Now;
check_lists Cl1 = testHelpers.CreateTemplate(cl1_Ca, cl1_Ua, "A1", "D1", "caseType1", "WhereItIs", 1, 0);
#endregion
#region SubCheckList
check_lists Cl2 = testHelpers.CreateSubTemplate("A2", "D2", "caseType2", 2, 0, Cl1);
#endregion
#region Fields
#region field1
fields f1 = testHelpers.CreateField(1, "barcode", Cl2, "e2f4fb", "custom", null, "", "Comment field description",
5, 1, DbContext.field_types.Where(x => x.field_type == "picture").First(), 0, 0, 1, 0, "Comment field", 1, 55, "55", "0", 0, 0, null, 1, 0,
0, 0, "", 49);
#endregion
#region field2
fields f2 = testHelpers.CreateField(1, "barcode", Cl2, "f5eafa", "custom", null, "", "showPDf Description",
45, 1, DbContext.field_types.Where(x => x.field_type == "comment").First(), 0, 1, 0, 0,
"ShowPdf", 0, 5, "5", "0", 0, 0, null, 0, 0, 0, 0, "", 9);
#endregion
#region field3
fields f3 = testHelpers.CreateField(0, "barcode", Cl2, "f0f8db", "custom", 3, "", "Number Field Description",
83, 0, DbContext.field_types.Where(x => x.field_type == "picture").First(), 0, 0, 1, 0,
"Numberfield", 1, 8, "4865", "0", 0, 1, null, 1, 0, 0, 0, "", 1);
#endregion
#region field4
fields f4 = testHelpers.CreateField(1, "barcode", Cl2, "fff6df", "custom", null, "", "date Description",
84, 0, DbContext.field_types.Where(x => x.field_type == "picture").First(), 0, 0, 1, 0,
"Date", 1, 666, "41153", "0", 0, 1, null, 0, 1, 0, 0, "", 1);
#endregion
#region field5
fields f5 = testHelpers.CreateField(0, "barcode", Cl2, "ffe4e4", "custom", null, "", "picture Description",
85, 0, DbContext.field_types.Where(x => x.field_type == "comment").First(), 1, 0, 1, 0,
"Picture", 1, 69, "69", "1", 0, 1, null, 0, 1, 0, 0, "", 1);
#endregion
#region field6
fields f6 = testHelpers.CreateField(0, "barcode", Cl2, "ffe4e4", "custom", null, "", "picture Description",
86, 0, DbContext.field_types.Where(x => x.field_type == "comment").First(), 1, 0, 1, 0,
"Picture", 1, 69, "69", "1", 0, 1, null, 0, 1, 0, 0, "", 1);
#endregion
#region field7
fields f7 = testHelpers.CreateField(0, "barcode", Cl2, "ffe4e4", "custom", null, "", "picture Description",
87, 0, DbContext.field_types.Where(x => x.field_type == "comment").First(), 1, 0, 1, 0,
"Picture", 1, 69, "69", "1", 0, 1, null, 0, 1, 0, 0, "", 1);
#endregion
#region field8
fields f8 = testHelpers.CreateField(0, "barcode", Cl2, "ffe4e4", "custom", null, "", "picture Description",
88, 0, DbContext.field_types.Where(x => x.field_type == "comment").First(), 1, 0, 1, 0,
"Picture", 1, 69, "69", "1", 0, 1, null, 0, 1, 0, 0, "", 1);
#endregion
#region field9
fields f9 = testHelpers.CreateField(0, "barcode", Cl2, "ffe4e4", "custom", null, "", "picture Description",
89, 0, DbContext.field_types.Where(x => x.field_type == "comment").First(), 1, 0, 1, 0,
"Picture", 1, 69, "69", "1", 0, 1, null, 0, 1, 0, 0, "", 1);
#endregion
#region field10
fields f10 = testHelpers.CreateField(0, "barcode", Cl2, "ffe4e4", "custom", null, "", "picture Description",
90, 0, DbContext.field_types.Where(x => x.field_type == "comment").First(), 1, 0, 1, 0,
"Picture", 1, 69, "69", "1", 0, 1, null, 0, 1, 0, 0, "", 1);
#endregion
#endregion
#region Worker
workers worker = testHelpers.CreateWorker("*****@*****.**", "Arne", "Jensen", 21);
#endregion
#region sites
#region Site1
sites site1 = testHelpers.CreateSite("SiteName1", 88);
#endregion
#region Site2
sites site2 = testHelpers.CreateSite("SiteName2", 89);
#endregion
#region Site3
sites site3 = testHelpers.CreateSite("SiteName3", 90);
#endregion
#region Site4
sites site4 = testHelpers.CreateSite("SiteName4", 91);
#endregion
#region Site5
sites site5 = testHelpers.CreateSite("SiteName5", 92);
#endregion
#region Site6
sites site6 = testHelpers.CreateSite("SiteName6", 93);
#endregion
#region Site7
sites site7 = testHelpers.CreateSite("SiteName7", 94);
#endregion
#region Site8
sites site8 = testHelpers.CreateSite("SiteName8", 95);
#endregion
#region Site9
sites site9 = testHelpers.CreateSite("SiteName9", 96);
#endregion
#region Site10
sites site10 = testHelpers.CreateSite("SiteName10", 97);
#endregion
#endregion
#region units
units unit = testHelpers.CreateUnit(48, 49, site1, 348);
#endregion
#region site_workers
site_workers site_workers = testHelpers.CreateSiteWorker(55, site1, worker);
#endregion
#endregion
// Act
var match = sut.SiteUpdate((int)site1.microting_uid, site1.name);
// Assert
Assert.True(match);
}
public async Task SQL_Site_SimpleSiteGetAll_DoesReturnSiteList()
{
// Arrance
#region Arrance
#region Checklist
DateTime cl1_Ca = DateTime.Now;
DateTime cl1_Ua = DateTime.Now;
check_lists Cl1 = await testHelpers.CreateTemplate(cl1_Ca, cl1_Ua, "A1", "D1", "caseType1", "WhereItIs", 1, 0);
#endregion
#region SubCheckList
check_lists Cl2 = await testHelpers.CreateSubTemplate("A2", "D2", "caseType2", 2, 0, Cl1);
#endregion
#region Fields
#region field1
fields f1 = await testHelpers.CreateField(1, "barcode", Cl2, "e2f4fb", "custom", null, "", "Comment field description",
5, 1, dbContext.field_types.Where(x => x.FieldType == "picture").First(), 0, 0, 1, 0, "Comment field", 1, 55, "55", "0", 0, 0, null, 1, 0,
0, 0, "", 49);
#endregion
#region field2
fields f2 = await testHelpers.CreateField(1, "barcode", Cl2, "f5eafa", "custom", null, "", "showPDf Description",
45, 1, dbContext.field_types.Where(x => x.FieldType == "comment").First(), 0, 1, 0, 0,
"ShowPdf", 0, 5, "5", "0", 0, 0, null, 0, 0, 0, 0, "", 9);
#endregion
#region field3
fields f3 = await testHelpers.CreateField(0, "barcode", Cl2, "f0f8db", "custom", 3, "", "Number Field Description",
83, 0, dbContext.field_types.Where(x => x.FieldType == "picture").First(), 0, 0, 1, 0,
"Numberfield", 1, 8, "4865", "0", 0, 1, null, 1, 0, 0, 0, "", 1);
#endregion
#region field4
fields f4 = await testHelpers.CreateField(1, "barcode", Cl2, "fff6df", "custom", null, "", "date Description",
84, 0, dbContext.field_types.Where(x => x.FieldType == "picture").First(), 0, 0, 1, 0,
"Date", 1, 666, "41153", "0", 0, 1, null, 0, 1, 0, 0, "", 1);
#endregion
#region field5
fields f5 = await testHelpers.CreateField(0, "barcode", Cl2, "ffe4e4", "custom", null, "", "picture Description",
85, 0, dbContext.field_types.Where(x => x.FieldType == "comment").First(), 1, 0, 1, 0,
"Picture", 1, 69, "69", "1", 0, 1, null, 0, 1, 0, 0, "", 1);
#endregion
#region field6
fields f6 = await testHelpers.CreateField(0, "barcode", Cl2, "ffe4e4", "custom", null, "", "picture Description",
86, 0, dbContext.field_types.Where(x => x.FieldType == "comment").First(), 1, 0, 1, 0,
"Picture", 1, 69, "69", "1", 0, 1, null, 0, 1, 0, 0, "", 1);
#endregion
#region field7
fields f7 = await testHelpers.CreateField(0, "barcode", Cl2, "ffe4e4", "custom", null, "", "picture Description",
87, 0, dbContext.field_types.Where(x => x.FieldType == "comment").First(), 1, 0, 1, 0,
"Picture", 1, 69, "69", "1", 0, 1, null, 0, 1, 0, 0, "", 1);
#endregion
#region field8
fields f8 = await testHelpers.CreateField(0, "barcode", Cl2, "ffe4e4", "custom", null, "", "picture Description",
88, 0, dbContext.field_types.Where(x => x.FieldType == "comment").First(), 1, 0, 1, 0,
"Picture", 1, 69, "69", "1", 0, 1, null, 0, 1, 0, 0, "", 1);
#endregion
#region field9
fields f9 = await testHelpers.CreateField(0, "barcode", Cl2, "ffe4e4", "custom", null, "", "picture Description",
89, 0, dbContext.field_types.Where(x => x.FieldType == "comment").First(), 1, 0, 1, 0,
"Picture", 1, 69, "69", "1", 0, 1, null, 0, 1, 0, 0, "", 1);
#endregion
#region field10
fields f10 = await testHelpers.CreateField(0, "barcode", Cl2, "ffe4e4", "custom", null, "", "picture Description",
90, 0, dbContext.field_types.Where(x => x.FieldType == "comment").First(), 1, 0, 1, 0,
"Picture", 1, 69, "69", "1", 0, 1, null, 0, 1, 0, 0, "", 1);
#endregion
#endregion
#region Worker
workers worker = await testHelpers.CreateWorker("*****@*****.**", "Arne", "Jensen", 21);
#endregion
#region sites
#region Site1
sites site1 = await testHelpers.CreateSite("SiteName1", 88);
#endregion
#region Site2
sites site2 = await testHelpers.CreateSite("SiteName2", 88);
#endregion
#region Site3
sites site3 = await testHelpers.CreateSite("SiteName3", 88);
#endregion
#region Site4
sites site4 = await testHelpers.CreateSite("SiteName4", 88);
#endregion
#region Site5
sites site5 = await testHelpers.CreateSite("SiteName5", 88);
#endregion
#region Site6
sites site6 = await testHelpers.CreateSite("SiteName6", 88);
#endregion
#region Site7
sites site7 = await testHelpers.CreateSite("SiteName7", 88);
#endregion
#region Site8
sites site8 = await testHelpers.CreateSite("SiteName8", 88);
#endregion
#region Site9
sites site9 = await testHelpers.CreateSite("SiteName9", 88);
#endregion
#region Site10
sites site10 = await testHelpers.CreateSite("SiteName10", 88);
#endregion
#endregion
#endregion
// Act
var match = await sut.SimpleSiteGetAll(Constants.WorkflowStates.Created, 0, 1);
// Assert
Assert.AreEqual(10, match.Count());
Assert.AreEqual(site1.Name, match[0].SiteName);
Assert.AreEqual(site2.Name, match[1].SiteName);
Assert.AreEqual(site3.Name, match[2].SiteName);
Assert.AreEqual(site4.Name, match[3].SiteName);
Assert.AreEqual(site5.Name, match[4].SiteName);
Assert.AreEqual(site6.Name, match[5].SiteName);
Assert.AreEqual(site7.Name, match[6].SiteName);
Assert.AreEqual(site8.Name, match[7].SiteName);
Assert.AreEqual(site9.Name, match[8].SiteName);
Assert.AreEqual(site10.Name, match[9].SiteName);
}
public async Task SQL_Check_CheckRead_ReturnsReplyElement()
{
// Arrance
#region Arrance
Random rnd = new Random();
#region Template1
DateTime cl1_Ca = DateTime.Now;
DateTime cl1_Ua = DateTime.Now;
check_lists cl1 = await testHelpers.CreateTemplate(cl1_Ca, cl1_Ua, "A", "D", "CheckList", "Template1FolderName", 1, 1);
#endregion
#region SubTemplate1
check_lists cl2 = await testHelpers.CreateSubTemplate("A.1", "D.1", "CheckList", 1, 1, cl1);
#endregion
#region Fields
#region field1
fields f1 = await testHelpers.CreateField(1, "barcode", cl2, "e2f4fb", "custom", null, "", "Comment field description",
5, 1, dbContext.field_types.Where(x => x.FieldType == "comment").First(), 0, 0, 1, 0, "Comment field", 1, 55, "55", "0", 0, 0, null, 1, 0,
0, 0, "", 49);
#endregion
#region field2
fields f2 = await testHelpers.CreateField(1, "barcode", cl2, "f5eafa", "custom", null, "", "showPDf Description",
45, 1, dbContext.field_types.Where(x => x.FieldType == "comment").First(), 0, 1, 0, 0,
"ShowPdf", 0, 5, "5", "0", 0, 0, null, 0, 0, 0, 0, "", 9);
#endregion
#region field3
fields f3 = await testHelpers.CreateField(0, "barcode", cl2, "f0f8db", "custom", 3, "", "Number Field Description",
83, 0, dbContext.field_types.Where(x => x.FieldType == "number").First(), 0, 0, 1, 0,
"Numberfield", 1, 8, "4865", "0", 0, 1, null, 1, 0, 0, 0, "", 1);
#endregion
#region field4
fields f4 = await testHelpers.CreateField(1, "barcode", cl2, "fff6df", "custom", null, "", "date Description",
84, 0, dbContext.field_types.Where(x => x.FieldType == "comment").First(), 0, 0, 1, 0,
"Date", 1, 666, "41153", "0", 0, 1, null, 0, 1, 0, 0, "", 1);
#endregion
#region field5
fields f5 = await testHelpers.CreateField(0, "barcode", cl2, "ffe4e4", "custom", null, "", "picture Description",
85, 0, dbContext.field_types.Where(x => x.FieldType == "comment").First(), 1, 0, 1, 0,
"Picture", 1, 69, "69", "1", 0, 1, null, 0, 1, 0, 0, "", 1);
#endregion
#endregion
#region Worker
workers worker = await testHelpers.CreateWorker("*****@*****.**", "Arne", "Jensen", 21);
#endregion
#region site
sites site = await testHelpers.CreateSite("SiteName", 88);
#endregion
#region units
units unit = await testHelpers.CreateUnit(48, 49, site, 348);
#endregion
#region site_workers
site_workers site_workers = await testHelpers.CreateSiteWorker(55, site, worker);
#endregion
#region Case1
cases aCase = await testHelpers.CreateCase("caseUId", cl1, DateTime.Now, "custom", DateTime.Now,
worker, rnd.Next(1, 255), rnd.Next(1, 255),
site, 66, "caseType", unit, DateTime.Now, 1, worker, Constants.WorkflowStates.Created);
#endregion
#region Check List Values
check_list_values check_List_Values = await testHelpers.CreateCheckListValue(aCase, cl2, "completed", null, 865);
#endregion
#region Field Values
#region fv1
field_values field_Values1 = await testHelpers.CreateFieldValue(aCase, cl2, f1, null, null, "tomt1", 61234, worker);
#endregion
#region fv2
field_values field_Values2 = await testHelpers.CreateFieldValue(aCase, cl2, f2, null, null, "tomt2", 61234, worker);
#endregion
#region fv3
field_values field_Values3 = await testHelpers.CreateFieldValue(aCase, cl2, f3, null, null, "tomt3", 61234, worker);
#endregion
#region fv4
field_values field_Values4 = await testHelpers.CreateFieldValue(aCase, cl2, f4, null, null, "tomt4", 61234, worker);
#endregion
#region fv5
field_values field_Values5 = await testHelpers.CreateFieldValue(aCase, cl2, f5, null, null, "tomt5", 61234, worker);
#endregion
#endregion
#endregion
// Act
ReplyElement match = await sut.CheckRead((int)aCase.MicrotingUid, (int)aCase.MicrotingCheckUid);
// Assert
#region Assert
Assert.AreEqual(1, match.ElementList.Count());
CheckListValue clv = (CheckListValue)match.ElementList[0];
Assert.AreEqual(5, clv.DataItemList.Count);
#region casts
Field _f1 = (Field)clv.DataItemList[0];
Field _f2 = (Field)clv.DataItemList[1];
Field _f3 = (Field)clv.DataItemList[2];
Field _f4 = (Field)clv.DataItemList[3];
Field _f5 = (Field)clv.DataItemList[4];
#endregion
#region Barcode
Assert.AreEqual(f1.BarcodeEnabled, 1);
Assert.AreEqual(f2.BarcodeEnabled, 1);
Assert.AreEqual(f3.BarcodeEnabled, 0);
Assert.AreEqual(f4.BarcodeEnabled, 1);
Assert.AreEqual(f5.BarcodeEnabled, 0);
Assert.AreEqual(f1.BarcodeType, "barcode");
Assert.AreEqual(f2.BarcodeType, "barcode");
Assert.AreEqual(f3.BarcodeType, "barcode");
Assert.AreEqual(f4.BarcodeType, "barcode");
Assert.AreEqual(f5.BarcodeType, "barcode");
#endregion
#region chckl_id
Assert.AreEqual(f1.CheckListId, cl2.Id);
Assert.AreEqual(f2.CheckListId, cl2.Id);
Assert.AreEqual(f3.CheckListId, cl2.Id);
Assert.AreEqual(f4.CheckListId, cl2.Id);
Assert.AreEqual(f5.CheckListId, cl2.Id);
#endregion
#region Color
Assert.AreEqual(f1.Color, _f1.FieldValues[0].Color);
Assert.AreEqual(f2.Color, _f2.FieldValues[0].Color);
Assert.AreEqual(f3.Color, _f3.FieldValues[0].Color);
Assert.AreEqual(f4.Color, _f4.FieldValues[0].Color);
Assert.AreEqual(f5.Color, _f5.FieldValues[0].Color);
#endregion
#region custom
// Assert.AreEqual(f1.custom, _f1.FieldValues[0].Id);
#endregion
#region Decimal_Count
Assert.AreEqual(f1.DecimalCount, null);
Assert.AreEqual(f2.DecimalCount, null);
Assert.AreEqual(f3.DecimalCount, 3);
Assert.AreEqual(f4.DecimalCount, null);
Assert.AreEqual(f5.DecimalCount, null);
#endregion
#region Default_value
Assert.AreEqual(f1.DefaultValue, "");
Assert.AreEqual(f2.DefaultValue, "");
Assert.AreEqual(f3.DefaultValue, "");
Assert.AreEqual(f4.DefaultValue, "");
Assert.AreEqual(f5.DefaultValue, "");
#endregion
#region Description
CDataValue f1desc = (CDataValue)_f1.Description;
CDataValue f2desc = (CDataValue)_f2.Description;
CDataValue f3desc = (CDataValue)_f3.Description;
CDataValue f4desc = (CDataValue)_f4.Description;
CDataValue f5desc = (CDataValue)_f5.Description;
Assert.AreEqual(f1.Description, f1desc.InderValue);
Assert.AreEqual(f2.Description, f2desc.InderValue);
Assert.AreEqual(f3.Description, f3desc.InderValue);
Assert.AreEqual(f4.Description, f4desc.InderValue);
Assert.AreEqual(f5.Description, f5desc.InderValue);
#endregion
#region Displayindex
Assert.AreEqual(f1.DisplayIndex, _f1.FieldValues[0].DisplayOrder);
Assert.AreEqual(f2.DisplayIndex, _f2.FieldValues[0].DisplayOrder);
Assert.AreEqual(f3.DisplayIndex, _f3.FieldValues[0].DisplayOrder);
Assert.AreEqual(f4.DisplayIndex, _f4.FieldValues[0].DisplayOrder);
Assert.AreEqual(f5.DisplayIndex, _f5.FieldValues[0].DisplayOrder);
#endregion
#region Dummy
Assert.AreEqual(f1.Dummy, 1);
Assert.AreEqual(f2.Dummy, 1);
Assert.AreEqual(f3.Dummy, 0);
Assert.AreEqual(f4.Dummy, 0);
Assert.AreEqual(f5.Dummy, 0);
#endregion
#region geolocation
#region enabled
Assert.AreEqual(f1.GeolocationEnabled, 0);
Assert.AreEqual(f2.GeolocationEnabled, 0);
Assert.AreEqual(f3.GeolocationEnabled, 0);
Assert.AreEqual(f4.GeolocationEnabled, 0);
Assert.AreEqual(f5.GeolocationEnabled, 1);
#endregion
#region forced
Assert.AreEqual(f1.GeolocationForced, 0);
Assert.AreEqual(f2.GeolocationForced, 1);
Assert.AreEqual(f3.GeolocationForced, 0);
Assert.AreEqual(f4.GeolocationForced, 0);
Assert.AreEqual(f5.GeolocationForced, 0);
#endregion
#region hidden
Assert.AreEqual(f1.GeolocationHidden, 1);
Assert.AreEqual(f2.GeolocationHidden, 0);
Assert.AreEqual(f3.GeolocationHidden, 1);
Assert.AreEqual(f4.GeolocationHidden, 1);
Assert.AreEqual(f5.GeolocationHidden, 1);
#endregion
#endregion
#region isNum
Assert.AreEqual(f1.IsNum, 0);
Assert.AreEqual(f2.IsNum, 0);
Assert.AreEqual(f3.IsNum, 0);
Assert.AreEqual(f4.IsNum, 0);
Assert.AreEqual(f5.IsNum, 0);
#endregion
#region Label
Assert.AreEqual(f1.Label, _f1.Label);
Assert.AreEqual(f2.Label, _f2.Label);
Assert.AreEqual(f3.Label, _f3.Label);
Assert.AreEqual(f4.Label, _f4.Label);
Assert.AreEqual(f5.Label, _f5.Label);
#endregion
#region Mandatory
Assert.AreEqual(f1.Mandatory, 1);
Assert.AreEqual(f2.Mandatory, 0);
Assert.AreEqual(f3.Mandatory, 1);
Assert.AreEqual(f4.Mandatory, 1);
Assert.AreEqual(f5.Mandatory, 1);
#endregion
#region maxLength
Assert.AreEqual(f1.MaxLength, 55);
Assert.AreEqual(f2.MaxLength, 5);
Assert.AreEqual(f3.MaxLength, 8);
Assert.AreEqual(f4.MaxLength, 666);
Assert.AreEqual(f5.MaxLength, 69);
#endregion
#region min/max_Value
#region max
Assert.AreEqual(f1.MaxValue, "55");
Assert.AreEqual(f2.MaxValue, "5");
Assert.AreEqual(f3.MaxValue, "4865");
Assert.AreEqual(f4.MaxValue, "41153");
Assert.AreEqual(f5.MaxValue, "69");
#endregion
#region min
Assert.AreEqual(f1.MinValue, "0");
Assert.AreEqual(f2.MinValue, "0");
Assert.AreEqual(f3.MinValue, "0");
Assert.AreEqual(f4.MinValue, "0");
Assert.AreEqual(f5.MinValue, "1");
#endregion
#endregion
#region Multi
Assert.AreEqual(f1.Multi, 0);
Assert.AreEqual(f2.Multi, 0);
Assert.AreEqual(f3.Multi, 0);
Assert.AreEqual(f4.Multi, 0);
Assert.AreEqual(f5.Multi, 0);
#endregion
#region Optional
Assert.AreEqual(f1.Optional, 0);
Assert.AreEqual(f2.Optional, 0);
Assert.AreEqual(f3.Optional, 1);
Assert.AreEqual(f4.Optional, 1);
Assert.AreEqual(f5.Optional, 1);
#endregion
#region Query_Type
Assert.AreEqual(f1.QueryType, null);
Assert.AreEqual(f2.QueryType, null);
Assert.AreEqual(f3.QueryType, null);
Assert.AreEqual(f4.QueryType, null);
Assert.AreEqual(f5.QueryType, null);
#endregion
#region Read_Only
Assert.AreEqual(f1.ReadOnly, 1);
Assert.AreEqual(f2.ReadOnly, 0);
Assert.AreEqual(f3.ReadOnly, 1);
Assert.AreEqual(f4.ReadOnly, 0);
Assert.AreEqual(f5.ReadOnly, 0);
#endregion
#region Selected
Assert.AreEqual(f1.Selected, 0);
Assert.AreEqual(f2.Selected, 0);
Assert.AreEqual(f3.Selected, 0);
Assert.AreEqual(f4.Selected, 1);
Assert.AreEqual(f5.Selected, 1);
#endregion
#region Split_Screen
Assert.AreEqual(f1.SplitScreen, 0);
Assert.AreEqual(f2.SplitScreen, 0);
Assert.AreEqual(f3.SplitScreen, 0);
Assert.AreEqual(f4.SplitScreen, 0);
Assert.AreEqual(f5.SplitScreen, 0);
#endregion
#region Stop_On_Save
Assert.AreEqual(f1.StopOnSave, 0);
Assert.AreEqual(f2.StopOnSave, 0);
Assert.AreEqual(f3.StopOnSave, 0);
Assert.AreEqual(f4.StopOnSave, 0);
Assert.AreEqual(f5.StopOnSave, 0);
#endregion
#region Unit_Name
Assert.AreEqual(f1.UnitName, "");
Assert.AreEqual(f2.UnitName, "");
Assert.AreEqual(f3.UnitName, "");
Assert.AreEqual(f4.UnitName, "");
Assert.AreEqual(f5.UnitName, "");
#endregion
#region Values
Assert.AreEqual(1, _f1.FieldValues.Count());
Assert.AreEqual(1, _f2.FieldValues.Count());
Assert.AreEqual(1, _f3.FieldValues.Count());
Assert.AreEqual(1, _f4.FieldValues.Count());
Assert.AreEqual(1, _f5.FieldValues.Count());
Assert.AreEqual(field_Values1.Value, _f1.FieldValues[0].Value);
Assert.AreEqual(field_Values2.Value, _f2.FieldValues[0].Value);
Assert.AreEqual(field_Values3.Value, _f3.FieldValues[0].Value);
Assert.AreEqual(field_Values4.Value, _f4.FieldValues[0].Value);
Assert.AreEqual(field_Values5.Value, _f5.FieldValues[0].Value);
#endregion
#region Version
Assert.AreEqual(f1.Version, 49);
Assert.AreEqual(f2.Version, 9);
Assert.AreEqual(f3.Version, 1);
Assert.AreEqual(f4.Version, 1);
Assert.AreEqual(f5.Version, 1);
#endregion
#endregion
}
.Select(type => (
type,
members: type.GetMembers().Where(member => member.DeclaringType?.Assembly == type.Assembly).ToArray(),
fields: type.GetFields().Where(field => field.DeclaringType?.Assembly == type.Assembly).ToArray(),
