public string SearchRole(PaginationData pd)
{
ListViewData <RoleInfo> view = new ListViewData <RoleInfo>();
view.PageData.PageIndex = pd.PageIndex;
view.PageData.PageSize = pd.PageSize;
view.PageData.PagintionJsFunction = "window.System.RoleTab.searchRole()";
view.PageData.OrderBy = pd.OrderBy;
string sql = @"SELECT A.*, CASE WHEN B.OrganizationName IS NOT NULL THEN STUFF(B.OrganizationName, 1, 1, '') ELSE '' END AS OrganizationName,
CASE WHEN C.UserName IS NOT NULL THEN STUFF(C.UserName, 1, 1, '') ELSE '' END AS UserName
FROM dbo.RoleInfo AS A
OUTER APPLY (SELECT ';' + IB.Name
FROM dbo.RoleToBusiness AS IA
INNER JOIN dbo.Organization AS IB ON IA.BusinessGuid = IB.UnitGuid
WHERE IB.Name > ''
ORDER BY IB.Code
FOR XML PATH('')) AS B(OrganizationName)
OUTER APPLY (SELECT ';' + IB.UserName
FROM dbo.RoleToBusiness AS IA
INNER JOIN dbo.UserInfo AS IB ON IA.BusinessGuid = IB.UserGuid
WHERE IB.UserName > ''
ORDER BY IB.UserCode
FOR XML PATH('')) AS C(UserName)";
view.List = new Pagintion(sql, null, view.PageData).ToList <RoleInfo>();
string table = UserControlExcutor.RenderUserControl("/System/UserControl/RoleList.ascx", view.List);
string pagination = UserControlExcutor.RenderUserControl("/System/CommonUserControl/Pagination.ascx", view.PageData);
return(JsonHelper.ToJson(new { table = table, pagination = pagination }));
}
private void InitializeControl()
{
//setting listview
FileListView.FullRowSelect = true;
FileListView.ShowGroups = false;
FileListView.HeaderUsesThemes = false;
FileListView.HideSelection = true;
FileListView.ItemSelectionChanged += FileListView_ItemSelectionChanged;
OLVColumn[] columns = new []
{
ListViewData.CreateColumn("FileName", "파일명", "FileName", 150),
ListViewData.CreateColumn("FileSize", "사이즈", "FileSize", 75),
ListViewData.CreateColumn("FileState", "상태", "FileState", 65),
};
ColumnHeader[] headers = new ColumnHeader[columns.Length];
for (int idx = 0; idx < columns.Length; idx++)
{
headers[idx] = columns[idx];
FileListView.AllColumns.Add(columns[idx]);
}
FileListView.Columns.AddRange(headers);
}
public async Task GetFacebookProfile(String token)
{
var url = "https://graph.facebook.com/v2.7/me/" + "?fields=name" + "&access_token=" + token;
var httpClient = new HttpClient();
var userJson = await httpClient.GetStringAsync(url);
JsonTextReader reader = new JsonTextReader(new StringReader(userJson));
var result = JsonConvert.DeserializeObject <FaceBookView>(userJson);
LoginPage.userName = result.name;
App.isLogin = true;
App.RootPage.Master.IsVisible = true;
App.RootPage.Master.IsEnabled = true;
App.RootPage.Detail = new NavigationPage(new HomePage());
List <JsonUserModel> x = await AzureManager.AzureManagerInstance.QueryLogin(result.name);
if (x.Count == 0)
{
JsonUserModel details = new JsonUserModel()
{
UserName = result.name
};
await AzureManager.AzureManagerInstance.AddDetails(details);
}
else
{
LoginPage.usermodel = x[0];
ListViewData.populateHashMap();
LoginPage.checkFavs();
}
}
void ProcessView(ListViewData _obj)
{
DataGridViewRow dgvRow;
DataGridViewCell dgvCell;
dgvRow = new DataGridViewRow();
//dgvRow.DefaultCellStyle.Font = new Font(this.Font, FontStyle.Regular);
if (_obj.Result == "Failed")
{
dgvRow.DefaultCellStyle.ForeColor = Color.Red;
}
dgvCell = new DataGridViewTextBoxCell(); //Column Time
var dataTimeInfo = DateTime.Now.ToString("yyyy-MM-dd HH:MM:ss");
dgvCell.Value = dataTimeInfo;
dgvRow.Cells.Add(dgvCell);
//
dgvCell = new DataGridViewTextBoxCell();
dgvCell.Value = _obj.Ch;
dgvRow.Cells.Add(dgvCell);
//
dgvCell = new DataGridViewTextBoxCell();
dgvCell.Value = _obj.Step;
dgvRow.Cells.Add(dgvCell);
//
dgvCell = new DataGridViewTextBoxCell();
dgvCell.Value = _obj.Result;
dgvRow.Cells.Add(dgvCell);
//
dgvCell = new DataGridViewTextBoxCell();
dgvCell.Value = _obj.RowData;
dgvRow.Cells.Add(dgvCell);
m_DataGridViewCtrlAddDataRow(dgvRow);
}
private List <ObjectChange> CollectChanges(ListViewData data)
{
changes.Clear();
foreach (T itemData in data.dataList)
{
if (HasItem(itemData))
{
changes.Add(new ObjectChange {
data = itemData, op = ListOpType.Update
});
}
else
{
changes.Add(new ObjectChange {
data = itemData, op = ListOpType.Add
});
}
}
foreach (ListItemView <T> view in views)
{
if (!HasData(data.dataList, view.data))
{
changes.Add(new ObjectChange {
data = view.data, op = ListOpType.Remove
});
}
}
return(changes);
}
private async Task SaveData(string type)
{
if (DataInput == null)
{
DataInput = new DataInput
{
Amount = Amount,
Description = Description,
UserId = Globals.currentUser.Id,
Type = type,
EntryDate = SelectedDate,
UpdateDate = Convert.ToDateTime(Globals.phoneDate)
};
}
if (DataInput != null)
{
if (DataInput.Description != Description || DataInput.Amount != Amount || DataInput.EntryDate != SelectedDate)
{
DataInput.Amount = Amount;
DataInput.EntryDate = SelectedDate;
DataInput.Description = Description;
DataInput.UpdateDate = Convert.ToDateTime(Globals.phoneDate);
}
}
if (string.IsNullOrWhiteSpace(Description) && Amount == 0)
{
await _pageService.DisplayAlert("ERROR", "Input Failed : Please complete the description/source and amount", "OK");
return;
}
if (DataInput.Id == 0)
{
await _dataInputInterface.AddDataInput(DataInput);
await _pageService.DisplayAlert("MEESEES", "Input Successfully Saved: " + $"Description: {DataInput.Description}, Amount = {DataInput.Amount}.", "OK");
ListViewData.Add(new DataInputViewModel(DataInput));
}
else
{
await _dataInputInterface.UpdateData(DataInput);
await _pageService.DisplayAlert("MEESEES", "Input Successfully Updated: " + $"Description: {DataInput.Description}, Amount = {DataInput.Amount}.", "OK");
var DataInList = ListViewData.Single(c => c.Id == DataInput.Id);
DataInList.Id = DataInput.Id;
DataInList.Description = DataInput.Description;
DataInList.Amount = DataInput.Amount;
DataInList.Type = DataInput.Type;
DataInList.UserId = DataInput.UserId;
DataInList.EntryDate = DataInput.EntryDate;
DataInList.UpdateDate = DataInput.UpdateDate;
}
SelectedDataInput = null;
DataInput = null;
Amount = 0;
Description = null;
}
public void EditList(string message, string fileName, int number, int image)
{
var data = new ListViewData {
Message = message, FileName = fileName, Number = number, Image = image
};
downloadData[number] = (data);
}
public ViewResult List()
{
Check.RequireThrowNotAuthorized(CurrentPerson.WebServiceAccessToken.HasValue, "Person must have already received their access token before accessing web service list.");
var allMethods = FindAttributedMethods(typeof(IWebServices), typeof(WebServiceDocumentationAttribute));
var serviceDocumentationList = allMethods.Select(c => new WebServiceDocumentation(c)).ToList();
var viewData = new ListViewData(CurrentPerson, new WebServiceToken(CurrentPerson.WebServiceAccessToken.Value.ToString()), serviceDocumentationList);
return(RazorView <List, ListViewData>(viewData));
}
public void List()
{
var section = this.CurrentContentItem as Section;
var items = section.List(1, 40);
var vd = new ListViewData<IContentItem>(items, section);
//RenderView("List", vd);
}
/// <summary>
/// Refreshses the ListView row with given values
/// </summary>
/// <param name="value1">Value for column 1</param>
private void RefreshListView(string value1)
{
ListViewData lvc = (ListViewData)urlListView.SelectedItem;
if (lvc != null && !_stopRefreshControls)
{
SetDataChanged(true);
lvc.Col1 = value1;
urlListView.Items.Refresh();
}
}
public void List()
{
var authors = Author.List();
var ci = new ListViewData<Author>(authors);
ci.CurrentContent = ContentItem.Get("/");
Response.ContentType = "text/xml";
Response.Write(Mubble.Data.Serialization.Xml.Serialize(authors));
//RenderView("List", ci);
}
/// <summary>
/// urlListView SelectionChnaged event handler.
/// Updates the textboxes with values in the row.
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void urlListView_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
ListViewData lvc = (ListViewData)urlListView.SelectedItem;
if (lvc != null)
{
_stopRefreshControls = true;
urlTextBox.Text = lvc.Col1;
_stopRefreshControls = false;
}
}
public ViewResult List()
{
Check.RequireThrowNotAuthorized(CurrentPerson?.WebServiceAccessToken != null, "Person must have already received their access token before accessing web service list.");
var firmaPage = FirmaPageTypeEnum.WebServicesList.GetFirmaPage();
var allMethods = FindAttributedMethods(typeof(IWebServices), typeof(WebServiceDocumentationAttribute));
var serviceDocumentationList = allMethods.Select(c => new WebServiceDocumentation(c)).ToList();
var geospatialAreaTypeList = HttpRequestStorage.DatabaseEntities.GeospatialAreaTypes.ToList();
var webServiceAccessToken = new WebServiceToken(CurrentPerson.WebServiceAccessToken.Value.ToString());
var viewData = new ListViewData(CurrentFirmaSession, webServiceAccessToken, serviceDocumentationList, geospatialAreaTypeList, firmaPage);
return(RazorView <List, ListViewData>(viewData));
}
private async void LoginClicked(Object sender, EventArgs args)
{
if (Username.Text == null | Password.Text == null)
{
await DisplayAlert("Invalid Username or Password", "Incorrect username or password", "Ok");
}
else
{
Activity.IsRunning = true;
login.IsEnabled = false;
signup.IsEnabled = false;
List <JsonUserModel> x = await AzureManager.AzureManagerInstance.QueryLogin(Username.Text);
if (x.Count == 0)
{
if (App.isLogin == false)
{
await DisplayAlert("Invalid Username or Password", "Incorrect username or password", "Ok");
}
Activity.IsRunning = false;
}
else if (!x[0].Password.Equals(Password.Text))
{
if (App.isLogin == false)
{
await DisplayAlert("Invalid Username or Password", "Incorrect username or password", "Ok");
}
Activity.IsRunning = false;
}
else
{
Activity.IsRunning = false;
App.RootPage.Detail = new NavigationPage(new HomePage());
App.isLogin = true;
App.RootPage.Master.IsVisible = true;
App.RootPage.Master.IsEnabled = true;
userName = Username.Text;
usermodel = x[0];
ListViewData.populateHashMap();
checkFavs();
}
login.IsEnabled = true;
signup.IsEnabled = true;
}
}
private async Task DeleteInput(DataInputViewModel viewModel)
{
string type = viewModel.Type == "F" ? "Fund :" : "Expense :";
if (await _pageService.DisplayAlert("Warning", $"Are you sure you want to delete {type} {viewModel.Description} : {viewModel.Amount}?", "YES", "NO"))
{
var data = await _dataInputInterface.GetDataInput(viewModel.Id);
await _dataInputInterface.DeleteData(data);
ListViewData.Remove(viewModel);
}
SelectedDataInput = null;
DataInput = null;
Amount = 0;
Description = null;
}
public async Task DeleteData(UserDataViewModel data)
{
string _type = data.Type == "F" ? "Fund :" : data.Type == "S" ? "Savings :" : data.Type == "E" ? "Expense :" : "";
if (await _pageService.DisplayAlert("WARNING", $"Are you sure you want to delete this record? Type : {_type}, Amount : {data.Amount}, Remarks : {data.Description}", "YES", "NO"))
{
var userdata = await _generalInterface.GetUserData(data.Id);
await _generalInterface.DeleteUserData(userdata);
ListViewData.Remove(data);
}
else
{
return;
}
}
private async void OnItemSelected(object sender, SelectedItemChangedEventArgs a)
{
if (a.SelectedItem != null)
{
var s = a.SelectedItem as Product;
var action = await DisplayActionSheet("Send to", "Return", null, "Cart", "Favourites");
listView.SelectedItem = null;
switch (action)
{
case "Cart":
ListViewData.CartList.Add(s);
break;
case "Favourites":
ListViewData.addToFavourites(s);
break;
}
}
}
public string SearchPermissionToRole(PaginationData pd, Guid actionGuid)
{
ListViewData <RoleInfo> view = new ListViewData <RoleInfo>();
view.PageData.PagintionJsFunction = "window.System.PermissionToRoleList.search()";
view.PageData.PageIndex = pd.PageIndex;
view.PageData.PageSize = pd.PageSize;
view.PageData.OrderBy = pd.OrderBy;
string sql = @"SELECT A.*, B.RoleToPermissionGuid AS PermissionGuid
FROM dbo.RoleInfo AS A
LEFT JOIN dbo.RoleToPermission AS B ON A.RoleGuid = B.RoleGuid AND B.ActionGuid = @ActionGuid
";
view.List = new Pagintion(sql, new { ActionGuid = actionGuid }, view.PageData).ToList <RoleInfo>();
string table = UserControlExcutor.RenderUserControl("/System/UserControl/BusinessToRole.ascx", view.List);
string pagination = UserControlExcutor.RenderUserControl("/System/CommonUserControl/Pagination.ascx", view.PageData);
return(JsonHelper.ToJson(new { table = table, pagination = pagination }));
}
public string SearchRoleByBusiness(PaginationData pd, Guid businessGuid)
{
ListViewData <RoleInfo> view = new ListViewData <RoleInfo>();
view.PageData.PageIndex = pd.PageIndex;
view.PageData.PageSize = pd.PageSize;
view.PageData.PagintionJsFunction = "window.System.RoleTab.searchRoleByBusiness()";
view.PageData.OrderBy = pd.OrderBy;
string sql = @"SELECT A.*
FROM dbo.RoleInfo AS A
INNER JOIN dbo.RoleToBusiness AS B ON A.RoleGuid = B.RoleGuid
WHERE B.BusinessGuid = @BusinessGuid";
view.List = new Pagintion(sql, new { BusinessGuid = businessGuid }, view.PageData).ToList <RoleInfo>();
string table = UserControlExcutor.RenderUserControl("/System/UserControl/RoleList.ascx", view.List);
string pagination = UserControlExcutor.RenderUserControl("/System/CommonUserControl/Pagination.ascx", view.PageData);
return(JsonHelper.ToJson(new { table = table, pagination = pagination }));
}
public static async void checkFavs()
{
if (ListViewData.FavouriteList.Count == 0)
{
List <JsonUserModel> x = await AzureManager.AzureManagerInstance.QueryLogin(LoginPage.userName);
if (x[0].Favourites != null && x[0].Favourites != "")
{
x[0].Favourites = x[0].Favourites.TrimEnd();
String[] favsplit = x[0].Favourites.Split();
foreach (String z in favsplit)
{
Product temp = new Product();
ListViewData.totalproductlist.TryGetValue(z, out temp);
if (temp.easyName != null)
{
ListViewData.addToFavourites(temp);
}
}
}
}
}
private void InitializeUrlScanList()
{
DetectionListView.AllColumns.Clear();
DetectionListView.Columns.Clear();
OLVColumn[] columns = new[]
{
ListViewData.CreateColumn("DetectionEngine", "탐지엔진", "DetectionEngine", 165),
ListViewData.CreateColumn("Detected", "탐지", "Detected", 105), //150
ListViewData.CreateColumn("DetectionResult", "결과", "DetectionResult", 150),
};
ColumnHeader[] headers = new ColumnHeader[columns.Length];
for (int idx = 0; idx < columns.Length; idx++)
{
headers[idx] = columns[idx];
DetectionListView.AllColumns.Add(columns[idx]);
}
DetectionListView.Columns.AddRange(headers);
}
public string SearchRoleBusiness(PaginationData pd, Guid roleGuid)
{
ListViewData <Organization> view = new ListViewData <Organization>();
view.PageData.PageIndex = pd.PageIndex;
view.PageData.PageSize = pd.PageSize;
view.PageData.OrderBy = pd.OrderBy;
view.PageData.PagintionJsFunction = "window.System.RoleToBusinessList.searchRoleBusiness()";
string sql = @"SELECT A.*, B.Name AS ParentName, C.RoleToBusinessGuid AS PermissionGuid
FROM dbo.Organization AS A
LEFT JOIN dbo.Organization AS B ON A.ParentGuid = B.UnitGuid
LEFT JOIN dbo.RoleToBusiness AS C ON A.UnitGuid = C.BusinessGuid AND C.RoleGuid = @RoleGuid
";
view.List = new Pagintion(sql, new { RoleGuid = roleGuid }, view.PageData).ToList <Organization>();
string table = UserControlExcutor.RenderUserControl("/System/UserControl/RoleOrganizationList.ascx", view.List);
string pagination = UserControlExcutor.RenderUserControl("/System/CommonUserControl/Pagination.ascx", view.PageData);
return(JsonHelper.ToJson(new { table = table, pagination = pagination }));
}
public virtual void Setup(ListViewData data)
{
CompleteActions(CollectChanges(data));
}
public override void Setup(ListViewData data)
{
base.Setup(data);
Debug.Log("Setup Achievment List View...");
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
//Dish
var DishDB = new List <Dish>(DishDao.GetAll());
myDish = DishDB.Where(x => x.Id == myDishId).FirstOrDefault();
myListStep = new ListViewData();
myListStep.ImageList = new ObservableCollection <List <StepImage> >();
//Step
var StepDB = RecipeDetailDao.getData();
StepDetail = new BindingList <RecipeDetail>(StepDB.Where(x => x.dishID == myDishId).ToList());
TotalElement += StepDetail.Count;
myBtnList = new BindingList <ButtonList>();
myBtnList.Add(new ButtonList()
{
buttonName = "Main"
});
//video
if (myDish.LinkVideo != "")
{
myDish.LinkVideo = getEmbedYoutubeLink(myDish.LinkVideo);
if (myDish.LinkVideo != "")
{
myBtnList.Add(new ButtonList()
{
buttonName = "Video"
});
videoGrid.Visibility = Visibility.Visible;
videoSP.Visibility = Visibility.Visible;
videolabel.Visibility = Visibility.Visible;
videocef.Visibility = Visibility.Visible;
videocef.Address = myDish.LinkVideo;
TotalElement++;
}
}
///
for (int i = 0; i < StepDetail.Count; i++)
{
var ListImgTemp = RecipeDetailDao.getStepImageData(myDishId, i + 1, StepDetail[i].quantityOfImage);
myBtnList.Add(new ButtonList()
{
buttonName = $"Step {i + 1}"
});
myListStep.ImageList.Add(ListImgTemp);
}
stepDetailView.ItemsSource = StepDetail;
this.DataContext = myListStep;
CarouselBtnSkip.ItemsSource = myBtnList;
//Food Type
myListType = new BindingList <FoodType>();
var DishTypeDB = Dish_TypeDao.getData();
var myDishType = new List <string>(DishTypeDB.Where(x => x.dishID == myDishId).Select(x => x.typeID).ToList());
var TypeDB = FoodTypeDao.getData();
foreach (var item in myDishType)
{
var temp = TypeDB.Where(x => x.typeID == item).FirstOrDefault();
myListType.Add(temp);
}
DishNameLabel.Content = myDish.Name;
dishDesTextBlock.Text = myDish.Description;
dishIngTextBlock.Text = myDish.Ingredient;
var Folder = AppDomain.CurrentDomain.BaseDirectory;
var path = $"{Folder}Resources\\Images\\{myDishId}.jpg";
var Bitmap = new BitmapImage(new Uri(path, UriKind.Absolute));
dishImage.Source = Bitmap;
tagList.ItemsSource = myListType;
}
public override void Setup(ListViewData data)
{
Debug.Log($"inventory list count {data.dataList.Count}");
base.Setup(data);
}
public override void Setup(ListViewData data)
{
base.Setup(data);
}
private void OnListViewDataChanged(object sender, ValueChangedEventArgs <ListViewData> e)
{
ListViewData = e.NewValue;
}
private async Task LoadDataByEntryDate(Payday payday)
{
if (payday == null)
{
return;
}
if (Globals.isDataLoaded == true)
{
return;
}
Globals.isDataLoaded = true;
DataInputs.Clear();
var dataInputs = await _dataInputInterface.GetDataInputByUserId(Globals.currentUser.Id);
foreach (DataInput data in dataInputs)
{
int cutOff = data.EntryDate.Day > 15 ? 2 : 1;
if (payday.Month == data.EntryDate.Month && payday.CutOff == cutOff)
{
DataInputs.Add(new DataInputViewModel(data));
}
}
ListViewData.Clear();
if (DataInputs.Count != 0)
{
ListViewData.Clear();
foreach (DataInputViewModel dmodel in DataInputs)
{
if (dmodel.Type == _type)
{
ListViewData.Add(dmodel);
}
}
}
TotalExpense = DataInputs.Where(x => x.Type == "E").Sum(x => x.Amount);
TotalFund = DataInputs.Where(x => x.Type == "F").Sum(x => x.Amount);
TotalBalance = TotalFund - TotalExpense;
Savings = Globals.currentUser.Savings;
Globals.gvTotalExpense = DataInputs.Where(x => x.Type == "E").Sum(x => x.Amount);
Globals.gvTotalFund = DataInputs.Where(x => x.Type == "F").Sum(x => x.Amount);
Globals.gvTotalBalance = Globals.gvTotalFund - Globals.gvTotalExpense;
PieChart.Clear();
ChartData = new ChartData
{
Amount = Globals.gvTotalExpense,
Type = "Remaining Balance"
};
PieChart.Add(new ChartDataViewModel(ChartData));
ChartData = new ChartData
{
Amount = Globals.gvTotalFund,
Type = "Expenses"
};
PieChart.Add(new ChartDataViewModel(ChartData));
if (Globals.currentUser.isNotify == true)
{
if (Savings > Globals.gvTotalBalance)
{
if (await _pageService.DisplayAlert("MEESEES", "Your remaining balance is less than your Savings, have you already set aside the savings from this amount?", "YES", "NO"))
{
return;
}
else
{
await _pageService.DisplayAlert("MEESEES", "Please set aside the savings amount now!", "OK");
return;
}
}
}
}
public RoleToBusinessListViewData()
{
listOrganization = new ListViewData <Organization>();
listUserInfo = new ListViewData <UserInfo>();
}
public override void Setup(ListViewData data)
{
base.Setup(data);
Debug.Log("Setup Buff List");
}