Exemplo n.º 1
0
        public void DeletePharmacuticles(PharmacuticlesInfo obj)
        {
            string Qry = "DELETE FROM PharmacuticlesInfo WHERE PharmaID='" + obj.pharmaId + "'";


            DbUtility.ExecuteQuery(Qry);
        }
Exemplo n.º 2
0
        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);
        }
Exemplo n.º 3
0
 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!");
 }
Exemplo n.º 4
0
        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();
        }
Exemplo n.º 5
0
 public void DeletePharmacuticles(PharmacuticlesInfo obj)
 {
     dalObj = new PharmacuticlesDAL();
     dalObj.DeletePharmacuticles(obj);
 }
Exemplo n.º 6
0
 public void UpdatePharmacuticles(PharmacuticlesInfo obj)
 {
     dalObj = new PharmacuticlesDAL();
     dalObj.UpdatePharmacuticles(obj);
 }
Exemplo n.º 7
0
 public void SavePharmacuticles(PharmacuticlesInfo obj)
 {
     dalObj = new PharmacuticlesDAL();
     dalObj.SavePharmacuticles(obj);
 }
Exemplo n.º 8
0
 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);
 }