public void DeleteMedicinegrp(MedicinegrpInfo obj)
{
string Qry = "DELETE FROM MedicineGroup WHERE GroupID='" + obj.GroupID + "'";
DbUtility.ExecuteQuery(Qry);
}
public void UpdateMedicinegrp(MedicinegrpInfo obj)
{
string Qry = "update MedicineGroup set GroupName='" + obj.GroupName + "'where GroupID='" + obj.GroupID + "'";
DbUtility.ExecuteQuery(Qry);
}
private void loadTOModel()
{
obj = new MedicinegrpInfo();
obj.GroupID = txtgrpid.Text;
obj.GroupName = txtgrpname.Text;
MedicinegrpInfoDAL bllObj = new MedicinegrpInfoDAL();
bllObj.DeleteMedicinegrp(obj);
MessageBox.Show("Data successfully Saved!");
this.LoadMedicinegrp();
}
private void btndelete_Click(object sender, EventArgs e)
{
this.LoadMedicinegrp();
obj = new MedicinegrpInfo();
obj.GroupID = txtgrpid.Text;
obj.GroupName = txtgrpname.Text;
MedicinegrpInfoDAL bllObj = new MedicinegrpInfoDAL();
bllObj.DeleteMedicinegrp(obj);
MessageBox.Show("Data successfully deleted!");
this.LoadMedicinegrp();
}
public void DeleteMedicinegrp(MedicinegrpInfo obj)
{
dalObj = new MedicinegrpInfoDAL();
dalObj.DeleteMedicinegrp(obj);
}
public void UpdateMedicinegrp(MedicinegrpInfo obj)
{
dalObj = new MedicinegrpInfoDAL();
dalObj.UpdateMedicinegrp(obj);
}
public void SaveMedicinegrp(MedicinegrpInfo obj)
{
dalObj = new MedicinegrpInfoDAL();
dalObj.SaveMedicinegrp(obj);
}
public void SaveMedicinegrp(MedicinegrpInfo obj)
{
string Qry = "INSERT INTO [CureDB].[dbo].[MedicineGroup]([GroupID],[GroupName])VALUES('" + obj.GroupID + "','" + obj.GroupName + "') ";
DbUtility.ExecuteQuery(Qry);
}
