public void UpdatePosition(Model.Position oData)
{
try
{
osb.ConnectionString = sConnectionString;
ddq = new DatabaseQuery.DBQuery();
ddq.ConnectionString = osb.ConnectionString;
ddq.CommandText = "Update tbl_Position set Status = '" + oData.STATUS + "', Position = '" + oData.POSITION + "' Where ID = '" + oData.ID + "'";
ddq.ExecuteNonQuery(CommandType.Text);
}
catch (Exception ex)
{
throw ex;
}
}
public void InsertPosition(Model.Position oData)
{
try
{
osb.ConnectionString = sConnectionString;
ddq = new DatabaseQuery.DBQuery();
ddq.ConnectionString = osb.ConnectionString;
ddq.CommandText = "Insert Into tbl_Position (Position,Status) Values ('" + oData.POSITION + "', '" + oData.STATUS + "')";
ddq.ExecuteNonQuery(CommandType.Text);
}
catch (Exception ex)
{
throw ex;
}
}