public void DeletePharmacuticles(PharmacuticlesInfo obj) { string Qry = "DELETE FROM PharmacuticlesInfo WHERE PharmaID='" + obj.pharmaId + "'"; DbUtility.ExecuteQuery(Qry); }
public void UpdatePharmacuticles(PharmacuticlesInfo obj) { string Qry = "update PharmacuticlesInfo set PharmaName='" + obj.pharmaName + "',[Address]='" + obj.address + "',CatagoryLeve='" + obj.catagories + "' where PharmaID='" + obj.pharmaId + "'"; DbUtility.ExecuteQuery(Qry); }
private void loadTOModel() { obj = new PharmacuticlesInfo(); obj.pharmaId = txtPharmaId.Text; obj.pharmaName = txtPharmaName.Text; obj.address = txtPharmaAddress.Text; obj.catagories = txtPharmaCatagories.Text; PharmacuticlesInfoBLL bllObj = new PharmacuticlesInfoBLL(); bllObj.SavePharmacuticles(obj); this.LoadPharmacuticles(); MessageBox.Show("Data successfully Saved!"); }
private void btndelete_Click(object sender, EventArgs e) { obj = new PharmacuticlesInfo(); obj.pharmaId = txtPharmaId.Text; obj.pharmaName = txtPharmaName.Text; obj.address = txtPharmaAddress.Text; obj.catagories = txtPharmaCatagories.Text; PharmacuticlesInfoBLL bllObj = new PharmacuticlesInfoBLL(); bllObj.DeletePharmacuticles(obj); MessageBox.Show("Data Deleted successfully !"); this.LoadPharmacuticles(); }
public void DeletePharmacuticles(PharmacuticlesInfo obj) { dalObj = new PharmacuticlesDAL(); dalObj.DeletePharmacuticles(obj); }
public void UpdatePharmacuticles(PharmacuticlesInfo obj) { dalObj = new PharmacuticlesDAL(); dalObj.UpdatePharmacuticles(obj); }
public void SavePharmacuticles(PharmacuticlesInfo obj) { dalObj = new PharmacuticlesDAL(); dalObj.SavePharmacuticles(obj); }
public void SavePharmacuticles(PharmacuticlesInfo obj) { string Qry = "INSERT INTO [CureDB].[dbo].[Pharmacuticles]([PharmaID],[PharmaName],[Address],[CategoryLevel],)VALUES('" + obj.pharmaId + "','" + obj.pharmaName + "','" + obj.address + "','" + obj.catagories + "') "; DbUtility.ExecuteQuery(Qry); }