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();
}
