private List <PromoServicesModel> loadServices(string promoID) { List <PromoServicesModel> lstPromoServices = new List <PromoServicesModel>(); PromoServicesModel promoService = new PromoServicesModel(); queryString = "SELECT dbspa.tblpromoservices.ID, dbspa.tblpromo.promoname, dbspa.tblservicetype.serviceType " + "FROM((dbspa.tblpromoservices INNER JOIN dbspa.tblpromo ON dbspa.tblpromoservices.promoID = dbspa.tblpromo.ID) " + "INNER JOIN dbspa.tblservicetype ON dbspa.tblpromoservices.serviceID = dbspa.tblservicetype.ID) " + "WHERE dbspa.tblpromoservices.isDeleted = 0 AND dbspa.tblpromoservices.promoID = ?"; parameters = new List <string>(); parameters.Add(promoID); MySqlDataReader reader = conDB.getSelectConnection(queryString, parameters); while (reader.Read()) { promoService.ID = reader["ID"].ToString(); promoService.PromoName = reader["promoname"].ToString(); promoService.ServiceName = reader["serviceType"].ToString(); lstPromoServices.Add(promoService); promoService = new PromoServicesModel(); } conDB.closeConnection(); return(lstPromoServices); }
private void loadDataGridServices(string promoID) { List <PromoServicesModel> lstPromoServ = new List <PromoServicesModel>(); PromoServicesModel promoServ = new PromoServicesModel(); queryString = "SELECT dbspa.tblpromoservices.ID, dbspa.tblpromo.promoname, dbspa.tblservicetype.serviceType, " + "dbspa.tblservicetype.description FROM ((dbspa.tblpromoservices INNER JOIN dbspa.tblpromo ON dbspa.tblpromoservices.promoID = dbspa.tblpromo.ID) " + "INNER JOIN dbspa.tblservicetype ON dbspa.tblpromoservices.serviceID = dbspa.tblservicetype.ID) " + "WHERE dbspa.tblpromoservices.isDeleted = 0 AND dbspa.tblpromoservices.promoID = ?"; parameters = new List <string>(); parameters.Add(promoID); MySqlDataReader reader = conDB.getSelectConnection(queryString, parameters); while (reader.Read()) { promoServ.ID = reader["ID"].ToString(); promoServ.PromoName = reader["promoname"].ToString(); promoServ.ServiceName = reader["description"].ToString(); lstPromoServ.Add(promoServ); promoServ = new PromoServicesModel(); } conDB.closeConnection(); dgvPromoServices.ItemsSource = lstPromoServ; }
private void btnEditServiceToPromo_Click(object sender, RoutedEventArgs e) { PromoServicesModel promoServModel = dgvPromoServices.SelectedItem as PromoServicesModel; if (promoServModel != null) { PromoServiceDetails promoServ = new PromoServiceDetails(this, promoServModel); //promoServ.dgvPromoServices.ItemsSource = loadServices(promoServModel.PromoID); promoServ.ShowDialog(); } }
private void loadDataGridDetailsForServicesInPromo() { List <PromoServicesModel> lstPromoServices = new List <PromoServicesModel>(); PromoServicesModel promoservice = new PromoServicesModel(); queryString = "SELECT dbspa.tblpromoservices.ID, dbspa.tblpromo.promoname, dbspa.tblservicetype.description, promoID FROM ((dbspa.tblpromoservices " + "INNER JOIN dbspa.tblpromo ON dbspa.tblpromoservices.promoID = dbspa.tblpromo.ID) INNER JOIN dbspa.tblservicetype " + "ON dbspa.tblpromoservices.serviceID = dbspa.tblservicetype.ID) WHERE dbspa.tblpromoservices.isDeleted = 0"; MySqlDataReader reader = conDB.getSelectConnection(queryString, null); while (reader.Read()) { promoservice.ID = reader["ID"].ToString(); promoservice.PromoName = reader["promoname"].ToString(); promoservice.ServiceName = reader["description"].ToString(); promoservice.PromoID = reader["promoID"].ToString(); lstPromoServices.Add(promoservice); promoservice = new PromoServicesModel(); } conDB.closeConnection(); dgvPromoServices.ItemsSource = lstPromoServices; }
private void loadDataGridDetails() { List <PromoServicesModel> lstPromoServices = new List <PromoServicesModel>(); PromoServicesModel promoservice = new PromoServicesModel(); queryString = "SELECT dbspa.tblpromoservices.ID, dbspa.tblpromo.ID as 'PROMO ID', dbspa.tblpromo.promoname, dbspa.tblpromo.price " + "FROM(dbspa.tblpromo INNER JOIN dbspa.tblpromoservices ON dbspa.tblpromo.ID = dbspa.tblpromoservices.promoID) " + "WHERE dbspa.tblpromo.isDeleted = 0"; MySqlDataReader reader = conDB.getSelectConnection(queryString, null); while (reader.Read()) { promoservice.ID = reader["ID"].ToString(); promoservice.PromoID = reader["PROMO ID"].ToString(); promoservice.PromoName = reader["promoname"].ToString(); promoservice.PromoPrice = reader["price"].ToString(); lstPromoServices.Add(promoservice); promoservice = new PromoServicesModel(); } conDB.closeConnection(); dgvPromoServices.ItemsSource = lstPromoServices; }
public PromoServiceDetails(PromoWindow psw, PromoServicesModel psm) { promoWindow = psw; promoServiceModel = psm; InitializeComponent(); }