public LoginController(MainFrame mainFrame, LoginScreen screen)
{
this._screen = screen;
_dbc = DatabaseController.Instance;
this.MainFrame = mainFrame;
}
public RemoveProductController(RemoveProductScreen screen, ProductModel product)
{
_dbc = DatabaseController.Instance;
this._screen = screen;
this._product = product;
screen.productNameLabel.Text = product.Name;
}
public InventoryEditController(InventoryEdit screen, ProductModel product, InventoryScreen inventoryScreen)
{
_dbc = DatabaseController.Instance;
this._product = product;
this._screen = screen;
this._inventoryScreen = inventoryScreen;
FillWithProductInfo();
}
/// <summary>
/// Rellena la página con el contenido pasado durante la navegación. Cualquier estado guardado se
/// proporciona también al crear de nuevo una página a partir de una sesión anterior.
/// </summary>
/// <param name="sender">
/// El origen del evento; suele ser <see cref="NavigationHelper"/>
/// </param>
/// <param name="e">Datos de evento que proporcionan tanto el parámetro de navegación pasado a
/// <see cref="Frame.Navigate(Type, Object)"/> cuando se solicitó inicialmente esta página y
/// un diccionario del estado mantenido por esta página durante una sesión
/// anterior. El estado será null la primera vez que se visite una página.</param>
/// <summary>
/// Mantiene el estado asociado con esta página en caso de que se suspenda la aplicación o
/// se descarte la página de la memoria caché de navegación. Los valores deben cumplir los requisitos
/// de serialización de <see cref="SuspensionManager.SessionState"/>.
/// </summary>
/// <param name="sender">El origen del evento; suele ser <see cref="NavigationHelper"/></param>
/// <param name="e">Datos de evento que proporcionan un diccionario vacío para rellenar con
/// un estado serializable.</param>
protected override void OnNavigatedTo(NavigationEventArgs e)
{
string type = e.Parameter as string;
FoodList foods = null;
DatabaseController dbController = new DatabaseController();
foods=dbController.searchFood(type);
foodController = new ListFoodController(foods);
this.DataContext = foodController;
}
public EditProductController(EditProductScreen screen, ProductModel productModel)
{
this._screen = screen;
_dbc = DatabaseController.Instance;
this._productModel = productModel;
_currentImagePath = Path.GetDirectoryName(Path.GetDirectoryName(Directory.GetCurrentDirectory())) +
@"\Resources\" + productModel.ImageFileName;
_isNewImage = false;
FillComboBox();
FillTextBoxes();
}
public Journey()
{
InitializeComponent();
DataBinder binder = new DataBinder();
DatabaseController controller = new DatabaseController();
binder.bindComboBox<Class>(cmbClass, controller.get<Class>("SELECT * FROM class"), "id", "name");
binder.bindComboBox<Airport>(cmbTo, controller.get<Airport>("SELECT id, CONCAT(name, ' (', id, ')') as name FROM airport"), "id", "name");
binder.bindComboBox<Airport>(cmbFrom, controller.get<Airport>("SELECT id, CONCAT(name, ' (', id, ')') as name FROM airport"), "id", "name");
binder.bindComboBox<Airline>(cmbAirline, controller.get<Airline>("SELECT id, name FROM airline"), "id", "name");
}
public EditProductController(EditProductScreen screen, ProductModel productModel)
{
this._screen = screen;
_dbc = DatabaseController.Instance;
this._productModel = productModel;
_currentImagePath = Environment.GetFolderPath(Environment.SpecialFolder.ApplicationData) +
@"\Kantoor Inrichting\Afbeeldingen producten\" + productModel.ImageFileName;
_isNewImage = false;
FillComboBox();
FillTextBoxes();
}
public CategoryManagerController()
{
Dbc = DatabaseController.Instance;
catman = new CategoryManager(this);
catman.ShowDialog();
if (catman.DialogResult == DialogResult.OK)
{
//update database
}
}
public List <CommitFileHirarhicalData> GetBranchFiles(int projectId, int branchId)
{
var result = new List <CommitFileHirarhicalData>();
using (var context = new DatabaseController(Context, Configuration))
{
var getProject = context.GetBranchFiles(projectId, branchId);
if (getProject != null)
{
result = context.GetFileHirarchy(getProject);
}
}
return(result);
}
public static Account FindByName(string name)
{
var account = new Account();
var key = new SqlParameter("?TITLE", name);
string sql = DatabaseController.GenerateSelectStatement(TABLE_NAME, key);
DataTable dataTable = DatabaseController.ExecuteSelectQuery(sql, key);
foreach (DataRow dataRow in dataTable.Rows)
{
account.SetPropertiesFromDataRow(dataRow);
}
return(account);
}
public void WriteToPlayerStats()
{
if (allowWriteToPlayerStats)
{
PlayerManager.mainPlayer.playerClassID = selectedCharacter;
PlayerManager.mainPlayer.playerName = playerName;
DatabaseController.updatePlayer(PlayerManager.mainPlayer);
PlayerPrefs.SetInt(LoadGame.PLAYED_BEFORE, 1);
}
else
{
Debug.Log("Pick character and player name befor continuing.");
}
}
public IActionResult WorkItems(int projectId, int boardId)
{
var currentUser = this.User;
var id = currentUser.Claims.ElementAt(1);
using (var context = new DatabaseController(Context, Configuration))
{
var currentId = int.Parse(id.Value);
ViewData["ProjectId"] = projectId;
ViewData["Name"] = context.GetUsername(currentId);
ViewData["BoardId"] = boardId;
}
return(View());
}
public static void CalculateElo(int winnerID, int loserID)
{
int WinnerElo = DatabaseController.GetElo(winnerID);
int LoserElo = DatabaseController.GetElo(loserID);
float expectedScoreA = 1 / (1 + Mathf.Pow(10, (LoserElo - WinnerElo) / mod));
float expectedScoreB = 1 / (1 + Mathf.Pow(10, (WinnerElo - LoserElo) / mod));
int winnerNewElo = CalculationOfElo(WinnerElo, K, pointsPerWin, expectedScoreA);
int loserNewElo = CalculationOfElo(LoserElo, K, pointsPerLoss, expectedScoreB);
DatabaseController.SetElo(winnerID, winnerNewElo);
DatabaseController.SetElo(loserID, loserNewElo);
}
internal static List <LoanProduct> GetList()
{
string sqlCommandText = string.Format("SELECT * FROM {0}", TABLE_NAME);
DataTable dataTable = DatabaseController.ExecuteSelectQuery(sqlCommandText);
var result = new List <LoanProduct>();
foreach (DataRow dataRow in dataTable.Rows)
{
var lp = new LoanProduct();
lp.SetPropertiesFromDataRow(dataRow);
result.Add(lp);
}
return(result);
}
//public ActionResult Index(string componentCategory, string searchString)
public ActionResult Index(ItemViewModel model)
{
ViewBag.Message = "Index Page!";
DatabaseController db = new DatabaseController();
//var allItems = db.FindItems(componentCategory, searchString);
var allItems = db.GetItems();
ItemViewModel items = new ItemViewModel()
{
Items = allItems
};
return(View(items));
}
public MainMenu()
{
InitializeComponent();
// If there is no database, run these.
DatabaseController.AddThemesForTheFirstRun();
DatabaseController.AddFloorsForFirstRun();
representativeList = new List <Representative>();
representativeList = DatabaseController.representativeList;
SetBackground(DatabaseController.getLastSubTheme());
this.mv = new MainView(this);
mv.Hide();
}
public Result Create()
{
Action createRecord = () =>
{
var sqlParameter = new List <SqlParameter>();
sqlParameter.Add(new SqlParameter("?Description", Description));
var sql = DatabaseController.GenerateInsertStatement(TABLE_NAME, sqlParameter);
ID = DatabaseController.ExecuteInsertQuery(sql,
sqlParameter.ToArray());
};
return(ActionController.InvokeAction(createRecord));
}
public static List <LoanCharge> GetList()
{
string sqlCommandText = string.Format("SELECT * FROM {0}", TableName);
DataTable dataTable = DatabaseController.ExecuteSelectQuery(sqlCommandText);
var list = new List <LoanCharge>();
foreach (DataRow row in dataTable.Rows)
{
var item = new LoanCharge();
item.SetPropertiesFromDataRow(row);
list.Add(item);
}
return(list);
}
public AssociatedWorkItemMessages WorkItemAddMessage([FromBody] IncomingWorkItemMessage request)
{
var result = default(AssociatedWorkItemMessages);
var currentUser = this.User;
var id = int.Parse(currentUser.Claims.ElementAt(1).Value);
using (var context = new DatabaseController(Context, Configuration))
{
result = context.AddNewWorkItemMessage(request, id);
result.Message.AssociatedWorkItemMessages = null;
result.Message.Sender = context.GetUserAccount(result.Message.SenderId);
}
return(result);
}
public List <OutgoingWorkItemSimple> UnassociatedChangelogItems(int projectId)
{
var result = new List <OutgoingWorkItemSimple>();
using (var context = new DatabaseController(Context, Configuration))
{
result = context.GetEmptyChangelogWorktItems(projectId).Select(y => new OutgoingWorkItemSimple {
Id = y.Id,
Name = string.IsNullOrEmpty(y.Title) ? "" : y.Title,
WorkItemTypeName = y.WorkItemType == null ? "" : y.WorkItemType.TypeName
}).ToList();
}
return(result);
}
public static List <Account> GetListGeneralAccount()
{
string sqlCommandText = string.Format("SELECT * FROM {0} WHERE AccountType = 'General'", TABLE_NAME);
DataTable dataTable = DatabaseController.ExecuteSelectQuery(sqlCommandText);
var result = new List <Account>();
foreach (DataRow dataRow in dataTable.Rows)
{
var item = new Account();
item.SetPropertiesFromDataRow(dataRow);
result.Add(item);
}
return(result);
}
public IViewComponentResult Invoke(int projectId)
{
var user = Request.HttpContext.User.Claims.ElementAt(1);
var Id = int.Parse(user.Value);
using (var context = new DatabaseController(Context, Configuration))
{
var projects = context.GetUserProjects(Id);
var current = projects.FirstOrDefault(x => x.Id == projectId);
ViewData["Projects"] = projects;
ViewData["SelectedIndex"] = projects.IndexOf(current);
}
return(View());
}
public static void intialize(TestContext tc)
{
DatabaseController.getInstance().removeTable(tableName.ToString());
DatabaseController.getInstance().addTable(tableName.ToString());
Word.setScoringHandler(new ScoringHandler("../../ScoringHandlerDaoTests.xml"));
testWords = new List <Word>(new Word[] { new Word("Daddy"), new Word("Mom"), new Word("Dnow"), new Word("Grandpa") });
using (var testDao = new WordDAO())
{
foreach (Word word in testWords)
{
testDao.save(word, tableName.ToString());
}
}
}
public OutgoingJsonData MakeBoardPublic([FromBody] IncomingPublicBoardRequest request)
{
var result = string.Empty;
using (var context = new DatabaseController(Context, Configuration))
{
var domain = Request.Host.Host;
result = context.ChangeProjectBoardStatus(request, domain);
}
return(new OutgoingJsonData {
Data = result
});
}
public IActionResult SprintBacklogs(int projectId, int boardId)
{
var currentUser = this.User;
var id = currentUser.Claims.ElementAt(1);
using (var context = new DatabaseController(Context, Configuration))
{
ViewData["Projects"] = context.GetUserProjects(int.Parse(id.Value));
ViewData["ProjectId"] = projectId;
ViewData["WorkItemTypes"] = context.GetAllWorkItemTypes();
ViewData["ProjectName"] = context.GetProjectName(projectId);
}
return(View());
}
private void EditDeviceType(object sender, RoutedEventArgs e)
{
DeviceType d = (DeviceType)this.dg_DeviceTypesList.SelectedItem;
AddDeviceTypeView adt = new AddDeviceTypeView(this, d);
if (adt.ShowDialog() == true)
{
DatabaseController.EditDeviceType(adt.NewDeviceType);
UpdateDeviceListView();
UpdateDeviceTypeListView();
UpdateLogbookView();
}
}
public IActionResult EditChangelog(int projectId, int changelog)
{
var currentUser = this.User;
var id = currentUser.Claims.ElementAt(1);
var currentId = int.Parse(id.Value);
using (var context = new DatabaseController(Context, Configuration))
{
ViewData["ProjectId"] = projectId;
ViewData["Name"] = context.GetUsername(currentId);
ViewData["Changelog"] = context.GetSpecificChangelog(changelog);
}
return(View());
}
public static List <ForwardedBalanceOld> GetListByYear(int year)
{
const string sql = "SELECT * FROM `ForwardedBalances` WHERE ForwardedYear = ?ForwardedYear";
DataTable dataTable = DatabaseController.ExecuteSelectQuery(sql, new SqlParameter("?ForwardedYear", year));
var result = new List <ForwardedBalanceOld>();
foreach (DataRow dataRow in dataTable.Rows)
{
var fb = new ForwardedBalanceOld();
fb.SetPropertiesFromDataRow(dataRow);
result.Add(fb);
}
return(result);
}
public IActionResult AddNewAccount()
{
var currentUser = this.User;
var currentUserId = currentUser.Claims.ElementAt(1);
using (var context = new DatabaseController(Context, Configuration))
{
ViewData["Projects"] = context.GetUserProjects(int.Parse(currentUserId.Value));
ViewData["Relationships"] = context.GetProjectRelationships();
}
return(View());
}
public static List <Account> GetListOfLoanReceivables()
{
var loanAccounts = new List <Account>();
const string sp = "sp_list_loan_receivables";
var dataTable = DatabaseController.ExecuteStoredProcedure(sp);
foreach (DataRow dataRow in dataTable.Rows)
{
var loanAccount = new Account();
loanAccount.SetPropertiesFromDataRow(dataRow);
loanAccounts.Add(loanAccount);
}
return(loanAccounts);
}
public Result Update()
{
Action updateRecord = () =>
{
var key = _paramKey;
var sqlParameters = Parameters;
var sql = DatabaseController.GenerateUpdateStatement(_tableName, Parameters,
_paramKey);
sqlParameters.Add(key);
DatabaseController.ExecuteNonQuery(sql, sqlParameters.ToArray());
};
return(ActionController.InvokeAction(updateRecord));
}
public MapsController(DatabaseController databaseController)
{
DatabaseController = databaseController;
//Initialize();
Pins = new ObservableCollection <PinItem>();
DatabaseController.CreateTable <PinItem>();
foreach (var PinItem in DatabaseController.Table <PinItem>())
{
Pins.Add(PinItem);
}
}
private void btnCreateClick(object sender, EventArgs e)
{
//inpute validation
bool invalid = false;
string name = tbxName.Text;
if (string.IsNullOrEmpty(name))
{
lblAssignmentName.ForeColor = Color.Red;
invalid = true;
}
if (cbxCategory.SelectedIndex == -1)
{
lblCategory.ForeColor = Color.Red;
invalid = true;
}
if (dtDate.Value == null)
{
lblDueDate.ForeColor = Color.Red;
invalid = true;
}
if (invalid)
{
return;
}
string cat = cbxCategory.SelectedItem.ToString();
DateTime date = dtDate.Value;
Task newTask = new Task(name.Trim(), date, cat, Mediator.CurrentUser.UserID);
//create the task in the database
(bool result, string error, Task task_returned) = DatabaseController.GetDBController().WriteTask(newTask, Mediator.AuthCookie);
if (result == false)
{
MessageBox.Show(error, "Task creation failed", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
else
{
MessageBox.Show(string.Format("Your task {0} has been created!", name), "Task creation succeeded", MessageBoxButtons.OK, MessageBoxIcon.Information);
//add the task to the observable collection
ObservableCollections.ObservableTaskCollection.Add(new SelectableTaskDecorator(task_returned));
Hide();
}
}
public IActionResult Commits(int id)
{
using (var context = new DatabaseController(Context, Configuration))
{
ViewData["ProjectId"] = id;
ViewData["ProjectName"] = context.GetProjectName(id);
}
using (var context = new WorkItemsContext(Context, Configuration))
ViewData["WorkItemTypes"] = context.GetAllWorkItemTypes();
ViewData["IsEmpty"] = true;
return(View());
}
private void AddNewProduct(object sender, EventArgs e)
{
DatabaseController db = new DatabaseController();
string expTime = "0";
if (ShowAddForm.Controls[9].Text != string.Empty && ShowAddForm.Controls[8].Text != string.Empty && ShowAddForm.Controls[7].Text != string.Empty)
{
//Converts Einddatum to amount of days and then into a string
expTime = (new DateTime(int.Parse(ShowAddForm.Controls[9].Text), int.Parse(ShowAddForm.Controls[8].Text), int.Parse(ShowAddForm.Controls[7].Text)) - DateTime.Today).Days.ToString();
}
//if the exp date is unknown (days till expiring is 0 or elss than 0), the product will get the general exp date from its given category.
if (int.Parse(expTime) <= 0)
{
expTime = Categories.First(c => ShowAddForm.Controls[11].Text.Equals(c.Name)).GeneralDaysToExpire.ToString();
}
//First inserts the product into the table with all products in our database
string sql = "INSERT INTO product (ID, Name, Expiration_time, Description, Category) VALUES (@val0, @val1, @val2, @val3, @val4)";
db.NonQuery(sql,
ShowAddForm.Controls[1].Text, //the ID
ShowAddForm.Controls[3].Text, //The name
expTime, //The expiration time
ShowAddForm.Controls[5].Text, //The description
ShowAddForm.Controls[11].Text //The category
);
//Then inserts it into the food table of the client
sql = "INSERT INTO food (Add_date, Product) VALUES (@val0, @val1)";
db.NonQuery(sql,
DateTime.Today.ToString("yyyy-MM-dd"),
ShowAddForm.Controls[1].Text
);
//Addform gets emptied again
ShowAddForm.Controls[1].Text = "";
ShowAddForm.Controls[3].Text = "";
ShowAddForm.Controls[5].Text = "";
(ShowAddForm.Controls[7] as ComboBox).SelectedItem = null;
(ShowAddForm.Controls[8] as ComboBox).SelectedItem = null;
(ShowAddForm.Controls[9] as ComboBox).SelectedItem = null;
(ShowAddForm.Controls[11] as ComboBox).SelectedItem = null;
DataManager.Instance.GetData();
Products = DataManager.Instance.Products;
Categories = DataManager.Instance.Categories;
ProductsInHouse = DataManager.Instance.ProductsInHouse;
FillExistingProductView();
ShowAddForm.Hide();
ViewExistingProduct.Show();
}
public IActionResult Index(int projectId)
{
var currentUser = this.User;
var id = currentUser.Claims.ElementAt(1);
using (var context = new DatabaseController(Context, Configuration))
{
ViewData["Projects"] = context.GetUserProjects(int.Parse(id.Value));
ViewData["Relationships"] = context.GetProjectRelationships();
ViewData["Branches"] = context.GetBranchesForProject(projectId);
ViewData["DefaultIteration"] = context.GetProjectDefautIteration(projectId);
}
return(View());
}
public static bool DeleteRecord(Record record, int requestingUserId)
{
if (!DatabaseController.RecordExists(record))
{
return(false);
}
if (record.User.Id != requestingUserId)
{
return(false);
}
var command = "delete from records where id = " + record.Id;
DatabaseController.ExecuteCommand(command);
return(true);
}
public Result Update()
{
Action updateRecord = () =>
{
var key = new SqlParameter("?ID", ID);
List <SqlParameter> sqlParameters = SqlParameters;
string sql = DatabaseController.GenerateUpdateStatement(TABLE_NAME, sqlParameters, key);
sqlParameters.Add(key);
DatabaseController.ExecuteNonQuery(sql, sqlParameters.ToArray());
};
return(ActionController.InvokeAction(updateRecord));
}
public AddFlights()
{
InitializeComponent();
controller = new DatabaseController();
DataBinder binder = new DataBinder();
flightCollection = new ObservableCollection<Flight>();
gridFlights.ItemsSource = flightCollection;
string queryJourney =
"SELECT J.id, A1.name as 'from_airport_id', A2.name as 'to_airport_id' FROM journey J LEFT JOIN airport A1 ON J.from_airport_id = A1.id LEFT JOIN airport A2 ON J.to_airport_id = A2.id";
journey = controller.get<Journey_>(queryJourney);
journeyList = controller.get<Journey_>("SELECT * FROM journey");
binder.bindComboBox<Journey_>(cmbJourney, journeyList, "id");
flightList = controller.get<Flight>("SELECT * FROM flight");
binder.bindComboBox<Flight>(cmbFlight, flightList, "id");
}
public AddNewProductController(AddNewProductScreen screen)
{
this._screen = screen;
_dbc = DatabaseController.Instance;
FillComboBox();
}
public ChangeCategoryNameController(ChangeCategoryName screen)
{
dbc = DatabaseController.Instance;
this.screen = screen;
}
