public ProductView()
{
InitializeComponent();
dG = new DG(dgProduct, snack, snackMessage);
sB = new SB(snack, snackMessage);
dataBaseQuery = new DataBaseQuery(snack, snackMessage);
comboBoxAddStrength = new CB(cbStrength, snack, snackMessage);
comboBoxEditStrength = new CB(cbEditStrength, snack, snackMessage);
comboBoxAddStrength.Loader("Strength", "NameStrength");
comboBoxEditStrength.Loader("Strength", "NameStrength");
this.Loaded += delegate
{
dG.Loader("SELECT * FROM dbo.[ProductStrength]");
};
snackMessage.ActionClick += delegate { dG.CloseSnackbar(); };
}
public T Get <T>(string id) where T : ModelBase
{
var table = this.Mapping.GetTableByObject(typeof(T));
var entry = this.Mapping.GetEntryByTable(table.Name);
var columnEntry = entry.Columns.FirstOrDefault(x => x.AttributeName == "Id");
if (columnEntry == null)
{
throw new Exception("Mapping of Property 'Id' is missing!");
}
var query = new DataBaseQuery(table, new Condition().Add(new PropertyExpression(table.Columns[columnEntry.ColumnName], CompareEnum.Equals, id)));
return(this.DataBaseConnection.ExecuteQuery(query).Select(x => (T)Activator.CreateInstance(typeof(T), x)).FirstOrDefault());
}
public EmployeeView()
{
InitializeComponent();
dG = new DG(dgEmployee, snack, snackMessage);
sB = new SB(snack, snackMessage);
dataBaseQuery = new DataBaseQuery(snack, snackMessage);
comboBoxAddEmployee = new CB(cbLogin, snack, snackMessage);
comboBoxEditEmployee = new CB(cbEditLogin, snack, snackMessage);
}
public UserView()
{
InitializeComponent();
dG = new DG(dgUser, snack, snackMessage);
dataBaseQuery = new DataBaseQuery(snack, snackMessage);
myListBox = new MyListBox(lbRole, snack, snackMessage);
comboBoxAddRole = new CB(cbRole, snack, snackMessage);
comboBoxEditRole = new CB(cbEditRole, snack, snackMessage);
sB = new SB(snack, snackMessage);
}
public RecipientView()
{
InitializeComponent();
dG = new DG(dgRecipient, snack, snackMessage);
sB = new SB(snack, snackMessage);
dataBaseQuery = new DataBaseQuery(snack, snackMessage);
this.Loaded += delegate {
dG.Loader("SELECT Id, FirstName + N' ' + LastName as Recipient," +
" Address, PhoneNumber, Email FROM dbo.Recipient");
};
snackMessage.ActionClick += delegate { dG.CloseSnackbar(); };
}
public string GetResponse(string request)
{
var table = this.mapping.GetTableByObject(typeof(Message));
var condition = new Condition().Add(new PropertyExpression(table.Columns["Request"], CompareEnum.Equals, request));
var query = new DataBaseQuery(table, condition);
var res = this.connection.ExecuteQuery(query).FirstOrDefault();
if (res == null)
{
return("");
}
var message = new Message(res);
var responses = message.Response.Split('|');
var rand = this.rnd.Next(responses.Length);
return(responses[rand]);
}
public SupplierView()
{
InitializeComponent();
dG = new DG(dgSupplier, snack, snackMessage);
sB = new SB(snack, snackMessage);
dataBaseQuery = new DataBaseQuery(snack, snackMessage);
this.Loaded += delegate
{
dG.Loader("SELECT * FROM dbo.[Supplier]");
};
snackMessage.ActionClick += delegate { dG.CloseSnackbar(); };
}
public OrderView()
{
InitializeComponent();
dG = new DG(dgOrder, snack, snackMessage);
sB = new SB(snack, snackMessage);
lb = new MyListBox(lbSortingCenter, snack, snackMessage);
comboBoxEmployee = new CB(cbEmployee, snack, snackMessage);
comboBoxClient = new CB(cbClient, snack, snackMessage);
comboBoxRecipient = new CB(cbRecipient, snack, snackMessage);
comboBoxSupplier = new CB(cbSupplier, snack, snackMessage);
comboBoxArticle = new CB(cbArticle, snack, snackMessage);
comboBoxSortingCenter = new CB(cbSortingCenter, snack, snackMessage);
comboBoxNameOrderTiming = new CB(cbNameOrderTiming, snack, snackMessage);
comboBoxEditEmployee = new CB(cbEditEmployee, snack, snackMessage);
comboBoxEditClient = new CB(cbEditClient, snack, snackMessage);
comboBoxEditRecipient = new CB(cbEditRecipient, snack, snackMessage);
comboBoxEditSupplier = new CB(cbEditSupplier, snack, snackMessage);
comboBoxEditArticle = new CB(cbEditArticle, snack, snackMessage);
comboBoxEditSortingCenter = new CB(cbEditSortingCenter, snack, snackMessage);
comboBoxEditNameOrderTiming = new CB(cbEditNameOrderTiming, snack, snackMessage);
dataBaseQuery = new DataBaseQuery(snack, snackMessage);
snackMessage.ActionClick += delegate { dG.CloseSnackbar(); };
}
public List <T> GetAll <T>() where T : ModelBase
{
var query = new DataBaseQuery(this.Mapping.GetTableByObject(typeof(T)));
return(this.DataBaseConnection.ExecuteQuery(query).Select(x => (T)Activator.CreateInstance(typeof(T), x)).ToList());
}
