private void GetToolsByProducts()
{
var query = Query.GetCategoryQuery(View.GetSelectedCategory());
if (query == "one product")
{
query = Query.GetProdIdByProductName(View.GetChoosenProd());
}
else
{
query = SelectFormatter.Get("prod_id", "(" + query + ")");
}
var conditions = new List <string>();
conditions.Add("time_end<=to_date('" + View.GetTimeEnd() + "','dd.mm.yyyy')");
conditions.Add("time_begin>=to_date('" + View.GetTimeBegin() + "','dd.mm.yyyy')");
conditions.Add(QueryFormatter.In("prod_id", query));
query = QueryFormatter.SelectFormatter.Get("prod_id"
, "products_exps"
, conditions);
query = Query.GetToolsByProdIdLab(query, View.GetChoosenLab());
Controller.Run <DirectorScientistsPresenter, string>(query);
}
private void GetTupleMasters()
{
var queryListWs = SelectFormatter.Get("name", "workshops");
var queryListSec = SelectFormatter.Get("name", "sectors");
Controller.Run <MastersChoosePresenter, string, string>(queryListWs, queryListSec);
}
private void ChooseSquad()
{
var queryListWs = SelectFormatter.Get("name", "workshops");
var queryListSec = SelectFormatter.Get("name", "sectors");
Controller.Run <TeamChoosePresenter, string, string>(queryListWs, queryListSec);
}
private void ChooseProdTuple()
{
var queryListWs = SelectFormatter.Get("name", "workshops");
var queryListSec = SelectFormatter.Get("name", "sectors");
Controller.Run <ProductionChoosePresenter, string, string>(queryListWs, queryListSec);
}
private void GetProductsByLaboratory()
{
var query = Query.GetProdIdByLaboratory(View.GetChoosenItem(), View.GetTimeBegin()
, View.GetTimeEnd());
var prodQuery = Query.GetCategoryQuery(View.GetSelectedCategory());
query = SelectFormatter.Get("*", "(" + prodQuery + ")", query, "prod_id");
Controller.Run <DirectorScientistsPresenter, string>(query);
}
private RoleManager.RoleType GetInformation()
{
var conditions = new List <string> {
"login='******'"
, "pas='******'"
};
var query = SelectFormatter.Get("role", "accounts", conditions);
var ls = Formatter
.GetStringData(Model.GetData(query));
return(RoleManager.GetType(ls[0]));
}
public static string GetProductsNames(string id)
{
var query = SelectFormatter.Union(new List <string> {
"name", "prod_id"
}, new List <string> {
"rockets"
, "gliders"
, "hang_gliders"
, "helicopters"
, "planes"
, "other_prods"
});
return(SelectFormatter.Get("name", "(" + query + ")", id, "prod_id"));
}