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