private void OrderFilterButton_Click(object sender, EventArgs e)
{
ordersFilter = new OrdersFilter()
{
Username = OrdersUsernameFilterTextBox.Text,
State = (OrdersStateFilterComboBox.SelectedIndex == 0 ? "": Enum.GetName(typeof(Database.OrderStates), OrdersStateFilterComboBox.SelectedIndex)),
startDate = OrdersDateFromFilterDatePicker.Value.ToString("yyyy-MM-dd"),
endDate = OrdersTillDateFilterDatetPicker.Value.ToString("yyyy-MM-dd"),
};
database.fillOrdersInfoList(dataGridView2, ordersFilter);
//dataGridView3.DataSource = null;
if (dataGridView2.RowCount != 0)
{
dataGridView2.Rows[0].Cells[0].Selected = true;
dataGridView2.CurrentCell = dataGridView2[0, 0];
}
else
{
dataGridView3.DataSource = null;
}
}
public bool fillOrdersInfoList(DataGridView grid, OrdersFilter filter){
/*string Query = "SELECT marsud.bts_carts.id, marsud.bts_users.username as Vartotojas, " +
"status as Busena, created_at as 'Sukurimo data' from " +
"marsud.bts_carts inner join marsud.bts_users on marsud.bts_users.id = marsud.bts_carts.user{0}";
*/
//SELECT marsud.bts_carts.id, marsud.bts_users.username as Vartotojas, status as Busena, created_at as 'Sukurimo data' from marsud.bts_carts inner join marsud.bts_users on marsud.bts_users.id = marsud.bts_carts.user where bts_users.id = 1
string Query = "SELECT marsud.bts_carts.id as 'Užsakymo nr', marsud.bts_users.username as Vartotojas, " +
"status as Busena, created_at as 'Sukurimo data' from " +
"marsud.bts_carts inner join marsud.bts_users on marsud.bts_users.id = marsud.bts_carts.user{0}";
string str = "";
if (filter == null)
{
Query = String.Format(Query,"");
}
else
{
/*
Query = String.Format("SELECT marsud.bts_orders.id, marsud.bts_users.username as Vartotojas, " +
"status as Busena, created_at as 'Sukurimo data' from " +
"marsud.bts_orders inner join marsud.bts_users on marsud.bts_users.id = marsud.bts_orders.user where {0}{1}{2}",
"marsud.bts_users.username="******" where marsud.bts_users.username LIKE'" + filter.Username+"%'";
}
if (!string.IsNullOrEmpty(str) && !string.IsNullOrEmpty(filter.State))
{
str = str + " and marsud.bts_carts.status= '" + TranslateStateToEnglish(filter.State)+"'";
}
else if (!string.IsNullOrEmpty(filter.State))
{
str = " where marsud.bts_carts.status='" + TranslateStateToEnglish(filter.State) + "'";
}
if (!string.IsNullOrEmpty(str) && !string.IsNullOrEmpty(filter.startDate) && filter.startDate!= filter.endDate)
{
str = str + " and marsud.bts_carts.created_at>'" + filter.startDate+"'";
}
else if (!string.IsNullOrEmpty(filter.startDate))
{
str = " where marsud.bts_carts.created_at>'" + filter.startDate +"'";
}
if (!string.IsNullOrEmpty(str) && !string.IsNullOrEmpty(filter.endDate) && filter.startDate != filter.endDate)
{
str = str + " and marsud.bts_carts.created_at<'" + filter.endDate+"'";
}
else if (!string.IsNullOrEmpty(filter.endDate))
{
str = " where marsud.bts_carts.created_at<'" + filter.endDate+"'";
}
if (!string.IsNullOrEmpty(str))
{
Query = String.Format(Query, str);
}
}
gridFillWithQuery(grid, Query + " order by marsud.bts_carts.id desc");
for (int i = 0; i < grid.RowCount; i++)
{
string atr = (string)grid[2, i].Value;
grid[2, i].Value = TranslateStateToLithuanian(atr);
}
return true;
}
private void OrderFilterButton_Click(object sender, EventArgs e)
{
ordersFilter = new OrdersFilter()
{
Username = OrdersUsernameFilterTextBox.Text,
State = (OrdersStateFilterComboBox.SelectedIndex == 0 ? "": Enum.GetName(typeof(Database.OrderStates), OrdersStateFilterComboBox.SelectedIndex)),
startDate = OrdersDateFromFilterDatePicker.Value.ToString("yyyy-MM-dd"),
endDate = OrdersTillDateFilterDatetPicker.Value.ToString("yyyy-MM-dd"),
};
database.fillOrdersInfoList(dataGridView2, ordersFilter);
//dataGridView3.DataSource = null;
if (dataGridView2.RowCount != 0)
{
dataGridView2.Rows[0].Cells[0].Selected = true;
dataGridView2.CurrentCell = dataGridView2[0, 0];
}
else
{
dataGridView3.DataSource = null;
}
}
public bool fillOrdersInfoList(DataGridView grid, OrdersFilter filter)
{
/*string Query = "SELECT marsud.bts_carts.id, marsud.bts_users.username as Vartotojas, " +
* "status as Busena, created_at as 'Sukurimo data' from " +
* "marsud.bts_carts inner join marsud.bts_users on marsud.bts_users.id = marsud.bts_carts.user{0}";
*/
//SELECT marsud.bts_carts.id, marsud.bts_users.username as Vartotojas, status as Busena, created_at as 'Sukurimo data' from marsud.bts_carts inner join marsud.bts_users on marsud.bts_users.id = marsud.bts_carts.user where bts_users.id = 1
string Query = "SELECT marsud.bts_carts.id as 'Užsakymo nr', marsud.bts_users.username as Vartotojas, " +
"status as Busena, created_at as 'Sukurimo data' from " +
"marsud.bts_carts inner join marsud.bts_users on marsud.bts_users.id = marsud.bts_carts.user{0}";
string str = "";
if (filter == null)
{
Query = String.Format(Query, "");
}
else
{
/*
* Query = String.Format("SELECT marsud.bts_orders.id, marsud.bts_users.username as Vartotojas, " +
* "status as Busena, created_at as 'Sukurimo data' from " +
* "marsud.bts_orders inner join marsud.bts_users on marsud.bts_users.id = marsud.bts_orders.user where {0}{1}{2}",
* "marsud.bts_users.username="******" where marsud.bts_users.username LIKE'" + filter.Username + "%'";
}
if (!string.IsNullOrEmpty(str) && !string.IsNullOrEmpty(filter.State))
{
str = str + " and marsud.bts_carts.status= '" + TranslateStateToEnglish(filter.State) + "'";
}
else if (!string.IsNullOrEmpty(filter.State))
{
str = " where marsud.bts_carts.status='" + TranslateStateToEnglish(filter.State) + "'";
}
if (!string.IsNullOrEmpty(str) && !string.IsNullOrEmpty(filter.startDate) && filter.startDate != filter.endDate)
{
str = str + " and marsud.bts_carts.created_at>'" + filter.startDate + "'";
}
else if (!string.IsNullOrEmpty(filter.startDate))
{
str = " where marsud.bts_carts.created_at>'" + filter.startDate + "'";
}
if (!string.IsNullOrEmpty(str) && !string.IsNullOrEmpty(filter.endDate) && filter.startDate != filter.endDate)
{
str = str + " and marsud.bts_carts.created_at<'" + filter.endDate + "'";
}
else if (!string.IsNullOrEmpty(filter.endDate))
{
str = " where marsud.bts_carts.created_at<'" + filter.endDate + "'";
}
if (!string.IsNullOrEmpty(str))
{
Query = String.Format(Query, str);
}
}
gridFillWithQuery(grid, Query + " order by marsud.bts_carts.id desc");
for (int i = 0; i < grid.RowCount; i++)
{
string atr = (string)grid[2, i].Value;
grid[2, i].Value = TranslateStateToLithuanian(atr);
}
return(true);
}
