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