public void DeleteDosage(DosageInfo obj) { string Qry = "DELETE FROM DosageForm WHERE DosageID='" + obj.DosageId + "'"; DbUtility.ExecuteQuery(Qry); }
public void UpdateDosage(DosageInfo obj) { string Qry = "update DosageForm set DosageName='" + obj.DosageName + "',DosageId='" + obj.DosageId + "'where DosageID='" + obj.DosageId + "'"; DbUtility.ExecuteQuery(Qry); }
private void btndelete_Click(object sender, EventArgs e) { obj = new DosageInfo(); obj.DosageId = txtdosageid.Text; obj.DosageName = txtdosagename.Text; DosageBLL bllObj = new DosageBLL(); bllObj.DeleteDosage(obj); MessageBox.Show("Data Deleted Successfully"); this.LoadDosage(); }
private void loadTOModel() { this.LoadDosage(); obj = new DosageInfo(); obj.DosageId = txtdosageid.Text; obj.DosageName = txtdosagename.Text; DosageBLL bllObj=new DosageBLL(); bllObj.SaveDosage(obj); MessageBox.Show("Data successfully Saved!"); }
public void DeleteDosage(DosageInfo obj) { dalObj = new DosageDAL(); dalObj.DeleteDosage(obj); }
public void UpdateDosage(DosageInfo obj) { dalObj = new DosageDAL(); dalObj.UpdateDosage(obj); }
public void SaveDosage(DosageInfo obj) { dalObj = new DosageDAL(); dalObj.SaveDosage(obj); }
public void SaveDosage(DosageInfo obj) { string Qry = "INSERT INTO [CureDB].[dbo].[DosageForm]([DosageID],[DosageName])VALUES('" + obj.DosageId + "','" + obj.DosageName + "') "; DbUtility.ExecuteQuery(Qry); }