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