// Method ListDataByCoumn
public Dictionary <string, object> ListDataByCoumn(string column)
{
List <string> data = UsersDao.Instance.ListDataByColumn(HelperBll.GetColumnNameInSQLByPropertyName <UsersModel>(column));
Dictionary <string, object> dics = new Dictionary <string, object>();
Type t = HelperBll.GetTypeOfProperty <UsersModel>(column);
if (t != null && t == typeof(Boolean))
{
switch (column)
{
case "Sex":
foreach (string item in data)
{
if (item == "True")
{
dics.Add("Nam", 1);
}
else if (item == "False")
{
dics.Add("Nữ", 0);
}
}
break;
case "Status":
foreach (string item in data)
{
if (item == "True")
{
dics.Add("Kích hoạt", 1);
}
else if (item == "False")
{
dics.Add("Khóa", 1);
}
}
break;
}
return(dics);
}
else
{
foreach (string item in data)
{
dics.Add(item, item);
}
return(dics);
}
}
public void Test_SaveProductInformationFromPos_Map_Response()
{
DateTime validTill = DateTime.UtcNow;
string phoneReservation = "8 600 54321";
string emailReservation = "*****@*****.**";
ProductServiceLocation location = new ProductServiceLocation();
location.Id = 1;
location.Name = "LocName";
location.City = "Wilno";
location.Address = "Juozapavi\u010diaus g. 9A - 174";
uint productValidTillTm = new HelperBll().GetUnixTimestamp();
var jsonResponse = "{\"Status\":\"true\",\"Message\":\"\",\"PosId\":1005,\"ProductName\":\"Gilus prisilietimas\",\"ProductDuration\":\"40 min\",\"ProductDescription\":\"NO\",\"RequestedAmountMinor\":\"3500\",\"CurrencyCode\":\"EUR\",\"ProductValidTillTm\":" + productValidTillTm + ",\"PosName\":\"\",\"PosUrl\":\"\",\"PosCity\":\"\",\"PosAddress\":\"\",\"PhoneForReservation\":\"" + phoneReservation + "\",\"EmailForReservation\":\"" + emailReservation + "\",\"Locations\":[{\"Id\":\"" + location.Id + "\",\"Name\":\"" + location.Name + "\",\"City\":\"" + location.City + "\",\"Address\":\"" + location.Address + "\"},{\"Id\":\"2\",\"Name\":\"SIGMOS SPORTO KLUBAS\",\"City\":\"Vilnius\",\"Address\":\"Kalvarij\u0173 g.131 Luk\u0161io g. 2\"}]}";
var posResponse = JsonConvert.DeserializeObject <PaymentRequestValidationResponse>(jsonResponse);
var co = new ProductCheckoutModel();
co.PaymentSystem = PaymentSystems.Paysera;
co.LocationId = location.Id;
co.CurrencyCode = "EUR";
co.CustomerEmail = "*****@*****.**";
co.CustomerName = "Aleksej Tak";
co.CustomerPhone = "+370 600 12345";
co.Remarks = "Suck it!";
var product = _productsBll.SaveProductInformationFromPos("12345678901234567890123456789012", posResponse, co);
Assert.AreEqual("Gilus prisilietimas", product.ProductName);
Assert.AreEqual("NO", product.ProductDescription);
Assert.AreEqual(35m, product.ProductPrice);
Assert.AreEqual("EUR", product.CurrencyCode);
Assert.AreEqual(1005, product.PosId);
Assert.IsTrue((validTill - product.ValidTill).TotalSeconds < 1);
Assert.AreEqual(co.CustomerName, product.CustomerName);
Assert.AreEqual(co.CustomerEmail, product.CustomerEmail);
Assert.AreEqual(co.CustomerPhone, product.CustomerPhone);
Assert.AreEqual(co.Remarks, product.Remarks);
Assert.AreEqual(PaymentSystems.Paysera, product.PaymentSystem);
Assert.IsFalse(String.IsNullOrEmpty(product.ProductUid));
Assert.AreEqual(location.Name, product.PosName);
Assert.AreEqual(location.City, product.PosCity);
Assert.AreEqual(location.Address, product.PosAddress);
Assert.AreEqual(product.PhoneForReservation, phoneReservation);
Assert.AreEqual(product.EmailForReservation, emailReservation);
}
// Method ListDataByCoumn
public Dictionary <string, object> ListDataByCoumn(string column)
{
List <string> data = StuffsDao.Instance.ListDataByColumn(HelperBll.GetColumnNameInSQLByPropertyName <StuffsModel>(column));
Dictionary <string, object> dics = new Dictionary <string, object>();
foreach (string item in data)
{
dics.Add(item, item);
}
return(dics);
}
// Method ListForExcel
public void ListForExcel(MetroGrid grid, string keyword, string sortColumn, string sortBy, string columnFilter, object filterValue)
{
grid.Rows.Clear();
grid.Columns.Clear();
List <StuffsModel> stuffs = StuffsDao.Instance.ListForExcel(keyword, !string.IsNullOrEmpty(sortColumn) ? HelperBll.GetColumnNameInSQLByPropertyName <StuffsModel>(sortColumn) : "", sortBy, !string.IsNullOrEmpty(columnFilter) ? HelperBll.GetColumnNameInSQLByPropertyName <StuffsModel>(columnFilter) : "", filterValue);
StuffsModel nameOf = new StuffsModel();
grid.Columns.Add(nameof(nameOf.BQCode), nameof(nameOf.BQCode));
grid.Columns.Add(nameof(nameOf.Name), nameof(nameOf.Name));
grid.Columns.Add(nameof(nameOf.Category), nameof(nameOf.Category));
grid.Columns.Add(nameof(nameOf.PlaceStuff), nameof(nameOf.PlaceStuff));
grid.Columns.Add(nameof(nameOf.DateBuy), nameof(nameOf.DateBuy));
grid.Columns.Add(nameof(nameOf.DateUse), nameof(nameOf.DateUse));
grid.Columns.Add(nameof(nameOf.YearRelease), nameof(nameOf.YearRelease));
grid.Columns.Add(nameof(nameOf.ColorStuffs), nameof(nameOf.ColorStuffs));
grid.Columns.Add(nameof(nameOf.State), nameof(nameOf.State));
grid.Columns.Add(nameof(nameOf.PriceBuy), nameof(nameOf.PriceBuy));
grid.Columns.Add(nameof(nameOf.Warranty), nameof(nameOf.Warranty));
grid.Columns.Add(nameof(nameOf.CreatedDate), nameof(nameOf.CreatedDate));
grid.Columns.Add(nameof(nameOf.CreatedBy), nameof(nameOf.CreatedBy));
grid.Columns.Add(nameof(nameOf.ModifiedDate), nameof(nameOf.ModifiedDate));
grid.Columns.Add(nameof(nameOf.ModifiedBy), nameof(nameOf.ModifiedBy));
for (int i = 0; i < stuffs.Count; i++)
{
grid.Rows.Add();
grid[nameof(nameOf.BQCode), i].Value = stuffs[i].BQCode;
grid[nameof(nameOf.Name), i].Value = stuffs[i].Name;
grid[nameof(nameOf.Category), i].Value = stuffs[i].Category;
grid[nameof(nameOf.PlaceStuff), i].Value = stuffs[i].PlaceStuff;
grid[nameof(nameOf.DateBuy), i].Value = stuffs[i].DateBuy;
grid[nameof(nameOf.DateUse), i].Value = stuffs[i].DateUse;
grid[nameof(nameOf.YearRelease), i].Value = stuffs[i].YearRelease;
grid[nameof(nameOf.ColorStuffs), i].Value = stuffs[i].ColorStuffs;
grid[nameof(nameOf.State), i].Value = stuffs[i].State;
grid[nameof(nameOf.PriceBuy), i].Value = stuffs[i].PriceBuy;
grid[nameof(nameOf.Warranty), i].Value = stuffs[i].Warranty;
grid[nameof(nameOf.CreatedDate), i].Value = stuffs[i].CreatedDate;
grid[nameof(nameOf.CreatedBy), i].Value = stuffs[i].CreatedBy;
grid[nameof(nameOf.ModifiedDate), i].Value = stuffs[i].ModifiedDate.ToString() == "01-Jan-01 12:00:00 AM" ? "" : stuffs[i].ModifiedDate.ToString();
grid[nameof(nameOf.ModifiedBy), i].Value = stuffs[i].ModifiedBy;
}
}
// Method ListForExcel
public void ListForExcel(MetroGrid grid, string keyword, string sortColumn, string sortBy)
{
grid.Rows.Clear();
grid.Columns.Clear();
List <CategoriesModel> stuffs = CategoriesDao.Instance.ListForExcel(keyword, !string.IsNullOrEmpty(sortColumn) ? HelperBll.GetColumnNameInSQLByPropertyName <CategoriesModel>(sortColumn) : "", sortBy);
CategoriesModel nameOf = new CategoriesModel();
grid.Columns.Add(nameof(nameOf.Name), nameof(nameOf.Name));
grid.Columns.Add(nameof(nameOf.CreatedDate), nameof(nameOf.CreatedDate));
grid.Columns.Add(nameof(nameOf.CreatedBy), nameof(nameOf.CreatedBy));
grid.Columns.Add(nameof(nameOf.ModifiedDate), nameof(nameOf.ModifiedDate));
grid.Columns.Add(nameof(nameOf.ModifiedBy), nameof(nameOf.ModifiedBy));
grid.Columns.Add(nameof(nameOf.CountStuffs), nameof(nameOf.CountStuffs));
for (int i = 0; i < stuffs.Count; i++)
{
grid.Rows.Add();
grid[nameof(nameOf.Name), i].Value = stuffs[i].Name;
grid[nameof(nameOf.CreatedDate), i].Value = stuffs[i].CreatedDate;
grid[nameof(nameOf.CreatedBy), i].Value = stuffs[i].CreatedBy;
grid[nameof(nameOf.ModifiedDate), i].Value = stuffs[i].ModifiedDate.ToString() == "01-Jan-01 12:00:00 AM" ? "" : stuffs[i].ModifiedDate.ToString();
grid[nameof(nameOf.ModifiedBy), i].Value = stuffs[i].ModifiedBy;
grid[nameof(nameOf.CountStuffs), i].Value = stuffs[i].CountStuffs;
}
}
// Method ListForExcel
public void ListForExcel(MetroGrid grid, string keyword, string sortColumn, string sortBy)
{
grid.Rows.Clear();
grid.Columns.Clear();
List <PlaceStuffsModel> stuffs = PlaceStuffsDao.Instance.ListForExcel(keyword, !string.IsNullOrEmpty(sortColumn) ? HelperBll.GetColumnNameInSQLByPropertyName <PlaceStuffsModel>(sortColumn) : "", sortBy);
PlaceStuffsModel nameOf = new PlaceStuffsModel();
grid.Columns.Add(nameof(nameOf.Name), nameof(nameOf.Name));
grid.Columns.Add(nameof(nameOf.CountStuffs), nameof(nameOf.CountStuffs));
for (int i = 0; i < stuffs.Count; i++)
{
grid.Rows.Add();
grid[nameof(nameOf.Name), i].Value = stuffs[i].Name;
grid[nameof(nameOf.CountStuffs), i].Value = stuffs[i].CountStuffs;
}
}
// Method ListForExcel
public void ListForExcel(MetroGrid grid, string keyword, string sortColumn, string sortBy, string columnFilter, object filterValue)
{
grid.Rows.Clear();
grid.Columns.Clear();
List <UsersModel> stuffs = UsersDao.Instance.ListForExcel(keyword, !string.IsNullOrEmpty(sortColumn) ? HelperBll.GetColumnNameInSQLByPropertyName <UsersModel>(sortColumn) : "", sortBy, !string.IsNullOrEmpty(columnFilter) ? HelperBll.GetColumnNameInSQLByPropertyName <UsersModel>(columnFilter) : "", filterValue);
UsersModel nameOf = new UsersModel();
grid.Columns.Add(nameof(nameOf.Name), nameof(nameOf.Name));
grid.Columns.Add(nameof(nameOf.RoleName), nameof(nameOf.RoleName));
grid.Columns.Add(nameof(nameOf.Sex), nameof(nameOf.Sex));
grid.Columns.Add(nameof(nameOf.BirthOfDate), nameof(nameOf.BirthOfDate));
grid.Columns.Add(nameof(nameOf.Email), nameof(nameOf.Email));
grid.Columns.Add(nameof(nameOf.PhoneNumber), nameof(nameOf.PhoneNumber));
grid.Columns.Add(nameof(nameOf.Status), nameof(nameOf.Status));
grid.Columns.Add(nameof(nameOf.CreatedDate), nameof(nameOf.CreatedDate));
grid.Columns.Add(nameof(nameOf.CreatedBy), nameof(nameOf.CreatedBy));
grid.Columns.Add(nameof(nameOf.ModifiedDate), nameof(nameOf.ModifiedDate));
grid.Columns.Add(nameof(nameOf.ModifiedBy), nameof(nameOf.ModifiedBy));
for (int i = 0; i < stuffs.Count; i++)
{
grid.Rows.Add();
grid[nameof(nameOf.Name), i].Value = stuffs[i].Name;
grid[nameof(nameOf.RoleName), i].Value = stuffs[i].RoleName;
grid[nameof(nameOf.Sex), i].Value = stuffs[i].Sex ? "Nam" : "Nữ";
grid[nameof(nameOf.BirthOfDate), i].Value = stuffs[i].BirthOfDate;
grid[nameof(nameOf.Email), i].Value = stuffs[i].Email;
grid[nameof(nameOf.PhoneNumber), i].Value = stuffs[i].PhoneNumber;
grid[nameof(nameOf.Status), i].Value = stuffs[i].Status ? "Kích hoạt" : "Khóa";
grid[nameof(nameOf.CreatedDate), i].Value = stuffs[i].CreatedDate;
grid[nameof(nameOf.CreatedBy), i].Value = stuffs[i].CreatedBy;
grid[nameof(nameOf.ModifiedDate), i].Value = stuffs[i].ModifiedDate.ToString() == "01-Jan-01 12:00:00 AM" ? "" : stuffs[i].ModifiedDate.ToString();
grid[nameof(nameOf.ModifiedBy), i].Value = stuffs[i].ModifiedBy;
}
}
