/// <summary>
/// Execute convert ouput.
/// </summary>
/// <param name="resultObject">DataModel</param>
/// <returns>ResponseModel</returns>
private InitResponseModel Convert(InitDataModel resultObject)
{
// Local variable declaration
InitResponseModel responseModel = null;
IList <OutputAcceptModel> listAccepts = null;
MCodeCom mCodeCom = null;
OutputAcceptModel accept = null;
// Variable initialize
responseModel = new InitResponseModel();
listAccepts = new List <OutputAcceptModel>();
mCodeCom = new MCodeCom();
// Get value
var slipStatusName = string.Empty;
var paymentMethodsName = string.Empty;
var deleteFlagName = string.Empty;
var cbSlipStatus = new ComboModel();
foreach (var obj in resultObject.ListAccepts)
{
accept = new OutputAcceptModel();
accept.AcceptSlipNo = DataHelper.ToString(obj.AcceptSlipNo);
accept.SlipStatus = DataHelper.ToString(obj.SlipStatus);
slipStatusName = mCodeCom.GetCodeName(Logics.GROUP_SLIP_STATUS, accept.SlipStatus);
accept.SlipStatusName = DataHelper.ToString(slipStatusName);
accept.AcceptDate = DataHelper.ToString(Formats.DATE, obj.AcceptDate);
accept.DeliveryDate = DataHelper.ToString(Formats.DATE, obj.DeliveryDate);
accept.ClientCd = DataHelper.ToString(obj.ClientCd);
accept.ClientName = DataHelper.ToString(obj.ClientName);
accept.ClientAddress = DataHelper.ToString(obj.ClientAddress);
accept.ClientTel = DataHelper.ToString(obj.ClientTel);
accept.DeliveryCd = DataHelper.ToString(obj.DeliveryCd);
accept.DeliveryName = DataHelper.ToString(obj.DeliveryName);
accept.DeliveryAddress = DataHelper.ToString(obj.DeliveryAddress);
accept.DeliveryTel = DataHelper.ToString(obj.DeliveryTel);
accept.PaymentMethods = DataHelper.ToString(obj.PaymentMethods);
paymentMethodsName = mCodeCom.GetCodeName(Logics.GROUP_PAYMENT_METHODS, accept.PaymentMethods);
accept.PaymentMethodsName = DataHelper.ToString(paymentMethodsName);
accept.GiftCd = DataHelper.ToString(obj.GiftCd);
accept.ViewId = DataHelper.ToString(obj.ViewId);
accept.Notes = DataHelper.ToString(obj.Notes);
accept.UpdateUser = DataHelper.ToString(obj.UpdateUser);
accept.UpdateDate = DataHelper.ToString(Formats.UPDATE_DATE, obj.UpdateDate);
accept.DeleteFlag = DataHelper.ToString(obj.DeleteFlag);
deleteFlagName = mCodeCom.GetCodeName(Logics.GROUP_DELETE_FLAG, accept.DeleteFlag);
accept.DeleteFlagName = DataHelper.ToString(deleteFlagName);
cbSlipStatus = MCodeCom.ToComboItems(resultObject.ListSlipStatus, accept.SlipStatus);
accept.ListSlipStatus = cbSlipStatus.ListItems;
accept.SlipStatus = cbSlipStatus.SeletedValue;
listAccepts.Add(accept);
}
// Set value
cbSlipStatus = MCodeCom.ToComboItems(resultObject.ListSlipStatus, null);
responseModel.ListSlipStatus = cbSlipStatus.ListItems;
responseModel.SlipStatus = cbSlipStatus.SeletedValue;
responseModel.AcceptDateStart = DataHelper.ToString(Formats.DATE, resultObject.AcceptDateStart);
responseModel.AcceptDateEnd = DataHelper.ToString(Formats.DATE, resultObject.AcceptDateEnd);
responseModel.ListAccepts = listAccepts;
// Return value
return(responseModel);
}
public async Task <List <ComboModel> > LoadComboModel(string commandText, string valueField, string textField, string descField)
{
var comboList = new List <ComboModel>();
var fields = new Dictionary <string, string>();
using (var command = db.Database.GetDbConnection().CreateCommand())
{
command.CommandText = commandText;
db.Database.OpenConnection();
using (var reader = await command.ExecuteReaderAsync())
{
for (var i = 0; i < reader.FieldCount; i++)
{
var name = reader.GetName(i);
if (name.Equals(valueField, StringComparison.CurrentCultureIgnoreCase))
{
fields["ValueField"] = name;
}
if (name.Equals(textField, StringComparison.CurrentCultureIgnoreCase))
{
fields["TextField"] = name;
}
if (name.Equals(descField, StringComparison.CurrentCultureIgnoreCase))
{
fields["DescField"] = name;
}
}
while (reader.Read())
{
var combo = new ComboModel();
foreach (var field in fields.Values)
{
if (field.Equals(valueField, StringComparison.CurrentCultureIgnoreCase))
{
combo.Value = reader[field].ToString();
}
if (field.Equals(textField, StringComparison.CurrentCultureIgnoreCase))
{
combo.Text = reader[field].ToString();
}
if (field.Equals(descField, StringComparison.CurrentCultureIgnoreCase))
{
combo.Desc = reader[field].ToString();
}
}
comboList.Add(combo);
}
}
db.Database.CloseConnection();
}
return(comboList);
}
public string GenerateTable <T>(Stack <T> stack, int option)
{
ComboModel comboModel = new ComboModel();
string _table = "";
int itelator = 0;
while (stack.Count > 0)
{
if (option == 0)
{
ProcessList processList = (ProcessList)(object)stack.Pop();
if (processList == null)
{
_table += "";
}
_table += "<h4>Data raportu: " + DateTimeOffset.FromUnixTimeSeconds(processList.Timestamp) + "</h4>";
_table += @"<div class=""table-responsive""><table class=""table table-striped table-sm""><thead><tr><th scope=""col"">#</th><th scope=""col"">ID</th><th scope=""col"">Nazwa</th><th scope=""col"">Data startu</th></tr></thead><tbody>";
foreach (var modelProcessList in processList.ProcessObjectList)
{
itelator++;
StringBuilder tempBuilder = new StringBuilder();
tempBuilder.AppendFormat(
@"<tr><th scope=""row"">{0}</th><td>{1}</td><td>{2}</td><td>{3}</td></tr>", itelator, modelProcessList.Id, modelProcessList.Name, modelProcessList.StartTime);
_table += tempBuilder.ToString();
}
_table += "</table> </div>";
itelator = 0;
}
if (option == 1)
{
BrowsingHistoryLists browsingHistory = (BrowsingHistoryLists)(object)stack.Pop();
_table += "<h4>Data raportu: " + DateTimeOffset.FromUnixTimeSeconds(browsingHistory.Timestamp) + "</h4>";
_table += @"<div class=""table-responsive""><table class=""table table-striped table-sm""><thead><tr><th scope=""col"">#</th><th scope=""col"">Nazwa strony www</th><th scope=""col"">Adres URL</th><th scope=""col"">Czas spędzony na witrynie</th><th scope=""col"">Czas ostatniej wizyty</th></tr></thead><tbody>";
foreach (var moBrowsingHistoryTab in browsingHistory.BrowsingHistoryList)
{
itelator++;
StringBuilder tempBuilder = new StringBuilder();
tempBuilder.AppendFormat(
@"<tr><th scope=""row"">{0}</th><td>{1}</td><td>{2}</td><td>{3}</td><td>{4}</td></tr>", itelator, moBrowsingHistoryTab.GetTitle, moBrowsingHistoryTab.GetUrl, moBrowsingHistoryTab.GetDurationTime, DateTimeOffset.FromUnixTimeSeconds(moBrowsingHistoryTab.GetLastVisitTime));
_table += tempBuilder.ToString();
}
_table += "</table> </div>";
itelator = 0;
}
if (option == 2)
{
FileDirectoryList fileDirectory = (FileDirectoryList)(object)stack.Pop();
_table += "<h4>Data raportu: " + DateTimeOffset.FromUnixTimeSeconds(fileDirectory.Timestamp) + "</h4>";
_table += @"<div class=""table-responsive""><table class=""table table-striped table-sm""><thead><tr><th scope=""col"">#</th><th scope=""col"">Ścieżka dostępu</th><th scope=""col"">Data utworzenia </th><th scope=""col"">Data ostatniego dostępu</th><th scope=""col"">Data ostatniego zapisu</th></tr></thead><tbody>";
foreach (var moFileDirectory in fileDirectory.FileDirectories)
{
itelator++;
StringBuilder tempBuilder = new StringBuilder();
tempBuilder.AppendFormat(
@"<tr><th scope=""row"">{0}</th><td>{1}</td><td>{2}</td><td>{3}</td><td>{4}</td></tr>", itelator, moFileDirectory.FullName, moFileDirectory.CreationTimeUtc, moFileDirectory.LastAccessTimeUtc, moFileDirectory.LastWriteTimeUtc);
_table += tempBuilder.ToString();
}
_table += "</table> </div>";
itelator = 0;
}
}
return(_table);
}
static void combo_SelectedValueTest(Assert Assert)
{
var model = new ComboModel
{
Items = new List <SimpleClass1>
{
new SimpleClass1
{
LastName = "Neşet Ertaş",
YearNullable = 5
},
new SimpleClass1
{
LastName = "Neşet Ertaş2",
YearNullable = 7
},
new SimpleClass1
{
LastName = "Neşet Ertaş -1",
YearNullable = -1
},
new SimpleClass1
{
LastName = "Neşet Ertaş null",
YearNullable = null
}
},
SelectedYear = 5
};
var htmlString = @"
<combo ItemsSource ='{Items}'
DisplayMemberPath = 'LastName'
SelectedValuePath = 'YearNullable'
SelectedValue = '{SelectedYear}' />
";
var ui = (Combo)TestHelper.BuildAndGetFirstLogicalChild(htmlString, model);
Assert.IsTrue(null != ui.SelectedValue);
Assert.IsTrue(ui.SelectedValue is int);
Assert.AreEqual(5, (int?)(ui.SelectedValue));
Assert.True(model.Items[0] == ui.SelectedItem);
ui.SelectedValue = 7;
Assert.AreEqual(7, model.SelectedYear);
Assert.True(model.Items[1] == ui.SelectedItem);
ui.SelectedValue = -1;
Assert.AreEqual(-1, model.SelectedYear);
Assert.True(model.Items[2] == ui.SelectedItem);
ui.SelectedValue = null;
Assert.AreEqual(null, model.SelectedYear);
Assert.True(model.Items[3] == ui.SelectedItem);
model = new ComboModel
{
Items = new List <SimpleClass1>
{
new SimpleClass1
{
LastName = "Neşet Ertaş",
YearNullable = 5
},
new SimpleClass1
{
LastName = "Neşet Ertaş2",
YearNullable = 7
},
new SimpleClass1
{
LastName = "Neşet Ertaş -1",
YearNullable = -1
},
new SimpleClass1
{
LastName = "Neşet Ertaş null",
YearNullable = null
}
},
SelectedYear = 7
};
ui.DataContext = model;
Assert.True(7 == ui.SelectedValue.ToInt32());
Assert.True(model.Items[1] == ui.SelectedItem);
model = new ComboModel
{
Items = new List <SimpleClass1>
{
new SimpleClass1
{
LastName = "Neşet Ertaş",
YearNullable = 5
},
new SimpleClass1
{
LastName = "Neşet Ertaş2",
YearNullable = 7
},
new SimpleClass1
{
LastName = "Neşet Ertaş -1",
YearNullable = -1
},
new SimpleClass1
{
LastName = "Neşet Ertaş null",
YearNullable = null
}
},
SelectedYear = null
};
ui.DataContext = model;
Assert.True(null == ui.SelectedValue);
Assert.True(model.Items[3] == ui.SelectedItem);
model.Items = new List <SimpleClass1>
{
new SimpleClass1
{
LastName = "Neşet Ertaş",
YearNullable = 5
},
new SimpleClass1
{
LastName = "Neşet Ertaş null",
YearNullable = null
},
new SimpleClass1
{
LastName = "Neşet Ertaş2",
YearNullable = 7
},
new SimpleClass1
{
LastName = "Neşet Ertaş -1",
YearNullable = -1
}
};
Assert.True(null == ui.SelectedValue);
Assert.True(model.Items[1] == ui.SelectedItem);
}
