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