public void DeleteUnit(UnitInfo obj)
{
string Qry = "DELETE FROM Unit WHERE UnitID='" + obj.UnitID + "'";
DbUtility.ExecuteQuery(Qry);
}
public void UpdateUnit(UnitInfo obj)
{
string Qry = "update Unit set UnitName='" + obj.UnitName + "'where UnitID='" + obj.UnitID + "'";
DbUtility.ExecuteQuery(Qry);
}
private void btndelete_Click(object sender, EventArgs e)
{
obj = new UnitInfo();
obj.UnitID = txtunitid.Text;
obj.UnitName = txtunitname.Text;
UnitInfoBLL bllObj = new UnitInfoBLL();
bllObj.Delete(obj);
MessageBox.Show("Data deleted successfully !");
this.LoadUnit();
}
private void loadTOModel()
{
obj = new UnitInfo();
obj.UnitID = txtunitid.Text;
obj.UnitName = txtunitname.Text;
UnitInfoBLL bllObj = new UnitInfoBLL();
bllObj.SaveUnit(obj);
MessageBox.Show("Data successfully Saved!");
this.LoadUnit();
}
public void SaveUnit(UnitInfo obj)
{
string Qry = "INSERT INTO [CureDB].[dbo].[Unit]([UnitID],[UnitName])VALUES('" + obj.UnitID + "','" + obj.UnitName + "') ";
DbUtility.ExecuteQuery(Qry);
}
public void Delete(UnitInfo obj)
{
dalObj = new UnitInfoDAL();
dalObj.DeleteUnit(obj);
}
public void UpdateUnit(UnitInfo obj)
{
dalObj = new UnitInfoDAL();
dalObj.UpdateUnit(obj);
}
public void SaveUnit(UnitInfo obj)
{
dalObj = new UnitInfoDAL();
dalObj.SaveUnit(obj);
}