private void btnEdit_Click(object sender, RoutedEventArgs e)
{
freebiesModel = dgvFreebies.SelectedItem as FreebiesModel;
btnUpdate.Visibility = Visibility.Visible;
btnSave.Visibility = Visibility.Hidden;
if (freebiesModel != null)
{
deliveryDate.Text = freebiesModel.DeliveryDate;
txtClientName.Text = freebiesModel.ClientName;
txtQuantity.Text = freebiesModel.Quantity.ToString();
foreach (CategoryModel ct in cmbCategory.Items)
{
if (ct.ID.Equals(freebiesModel.CategoryID))
{
cmbCategory.SelectedItem = ct;
}
}
foreach (ProductModel pm in cmbProduct.Items)
{
if (pm.ID.Equals(freebiesModel.ProductID))
{
cmbProduct.SelectedItem = pm;
}
}
}
}
private List <FreebiesModel> loadDataGridDetails()
{
conDB = new ConnectionDB();
FreebiesModel freebies = new FreebiesModel();
List <FreebiesModel> lstFreebies = new List <FreebiesModel>();
string queryString = "SELECT dbfh.tblfreebies.ID, clientname, quantity, dbfh.tblcategory.description, dbfh.tblfreebies.categoryID as catID, deliverydate, dbfh.tblproducts.description as prod, dbfh.tblfreebies.productID as prodID FROM ((dbfh.tblfreebies " +
" INNER JOIN dbfh.tblcategory ON dbfh.tblfreebies.categoryID = dbfh.tblcategory.ID) INNER JOIN dbfh.tblproducts ON dbfh.tblfreebies.productID = dbfh.tblproducts.ID)" +
" WHERE dbfh.tblfreebies.isDeleted = 0";
MySqlDataReader reader = conDB.getSelectConnection(queryString, null);
while (reader.Read())
{
freebies.ID = reader["ID"].ToString();
freebies.ClientName = reader["clientname"].ToString();
freebies.Quantity = Convert.ToInt32(reader["quantity"].ToString());
freebies.CategoryName = reader["description"].ToString();
DateTime dte = DateTime.Parse(reader["deliveryDate"].ToString());
freebies.DeliveryDate = dte.ToShortDateString();
freebies.CategoryID = reader["catID"].ToString();
freebies.ProductName = reader["prod"].ToString();
freebies.ProductID = reader["prodID"].ToString();
lstFreebies.Add(freebies);
freebies = new FreebiesModel();
}
conDB.closeConnection();
return(lstFreebies);
}
private List <FreebiesModel> search()
{
conDB = new ConnectionDB();
FreebiesModel freebies = new FreebiesModel();
List <FreebiesModel> lstFreebies = new List <FreebiesModel>();
string queryString = "SELECT dbfh.tblfreebies.ID, clientname, quantity, dbfh.tblcategory.description, dbfh.tblfreebies.categoryID as catID, deliverydate, dbfh.tblproducts.description as prod, dbfh.tblfreebies.productID as prodID FROM ((dbfh.tblfreebies " +
" INNER JOIN dbfh.tblcategory ON dbfh.tblfreebies.categoryID = dbfh.tblcategory.ID) INNER JOIN dbfh.tblproducts ON dbfh.tblfreebies.productID = dbfh.tblproducts.ID)" +
" WHERE dbfh.tblfreebies.isDeleted = 0";
List <string> parameters = new List <string>();
if (checkDate.IsChecked == true)
{
queryString += " AND (deliverydate BETWEEN ? AND ?)";
DateTime sdate = DateTime.Parse(searchDateFrom.Text);
parameters.Add(sdate.Year + "/" + sdate.Month + "/" + sdate.Day);
sdate = DateTime.Parse(searchDateTo.Text);
parameters.Add(sdate.Year + "/" + sdate.Month + "/" + sdate.Day);
}
if (checkCategory.IsChecked == true)
{
queryString += " AND (dbfh.tblfreebies.categoryID = ?)";
parameters.Add(searchCategory.SelectedValue.ToString());
}
MySqlDataReader reader = conDB.getSelectConnection(queryString, parameters);
while (reader.Read())
{
freebies.ID = reader["ID"].ToString();
freebies.ClientName = reader["clientname"].ToString();
freebies.Quantity = Convert.ToInt32(reader["quantity"].ToString());
freebies.CategoryName = reader["description"].ToString();
DateTime dte = DateTime.Parse(reader["deliveryDate"].ToString());
freebies.DeliveryDate = dte.ToShortDateString();
freebies.CategoryID = reader["catID"].ToString();
freebies.ProductName = reader["prod"].ToString();
freebies.ProductID = reader["prodID"].ToString();
lstFreebies.Add(freebies);
}
conDB.closeConnection();
return(lstFreebies);
}
private void updateRecord(FreebiesModel fribis)
{
conDB = new ConnectionDB();
string queryString = "UPDATE dbfh.tblfreebies SET clientname = ?, quantity = ?, categoryID = ?, productID = ?, " +
"deliverydate = ? WHERE ID = ?";
List <string> parameters = new List <string>();
parameters.Add(txtClientName.Text);
parameters.Add(txtQuantity.Text);
parameters.Add(cmbCategory.SelectedValue.ToString());
parameters.Add(cmbProduct.SelectedValue.ToString());
DateTime date = DateTime.Parse(deliveryDate.Text);
parameters.Add(date.Year + "/" + date.Month + "/" + date.Day);
parameters.Add(fribis.ID);
conDB.AddRecordToDatabase(queryString, parameters);
conDB.closeConnection();
}
